Redshift Observatory

System Table Tracker

System view pg_catalog.stl_hot_tables_qpd_stats version 1.0.50708 / 2023-05-19

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