Help Center/ GaussDB/ Developer Guide(Distributed_2.x)/ Schemas/ DBE_PERF Schema/ Global Plan Cache/ LOCAL_PREPARE_STATEMENT_STATUS (Discarded)
Updated on 2024-10-14 GMT+08:00
View PDF
Share

LOCAL_PREPARE_STATEMENT_STATUS (Discarded)

LOCAL_PREPARE_STATEMENT_STATUS displays the information about prepare statements corresponding to the GPC plan cache on the current node. (The current feature is a lab feature. Contact Huawei technical support before using it.)

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