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.
| 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.