SVCS_S3PARTITION_SUMMARY

Use the SVCS_S3PARTITION_SUMMARY view to get a summary of Redshift Spectrum queries partition processing at the segment level. One segment can perform one external table scan.

Note

System views with the prefix SVCS provide details about queries on both the main and concurrency scaling clusters. The views are similar to the views with the prefix SVL except that the SVL views provide information only for queries run on the main cluster.

SVCS_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 SVL_S3PARTITION, see SVL_S3PARTITION.

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

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