# 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                                                                                                                                                                                                                                                                                                                                 |
| ------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `UPLOAD_QUEUE_WAIT_SECS`              | Number of seconds the uploads to remote storage are delayed in the entirecluster.                                                                                                                                                                                                                                                           |
| `UPLOAD_MB_PER_SEC`                   | The rate at which files are being uploaded to remote storage in the entirecluster.                                                                                                                                                                                                                                                          |
| `LAST_UPLOAD_RESULT`                  | If all partitions in theclusterreport 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 entirecluster.                                                                                                                                                                                                                                                 |
| `BLOB_CACHE_EVICTION_MB_PER_SEC`      | Rate at which the blob cache is evicting files in the entirecluster, per second.                                                                                                                                                                                                                                                            |
| `OLDEST_DATA_AGE_DAYS`                | Age of the oldest piece of data in the entirecluster.                                                                                                                                                                                                                                                                                       |
| `API_REQUESTS_PER_SEC`                | Rate of API requests made to remote storage in the entirecluster.                                                                                                                                                                                                                                                                           |
| `IS_BEING_RATE_LIMITED`               | Indicates whether any node in the entireclusteris being rate limited on API requests to remote storage. On S3, rate limiting starts when we receive`503 SLOWDOWN`errors.                                                                                                                                                                    |
| `BOTTLE_SERVICE_AVAILABILITY`         | Number of successful bottle service api calls per second to the total number of bottle service api calls per second (success + failed) over the last 30 seconds. It is calculated as:`BOTTLE_SERVICE_AVAILABILITY = SUCCESS_BOTTLE_SERVICE_API_PER_SECOND / (SUCCESS_BOTTLE_SERVICE_API_PER_SECOND + FAILED_BOTTLE_SERVICE_API_PER_SECOND)` |
| `OBJECT_STORE_AVAILABILITY`           | Number of successful bottomless api calls per second to the total number of bottomless api calls per second (success + failed) over the last 30 seconds. It is calculated as:`OBJECT_STORE_AVAILABILITY = SUCCESS_API_PER_SECOND / (SUCCESS_API_PER_SECOND + FAILED_API_PER_SECOND)`                                                        |
| `IS_BOTTLE_SERVICE_UP`                | Shows`false`if any node's bottle service heartbeat is down.                                                                                                                                                                                                                                                                                 |
| `BOTTLE_SERVICE_UPTIME_DOWNTIME_SECS` | Shows the maximum downtime (in seconds) if any node's bottle service heartbeat is down, else if all node's bottle service heartbeat is up, it shows the minimum uptime.                                                                                                                                                                     |
| `UPLOAD_BLOB_LEAD_PAGES`              | Specifies the amount of log data queued for upload but not yet persisted to the remote storage. This is calculated as the difference between the maximum of`BLOB_PERSISTED_LSN`and`LOG_PERSISTED_LSN`from`MV_BOTTOMLESS_STATUS_EXTENDED`information schema view.                                                                            |

Example:

```sql
SELECT * FROM information_schema.MV_BOTTOMLESS_SUMMARY;

```

```output

+------------------------+-------------------+--------------------+--------------------------------+--------------------------------+----------------------+----------------------+-----------------------+---------------------------+-----------------------------+----------------------+-------------------------------------+------------------------+
| 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 | OBJECT_STORE_AVAILABILITY | BOTTLE_SERVICE_AVAILABILITY | IS_BOTTLE_SERVICE_UP | BOTTLE_SERVICE_UPTIME_DOWNTIME_SECS | UPLOAD_BLOB_LEAD_PAGES |
+------------------------+-------------------+--------------------+--------------------------------+--------------------------------+----------------------+----------------------+-----------------------+---------------------------+-----------------------------+----------------------+-------------------------------------+------------------------+
|                      0 |                 0 | Success            |                              0 |                              0 |               6.9887 |   0.3706105867031148 |                     0 |                         1 |                           1 |                    1 |                                1484 |                      2 |
+------------------------+-------------------+--------------------+--------------------------------+--------------------------------+----------------------+----------------------+-----------------------+---------------------------+-----------------------------+----------------------+-------------------------------------+------------------------+

```

***

Modified at: May 27, 2026

Source: [/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-summary/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-summary/)

(An index of the documentation is available at /llms.txt)