Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

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


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