Help Center/ GaussDB(DWS)/ 3.0 Developer Guide/ System Views/ PGXC_DISK_CACHE_STATS
Updated on 2024-03-14 GMT+08:00
View PDF

PGXC_DISK_CACHE_STATS

Records the usage of the file cache. This system view is supported only by DWS 3.0.

Table 1 PGXC_DISK_CACHE_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 reads the local disk

remote_read

bigint

Total number of times that the disk cache reads data from 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

Example

Run the following command to query the hit ratio of the 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