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

GS_SPM_PLAN_HISTORY

GS_SPM_PLAN_HISTORY is a system catalog used to record plan change history. Users with SYSADMIN permissions can read the system catalog, but only the initial user can write data to the system catalog.

Table 1 GS_SPM_PLAN_HISTORY columns

Name

Type

Description

sql_hash

bigint

Unique ID of the SQL statement in the SPM.

plan_hash

bigint

Plan ID.

plan_hash_previous

bigint

ID of the previous plan. If there is no previous plan, the value is 0.

userid

oid

User who creates the change history.

creation_time

timestamp with time zone

Time when the change history is created.
Parent topic: SPM