PGXC_DISK_CACHE_PATH_INFO
Records the information about the hard disk where the file cache is located. This system view is supported only by DWS 3.0.
Column |
Type |
Description |
---|---|---|
path_name |
text |
Path name. |
node_name |
text |
Name of the node to which the hard disk belongs |
cache_size |
bigint |
Total size of cache files on the hard disk (bytes) |
disk_available |
bigint |
Available space of the hard disk (bytes) |
disk_size |
bigint |
Total capacity of the hard disk (bytes) |
disk_use_ratio |
double precision |
Disk space usage |
Example
Query information about the hard disk used by the file cache:
select * from pgxc_disk_cache_path_info order by 1; path_name | node_name | cache_size | disk_available | disk_size | disk_use_ratio ----------------+--------------+------------+----------------+--------------+------------------ dn_6001_6002_0 | dn_6001_6002 | 19619 | 137401716736 | 160982630400 | .146481105479564 dn_6001_6002_1 | dn_6001_6002 | 35968 | 137401716736 | 160982630400 | .146481105479564 dn_6003_6004_0 | dn_6003_6004 | 27794 | 121600655360 | 160982630400 | .244634933235629 dn_6003_6004_1 | dn_6003_6004 | 26158 | 121600655360 | 160982630400 | .244634933235629 dn_6005_6006_0 | dn_6005_6006 | 24533 | 134394839040 | 160982630400 | .165159379579873 dn_6005_6006_1 | dn_6005_6006 | 31065 | 134394839040 | 160982630400 | .165159379579873
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