GLOBAL_CANDIDATE_STATUS
GLOBAL_CANDIDATE_STATUS displays the number of candidate buffers and buffer eviction information of all instances in the database.
| Name | Type | Description |
|---|---|---|
| node_name | text | Instance name. |
| candidate_slots | integer | Number of pages in the candidate buffer chain of the current normal buffer pool. |
| get_buf_from_list | bigint | Number of times that pages are obtained from the candidate buffer chain during buffer eviction in the current normal buffer pool. |
| get_buf_clock_sweep | bigint | Number of times that pages are obtained from the original eviction solution during buffer eviction in the current normal buffer pool. |
| seg_candidate_slots | integer | Number of pages in the candidate buffer chain of the current segment buffer pool. |
| seg_get_buf_from_list | bigint | Number of times that pages are obtained from the candidate buffer chain during buffer eviction in the current segment buffer pool. |
| seg_get_buf_clock_sweep | bigint | Number of times that pages are obtained from the original eviction solution during buffer eviction in the current segment buffer pool. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.