Redshift Observatory

System Table Tracker

System view pg_catalog.svl_s3partition version 1.0.53301 / 2023-07-19

schema	name	column	data type
pg_catalog	svl_s3partition	assigned_partitions	int4
pg_catalog	svl_s3partition	assignment	char(1)
pg_catalog	svl_s3partition	duration	int8
pg_catalog	svl_s3partition	endtime	timestamp
pg_catalog	svl_s3partition	node	int4
pg_catalog	svl_s3partition	qualified_partitions	int4
pg_catalog	svl_s3partition	query	int4
pg_catalog	svl_s3partition	segment	int4
pg_catalog	svl_s3partition	slice	int4
pg_catalog	svl_s3partition	starttime	timestamp
pg_catalog	svl_s3partition	total_partitions	int4

View Text

SELECT stl_s3partition_elimination.query,
       stl_s3partition_elimination.segment,
       stl_s3partition_elimination.node,
       stl_s3partition_elimination.slice,
       stl_s3partition_elimination.starttime,
       stl_s3partition_elimination.endtime,
       stl_s3partition_elimination.duration,
       stl_s3partition_elimination.total_partitions,
       stl_s3partition_elimination.qualified_partitions,
       stl_s3partition_elimination.assigned_partitions,
       stl_s3partition_elimination.assignment
FROM stl_s3partition_elimination

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