Redshift Observatory

System Table Tracker

System view pg_catalog.stl_table_partitions_hotness_stats version 1.0.51781 / 2023-06-13

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