Updated on 2025-10-14 GMT+08:00

PG_PLAN_BASELINE

Records the binding relationships between statements and plans. A statement can be bound to only one plan. This system catalog is supported by only the 8.2.1.200 cluster version.

Table 1 PG_PLAN_BASELINE columns

Column

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 used time. This column is reserved.

apply_skew_hint

boolean

Whether to apply skew hints in outlines. This column is supported by cluster 9.1.0 and later versions.