Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_metrics version 1.0.76642 / 2024-10-18

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