Redshift Observatory

System Table Tracker

System view pg_catalog.stl_version version 1.0.74159 / 2024-09-10

schema	name	column	data type
pg_catalog	stl_version	bootstrap_time	timestamp
pg_catalog	stl_version	db_version	char(50)
pg_catalog	stl_version	instance_type	char(30)
pg_catalog	stl_version	major_version	int4
pg_catalog	stl_version	num_nodes	int4
pg_catalog	stl_version	restart_reason	char(100)
pg_catalog	stl_version	restart_trace_id	char(64)
pg_catalog	stl_version	track_name	char(30)

View Text

SELECT stll_version.bootstrap_time,
       stll_version.db_version,
       stll_version.restart_reason,
       stll_version.restart_trace_id,
       stll_version.track_name,
       stll_version.instance_type,
       stll_version.num_nodes,
       stll_version.major_version
FROM stll_version

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers