Redshift Observatory

System Table Tracker

System table pg_catalog.stv_table_partitions version 1.0.52931 / 2023-07-07

schema name column data type PK U NN
pg_catalog stv_table_partitions degree_of_overlap int4 NN
pg_catalog stv_table_partitions first_marked_hot_ts timestamp NN
pg_catalog stv_table_partitions first_qpd_rise_ts timestamp NN
pg_catalog stv_table_partitions flags int4 NN
pg_catalog stv_table_partitions id int4 NN
pg_catalog stv_table_partitions is_hot char(1) NN
pg_catalog stv_table_partitions is_range_partitioned char(1) NN
pg_catalog stv_table_partitions is_sorted char(1) NN
pg_catalog stv_table_partitions no_loss_scans_count int8 NN
pg_catalog stv_table_partitions num_blocks int8 NN
pg_catalog stv_table_partitions num_overlapping_partitions int4 NN
pg_catalog stv_table_partitions num_scans_to_mark_hot int8 NN
pg_catalog stv_table_partitions partition_id int8 NN
pg_catalog stv_table_partitions qpd int4 NN
pg_catalog stv_table_partitions rows int8 NN
pg_catalog stv_table_partitions scan_count int8 NN
pg_catalog stv_table_partitions slice int4 NN
pg_catalog stv_table_partitions total_blocks_read int8 NN
pg_catalog stv_table_partitions total_blocks_used int8 NN
pg_catalog stv_table_partitions total_wasted_blocks int8 NN
pg_catalog stv_table_partitions 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