MV_BOTTOMLESS_DATABASES

This view provides basic information about all the databases on an unlimited storage cluster. Includes databases currently attached on the cluster, as well as any detached databases.

Column name	Description
`DATABASE_NAME`	Name of the database.
`STORAGE_ID`	The unique ID of the storage backing the unlimited storage database.
`COMPUTE_ID`	Compute ID of the database.
`CREATED_TIME`	Time at which the unlimited storage database was created.
`IS_DETACHED`	Values can be "DETACHED" or "ATTACHED" depending on whether the database is currently detached or attached.
`RETENTION_PERIOD_MINUTES`	Minimum period of time, in minutes, before GC will clean up remote storage. Configured via `bottomless_gc_retention_period_minutes`.
`EARLIEST_AVAILABLE_TIME`	Earliest timestamp at which this database is attachable.
`LAST_DETACHED_MILESTONE`	The most recent milestone at which this database was detached.
`STORAGE_CONFIG`	The unlimited storage configuration information which with this database was created.
`STORAGE_TYPE`	The cloud service provider (S3/Azure/GCP) on which the storage for this unlimited storage database exists.
`HAS_METADATA_SERVICE`	Whether this database has the unlimited storage metadata service enabled.
`MEMORY_USE_ON_DETACH`	The memory usage, in bytes, of this unlimited storage database's storage at time of detach. NULL if the database is attached (this column is not used for tracking memory usage of active databases).

Example:

Version 8.5 and newer:

SQL

SELECT * FROM information_schema.MV_BOTTOMLESS_DATABASES;

+-----------------+------------------------------------------+-------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+----------------------+----------------------+
| DATABASE_NAME   | STORAGE_ID                               | COMPUTE_ID              | CREATED_TIME        | IS_DETACHED | RETENTION_PERIOD_MINUTES | EARLIEST_AVAILABLE_TIME | LAST_DETACHED_MILESTONE    | STORAGE_CONFIG                                       | STORAGE_TYPE | HAS_METADATA_SERVICE | MEMORY_USE_ON_DETACH |
+-----------------+------------------------------------------+-------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+----------------------+----------------------+
| attached_db     | 2396611468173586007:12754783369249135506 | 16632719075037216741:5  | 2023-09-12 12:00:02 | ATTACHED    | 1440                     | 2023-09-12 12:00:02     |                            | {"endpoint_url": "http://storage_provider_endpoint"} | S3           | 0                    | NULL                 |
| detached_db     | 7514729589540251805:4355643310554835616  | NULL                    | 2023-09-12 12:01:01 | DETACHED    | 1440                     | 2023-09-12 12:01:01     | 2023-09-12 12_01_17.682054 | {"endpoint_url": "http://storage_provider_endpoint"} | S3           | 0                    | 0                    |
+-----------------+------------------------------------------+-------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+----------------------+----------------------+

Versions 7.6 through 8.1:

SQL

+-----------------+------------------------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+--------------+
| DATABASE_NAME   | STORAGE_ID                               | CREATED_TIME        | IS_DETACHED | RETENTION_PERIOD_MINUTES | EARLIEST_AVAILABLE_TIME | LAST_DETACHED_MILESTONE    | STORAGE_CONFIG                                       | STORAGE_TYPE | MEMORY_USAGE |
+-----------------+------------------------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+--------------+
| attached_db     | 2396611468173586007:12754783369249135506 | 2023-09-12 12:00:02 | ATTACHED    | 1440                     | 2023-09-12 12:00:02     |                            | {"endpoint_url": "http://storage_provider_endpoint"} | S3           | NULL         |
| detached_db     | 7514729589540251805:4355643310554835616  | 2023-09-12 12:01:01 | DETACHED    | 1440                     | 2023-09-12 12:01:01     | 2023-09-12 12_01_17.682054 | {"endpoint_url": "http://storage_provider_endpoint"} | S3           | 0            |
+-----------------+------------------------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+--------------+

MV_BOTTOMLESS_DATABASES

Was this article helpful?

Was this article helpful?