Information schema
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.
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. |
| region | TEXT | [DEPRECATED] The region in which the engine was created. |
| spec | TEXT | [DEPRECATED] The specification of nodes comprising the engine. |
| scale | INTEGER | [DEPRECATED] The number of nodes in the engine. |
| 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 | INTEGER | The number of nodes in a cluster. |
| clusters | INTEGER | 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. |
| status | TEXT | The engine status. For more information, see Viewing and understanding engine status. |
| attached_to | TEXT | [DEPRECATED] The name of the database to which the engine is attached. |
| auto_start | BOOLEAN | When true, queries issued to a stopped engine will attempt to start the engine first. |
| auto_stop | INTEGER | Indicates the amount of time (in minutes) after which the engine automatically stops. |
| auto_vacuum | BOOLEAN | Indicates whether VACUUM is enabled or disabled by the user. Could also be NULL to indicate that VACUUM is automatically enabled by default. |
| engine_type | TEXT | [DEPRECATED] The type of the engine. |
| initially_stopped | BOOLEAN | When true, the engine will have attempted to start after creation. |
| url | TEXT | A url which can be used to issue queries to this engine. |
| warmup | TEXT | [DEPRECATED] The warmup method of the engine. |
| default_database | TEXT | The database an engine will attempt to use by default when dealing with queries that require a database. |
| version | TEXT | The engine version. |
| 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. |