SQL_PLAN_BASELINE
The SQL_PLAN_BASELINE view displays plan binding information, which comes from the PG_PLAN_BASELINE system catalog.
|
Name |
Type |
Description |
|---|---|---|
|
sql_hash |
text |
sql_hash of the statement |
|
outline_name |
text |
Name of the outline bound to the SQL statement corresponding to the sql_hash |
|
plan_baseline |
name |
Baseline name of the binding relationship |
|
create_time |
timestamp with time zone |
Time when the plan binding task is created |
|
last_modify_time |
timestamp with time zone |
Last modification time, that is, the time when the statement was bound to the plan for the last time |
|
last_execute_time |
timestamp with time zone |
Last execution time |
|
apply_skew_hint |
boolean |
Whether to apply the skew hint in the outline. This column is available in clusters of version 9.1.0 or later. |
|
status |
tinyint |
Binding status. This column is available in clusters of version 9.1.1.200 or later. Available values are as follows:
|
|
cost |
float8 |
Cost of the plan for generating the outline. This column is available in clusters of version 9.1.1.200 or later. |
|
normalize_cost |
float8 |
Normalized cost calculated based on the duration, CPU usage, and memory usage of the statement in the top SQL statements. This column is reserved and not used. This column is available in clusters of version 9.1.1.200 or later. |
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