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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot