Redshift Observatory

System Table Tracker

System view pg_catalog.svl_s3partition_summary version 1.0.39009 / 2022-06-08

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