MV_ BOTTOMLESS_ STATUS_ EXTENDED
This view provides more diagnostic information compared to MV_
, such as more detailed LSN, upload statistics, API statistics, and logchunk/snapshot information.
Columns CLEANUP_
, query the remote storage and could slow down the information_
Column name |
Description |
---|---|
|
Name of the database. |
|
Storage ID of the database. |
|
Compute ID of the database. |
|
Values can be 'Legacy', 'Broken', or 'Full' which indicates: none, unhealthy, or healthy. |
|
Remote storage directory path for the database. |
|
Remote storage bucket located for the database. |
|
Current role of the database (primary / secondary / offline). |
|
A unique identifier of the current master instance of the database. |
|
Log sequence number below which all log chunks have been permanently stored to remote storage. |
|
Log sequence number below which all blob files have been enqueued for permanent storage to remote storage. |
|
Log sequence number below which all log chunks have been enqueued for permanent storage to remote storage. |
|
Log sequence number below which all blob files have been enqueued for persistence to remote storage. |
|
Position in the log before which all pages have been committed. |
|
Position in the log before which all pages have been written to the disk. |
|
Position in the log before which all pages have been replayed into memory. |
|
Position in the log before which all pages have been reserved for transactions. |
|
The log sequence number of the highest cleanup file in the remote snapshot directory. |
|
Log content below this log sequence number is invalid and must not be referenced by anyone. |
|
EndTag version below which all log chunks have been persisted stored to remote storage. |
|
Number of seconds by which the uploads to remote storage are lagging behind. |
|
Number of bytes uploaded. |
|
The number of seconds since the last attempted upload. |
|
The result of the last attempted upload. |
|
Rate at which the blob cache is downloading files from remote storage. |
|
Rate at which the blob cache is evicting files. |
|
Number of bytes downloaded by the blob cache. |
|
Number of bytes evicted by the blob cache. |
|
Number of files downloaded by the blob cache. |
|
Number of files evicted by the blob cache. |
|
Number of uploads made by the background thread. |
|
Number of uploads made by an ingest thread. |
|
Timestamp when the oldest piece of data became garbage collectable. |
|
Number of GET requests made to remote storage. |
|
Rate of GET requests made to remote storage. |
|
Number of POST requests made to remote storage. |
|
Rate of POST requests made to remote storage. |
|
Number of PUT requests made to remote storage. |
|
Rate of PUT requests made to remote storage. |
|
Number of HEAD requests made to remote storage. |
|
Rate of HEAD requests made to remote storage. |
|
Number of DELETE requests made to remote storage. |
|
Rate of DELETE requests made to remote storage. |
|
Number of outstanding API requests to be made to remote storage. |
|
Number of retried API requests made to remote storage. |
|
Whether API requests to remote storage are being rate limited. |
|
Total number of successful api calls to remote storage. |
|
Total number of failed api calls to remote storage. |
|
Number of successful remote storage api calls per second over the last 30 seconds. |
|
Number of failed remote storage api calls per second over the last 30 seconds. |
|
Average latency to complete a remote storage api event over the past 30 seconds. |
|
Average latency of receiving a response for a remote storage api request. |
|
Whether unlimited storage GC is running currently. |
|
Total number of remote files deleted. |
|
Number of rate limiting slow downs on api calls to remote storage. |
|
List of tuples of log chunk beginLSN and endLSN. |
|
List of log sequence numbers of valid remote snapshots. |
|
List of begin log sequence numbers of local log files on disk. |
|
List of begin log sequence numbers of files listed in the log. |
|
List of snapshot log sequence numbers of files listed in the log. |
|
ID of the node where the database is located. |
|
Host of the node where the database is located. |
|
Port of the node where the database is located. |
|
Ordinal of the database if it is a partition database, NULL for reference database. |
|
Number of failed bottle service api calls per second over
the last 30 seconds. |
Example:
SELECT * FROM information_schema.MV_BOTTOMLESS_STATUS_EXTENDED;
+---------------+---------------+---------------+---------------+-----------------------+------------+--------+------+-------------------+------------------+--------------------+-------------------+------------+--------------+------------+----------+-------------+------------------+-------------------------------+------------------------+-----------------------+----------------+------------------------+--------------------+--------------------------------+--------------------------------+-----------------------------+--------------------------+-----------------------------+--------------------------+---------------------------+-----------------------+----------------------------+-------------------+-------------------+-----------------------+------------------------+------------------------+------------------+----------------------+-------------------+-----------------------+------------------+----------------------+-------------------+-----------------------+---------------------+-------------------------+--------------------------+----------------------+-----------------------+--------------------------+-------------------------+-------------------------+------------------------+---------------+--------------------------+----------------+-------------------+------------------+-----------------+---------------+--------------------+---------+-----------+-------+---------+
| DATABASE_NAME | STORAGE_ID | COMPUTE_ID | COMPUTE_STATE | 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 | NEXT_DEADLINE_LSN | LAST_DEADLINE_LSN | NEXT_DEADLINE_VERSION | VH_OF_OLDEST_VALID_LSN | VL_OF_OLDEST_VALID_LSN | 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 | NUM_SUCCESS_API_REQUESTS | NUM_FAILED_API_REQUESTS | LATEST_API_FAILURE_RATE | AVERAGE_API_LATENCY_US | IS_GC_RUNNING | NUM_REMOTE_FILES_DELETED | NUM_SLOW_DOWNS | REMOTE_LOG_CHUNKS | REMOTE_SNAPSHOTS | LOCAL_LOG_FILES | LOG_FILE_LIST | SNAPSHOT_FILE_LIST | NODE_ID | HOST | PORT | ORDINAL |
+---------------+---------------+---------------+---------------+-----------------------+------------+--------+------+-------------------+------------------+--------------------+-------------------+------------+--------------+------------+----------+-------------+------------------+-------------------------------+------------------------+-----------------------+----------------+------------------------+--------------------+--------------------------------+--------------------------------+-----------------------------+--------------------------+-----------------------------+--------------------------+---------------------------+-----------------------+----------------------------+-------------------+-------------------+-----------------------+------------------------+------------------------+------------------+----------------------+-------------------+-----------------------+------------------+----------------------+-------------------+-----------------------+---------------------+-------------------------+--------------------------+----------------------+-----------------------+--------------------------+-------------------------+-------------------------+------------------------+---------------+--------------------------+----------------+-------------------+------------------+-----------------+---------------+--------------------+---------+-----------+-------+---------+
| x_db | 1789...990118 | 1169...1454:1 | Full | cabd/1755_10...18/ref | bottomless | master | 3 | 8 | 8 | 10 | 10 | 10 | 10 | NULL | 10 | 0 | 0 | 2199023255496 | 0 | 0.0009117126161257436 | 32784 | 21.3 | Success | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | NULL | NULL | NULL | NULL | 1 | 1 | 22 | 0.100000029999999 | 0 | 0 | 5 | 0.03333336555555448 | 4 | 0 | 0 | 0 | 0 | 1 | 0 | 25 | 6 | 0 | 35317 | 0 | 0 | 0 | [[0,1],[1,8]] | [0,1] | [0,4096] | [0,4096] | [0,1] | 1 | 127.0.0.1 | 10000 | NULL |
+---------------+---------------+---------------+---------------+-----------------------+------------+--------+------+-------------------+------------------+--------------------+-------------------+------------+--------------+------------+----------+-------------+------------------+-------------------------------+------------------------+-----------------------+----------------+------------------------+--------------------+--------------------------------+--------------------------------+-----------------------------+--------------------------+-----------------------------+--------------------------+---------------------------+-----------------------+----------------------------+-------------------+-------------------+-----------------------+------------------------+------------------------+------------------+----------------------+-------------------+-----------------------+------------------+----------------------+-------------------+-----------------------+---------------------+-------------------------+--------------------------+----------------------+-----------------------+--------------------------+-------------------------+-------------------------+------------------------+---------------+--------------------------+----------------+-------------------+------------------+-----------------+---------------+--------------------+---------+-----------+-------+---------+
Last modified: October 8, 2024