MV_
This view provides basic information about all the databases on an unlimited storage cluster.
|
Column name |
Description |
|---|---|
|
|
Name of the database. |
|
|
The unique ID of the storage backing the unlimited storage database. |
|
|
Values can be "DETACHED" or "ATTACHED" depending on whether the database is currently detached or attached. |
|
|
Minimum period of time, in minutes, before GC will clean up remote storage. Configured via |
|
|
Earliest timestamp at which this database is attachable. |
|
|
The most recent milestone at which this database was detached. |
|
|
The unlimited storage configuration information which with this database was created. |
|
|
The cloud service provider (S3/Azure/GCP) on which the storage for this unlimited storage database exists. |
|
|
In versions up to v8. The memory usage, in bytes, of this unlimited storage database's storage at time of detach. |
Example:
Versions 7.
+-----------------+------------------------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+--------------+| 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 |+-----------------+------------------------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+--------------+
Last modified: July 18, 2024