SVCS_S3PARTITION_SUMMARY - Amazon Redshift
Table columnsSample query
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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;