Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/) that was published on June 30, 2025. 

# SVCS\_S3PARTITION\_SUMMARY
<a name="r_SVCS_S3PARTITION_SUMMARY"></a>

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](cm_chap_system-tables.md#c_visibility-of-data).

For information about SVL\_S3PARTITION, see [SVL\_S3PARTITION](r_SVL_S3PARTITION.md).

## Table columns
<a name="r_SVCS_S3PARTITION_SUMMARY-table-columns"></a>


| 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
<a name="r_SVCS_S3PARTITION_SUMMARY-sample-query"></a>

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;
```