MV_CACHED_BLOBS

This view stores information about currently cached blobs.

Column Name

Description

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

TIMESTAMP_TICKS

Internal timestamp of last access time for this blob.

EVICTABLE

Either yes or no. Blobs will not be evictable if a query is currently referencing them or if the blob has not yet been uploaded to S3.

SIZE

The size of the blob, in bytes.

TYPE

Whether the blob belongs to a primary or secondary partition of the database (primary, secondary).

Last modified: August 29, 2022

Was this article helpful?