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

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.

The HTAP feature does not support the distributed mode, and enable_htap cannot be set to on in the distributed mode. Therefore, no information is displayed when you query this system view.

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.
Parent topic: Other System Views