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

Information from this view can be expensive as it queries 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               |
+---------------+---------+------------------------+-------------+-----------+------------------+----------------+-----------------+---------------+------------------+-----------------+