MV_BOTTOMLESS_SUMMARY
This view is an at-a-glance rollup table the shows what is happening at the moment with the unlimited storage cluster.
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 |
|---|---|
| Number of seconds the uploads to remote storage are delayed in the entire cluster. |
| The rate at which files are being uploaded to remote storage in the entire cluster. |
| If all partitions in the cluster report SUCCESS for upload, then this reports SUCCESS. |
| Rate at which the blob cache is downloading files from remote storage in the entire cluster. |
| Rate at which the blob cache is evicting files in the entire cluster, per second. |
| Age of the oldest piece of data in the entire cluster. |
| Rate of API requests made to remote storage in the entire cluster. |
| Indicates whether any node in the entire cluster is being rate limited on API requests to remote storage. On S3, rate limiting starts when we receive |
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 | +------------------------+-------------------+--------------------+--------------------------------+--------------------------------+----------------------+----------------------+-----------------------+