> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8c05c8a2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing information about Refreshable Materialized Views.

# system.view_refreshes

<Info>
  **Querying in ClickHouse Cloud**

  The data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the `clusterAllReplicas` function. See [here](/reference/system-tables/overview#system-tables-in-clickhouse-cloud) for further details.
</Info>

<h2 id="description">
  Description
</h2>

Information about [Refreshable Materialized Views](/reference/statements/create/view#refreshable-materialized-view). Contains all refreshable materialized views, regardless of whether there's a refresh in progress or not.

<h2 id="columns">
  Columns
</h2>

* `database` ([String](/reference/data-types/index)) — The name of the database the table is in.
* `view` ([String](/reference/data-types/index)) — Table name.
* `uuid` ([UUID](/reference/data-types/index)) — Table uuid (Atomic database).
* `status` ([String](/reference/data-types/index)) — Current state of the refresh.
* `last_success_time` ([Nullable(DateTime)](/reference/data-types/index)) — Time when the latest successful refresh started. NULL if no successful refreshes happened since server startup or table creation.
* `last_success_duration_ms` ([Nullable(UInt64)](/reference/data-types/index)) — How long the latest refresh took.
* `last_refresh_time` ([Nullable(DateTime)](/reference/data-types/index)) — Time when the latest refresh attempt finished (if known) or started (if unknown or still running). NULL if no refresh attempts happened since server startup or table creation.
* `last_refresh_replica` ([String](/reference/data-types/index)) — If coordination is enabled, name of the replica that made the current (if running) or previous (if not running) refresh attempt.
* `next_refresh_time` ([Nullable(DateTime)](/reference/data-types/index)) — Time at which the next refresh is scheduled to start. NULL if the next refresh time is not currently known, e.g. when waiting for dependencies (status `WaitingForDependencies` or `MissingDependencies`).
* `exception` ([String](/reference/data-types/index)) — Error message from previous attempt if it failed.
* `retry` ([UInt64](/reference/data-types/index)) — How many failed attempts there were so far, for the current refresh. Not available if status is `RunningOnAnotherReplica`.
* `progress` ([Nullable(Float64)](/reference/data-types/index)) — Progress of the current running or most recently completed refresh at the given replica, between 0 and 1. NULL if status is `RunningOnAnotherReplica` or the refresh is not running.
* `read_rows` ([Nullable(UInt64)](/reference/data-types/index)) — Number of rows read by the current running or most recently completed refresh at the given replica. NULL if status is `RunningOnAnotherReplica`.
* `read_bytes` ([Nullable(UInt64)](/reference/data-types/index)) — Number of bytes read by the current running or most recently completed refresh at the given replica. NULL if status is `RunningOnAnotherReplica`
* `total_rows` ([Nullable(UInt64)](/reference/data-types/index)) — Estimated total number of rows that need to be read by the current running or most recently completed refresh at the given replica. NULL if status is `RunningOnAnotherReplica`
* `written_rows` ([Nullable(UInt64)](/reference/data-types/index)) — Number of rows written by the current running or most recently completed refresh at the given replica. NULL if status is `RunningOnAnotherReplica`
* `written_bytes` ([Nullable(UInt64)](/reference/data-types/index)) — Number of bytes written by the current running or most recently completed refresh at the given replica. NULL if status is `RunningOnAnotherReplica`

<h2 id="example">
  Example
</h2>

```sql theme={null}
SELECT
    database,
    view,
    status,
    last_refresh_time,
    next_refresh_time
FROM system.view_refreshes

┌─database─┬─view───────────────────────┬─status────┬───last_refresh_time─┬───next_refresh_time─┐
│ default  │ hello_documentation_reader │ Scheduled │ 2023-12-01 01:24:00 │ 2023-12-01 01:25:00 │
└──────────┴────────────────────────────┴───────────┴─────────────────────┴─────────────────────┘
```