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.
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.
|
refer_plan |
bigint |
Plan hash used as a reference for report generation. |
status |
integer |
Determines whether exceptions occur during the evolution.
|
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.