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.

For information about SVCS_S3PARTITION, see SVCS_S3PARTITION_SUMMARY.

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 completed.

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