PGXC_DISK_CACHE_PATH_INFO
PGXC_DISK_CACHE_PATH_INFO records information about the hard disk where the file cache is stored. This system view is supported only by clusters of version 9.1.0 or later.
| Column | Type | Description |
|---|---|---|
| path_name | text | Path name. |
| node_name | text | Name of the node the hard disk belongs to. |
| cache_size | bigint | Total size of cache files in the hard disk, in bytes. |
| disk_available | bigint | Available space in the hard disk, in bytes. |
| disk_size | bigint | Total capacity of the hard drive, in bytes. |
| disk_use_ratio | double precision | Disk space usage. |
Example
Query information about the hard disk used by the file cache.
1 | SELECT * FROM pgxc_disk_cache_path_info order by 1; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
