Updated on 2025-05-29 GMT+08:00

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.