MV_BOTTOMLESS_STATUS_EXTENDED

This view provides more diagnostic information compared to MV_BOTTOMLESS_STATUS, such as more detailed LSN, upload statistics, API statistics, and logchunk/snapshot information.

Columns CLEANUP_LSN, REMOTE_LOG_CHUNKS, REMOTE_SNAPSHOTS, LOCAL_LOG_FILES, LOG_FILE_LIST, SNAPSHOT_FILE_LIST, query the remote storage and could slow down the information_schema.

Column name

Description

DATABASE_NAME

Name of the database.

STORAGE_ID

Storage ID of the database.

COMPUTE_ID

Compute ID of the database.

STORAGE_DIRECTORY

Remote storage directory path for the database.

BUCKET

Remote storage bucket located for the database.

ROLE

Current role of the database (primary / secondary / offline).

TERM

A unique identifier of the current master instance of the database.

LOG_PERSISTED_LSN

Log sequence number below which all log chunks have been permanently stored to remote storage.

LOG_ENQUEUED_LSN

Log sequence number below which all blob files have been enqueued for permanent storage to remote storage.

BLOB_PERSISTED_LSN

Log sequence number below which all log chunks have been enqueued for permanent storage to remote storage.

BLOB_ENQUEUED_LSN

Log sequence number below which all blob files have been enqueued for persistence to remote storage.

COMMIT_LSN

Position in the log before which all pages have been committed. All content is committed in the pages that are in the log before this log sequence number.

HARDENED_LSN

Position in the log before which all pages have been written to the disk.

REPLAY_LSN

Position in the log before which all pages have been replayed into memory.

TAIL_LSN

Position in the log before which all pages have been reserved for transactions. The next transaction to reserve space from the log will start writing at this log sequence number.

CLEANUP_LSN

The log sequence number of the highest cleanup file in the remote snapshot directory.

OLDEST_VALID_LSN

Log content below this log sequence number is invalid and must not be referenced by anyone.

LOG_PERSISTED_END_TAG_VERSION

EndTag version below which all log chunks have been persisted stored to remote storage.

UPLOAD_QUEUE_WAIT_SECS

Number of seconds by which the uploads to remote storage are lagging behind.

UPLOADED_BYTES

Number of bytes uploaded.

SECS_SINCE_LAST_UPLOAD

The number of seconds since the last attempted upload.

LAST_UPLOAD_RESULT

The result of the last attempted upload.

BLOB_CACHE_DOWNLOAD_MB_PER_SEC

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

BLOB_CACHE_EVICTION_MB_PER_SEC

Rate at which the blob cache is evicting files.

BLOB_CACHE_DOWNLOADED_BYTES

Number of bytes downloaded by the blob cache.

BLOB_CACHE_EVICTED_BYTES

Number of bytes evicted by the blob cache.

BLOB_CACHE_DOWNLOADED_FILES

Number of files downloaded by the blob cache.

BLOB_CACHE_EVICTED_FILES

Number of files evicted by the blob cache.

BACKGROUND_THREAD_UPLOADS

Number of uploads made by the background thread.

INGEST_THREAD_UPLOADS

Number of uploads made by an ingest thread. This indicates whether and how much ingest has been throttled to keep bottomless uploads up to date.

OLDEST_DATA_UNIX_TIMESTAMP

Timestamp when the oldest piece of data became garbage collectable. If this value is near the current timestamp minus the bottomless_gc_retention_period_minutes, then unlimited garbage collection (gc) is keeping up.

NUM_GET_REQUESTS

Number of GET requests made to remote storage.

GET_REQUESTS_PER_SEC

Rate of GET requests made to remote storage.

NUM_POST_REQUESTS

Number of POST requests made to remote storage.

POST_REQUESTS_PER_SEC

Rate of POST requests made to remote storage.

NUM_PUT_REQUESTS

Number of PUT requests made to remote storage.

PUT_REQUESTS_PER_SEC

Rate of PUT requests made to remote storage.

NUM_HEAD_REQUESTS

Number of HEAD requests made to remote storage.

HEAD_REQUESTS_PER_SEC

Rate of HEAD requests made to remote storage.

NUM_DELETE_REQUESTS

Number of DELETE requests made to remote storage.

DELETE_REQUESTS_PER_SEC

Rate of DELETE requests made to remote storage.

NUM_OUTSTANDING_REQUESTS

Number of outstanding API requests to be made to remote storage.

NUM_RETRIED_REQUESTS

Number of retried API requests made to remote storage.

IS_BEING_RATE_LIMITED

Whether API requests to remote storage are being rate limited. On S3, rate limiting starts when we receive 503 SLOWDOWN errors.

REMOTE_LOG_CHUNKS

List of tuples of log chunk beginLSN and endLSN.

REMOTE_SNAPSHOTS

List of log sequence numbers of valid remote snapshots.

LOCAL_LOG_FILES

List of begin log sequence numbers of local log files on disk.

LOG_FILE_LIST

List of begin log sequence numbers of files listed in the log.

SNAPSHOT_FILE_LIST

