从补丁 198 开始，Amazon Redshift 将不再支持创建新的 Python UDF。现有的 Python UDF 将继续正常运行至 2026 年 6 月 30 日。有关更多信息，请参阅[博客文章](https://www.amazonaws.cn/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/)。
# SYS\_AUTOMATIC\_OPTIMIZATION
使用 SYS\_AUTOMATIC\_OPTIMIZATION 可查看有关 Amazon Redshift 为自动优化（也称为自动处理）而运行的任务的详细信息。有关自动优化的更多信息，请参阅[自动数据库优化](c_autonomics.md)。
SYS\_AUTOMATIC\_OPTIMIZATION 仅对超级用户可见。有关更多信息，请参阅 [系统表和视图中的数据可见性](cm_chap_system-tables.md#c_visibility-of-data)。
## 表列
| 列名称 | 数据类型 | 说明 |
| --- | --- | --- |
| session\_id | 整数 | 执行任务查询的进程 ID。创建任务时最初设置为 0，仅当 event 设置为“已启动”时，该值才会变为非零。 |
| database\_name | character(128) | 在其中执行任务的数据库的名称。 |
| object\_type | character(30) | 针对其运行自主处理任务的对象的类型。可能的值包括：[See the AWS documentation website for more details](http://docs.amazonaws.cn/redshift/latest/dg/SYS_AUTOMATIC_OPTIMIZATION.html) |
| object\_ids | character(512) | 针对其运行自主处理任务的对象的标识符。当针对多个数据库对象运行任务时，此字段可以容纳多个对象。在这种情况下，标识符用逗号分隔。 |
| task\_type | character(100) | 运行的自主处理任务的类型。可能的任务如下所示：[See the AWS documentation website for more details](http://docs.amazonaws.cn/redshift/latest/dg/SYS_AUTOMATIC_OPTIMIZATION.html) |
| 事件 | character(50) | 自主处理任务的状态转换事件的类型。可能的值包括：[See the AWS documentation website for more details](http://docs.amazonaws.cn/redshift/latest/dg/SYS_AUTOMATIC_OPTIMIZATION.html) |
| event\_time | timestamp | 状态转换发生的时间。 |
| status | character(512) | 优化任务的执行状态。如果任务未尝试运行，则为空。 |
| compute\_type | character(100) | 任务使用的计算资源类型。适用于预置的可能值如下所示：[See the AWS documentation website for more details](http://docs.amazonaws.cn/redshift/latest/dg/SYS_AUTOMATIC_OPTIMIZATION.html)如果任务未使用任何计算，则对于预置，该值也可能为空。有关可用于自主处理的不同类型的计算资源的更多信息，请参阅[分配额外的计算资源来执行自动数据库优化](t_extra-compute-autonomics.md)。 |
| task\_details | character(512) | 其它任务详细信息（如果有）。此字段可以为空。 |
## 使用说明
对于无服务器集群，compute\_type 列将为空，因为我们没有区分主计算资源和主扩展计算资源。无服务器集群计算资源以 Redshift 处理器（RPU）用量为单位。有关更多信息，请参阅 [Amazon Redshift Serverless 的计算容量](https://docs.amazonaws.cn/redshift/latest/mgmt/serverless-capacity.html)。
## 示例
下面的查询显示对表 155259 执行的自动优化。
```
SELECT pid, trim(task_type) as task_type,
trim(database) as database,
trim(status) as status,
trim(event) as event,
event_time
from SYS_AUTOMATIC_OPTIMIZATION
WHERE object_ids like '%155259%'
AND status = 'Task completed successfully';
task_type | database | status | event | event_time
------------+----------------+-----------------------------+-----------+----------------------------
VacuumSort | tpcds_100g_oob | Task completed successfully | Completed | 2025-12-22 07:27:15.943018
```
以下查询显示所有已执行的自动“VacuumSort”优化。有关“VacuumSort”的更多信息，请参阅[自动表排序](t_Reclaiming_storage_space202.md#automatic-table-sort)。
```
SELECT trim(task_type) as task_type,
trim(database) as database,
trim(object_type) as object_type,
trim(object_ids) as object_ids,
trim(status) as status,
trim(event) as event,
event_time
from SYS_AUTOMATIC_OPTIMIZATION
WHERE task_type like '%VacuumSort%'
AND status = 'Task completed successfully';
task_type | database | object_type | object_ids | status | event | event_time
------------+----------------+-------------+------------+-----------------------------+-----------+----------------------------
VacuumSort | tpcds_100g_oob | table | 155301 | Task completed successfully | Completed | 2025-12-22 07:14:00.065391
VacuumSort | tpcds_100g_oob | table | 155303 | Task completed successfully | Completed | 2025-12-22 07:14:09.158251
VacuumSort | tpcds_100g_oob | table | 155291 | Task completed successfully | Completed | 2025-12-22 07:17:06.61164
VacuumSort | tpcds_100g_oob | table | 155293 | Task completed successfully | Completed | 2025-12-22 07:17:37.015069
VacuumSort | tpcds_100g_oob | table | 155281 | Task completed successfully | Completed | 2025-12-22 07:18:54.903935
VacuumSort | tpcds_100g_oob | table | 155279 | Task completed successfully | Completed | 2025-12-22 07:20:13.960002
VacuumSort | tpcds_100g_oob | table | 155271 | Task completed successfully | Completed | 2025-12-22 07:21:26.095549
VacuumSort | tpcds_100g_oob | table | 155267 | Task completed successfully | Completed | 2025-12-22 07:22:48.119249
VacuumSort | tpcds_100g_oob | table | 155269 | Task completed successfully | Completed | 2025-12-22 07:24:12.010424
VacuumSort | tpcds_100g_oob | table | 155263 | Task completed successfully | Completed | 2025-12-22 07:25:35.958388
VacuumSort | tpcds_100g_oob | table | 155265 | Task completed successfully | Completed | 2025-12-22 07:26:40.580395
VacuumSort | tpcds_100g_oob | table | 155259 | Task completed successfully | Completed | 2025-12-22 07:27:15.943018
(12 rows)
```