GS_SPM_SQL_EVOLUTION

SUCCESS: The evolution is successful.
FAILED: The evolution fails.

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.

**Table 1** GS_SPM_SQL_EVOLUTION columns
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: SUCCESS: The evolution is successful. FAILED: The evolution fails.
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.