PGXC_DISK_CACHE_STATS

Updated on 2024-09-30 GMT+08:00

View PDF

PGXC_DISK_CACHE_STATS records the usage of file cache. This system view is supported only by clusters of version 9.1.0 or later.

**Table 1** PGXC_DISK_CACHE_STATS columns
Column	Type	Description
node_name	text	Node name.
total_read	bigint	Total number of accesses to disk cache.
local_read	bigint	Total number of times disk cache reads from local disk.
remote_read	bigint	Total number of times disk cache reads from remote storage.
hit_rate	numeric(5,2)	Hit rate of disk cache.
cache_size	bigint	Total size of data saved in disk cache, in KB.
fill_rate	numeric(5,2)	Fill rate of disk cache.

Query the hit rate of 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)

Parent topic: System Views

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel