Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	svl_s3partition_summary	assignment	char(1)
pg_catalog	svl_s3partition_summary	avg_assigned_partitions	int8
pg_catalog	svl_s3partition_summary	avg_duration	int8
pg_catalog	svl_s3partition_summary	max_assigned_partitions	int4
pg_catalog	svl_s3partition_summary	max_duration	int8
pg_catalog	svl_s3partition_summary	max_endtime	timestamp
pg_catalog	svl_s3partition_summary	min_assigned_partitions	int4
pg_catalog	svl_s3partition_summary	min_duration	int8
pg_catalog	svl_s3partition_summary	min_starttime	timestamp
pg_catalog	svl_s3partition_summary	qualified_partitions	int4
pg_catalog	svl_s3partition_summary	query	int4
pg_catalog	svl_s3partition_summary	segment	int4
pg_catalog	svl_s3partition_summary	total_partitions	int4

View Text

SELECT stl_s3partition_elimination.query,
       stl_s3partition_elimination.segment,
       stl_s3partition_elimination.assignment,
       min(stl_s3partition_elimination.starttime) AS min_starttime,
       max(stl_s3partition_elimination.endtime) AS max_endtime,
       min(date_diff(CAST('us' AS text),
                     stl_s3partition_elimination.starttime,
                     stl_s3partition_elimination.endtime)) AS min_duration,
       max(date_diff(CAST('us' AS text),
                     stl_s3partition_elimination.starttime,
                     stl_s3partition_elimination.endtime)) AS max_duration,
       avg(date_diff(CAST('us' AS text),
                     stl_s3partition_elimination.starttime,
                     stl_s3partition_elimination.endtime)) AS avg_duration,
       max(stl_s3partition_elimination.total_partitions) AS total_partitions,
       max(stl_s3partition_elimination.qualified_partitions) AS qualified_partitions,
       min(stl_s3partition_elimination.assigned_partitions) AS min_assigned_partitions,
       max(stl_s3partition_elimination.assigned_partitions) AS max_assigned_partitions,
       avg(stl_s3partition_elimination.assigned_partitions) AS avg_assigned_partitions
FROM stl_s3partition_elimination
GROUP BY stl_s3partition_elimination.query, stl_s3partition_elimination.segment, stl_s3partition_elimination.assignment

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