Back to Clickhouse

system.view_refreshes

docs/en/operations/system-tables/view_refreshes.md

26.4.1.1-new1.2 KB
Original Source

import SystemTableCloud from '@site/docs/_snippets/_system_table_cloud.md';

system.view_refreshes

Information about Refreshable Materialized Views. Contains all refreshable materialized views, regardless of whether there's a refresh in progress or not.

Columns:

<!--AUTOGENERATED_START--> <!--AUTOGENERATED_END-->

Example

sql
SELECT
    database,
    view,
    status,
    last_refresh_result,
    last_refresh_time,
    next_refresh_time
FROM system.view_refreshes

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