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 |
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