PGXC_DISK_CACHE_ALL_STATS
Records the usage of the file cache. This system view is supported only in cloud native 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 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 |
Example
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)
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
