Updated on 2024-05-07 GMT+08:00

GS_MATVIEW

GS_MATVIEW provides information about each materialized view in the database.

Table 1 GS_MATVIEW columns

Name

Type

Description

oid

oid

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

matviewid

oid

OID of a materialized view.

mapid

oid

OID of a map table associated with a materialized view. Each map table corresponds to one materialized view. If a full materialized view does not correspond to a map table, the value of this column is 0.

ivm

boolean

Type of a materialized view. The value t indicates an incremental materialized view, and the value f indicates a full materialized view.

needrefresh

boolean

Reserved column.

refreshtime

timestamp without time zone

Last time when a materialized view was refreshed. If the materialized view is not refreshed, the value is null. This column is maintained only for incremental materialized views on DNs. In other cases, the value is null.