Redshift Observatory

System Table Tracker

System table pg_catalog.stcs_table_partitions_hotness_stats version 1.0.43551 / 2022-11-08

schema name column data type PK U NN
pg_catalog stcs_table_partitions_hotness_stats avg_qpd float8 NN
pg_catalog stcs_table_partitions_hotness_stats __cluster_type char(4) NN
pg_catalog stcs_table_partitions_hotness_stats eventtime int8 NN
pg_catalog stcs_table_partitions_hotness_stats id int4 NN
pg_catalog stcs_table_partitions_hotness_stats __log_generated_date char(8) NN
pg_catalog stcs_table_partitions_hotness_stats no_loss_scans_count int8 NN
pg_catalog stcs_table_partitions_hotness_stats num_partitions int4 NN
pg_catalog stcs_table_partitions_hotness_stats num_sorted_rows int8 NN
pg_catalog stcs_table_partitions_hotness_stats num_unsorted_rows int8 NN
pg_catalog stcs_table_partitions_hotness_stats __path varchar(2050) NN
pg_catalog stcs_table_partitions_hotness_stats scan_count int8 NN
pg_catalog stcs_table_partitions_hotness_stats __size int8 NN
pg_catalog stcs_table_partitions_hotness_stats slice int4 NN
pg_catalog stcs_table_partitions_hotness_stats __spectrum_oid varchar(128) NN
pg_catalog stcs_table_partitions_hotness_stats total_blocks_read int8 NN
pg_catalog stcs_table_partitions_hotness_stats total_blocks_used int8 NN
pg_catalog stcs_table_partitions_hotness_stats total_wasted_blocks int8 NN
pg_catalog stcs_table_partitions_hotness_stats zero_bias_scans_count int8 NN


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