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 |
|---|---|---|
| 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. |
| node | integer | The node number. |
| slice | integer | The data slice that a particular segment executed against. |
| starttime | timestamp without time zone | Time in UTC that the partition pruning started executing. |
| endtime | timestamp without time zone | Time in UTC that the partition pruning completed. |
| duration | bigint | Elapsed time (in microseconds). |
| total_partitions | integer | Number of total partitions. |
| qualified_partitions | integer | Number of qualified partitions. |
| assigned_partitions | integer | Number of assigned partitions on the slice. |
| assignment | character | Type of assignment. |
Sample Query
The following example gets the partition details for the last query executed.
SELECT query, segment, MIN(starttime) AS starttime, MAX(endtime) AS endtime, datediff(ms,MIN(starttime),MAX(endtime)) AS dur_ms, MAX(total_partitions) AS total_partitions, MAX(qualified_partitions) AS qualified_partitions, MAX(assignment) as assignment_type FROM svl_s3partition WHERE query=pg_last_query_id() GROUP BY query, segment
query | segment | starttime | endtime | dur_ms| total_partitions | qualified_partitions | assignment_type ------+---------+-------------------------------+-----------------------------+-------+------------------+----------------------+---------------- 99232 | 0 | 2018-04-17 22:43:50.201515 | 2018-04-17 22:43:54.674595 | 4473 | 2526 | 334 | p
