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.

To view engine information, the user must have ownership of the engine or access to the necessary engine privileges.

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.

Column NameData TypeDescription
engine_nameTEXTThe name of the engine.
regionTEXT[DEPRECATED] The region in which the engine was created.
specTEXT[DEPRECATED] The specification of nodes comprising the engine.
scaleINTEGER[DEPRECATED] The number of nodes in the engine.
typeTEXTDetermines the capability of the nodes in the engine.
familyTEXTThe family of a given engine. Choose from STORAGE_OPTIMIZED or COMPUTE_OPTIMIZED.
nodesINTEGERThe number of nodes in a cluster.
clustersINTEGERThe number of node groupings in an engine.
min_clustersBIGINTThe minimum number of clusters in the engine. Auto-scaling scales the clusters between the defined minimum and maximum.
max_clustersBIGINTThe maximum number of clusters in the engine. Auto-scaling scales the clusters between the defined minimum and maximum.
statusTEXTThe engine status. For more information, see Viewing and understanding engine status.
attached_toTEXT[DEPRECATED] The name of the database to which the engine is attached.
auto_startBOOLEANWhen true, queries issued to a stopped engine will attempt to start the engine first.
auto_stopINTEGERIndicates the amount of time (in minutes) after which the engine automatically stops.
auto_vacuumBOOLEANIndicates whether VACUUM is enabled or disabled by the user. Could also be NULL to indicate that VACUUM is automatically enabled by default.
engine_typeTEXT[DEPRECATED] The type of the engine.
initially_stoppedBOOLEANWhen true, the engine will have attempted to start after creation.
urlTEXTA url which can be used to issue queries to this engine.
warmupTEXT[DEPRECATED] The warmup method of the engine.
default_databaseTEXTThe database an engine will attempt to use by default when dealing with queries that require a database.
versionTEXTThe engine version.
last_startedTIMESTAMPTZThe last time this engine was started (UTC).
last_stoppedTIMESTAMPTZThe last time this engine was stopped (UTC).
descriptionTEXTA user defined description for the engine.
createdTIMESTAMPTZThe time when this engine was created (UTC).
engine_ownerTEXTThe name of the user who created the engine.
last_altered_byTEXTThe user who last altered this engine.
last_alteredTIMESTAMPTZThe time when this engine was last altered (UTC).
fbu_rateNUMERICHourly FBU consumption rate of engines based on engine topology at the time the view is invoked by the user.