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.