Amazon Redshift
Database Developer Guide (API Version 2012-12-01)


Use the SVL_S3PARTITION view to get details about Amazon Redshift Spectrum partitions at the segment and node slice level.

SVL_S3PARTITION 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
userid integer The ID of user who generated a given entry.
query integer The query ID.
segment integer A segment number. A query consists of multiple segments, and each segment consists of one or more steps.
step integer The query step that executed.
node integer The node number.
slice integer The data slice that a particular segment executed against.
starttime Time Time in UTC that the query started executing.
endtime Time Time in UTC that the query execution completed
duration integer Elapsed time (in microseconds).
assigned_partitions integer Number of assigned partitions.
qualified_partitions integer Number of qualified partitions.
assignment text Value that indicates whether assignment occurred.

Sample Query

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

select query, segment, node, slice, duration, assigned_partitions as assigned, qualified_partitions as qualified, assignment from svl_s3partition where query = pg_last_query_id() order by query,segment,slice;
query | segment | node | slice | duration | assigned | qualified | assignment
17223 |       2 |    0 |     0 |   302671 |       12 |        1 | f         
17223 |       2 |    1 |     2 |   265677 |       12 |        1 | f