Amazon Redshift
Database Developer Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

SVL_S3PARTITION_SUMMARY

Use the SVL_S3PARTITION_SUMMARY view to get a summary of Redshift Spectrum queries partition processing at the segment level.

SVL_S3PARTITION_SUMMARY is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of Data in System Tables and Views.

Table Columns

Column Name Data Type Description
query integer The query ID. You can use this value to join various other system tables and views.
segment integer The segment number. A query consists of multiple segments.
assignment char(1) The type of partition assignment across nodes.
min_starttime timestamp The time in UTC that the partition processing started.
max_endtime timestamp The time in UTC that the partition processing completed.
min_duration bigint The minimum partition processing time used by a node for this query (in microseconds).
max_duration bigint The maximum partition processing time used by a node for this query (in microseconds).
avg_duration bigint The average partition processing time used by a node for this query (in microseconds).
total_partitions integer The total number of partitions in an external table.
qualified_partitions integer The total number of qualified partitions.
min_assigned_partitions integer The minimum number of partitions assigned on one node.
max_assigned_partitions integer The maximum number of partitions assigned on one node.
avg_assigned_partitions bigint The average number of partitions assigned on one node.

Sample Query

The following example gets the partition scan details for the last query executed.

select query, segment, assignment, min_starttime, max_endtime, min_dureation, avg_duration from svl_s3partition_summary where query = pg_last_query_id() order by query,segment;