relationalai.api.show_warm_engines()

show_warm_engines()

A procedure that retrieves details about all currently existing warm engines. Requires the eng_user application role.

Parameters

This procedure does not take any parameters.

Returns

A table with the following columns:

Name	Type	Description
TYPE	STRING	The type of warm engine, e.g. "LOGIC".
SIZE	STRING	The size of the warm engine, e.g. "HIGHMEM_X64_S".
NAME	STRING	The name of the warm engine.
COMPUTE_POOL	STRING	The name of the compute pool to which the warm engine belongs.
CREATED_ON	TIMESTAMP	The timestamp when the warm engine was created.
READY_ON	TIMESTAMP	The timestamp when the warm engine became ready to use.

Example

Use the api.show_warm_engines() procedure to show information about all currently existing warm engines:

CALL relationalai.api.show_warm_engines();
/*+-------+---------------+--------------------------------+-----------------------------+---------+-------------------------------+-------------------------------+
  | TYPE  | SIZE          | NAME                           | COMPUTE_POOL                | STATUS  | CREATED_ON                    | READY_ON                      |
  |-------+---------------+--------------------------------+-----------------------------+---------+--------------------------0----+-------------------------------+
  | LOGIC | HIGHMEM_X64_S | WARM_ENGINE_LOGIC_a57c7945da89 | RELATIONAL_AI_HIGHMEM_X64_S | READY   | 2026-01-28 07:16:55.707 -0800 | 2026-01-28 07:19:31.244 -0800 |
  | LOGIC | HIGHMEM_X64_M | WARM_ENGINE_LOGIC_9f7d942067d9 | RELATIONAL_AI_HIGHMEM_X64_M | PENDING | 2026-01-28 07:17:05.645 -0800 | NULL                          |
  +-------+---------------+--------------------------------+-----------------------------+---------+-------------------------------+-------------------------------+ */

See Warm Engines for more information on warm engines and how to manage them.

See Also

• app.enable_warm_engine()
• app.disable_warm_engine()