# 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/v9.1/user-and-cluster-administration/cluster-health-and-performance/components-to-monitor/#UUID-f938834d-7cd6-5643-75cb-266137b4c1a2.md) guide.

| 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:<ul> <li>Fetch error. Fetch will be retried on next request.</li> <li>Cached</li> <li>Downloading</li> </ul>    |
| `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).                                     |

***

Modified at: August 29, 2022

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

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