Help Center> GaussDB> Distributed_2.x> Schemas> DBE_PERF Schema> Global Plan Cache> LOCAL_PREPARE_STATEMENT_STATUS (Discarded)

Updated on 2023-10-23 GMT+08:00

View PDF

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 engineers for 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.