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
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.
|
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
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
