Redshift Observatory

System Table Tracker

System view pg_catalog.stl_table_partition_qpd_stats version 1.0.52931 / 2023-07-07

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