PG_MATVIEW¶
PG_MATVIEW records materialized view information about the current node.
Column | Type | Description |
|---|---|---|
mvid | OID | OID of the materialized view. |
build_mode | Char | Build mode of the materialized view.
|
refresh_method | Char | Refresh method of the materialized view. 'c': indicates complete refresh. |
refresh_mode | Char | Refresh mode of the materialized view. 'd': stands for demand, indicating on-demand update. |
rewrite_enable | Boolean | Indicates whether query rewriting of the materialized view is supported. |
active | Boolean | Indicates whether the materialized view needs to be refreshed. |
relnum | Int | Number of materialized view base tables. |
start_time | timestamptz | Time when the materialized view is refreshed for the first time. If this parameter is left blank, the first refresh time is the current time plus the interval. |
interval | Interval | Interval for refreshing the materialized view. |
refresh_time | timestamptz | Last refresh time of the materialized view. |
refresh_finish_time | timestamptz | End time of the last refresh of a materialized view. |