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
attached_to ILIKE 'deng%'
Each row has the following columns with information about each engine.
|The name of the engine.
|The AWS Region in which the engine was created.
|The specification of nodes comprising the engine.
|The number of nodes in the engine.
|The engine status. For more information, see Viewing and understanding engine status.
|The name of the database to which the engine is attached.
|The engine version.
|The engine url.
|The warmup method of the engine.
|The engine auto stop in seconds.
|The type of the engine.