PV_MATVIEW_DETAIL
PV_MATVIEW_DETAIL displays detailed information about a materialized view. This view is supported only by clusters of 9.1.0 200 or later.
| Name | Type | Description |
|---|---|---|
| matview | text | Materialized view name |
| baserel | text | Base table name |
| partids | oidvector | OID of the partition when the partition is specified |
| 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 (same as build_mode in pg_matview) |
| 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 complete refresh. |
| mapping | text | Mapping between base table partitions and materialized view partitions |
| active | boolean | Whether the materialized view needs to be refreshed |
| last_refresh_start | timestamp with time zone | Start time of the last refresh |
| last_refresh_end | timestamp with time zone | End time of the last refresh |
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
