PV_MATVIEW_DETAIL

'd': indicates "deferred", which means that data is contained in the materialized view only when the view is refreshed for the first time.
'i': indicates "immediate", which means that the latest data is included when the materialized view is created.

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.

**Table 1** PV_MATVIEW_DETAIL columns
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. 'd': indicates "deferred", which means that data is contained in the materialized view only when the view is refreshed for the first time. 'i': indicates "immediate", which means that the latest data is included when the materialized view is created.
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