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

GS_ILM_OBJECT

GS_ILM_OBJECT records the relationships between data objects and policies as well as the scheduling information of policies on the data objects. When a policy is set for a partitioned table, this catalog generates an independent record for each partition or subpartition.

Table 1 GS_ILM_OBJECT columns

Name

Type

Description

pidx

integer

Policy ID.

objoid

oid

OID of a logical data object which has a partitioned table.

dataobjoid

oid

OID of a physical data object, which is the entity that needs to execute the policy and the leaf of the tree-level partition relationship.

objtype

"char"

Current data object type. The options are as follows:

  • Table ('r')
  • Partition ('p')

origobjoid

oid

OID of the original object that defines the policy.

origobjtype

"char"

Type of the original data object that defines the policy. The options are as follows:

  • Table ('r')
  • Partition ('p')

lastchktime

timestamp with time zone

Time of the last ADO task.

lastexetime

timestamp with time zone

Time of the last ADO job.

roundcnt

smallint

Number of successful rounds.

failcnt

smallint

Number of failures.

lastjobstatus

"char"

Execution status of the last job.

lastroundstarttime

timestamp with time zone

Start time of the full table scan.

lastjobblkid

bigint

ID of the block that has been processed by the job last time.

flag

smallint

Value range:

  • 0: The object compression policy is enabled.
  • 1: The object compression policy is disabled.
  • 2: The object compression policy is enabled, and a full table scan is completed during the last compression scheduling.

lasthashbktpos

ARRAY

Records the last compression position of the previous compression scheduling by storing two values: [bucketid, blockid].