Help Center/ GaussDB/ Developer Guide(Distributed_3.x)/ Schemas/ DBE_PERF Schema/ Discarded/ Global Plancache/ LOCAL_PREPARE_STATEMENT_STATUS

Updated on 2024-05-07 GMT+08:00

View PDF

LOCAL_PREPARE_STATEMENT_STATUS

LOCAL_PREPARE_STATEMENT_STATUS displays the information about prepare 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 Plancache

Previous topic: Global Plancache

Next topic: GLOBAL_PREPARE_STATEMENT_STATUS

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.