| 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 |
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