Redshift Observatory

System Table Tracker

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

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