Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_query_metrics	blocks_read	int8
pg_catalog	stl_query_metrics	blocks_to_disk	int8
pg_catalog	stl_query_metrics	cpu_time	int8
pg_catalog	stl_query_metrics	max_blocks_read	int4
pg_catalog	stl_query_metrics	max_blocks_to_disk	int8
pg_catalog	stl_query_metrics	max_cpu_time	int8
pg_catalog	stl_query_metrics	max_query_scan_size	int8
pg_catalog	stl_query_metrics	max_rows	int8
pg_catalog	stl_query_metrics	max_run_time	int8
pg_catalog	stl_query_metrics	query	int4
pg_catalog	stl_query_metrics	query_priority	int4
pg_catalog	stl_query_metrics	query_queue_time	int8
pg_catalog	stl_query_metrics	query_scan_size	int8
pg_catalog	stl_query_metrics	rows	int8
pg_catalog	stl_query_metrics	run_time	int8
pg_catalog	stl_query_metrics	segment	int4
pg_catalog	stl_query_metrics	service_class	int4
pg_catalog	stl_query_metrics	service_class_name	char(64)
pg_catalog	stl_query_metrics	slices	int4
pg_catalog	stl_query_metrics	starttime	timestamp
pg_catalog	stl_query_metrics	step	int4
pg_catalog	stl_query_metrics	step_type	int4
pg_catalog	stl_query_metrics	userid	int4

View Text

SELECT stll_query_metrics.userid,
       stll_query_metrics.service_class,
       stll_query_metrics.query,
       stll_query_metrics.segment,
       stll_query_metrics.step_type,
       stll_query_metrics.starttime,
       stll_query_metrics.slices,
       stll_query_metrics.max_rows,
       stll_query_metrics.rows,
       stll_query_metrics.max_cpu_time,
       stll_query_metrics.cpu_time,
       stll_query_metrics.max_blocks_read,
       stll_query_metrics.blocks_read,
       stll_query_metrics.max_run_time,
       stll_query_metrics.run_time,
       stll_query_metrics.max_blocks_to_disk,
       stll_query_metrics.blocks_to_disk,
       stll_query_metrics.step,
       stll_query_metrics.max_query_scan_size,
       stll_query_metrics.query_scan_size,
       stll_query_metrics.query_priority,
       stll_query_metrics.query_queue_time,
       stll_query_metrics.service_class_name
FROM stll_query_metrics
WHERE stll_query_metrics.access_control = 0
   OR stll_query_metrics.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

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