MV_BOTTOMLESS_SUMMARY

This view is an at-a-glance rollup table the shows what is happening at the moment with the unlimited storage workspace.

It consolidates a lot of the detailed information in the MV_BOTTOMLESS_STATUS_EXTENDED view and displays it in one smaller, easy to read table.

Column name

Description

UPLOAD_QUEUE_WAIT_SECS

Number of seconds the uploads to remote storage are delayed in the entire workspace.

UPLOAD_MB_PER_SEC

The rate at which files are being uploaded to remote storage in the entire workspace.

LAST_UPLOAD_RESULT

If all partitions in the workspace report SUCCESS for upload, then this reports SUCCESS.

BLOB_CACHE_DOWNLOAD_MB_PER_SEC

Rate at which the blob cache is downloading files from remote storage in the entire workspace.

BLOB_CACHE_EVICTION_MB_PER_SEC

Rate at which the blob cache is evicting files in the entire workspace, per second.

OLDEST_DATA_AGE_DAYS

Age of the oldest piece of data in the entire workspace.

API_REQUESTS_PER_SEC

Rate of API requests made to remote storage in the entire workspace.

IS_BEING_RATE_LIMITED

Indicates whether any node in the entire workspace is being rate limited on API requests to remote storage. On S3, rate limiting starts when we receive 503 SLOWDOWN errors.

Example:

SELECT * FROM information_schema.MV_BOTTOMLESS_SUMMARY;
+------------------------+-------------------+--------------------+--------------------------------+--------------------------------+----------------------+----------------------+-----------------------+
| UPLOAD_QUEUE_WAIT_SECS | UPLOAD_MB_PER_SEC | LAST_UPLOAD_RESULT | BLOB_CACHE_DOWNLOAD_MB_PER_SEC | BLOB_CACHE_EVICTION_MB_PER_SEC | OLDEST_DATA_AGE_DAYS | API_REQUESTS_PER_SEC | IS_BEING_RATE_LIMITED |
+------------------------+-------------------+--------------------+--------------------------------+--------------------------------+----------------------+----------------------+-----------------------+
|                    0.3 |  65.8199313476182 | Success            |               4.39891453458896 |             131.24585362684732 |               0.9862 |     68.3373684189926 |                     0 |
+------------------------+-------------------+--------------------+--------------------------------+--------------------------------+----------------------+----------------------+-----------------------+

Last modified: June 7, 2023

Was this article helpful?