Redshift Observatory

System Table Tracker

System view pg_catalog.stl_table_partition_qpd_stats version 1.0.71912 / 2024-08-02

schema name column data type
pg_catalog stl_table_partition_qpd_stats bias_factor float8
pg_catalog stl_table_partition_qpd_stats blocks_read int4
pg_catalog stl_table_partition_qpd_stats blocks_used int4
pg_catalog stl_table_partition_qpd_stats eventtime timestamp
pg_catalog stl_table_partition_qpd_stats id int4
pg_catalog stl_table_partition_qpd_stats partition_id int4
pg_catalog stl_table_partition_qpd_stats query int4
pg_catalog stl_table_partition_qpd_stats rows_read int8
pg_catalog stl_table_partition_qpd_stats rows_used int8
pg_catalog stl_table_partition_qpd_stats slice int4
pg_catalog stl_table_partition_qpd_stats sort_key_col int4

View Text

SELECT stll_table_partition_qpd_stats.eventtime,
       stll_table_partition_qpd_stats.id,
       stll_table_partition_qpd_stats.slice,
       stll_table_partition_qpd_stats.partition_id,
       stll_table_partition_qpd_stats.sort_key_col,
       stll_table_partition_qpd_stats.blocks_read,
       stll_table_partition_qpd_stats.blocks_used,
       stll_table_partition_qpd_stats.rows_read,
       stll_table_partition_qpd_stats.rows_used,
       stll_table_partition_qpd_stats.bias_factor,
       stll_table_partition_qpd_stats.query
FROM stll_table_partition_qpd_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