GS_SPM_SQL_EVOLUTION
GS_SPM_SQL_EVOLUTION is used to view the planned evolution result of the current user. Common users and users with higher permissions can access this view.
| Name | Type | Description |
|---|---|---|
| sql_namespace | oid | OID of a schema. |
| sql_hash | bigint | Unique ID of an SQL statement in the current schema. |
| plan_hash | bigint | Unique ID of a plan in the current SQL statement. |
| better | Boolean | Determines whether it is a positive evolution. |
| status | text | Specifies whether exceptions occur during the evolution. Value range:
|
| refer_plan | bigint | Plan hash used as a reference for report generation. |
| sql_text | text | SQL text string. |
| outline | text | Hint string list of the current plan. |
| reason | text | Content of the evolution report. |
| gplan | Boolean | Determines whether the plan is a gplan. |
| creation_time | timestamp with time zone | Time when the evolution result is created. |
