Redshift Observatory

System Table Tracker

System view pg_catalog.stl_services_control_metrics version 1.0.70634 / 2024-07-11

schema	name	column	data type
pg_catalog	stl_services_control_metrics	node	int4
pg_catalog	stl_services_control_metrics	phase	char(128)
pg_catalog	stl_services_control_metrics	pid	int4
pg_catalog	stl_services_control_metrics	restart_reason	char(64)
pg_catalog	stl_services_control_metrics	restart_trace_id	char(64)
pg_catalog	stl_services_control_metrics	script_action	char(128)
pg_catalog	stl_services_control_metrics	script_status	char(32)
pg_catalog	stl_services_control_metrics	step_endtime	timestamp
pg_catalog	stl_services_control_metrics	step_starttime	timestamp

View Text

SELECT stll_services_control_metrics.node,
       stll_services_control_metrics.pid,
       stll_services_control_metrics.step_starttime,
       stll_services_control_metrics.step_endtime,
       stll_services_control_metrics.script_action,
       stll_services_control_metrics.phase,
       stll_services_control_metrics.script_status,
       stll_services_control_metrics.restart_trace_id,
       stll_services_control_metrics.restart_reason
FROM stll_services_control_metrics

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