PGXC_DISK_CACHE_ALL_STATS

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

**Table 1** PGXC_DISK_CACHE_ALL_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 accesses local disk.
remote_read	bigint	Total number of times disk cache accesses 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.
temp_file_size	bigint	Total size of temporary/cold cache files, in KB.
a1in_size	bigint	Total size of data saved in the a1in queue of disk cache, in KB.
a1out_size	bigint	Total size of data saved in the a1out queue of disk cache, in KB.
am_size	bigint	Total size of data saved in the am queue of disk cache, in KB.
a1in_fill_rate	numeric(5,2)	Fill rate of the a1in queue in disk cache.
a1out_fill_rate	numeric(5,2)	Fill rate of the a1out queue in disk cache.
am_fill_rate	numeric(5,2)	Fill rate of the am queue in disk cache.
fd	integer	Number of file descriptors currently in use by disk cache.
pin_block_count	bigint	Number of pinned blocks in disk cache. This field is supported only by 9.1.0.100 and later cluster versions.

Query the number of file descriptors used by disk cache on each node.

    
         SELECT fd FROM pgxc_disk_cache_all_stats;
  fd
------
 1000
 1000
    0
    0
    0
    0
(6 rows)

Parent topic: System Views

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

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

For any further questions, feel free to contact us through the chatbot.