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

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.