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).

Was this article helpful?