You can use the
information_schema.engines view to return information about each engine in an account. The view is available for each database and contains one row for each engine in the account. You can use a
SELECT query to return information about each engine as shown in the example below, which uses a
WHERE clause to return all engines attached to databases that begin with
SELECT * FROM information_schema.engines WHERE attached_to ILIKE 'deng%'
Each row has the following columns with information about each engine.
|engine_name||TEXT||Name of the engine.|
|region||TEXT||AWS Region in which the engine was created.|
|spec||TEXT||Specification of nodes comprising the engine.|
|scale||INTEGER||Number of nodes in the engine.|
|status||TEXT||Engine status. For more information, see Viewing and understanding engine status.|
|attached_to||TEXT||Name of the database to which the engine is attached.|
|warmup||TEXT||Warmup method of the engine.|
|auto_stop||BIGINT||Engine auto stop in seconds.|
|engine_type||TEXT||Type of the engine.|