Amazon Redshift dejará de admitir la creación de nuevas UDF de Python a partir del parche 198. Las UDF de Python existentes seguirán funcionando hasta el 30 de junio de 2026. Para obtener más información, consulte la [publicación del blog](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# SYS\$1AUTOMATIC\$1OPTIMIZATION
<a name="SYS_AUTOMATIC_OPTIMIZATION"></a>

Utilice SYS\$1AUTOMATIC\$1OPTIMIZATION para ver los detalles de las tareas que Amazon Redshift ejecuta para la optimización automática, también conocida como características automatizadas. Para obtener más información sobre la automatización automática, consulte [Optimización automática de bases de datos](c_autonomics.md).

SYS\$1AUTOMATIC\$1OPTIMIZATION solo es visible para los superusuarios. Para obtener más información, consulte [Visibilidad de datos en las tablas y vistas de sistema](cm_chap_system-tables.md#c_visibility-of-data).

## Columnas de la tabla
<a name="SYS_AUTOMATIC_OPTIMIZATION-table-columns"></a>

[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/es_es/redshift/latest/dg/SYS_AUTOMATIC_OPTIMIZATION.html)

## Notas de uso
<a name="SYS_AUTOMATIC_OPTIMIZATION-usage-notes"></a>

La columna compute\$1type estará vacía en el caso de los clústeres sin servidor, ya que no diferenciamos los recursos de computación primarios de los de escala primaria. Los recursos de computación del clúster sin servidor se miden por el uso de unidades de procesamiento de Redshift (RPU). Para obtener más información, consulte [Capacidad informática para Amazon Redshift sin servidor](https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-capacity.html).

## Ejemplos
<a name="SYS_AUTOMATIC_OPTIMIZATION-examples"></a>

La siguiente consulta muestra las optimizaciones automáticas realizadas en la tabla 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
```

La siguiente consulta muestra todas las optimizaciones automáticas de “VacuumSort” ejecutadas. Para obtener más información sobre “VacuumSort”, consulte [Clasificación automática de tablas](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)
```