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.

**Table 1** PV_MATVIEW_DETAIL columns
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
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