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

GS_SPM_EVOLUTION

GS_SPM_EVOLUTION is a system catalog in the SPM feature. Currently, this feature is not supported in the distributed system. It is a system catalog used to store plan evolution result. Users with sysadmin permissions can read the system catalog, but only the initial user can write the system catalog.

Table 1 GS_SPM_EVOLTOIN columns

Name

Type

Description

sql_namespace

oid

Schema OID.

sql_hash

bigint

Unique ID of the SQL statement in the SPM.

plan_hash

bigint

Plan ID.

better

boolean

Determines whether it is a positive evolution.

  • t indicates positive evolution.
  • f indicates negative evolution.

refer_plan

bigint

Plan hash used as a reference for report generation.

status

integer

Determines whether exceptions occur during the evolution.

  • The value 0 indicates that no exception occurs.
  • The value 1 indicates that an exception occurs.

reason

text

Content of the evolution report.

user

oid

User who generates the evolution result.

creation_time

timestamp with time zone

Time when the evolution result is created.
Parent topic: SPM