Redshift Observatory

System Table Tracker

System view pg_catalog.stl_hot_tables_qpd_stats version 1.0.52931 / 2023-07-07

schema name column data type
pg_catalog stl_hot_tables_qpd_stats avg_qpd int8
pg_catalog stl_hot_tables_qpd_stats eventtime timestamp
pg_catalog stl_hot_tables_qpd_stats highest_qpd int8
pg_catalog stl_hot_tables_qpd_stats max_qpd int8
pg_catalog stl_hot_tables_qpd_stats median_qpd int8
pg_catalog stl_hot_tables_qpd_stats min_qpd int8
pg_catalog stl_hot_tables_qpd_stats num_hot_tables int4
pg_catalog stl_hot_tables_qpd_stats table_id int4

View Text

SELECT stll_hot_tables_qpd_stats.eventtime,
       stll_hot_tables_qpd_stats.num_hot_tables,
       stll_hot_tables_qpd_stats.table_id,
       stll_hot_tables_qpd_stats.highest_qpd,
       stll_hot_tables_qpd_stats.min_qpd,
       stll_hot_tables_qpd_stats.max_qpd,
       stll_hot_tables_qpd_stats.avg_qpd,
       stll_hot_tables_qpd_stats.median_qpd
FROM stll_hot_tables_qpd_stats


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