Amazon Redshift 將不再支援從修補程式 198 開始建立新的 Python UDFs。現有 Python UDF 將繼續正常運作至 2026 年 6 月 30 日。如需詳細資訊，請參閱[部落格文章](https://aws.amazon.com/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 | integer | 執行任務查詢的程序 ID。建立任務時，此值一開始會設為 0，只有在 設定為已啟動時event才會變成非零。 |
| database\_name | character(128) | 執行任務的資料庫名稱。 |
| object\_type | character(30) | 自主操作任務所在的物件類型。可能的值如下：[See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/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.aws.amazon.com/zh_tw/redshift/latest/dg/SYS_AUTOMATIC_OPTIMIZATION.html) |
| 事件 | character(50) | 自主任務的狀態轉換事件類型。可能的值如下：[See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/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.aws.amazon.com/zh_tw/redshift/latest/dg/SYS_AUTOMATIC_OPTIMIZATION.html)如果任務未使用任何運算，則佈建時的值也可以為空白。如需可用於自律的不同類型的運算資源的詳細資訊，請參閱 [配置額外的運算資源以進行自動資料庫最佳化](t_extra-compute-autonomics.md)。 |
| task\_details | character(512) | 若有其他任務詳細資訊，請加以說明。此欄位可以是空的。 |
## 使用須知
無伺服器叢集的 compute\_type 資料欄將為空，因為我們無法區分主要或主要規模的運算資源。無伺服器叢集運算資源是以 Redshift 處理單元 (RPUs用量測量。如需詳細資訊，請參閱 [Amazon Redshift Serverless 的運算容量](https://docs.aws.amazon.com/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)
```