Redshift Observatory

System Table Tracker

System view pg_catalog.svl_query_metrics_summary version 1.0.54239 / 2023-08-04

schema name column data type
pg_catalog svl_query_metrics_summary cpu_skew numeric(38,2)
pg_catalog svl_query_metrics_summary io_skew numeric(38,2)
pg_catalog svl_query_metrics_summary join_row_count int8
pg_catalog svl_query_metrics_summary nested_loop_join_row_count int8
pg_catalog svl_query_metrics_summary query int4
pg_catalog svl_query_metrics_summary query_blocks_read int8
pg_catalog svl_query_metrics_summary query_cpu_time int8
pg_catalog svl_query_metrics_summary query_cpu_usage_percent numeric(38,2)
pg_catalog svl_query_metrics_summary query_execution_time int8
pg_catalog svl_query_metrics_summary query_queue_time int8
pg_catalog svl_query_metrics_summary query_temp_blocks_to_disk int8
pg_catalog svl_query_metrics_summary return_row_count int8
pg_catalog svl_query_metrics_summary scan_row_count int8
pg_catalog svl_query_metrics_summary segment_execution_time int8
pg_catalog svl_query_metrics_summary service_class int4
pg_catalog svl_query_metrics_summary service_class_name char(64)
pg_catalog svl_query_metrics_summary spectrum_scan_row_count int8
pg_catalog svl_query_metrics_summary spectrum_scan_size_mb int8
pg_catalog svl_query_metrics_summary userid int4

View Text

SELECT svl_query_metrics.userid,
       svl_query_metrics.query,
       svl_query_metrics.service_class,
       max(svl_query_metrics.query_cpu_time) AS query_cpu_time,
       max(svl_query_metrics.query_blocks_read) AS query_blocks_read,
       max(svl_query_metrics.query_execution_time) AS query_execution_time,
       max(svl_query_metrics.query_cpu_usage_percent) AS query_cpu_usage_percent,
       max(svl_query_metrics.query_temp_blocks_to_disk) AS query_temp_blocks_to_disk,
       max(svl_query_metrics.segment_execution_time) AS segment_execution_time,
       max(svl_query_metrics.cpu_skew) AS cpu_skew,
       max(svl_query_metrics.io_skew) AS io_skew,
       max(svl_query_metrics.scan_row_count) AS scan_row_count,
       max(svl_query_metrics.join_row_count) AS join_row_count,
       max(svl_query_metrics.nested_loop_join_row_count) AS nested_loop_join_row_count,
       max(svl_query_metrics.return_row_count) AS return_row_count,
       max(svl_query_metrics.spectrum_scan_row_count) AS spectrum_scan_row_count,
       max(svl_query_metrics.spectrum_scan_size_mb) AS spectrum_scan_size_mb,
       max(svl_query_metrics.query_queue_time) AS query_queue_time,
       svl_query_metrics.service_class_name
FROM svl_query_metrics
GROUP BY svl_query_metrics.userid, svl_query_metrics.query, svl_query_metrics.service_class, svl_query_metrics.service_class_name


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