GS_SPM_SQL_BASELINE

GS_SPM_SQL_BASELINE is used to view the baseline information of the current user. Users with permissions higher than common users can access this view.

**Table 1** GS_SPM_SQL_BASELINE 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.
outline	text	Outline text, which can be used to fix a group of hints of the current plan.
status	text	Status of a plan. Value range: UNACC: The plan is not accepted. ACC: The plan has been accepted. FIXED: indicates a special ACC plan. The matching priority of this plan is higher than that of other ACC plans.
gplan	Boolean	Specifies whether the plan corresponding to the current outline is a gplan.
cost	double precision	Total plan cost.
sql_text	text	SQL text string.
param_num	integer	Number of SQL parameters.
source	text	Baseline source.
creation_time	timestamp with time zone	Time when the baseline is created.
modification_time	timestamp with time zone	Time when the baseline is modified.
jump_intercept_cnt	bigint	Number of baseline interception plan jumps.
invalid	Boolean	Specifies whether the current baseline is invalid.

Parent topic: SPM

Previous topic: SPM

Next topic: GS_SPM_SQL_PARAM

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.