SVL_S3PARTITION
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
