PGXC_DISK_CACHE_STATS
Records the usage of the file cache. This system view is supported only by DWS 3.0.
Column |
Type |
Description |
---|---|---|
node_name |
text |
Node name |
total_read |
bigint |
Total number of times that the disk cache is accessed |
local_read |
bigint |
Total number of times that the disk cache reads the local disk |
remote_read |
bigint |
Total number of times that the disk cache reads data from the remote storage. |
hit_rate |
numeric(5,2) |
Hit ratio of the disk cache |
cache_size |
bigint |
Total size of data stored in the disk cache (KB) |
fill_rate |
numeric(5,2) |
Disk cache filling rate |
Example
Run the following command to query the hit ratio of the disk cache on each node:
SELECT hit_rate FROM pgxc_disk_cache_stats; hit_rate ---------- 56.91 56.85 NaN NaN NaN NaN (6 rows)
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