Updated on 2024-06-03 GMT+08:00

GS_SPM_EVOLUTION

GS_SPM_EVOLUTION is a system catalog used to store plan evolution result. Users with sysadmin permissions can read the system catalog, but only initial users 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.