Redshift Observatory

System Table Tracker

System view pg_catalog.stl_state_gui_status version 1.0.70890 / 2024-07-14

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 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