Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ Materialized Views/ GS_MATVIEW_DEPENDENCY
Updated on 2025-08-19 GMT+08:00
View PDF

GS_MATVIEW_DEPENDENCY

GS_MATVIEW_DEPENDENCY provides association information about each fast-fresh materialized view, base table, and Mlog table in the database. The Mlog table corresponding to the base table does not exist in the complete-refresh materialized view. Therefore, no record is written into the Mlog table.

Table 1 GS_MATVIEW_DEPENDENCY columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified).

matviewid

oid

OID of a materialized view.

relid

oid

OID of a base table of a materialized view.

mlogid

oid

OID of a Mlog table which is the log table of a materialized view. Each Mlog table corresponds to one base table.

mxmin

integer

Reserved column.
Parent topic: Materialized Views