List of snapshot log sequence numbers of files listed in the log.

NODE_ID

ID of the node where the database is located.

HOST

Host of the node where the database is located.

PORT

Port of the node where the database is located.

ORDINAL

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

Example:

SELECT * FROM information_schema.MV_BOTTOMLESS_STATUS_EXTENDED;
+---------------+------------------------+------------------------+----------------------------------------------+----------+---------+------------------+-------------------+------------------+--------------------+-------------------+------------+--------------+------------+----------+-------------+------------------+-------------------------------+------------------------+-------------------+----------------+------------------------+--------------------+--------------------------------+--------------------------------+-----------------------------+--------------------------+-----------------------------+--------------------------+---------------------------+-----------------------+----------------------------+------------------+----------------------+-------------------+-----------------------+------------------+----------------------+-------------------+-----------------------+---------------------+-------------------------+--------------------------+----------------------+-----------------------+-------------------+------------------+-----------------+---------------+--------------------+---------+-----------+-------+---------+
| DATABASE_NAME | STORAGE_ID             | COMPUTE_ID             | STORAGE_DIRECTORY                            | BUCKET   | ROLE    | TERM             | LOG_PERSISTED_LSN | LOG_ENQUEUED_LSN | BLOB_PERSISTED_LSN | BLOB_ENQUEUED_LSN | COMMIT_LSN | HARDENED_LSN | REPLAY_LSN | TAIL_LSN | CLEANUP_LSN | OLDEST_VALID_LSN | LOG_PERSISTED_END_TAG_VERSION | UPLOAD_QUEUE_WAIT_SECS | UPLOAD_MB_PER_SEC | UPLOADED_BYTES | SECS_SINCE_LAST_UPLOAD | LAST_UPLOAD_RESULT | BLOB_CACHE_DOWNLOAD_MB_PER_SEC | BLOB_CACHE_EVICTION_MB_PER_SEC | BLOB_CACHE_DOWNLOADED_BYTES | BLOB_CACHE_EVICTED_BYTES | BLOB_CACHE_DOWNLOADED_FILES | BLOB_CACHE_EVICTED_FILES | BACKGROUND_THREAD_UPLOADS | INGEST_THREAD_UPLOADS | OLDEST_DATA_UNIX_TIMESTAMP | NUM_GET_REQUESTS | GET_REQUESTS_PER_SEC | NUM_POST_REQUESTS | POST_REQUESTS_PER_SEC | NUM_PUT_REQUESTS | PUT_REQUESTS_PER_SEC | NUM_HEAD_REQUESTS | HEAD_REQUESTS_PER_SEC | NUM_DELETE_REQUESTS | DELETE_REQUESTS_PER_SEC | NUM_OUTSTANDING_REQUESTS | NUM_RETRIED_REQUESTS | IS_BEING_RATE_LIMITED | REMOTE_LOG_CHUNKS | REMOTE_SNAPSHOTS | LOCAL_LOG_FILES | LOG_FILE_LIST | SNAPSHOT_FILE_LIST | NODE_ID | HOST      | PORT  | ORDINAL |
+---------------+------------------------+------------------------+----------------------------------------------+----------+---------+------------------+-------------------+------------------+--------------------+-------------------+------------+--------------+------------+----------+-------------+------------------+-------------------------------+------------------------+-------------------+----------------+------------------------+--------------------+--------------------------------+--------------------------------+-----------------------------+--------------------------+-----------------------------+--------------------------+---------------------------+-----------------------+----------------------------+------------------+----------------------+-------------------+-----------------------+------------------+----------------------+-------------------+-----------------------+---------------------+-------------------------+--------------------------+----------------------+-----------------------+-------------------+------------------+-----------------+---------------+--------------------+---------+-----------+-------+---------+
| x_db          | 10930645997319398241:1 | 10930645997319398241:1 |  cadccdac/10930645997319398241_1/ref         | s3bucket | master  | 2251799813685329 | 0                 | 0                | 0                  | 0                 | 3          | 3            | NULL       | 3        | 0           | 0                | NULL                          | 0                      | 0                 | 0              | NULL                   | NULL               | 0                              | 0                              | 0                           | 0                        | 0                           | 0                        | 0                         | 0                     | NULL                       | 10               | 0.3333333555555548   | 0                 | 0                     | 5                | 0.16666669444444351  | 1                 | 0.03333336555555448   | 0                   | 0                       | 0                        | 0                    | 0                     | []                | []               | [0,4096]        | [0,4096]      | [0]                | 1       | 127.0.0.1 | 10000 | NULL    |
| x_db          | 10930645997319398241:1 | 10930645997319398241:1 |  cadccdac/10930645997319398241_1/ref         | s3bucket | replica | 2251799813685329 | 0                 | NULL             | 0                  | NULL              | 2          | 3            | 2          | 3        | 0           | 0                | NULL                          | 0                      | NULL              | 0              | NULL                   | NULL               | 0                              | 0                              | 0                           | 0                        | 0                           | 0                        | 0                         | 0                     | NULL                       | 10               | 0.3333333555555548   | 0                 | 0                     | 0                | 0                    | 1                 | 0.03333336555555448   | 0                   | 0                       | 0                        | 0                    | 0                     | []                | []               | [0,4096]        | [0,4096]      | [0]                | 2       | 127.0.0.1 | 10001 | NULL    |
| x_db          | 10930645997319398241:1 | 10930645997319398241:1 |  acdcadcc/10930645997319398241_1/partition_0 | s3bucket | master  | 2251799813685330 | 0                 | 0                | 0                  | 0                 | 2          | 2            | NULL       | 2        | 0           | 0                | NULL                          | 0                      | 0                 | 0              | NULL                   | NULL               | 0                              | 0                              | 0                           | 0                        | 0                           | 0                        | 0                         | 0                     | NULL                       | 10               | 0.3333333555555548   | 0                 | 0                     | 1                | 0.03333336555555448  | 1                 | 0.03333336555555448   | 0                   | 0                       | 0                        | 0                    | 0                     | []                | []               | [0,4096]        | [0,4096]      | [0]                | 2       | 127.0.0.1 | 10001 | 0       |
| x_db          | 10930645997319398241:1 | 10930645997319398241:1 |  abcdcddd/10930645997319398241_1/partition_1 | s3bucket | replica | 2251799813685331 | 0                 | NULL             | 0                  | NULL              | 1          | 2            | 1          | 2        | 0           | 0                | NULL                          | 0                      | NULL              | 0              | NULL                   | NULL               | 0                              | 0                              | 0                           | 0                        | 0                           | 0                        | 0                         | 0                     | NULL                       | 11               | 0.36666668777777706  | 0                 | 0                     | 0                | 0                    | 1                 | 0.03333336555555448   | 0                   | 0                       | 0                        | 0                    | 0                     | []                | []               | [0,4096]        | [0,4096]      | [0]                | 2       | 127.0.0.1 | 10001 | 1       |
| x_db          | 10930645997319398241:1 | 10930645997319398241:1 |  cadccdac/10930645997319398241_1/ref         | s3bucket | replica | 2251799813685329 | 0                 | NULL             | 0                  | NULL              | 2          | 3            | 2          | 3        | 0           | 0                | NULL                          | 0                      | NULL              | 0              | NULL                   | NULL               | 0                              | 0                              | 0                           | 0                        | 0                           | 0                        | 0                         | 0                     | NULL                       | 10               | 0.3333333555555548   | 0                 | 0                     | 0                | 0                    | 1                 | 0.03333336555555448   | 0                   | 0                       | 0                        | 0                    | 0                     | []                | []               | [0,4096]        | [0,4096]      | [0]                | 3       | 127.0.0.1 | 10002 | NULL    |
| x_db          | 10930645997319398241:1 | 10930645997319398241:1 |  acdcadcc/10930645997319398241_1/partition_0 | s3bucket | replica | 2251799813685330 | 0                 | NULL             | 0                  | NULL              | 1          | 2            | 1          | 2        | 0           | 0                | NULL                          | 0                      | NULL              | 0              | NULL                   | NULL               | 0                              | 0                              | 0                           | 0                        | 0                           | 0                        | 0                         | 0                     | NULL                       | 11               | 0.36666668777777706  | 0                 | 0                     | 0                | 0                    | 1                 | 0.03333336555555448   | 0                   | 0                       | 0                        | 0                    | 0                     | []                | []               | [0,4096]        | [0,4096]      | [0]                | 3       | 127.0.0.1 | 10002 | 0       |
| x_db          | 10930645997319398241:1 | 10930645997319398241:1 |  abcdcddd/10930645997319398241_1/partition_1 | s3bucket | master  | 2251799813685331 | 0                 | 0                | 0                  | 0                 | 2          | 2            | NULL       | 2        | 0           | 0                | NULL                          | 0                      | 0                 | 0              | NULL                   | NULL               | 0                              | 0                              | 0                           | 0                        | 0                           | 0                        | 0                         | 0                     | NULL                       | 10               | 0.3333333555555548   | 0                 | 0                     | 1                | 0.03333336555555448  | 1                 | 0.03333336555555448   | 0                   | 0                       | 0                        | 0                    | 0                     | []                | []               | [0,4096]        | [0,4096]      | [0]                | 3       | 127.0.0.1 | 10002 | 1       |
+---------------+------------------------+------------------------+----------------------------------------------+----------+---------+------------------+-------------------+------------------+--------------------+-------------------+------------+--------------+------------+----------+-------------+------------------+-------------------------------+------------------------+-------------------+----------------+------------------------+--------------------+--------------------------------+--------------------------------+-----------------------------+--------------------------+-----------------------------+--------------------------+---------------------------+-----------------------+----------------------------+------------------+----------------------+-------------------+-----------------------+------------------+----------------------+-------------------+-----------------------+---------------------+-------------------------+--------------------------+----------------------+-----------------------+-------------------+------------------+-----------------+---------------+--------------------+---------+-----------+-------+---------+

Last modified: June 7, 2023

Was this article helpful?