pg_matviews - PolarDB - Alibaba Cloud Documentation Center

The pg_matviews view provides access to useful information about each materialized view in the database.

Overview

The pg_matviews view contains the following columns:

Column name	Type	Description
schemaname	name	The name of the schema that contains the materialized view.
matviewname	name	The name of the materialized view.
matviewowner	name	The name of the materialized view owner.
tablespace	name	The name of the tablespace that contains the materialized view. If the default tablespace of the database is used, this value is empty.
hasindexes	bool	The value is `true` if the materialized view has or recently had indexes. Otherwise, the value is `false`.
ispopulated	bool	The value is `true` if the materialized view is currently populated. Otherwise, the value is `false`.
definition	text	The definition of the materialized view, which is a reconstructed `SELECT` query.