Updated on 2023-10-23 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 complete-refresh 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 a fast-refresh materialized view, and the value f indicates a complete-refresh materialized view.

needrefresh

boolean

Reserved column

refreshtime

timestamp

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 fast-refresh materialized views. For complete-refresh materialized views, the value is null.