Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ Schemas/ DBE_PERF Schema/ Global Plan Cache/ LOCAL_PREPARE_STATEMENT_STATUS (Deprecated)
Updated on 2025-08-19 GMT+08:00
View PDF

LOCAL_PREPARE_STATEMENT_STATUS (Deprecated)

LOCAL_PREPARE_STATEMENT_STATUS displays the information about prepared statements corresponding to the GPC plan cache on the current node.

Table 1 LOCAL_PREPARE_STATEMENT_STATUS columns

Name

Type

Description

nodename

text

Name of the node that the statement belongs to

cn_sess_id

bigint

Session ID of the CN that the statement is sent from

cn_node_id

integer

Node ID of the CN that the statement is sent from

cn_time_line

integer

Number of restart times of the CN that the statement is sent from

statement_name

text

Statement name

refcount

integer

Number of times that the corresponding plan cache is referenced

is_shared

bool

Whether the corresponding plan cache is shared

query

text

Corresponding query statement.
Parent topic: Global Plan Cache