Updated on 2024-06-03 GMT+08:00

GS_SPM_SQL_BASELINE

GS_SPM_SQL_BASELINE is a system view of the SPM feature. Currently, this feature is not supported in the distributed system. This view 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: indicates that the plan is not accepted.
  • ACC: indicates that 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.