Link Search Menu Expand Document

Information schema for engines

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 deng.

SELECT
  *
FROM
  information_schema.engines
WHERE
  attached_to ILIKE 'deng%'

Columns in information_schema.engines

Each row has the following columns with information about each engine.

Name Data Type Description
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.
version TEXT Engine version.
url TEXT Engine url.
warmup TEXT Warmup method of the engine.
auto_stop BIGINT Engine auto stop in seconds.
engine_type TEXT Type of the engine.