Redshift Observatory

System Table Tracker

System view pg_catalog.stl_state_gui_status version 1.0.106073 / 2025-01-23

schema	name	column	data type
pg_catalog	stl_state_gui_status	load_time	timestamp
pg_catalog	stl_state_gui_status	num_nodes	int4
pg_catalog	stl_state_gui_status	num_sessions	int4
pg_catalog	stl_state_gui_status	recent_queries	int4
pg_catalog	stl_state_gui_status	start_time	timestamp
pg_catalog	stl_state_gui_status	system_status	char(30)
pg_catalog	stl_state_gui_status	timestamp	int8
pg_catalog	stl_state_gui_status	total_queries	int4

View Text

SELECT stll_state_gui_status.timestamp,
       stll_state_gui_status.start_time,
       stll_state_gui_status.num_nodes,
       stll_state_gui_status.num_sessions,
       stll_state_gui_status.total_queries,
       stll_state_gui_status.recent_queries,
       stll_state_gui_status.load_time,
       stll_state_gui_status.system_status
FROM stll_state_gui_status

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace System Table Tracker The Known Universe White Papers