Redshift Observatory

System Table Tracker

System view pg_catalog.stl_table_partition_scan version 1.0.51304 / 2023-06-04

schema	name	column	data type
pg_catalog	stl_table_partition_scan	blocks_read	int4
pg_catalog	stl_table_partition_scan	blocks_used	int4
pg_catalog	stl_table_partition_scan	col	int4
pg_catalog	stl_table_partition_scan	part	int4
pg_catalog	stl_table_partition_scan	query	int4
pg_catalog	stl_table_partition_scan	rows_read	int8
pg_catalog	stl_table_partition_scan	rows_used	int8
pg_catalog	stl_table_partition_scan	segment	int4
pg_catalog	stl_table_partition_scan	slice	int4
pg_catalog	stl_table_partition_scan	step	int4

View Text

SELECT stll_table_partition_scan.query,
       stll_table_partition_scan.segment,
       stll_table_partition_scan.step,
       stll_table_partition_scan.slice,
       stll_table_partition_scan.col,
       stll_table_partition_scan.part,
       stll_table_partition_scan.blocks_read,
       stll_table_partition_scan.blocks_used,
       stll_table_partition_scan.rows_read,
       stll_table_partition_scan.rows_used
FROM stll_table_partition_scan

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