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. This means there is either an accurate view of remote storage, or a single NULL row which means "we don’t know, try again".

The number shown in the "_BYTES" columns is the physical, post-compression size (Unlimited Storage does not utilize compression, so the unlimited storage is not directly comparable to the on-disk size). Rowstore data is tracked as snapshots and logs, and columnstore data is tracked as blobs.

Information from this view can be expensive as it queries remote storage.

Column name

Description

DATABASE_NAME

Name of the database.

ORDINAL

Ordinal of the database if it is a partition database, NULL for reference database.

STORAGE_ID

Storage ID of the database.

BLOBS_BYTES

Size of blob files in remote storage, in bytes.

NUM_BLOBS

Number of blob files in remote storage.

LOG_CHUNKS_BYTES

Size of log chunk files in remote storage, in bytes.

NUM_LOG_CHUNKS

Number of log chunk files in remote storage.

SNAPSHOTS_BYTES

Size of snapshot files in remote storage, in bytes.

NUM_SNAPSHOTS

Number of snapshot files in remote storage.

OTHER_FILE_BYTES

Size of other files in remote storage, in bytes.

NUM_OTHER_FILES

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: March 13, 2024

Was this article helpful?