# MV\_BLOB\_CACHE\_EVENTS

This view stores information about events pertaining to 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                                                                                                                                                                                                                        |
| --------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `NODE_ID`             | ID of the related node.                                                                                                                                                                                                            |
| `EVENT_TYPE`          | Either`fetch`or`eviction`:<ul> <li><code>fetch</code> - downloading a columnar blob file from S3.</li> <li><code>eviction</code> - deleting the blob file because it can be retrieved again from S3 later if necessary.</li> </ul> |
| `DATABASE_NAME`       | The name of the related database.                                                                                                                                                                                                  |
| `ORDINAL`             | The partition ordinal of the database, if relevant.                                                                                                                                                                                |
| `FILE_NAME`           | The on-disk filename of the blob (not the S3 path).                                                                                                                                                                                |
| `FILE_SIZE`           | The size of the blob, in bytes.                                                                                                                                                                                                    |
| `UNIX_TIMESTAMP`      | Timestamp of the event.                                                                                                                                                                                                            |
| `FETCH_TIME_TAKEN_MS` | Only applies for fetches. The time in milliseconds spent waiting on network for the blob fetch. This does not track time spent waiting for other fetches to complete before submitting the fetch for this blob.                    |

***

Modified at: August 29, 2022

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

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