MV_ BOTTOMLESS_ REMOTE_ STATS
This view gives a breakdown of the remote storage information for each unlimited storage database, both reference and partition.
Each output row gives the full breakdown of the database only if all the information is present, otherwise it gives a single NULL row if anything is missing.
Information from this view can be expensive as it queries remote storage.
Column name |
Description |
---|---|
|
Name of the database. |
|
Ordinal of the database if it is a partition database, NULL for reference database. |
|
Storage ID of the database. |
|
Size of blob files in remote storage, in bytes. |
|
Number of blob files in remote storage. |
|
Size of log chunk files in remote storage, in bytes. |
|
Number of log chunk files in remote storage. |
|
Size of snapshot files in remote storage, in bytes. |
|
Number of snapshot files in remote storage. |
|
Size of other files in remote storage, in bytes. |
|
Number of other files in remote storage. |
Example:
SELECT * FROM information_schema.MV_BOTTOMLESS_REMOTE_STATS;
+---------------+---------+------------------------+-------------+-----------+------------------+----------------+-----------------+---------------+------------------+-----------------+
| DATABASE_NAME | ORDINAL | STORAGE_ID | BLOBS_BYTES | NUM_BLOBS | LOG_CHUNKS_BYTES | NUM_LOG_CHUNKS | SNAPSHOTS_BYTES | NUM_SNAPSHOTS | OTHER_FILE_BYTES | NUM_OTHER_FILES |
+---------------+---------+------------------------+-------------+-----------+------------------+----------------+-----------------+---------------+------------------+-----------------+
| x_db | 0 | 10930645997319398241:1 | 0 | 0 | 0 | 0 | 432 | 1 | 0 | 0 |
| x_db | NULL | 10930645997319398241:1 | 0 | 0 | 0 | 0 | 431 | 1 | 186 | 3 |
| x_db | 1 | 10930645997319398241:1 | 0 | 0 | 0 | 0 | 432 | 1 | 0 | 0 |
+---------------+---------+------------------------+-------------+-----------+------------------+----------------+-----------------+---------------+------------------+-----------------+
Last modified: June 7, 2023