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

LOCAL_PREPARE_STATEMENT_STATUS

LOCAL_PREPARE_STATEMENT_STATUS displays the information about prepare statements corresponding to the GPC plan cache on the current node, as described in Table 1.

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

Specifies whether the corresponding plan cache is shared.

query

text

Corresponding query statement.
Parent topic: Global Plan Cache