Redshift Observatory

System Table Tracker

System view pg_catalog.stl_sage_query_trace_data version 1.0.76759 / 2024-10-18

schema	name	column	data type
pg_catalog	stl_sage_query_trace_data	arrival_time	timestamp
pg_catalog	stl_sage_query_trace_data	burstable	int4
pg_catalog	stl_sage_query_trace_data	cluster_size	int4
pg_catalog	stl_sage_query_trace_data	consumed_megabytes	int4
pg_catalog	stl_sage_query_trace_data	event_time	timestamp
pg_catalog	stl_sage_query_trace_data	execution_time_ms	int4
pg_catalog	stl_sage_query_trace_data	inflight	int4
pg_catalog	stl_sage_query_trace_data	predicted_execution_times	char(400)
pg_catalog	stl_sage_query_trace_data	query_id	int4

View Text

SELECT stll_sage_query_trace_data.event_time,
       stll_sage_query_trace_data.query_id,
       stll_sage_query_trace_data.inflight,
       stll_sage_query_trace_data.burstable,
       stll_sage_query_trace_data.arrival_time,
       stll_sage_query_trace_data.execution_time_ms,
       stll_sage_query_trace_data.consumed_megabytes,
       stll_sage_query_trace_data.cluster_size,
       stll_sage_query_trace_data.predicted_execution_times
FROM stll_sage_query_trace_data

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