Updated on 2025-05-29 GMT+08:00

GS_IMCV_STATUS

GS_IMCV_STATUS displays the status information in the IMCV catalog in the database. This view exists in both PG_CATALOG and SYS schemas.

Table 1 GS_IMCV_STATUS columns

Name

Type

Description

reloid

oid

Table ID.

relname

name

Table name.

dbname

name

Database name.

username

name

Username.

parentoid

oid

Parent table ID.

imcvstatus

char

IMCV table status:

  • I: POPULATE_STAT_INIT (initiate)
  • L: POPULATE_STAT_LOAD_START (start loading)
  • M: POPULATE_STAT_LOAD_META_DONE (load metadata)
  • F: POPULATE_STAT_LOAD_FINISH (loading completed)
  • D: POPULATE_STAT_DROP (deleted)
  • E: POPULATE_STAT_ERROR (abnormal)

imcvnattr

smallint

Number of loaded columns.

imcvkey

int2vector

Array of loaded columns.

priority

smallint

Loading priority.

rowgroup_num

integer

Number of loaded row groups.

cu_num_in_mem

integer

Number of IMCUs in the memory.

cu_mem_size

bigint

Memory occupied by IMCU, in bytes.

cu_num_in_disk

integer

Not supported. The value is 0.

cu_disk_size

bigint

Not supported. The value is 0.