MV_CACHED_BLOBS

This view stores information about currently cached blobs.

Learn more about interpreting this view in the Components to Monitor guide.

Column Name

Description

NODE_ID

The ID of the node on which the blob is cached.

FILE_NAME

The on-disk filename of the blob (not the S3 path).

DATABASE_NAME

The name of the related database.

ORDINAL

The partition ordinal of the database, if relevant.

STATUS

The status of the blob:

  • Fetch error. Fetch will be retried on next request.

  • Cached

  • Downloading

MOST_RECENT_TIMESTAMP_TICKS

The internal timestamp of the most recent scan access to the blob. This is the primary timestamp used for LRU2 eviction.

SECOND_MOST_RECENT_TIMESTAMP_TICKS

The internal timestamp of the second most recent scan access to the blob. This is the tie-breaker timestamp used for LRU2 eviction.

EVICTABLE

Whether the blob can be evicted (Yes or No). A blob is not evictable while a query references it or before it has been uploaded to S3.

SIZE

The size of the blob, in bytes.

TYPE

Whether the blob belongs to a primary or replica partition of the database (Primary or Replica).

Last modified:

Was this article helpful?