PGXC_DISK_CACHE_ALL_STATS

Records the usage of the file cache. This system view is supported only in cloud native 3.0.

**Table 1** PGXC_DISK_CACHE_ALL_STATS columns
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 accesses the local disk.
remote_read	bigint	Total number of times that the disk cache accesses 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
temp_file_size	bigint	Total size of temporary/cold cache files (KB)
a1in_size	bigint	Total size of data stored in the a1in queue in the disk cache (KB)
a1out_size	bigint	Total size of data stored in the a1out queue in the disk cache (KB)
am_size	bigint	Total size of data stored in the am queue in the disk cache (KB)
a1in_fill_rate	numeric(5,2)	Filling rate of the a1in queue in the disk cache
a1out_fill_rate	numeric(5,2)	Filling rate of the a1out queue in the disk cache
am_fill_rate	numeric(5,2)	Filling rate of the am queue in the disk cache
fd	integer	Number of file descriptors that are being used by the disk cache

Query the number of file descriptors used by the 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.