Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_table_partitions_hotness_stats	avg_qpd	float8
pg_catalog	stl_table_partitions_hotness_stats	eventtime	timestamp
pg_catalog	stl_table_partitions_hotness_stats	id	int4
pg_catalog	stl_table_partitions_hotness_stats	no_loss_scans_count	int8
pg_catalog	stl_table_partitions_hotness_stats	num_partitions	int4
pg_catalog	stl_table_partitions_hotness_stats	num_sorted_rows	int8
pg_catalog	stl_table_partitions_hotness_stats	num_unsorted_rows	int8
pg_catalog	stl_table_partitions_hotness_stats	scan_count	int8
pg_catalog	stl_table_partitions_hotness_stats	slice	int4
pg_catalog	stl_table_partitions_hotness_stats	total_blocks_read	int8
pg_catalog	stl_table_partitions_hotness_stats	total_blocks_used	int8
pg_catalog	stl_table_partitions_hotness_stats	total_wasted_blocks	int8
pg_catalog	stl_table_partitions_hotness_stats	zero_bias_scans_count	int8

View Text

SELECT stll_table_partitions_hotness_stats.eventtime,
       stll_table_partitions_hotness_stats.id,
       stll_table_partitions_hotness_stats.slice,
       stll_table_partitions_hotness_stats.total_wasted_blocks,
       stll_table_partitions_hotness_stats.total_blocks_read,
       stll_table_partitions_hotness_stats.total_blocks_used,
       stll_table_partitions_hotness_stats.no_loss_scans_count,
       stll_table_partitions_hotness_stats.zero_bias_scans_count,
       stll_table_partitions_hotness_stats.scan_count,
       stll_table_partitions_hotness_stats.num_sorted_rows,
       stll_table_partitions_hotness_stats.num_unsorted_rows,
       stll_table_partitions_hotness_stats.num_partitions,
       stll_table_partitions_hotness_stats.avg_qpd
FROM stll_table_partitions_hotness_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