Updated on 2024-03-14 GMT+08:00

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

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)