Redshift Observatory

System Table Tracker

System view pg_catalog.svl_query_metrics_summary version 1.0.39278 / 2022-07-23

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