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.
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:
|
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.