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

GS_SPM_BASELINE

GS_PLAN_BASELINE is a system catalog used to store baseline information. Users with sysadmin permissions can read the system catalog, but only initial users can write the system catalog.

Table 1 GS_SPM_BASELINE columns

Name

Type

Description

sql_namespace

oid

Schema OID.

sql_hash

bigint

Unique ID of the SQL statement in the SPM.

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.

cost

double precision

Total plan cost.

user

oid

User who creates the baseline.

status

integer

Baseline status. The options are as follows:

  • 0 (UNACC): indicates that the plan is not accepted.
  • 1 (ACC): indicates that the plan has been accepted.
  • 2 (FIXED): indicates a special ACC plan. The matching priority of this plan is higher than that of other ACC plan.

source

text

Baseline source.

gplan

Boolean

Determines whether the plan is a gplan.

creation_time

timestamp with time zone

Time when the baseline is created.

last_used_time

timestamp with time zone

Last time when a plan was used.

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.