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. 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 Name	Data Type	Description
engine_name	TEXT	The name of the engine.
status	TEXT	The engine status. For more information, see Viewing and understanding engine status.
version	TEXT	The engine version.
url	TEXT	A url which can be used to issue queries to this engine.
auto_stop	BIGINT	Indicates the amount of time (in minutes) after which the engine automatically stops.
auto_vacuum	BOOLEAN	Indicates whether AUTO_VACUUM is enabled or disabled by the user. Could also be `NULL` to indicate that `AUTO_VACUUM` is automatically enabled by default.
cache_size	TEXT	Maximum 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).
type	TEXT	Determines the capability of the nodes in the engine.
family	TEXT	The family of a given engine. Choose from `STORAGE_OPTIMIZED` or `COMPUTE_OPTIMIZED`.
nodes	BIGINT	The number of nodes in a cluster.
clusters	BIGINT	The number of node groupings in an engine.
min_clusters	BIGINT	The minimum number of clusters in the engine. Auto-scaling scales the clusters between the defined minimum and maximum.
max_clusters	BIGINT	The maximum number of clusters in the engine. Auto-scaling scales the clusters between the defined minimum and maximum.
auto_start	BOOLEAN	When true, queries issued to a stopped engine will attempt to start the engine first.
initially_stopped	BOOLEAN	When true, the engine will have attempted to start after creation.
default_database	TEXT	The database an engine will attempt to use by default when dealing with queries that require a database.
last_started	TIMESTAMPTZ	The last time this engine was started (UTC).
last_stopped	TIMESTAMPTZ	The last time this engine was stopped (UTC).
description	TEXT	A user defined description for the engine.
created	TIMESTAMPTZ	The time when this engine was created (UTC).
engine_owner	TEXT	The name of the user who created the engine.
last_altered_by	TEXT	The user who last altered this engine.
last_altered	TIMESTAMPTZ	The time when this engine was last altered (UTC).
fbu_rate	NUMERIC	Hourly FBU consumption rate of engines based on engine topology at the time the view is invoked by the user.
release_channel	TEXT	The release channel.

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Columns in information_schema.engines

​Columns in information_schema.engines

Columns in information_schema.engines