Skip to main content
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.
statusTEXTThe engine status. For more information, see Viewing and understanding engine status.
versionTEXTThe engine version.
urlTEXTA url which can be used to issue queries to this engine.
auto_stopBIGINTIndicates the amount of time (in minutes) after which the engine automatically stops.
auto_vacuumBOOLEANIndicates whether AUTO_VACUUM is enabled or disabled by the user. Could also be NULL to indicate that AUTO_VACUUM is automatically enabled by default.
auto_warmupBOOLEANIndicates whether AUTO_WARMUP is enabled or disable by the user.
cache_sizeTEXTMaximum memory ratio used for different cache pools (in percent relative to the total available memory). This indicates how much of the engine’s memory is used for each type of cache (e.g., result cache).
typeTEXTDetermines the capability of the nodes in the engine.
familyTEXTThe family of a given engine. Choose from STORAGE_OPTIMIZED or COMPUTE_OPTIMIZED.
nodesBIGINTThe number of nodes in a cluster.
clustersBIGINTThe 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.
auto_startBOOLEANWhen true, queries issued to a stopped engine will attempt to start the engine first.
initially_stoppedBOOLEANWhen true, the engine will have attempted to start after creation.
default_databaseTEXTThe database an engine will attempt to use by default when dealing with queries that require a database.
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.
release_channelTEXTThe release channel.