# MV\_CACHED\_BLOBS

This view stores information about currently cached blobs.

Learn more about interpreting this view in the [Components to Monitor](https://docs.singlestore.com/db/v10/user-and-cluster-administration/cluster-health-and-performance/components-to-monitor/#UUID-f938834d-7cd6-5643-75cb-266137b4c1a2.md) 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:<ul> <li>Fetch error. Fetch will be retried on next request.</li> <li>Cached</li> <li>Downloading</li> </ul>    |
| `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).                                       |

***

Modified at: November 6, 2026

Source: [/db/v10/reference/information-schema-reference/cluster-component/mv-cached-blobs/](https://docs.singlestore.com/db/v10/reference/information-schema-reference/cluster-component/mv-cached-blobs/)

(An index of the documentation is available at /llms.txt)
