PV_MATVIEW_DETAIL¶
PV_MATVIEW_DETAIL displays detailed information about a materialized view. This view is supported only by clusters of version 9.1.0 200 or later.
Column | Type | Description |
---|---|---|
matview | Text | Materialized view name |
baserel | Text | Base table name |
partids | oidvector | OID of a specified partition. |
contain_entire_rel | Boolean | Whether to create a materialized view based on the entire base table |
build_mode | Text | Build mode of the materialized view.
|
refresh_mode | Text | Refresh mode of the materialized view. 'd': stands for demand, indicating on-demand update. |
refresh_method | Text | Refresh method of the materialized view. 'c' indicates a full refresh. |
mapping | Text | Mapping between base table partitions and materialized view partitions |
active | Boolean | Whether the materialized view needs to be refreshed |
refresh_start_time | Timestamp with time zone | Start time of the last refresh |
refresh_finish_time | Timestamp with time zone | End time of the last refresh |