Help Center/ GaussDB(DWS)/ Standard Data Warehouse (9.1.0.x)/ System Catalogs and System Views/ System Views/ PGXC_DISK_CACHE_PATH_INFO
Updated on 2024-09-30 GMT+08:00
View PDF

PGXC_DISK_CACHE_PATH_INFO

PGXC_DISK_CACHE_PATH_INFO records information about the hard disk where the file cache is stored. This system view is supported only by clusters of version 9.1.0 or later.

Table 1 PGXC_DISK_CACHE_PATH_INFO columns

Column

Type

Description

path_name

text

Path name.

node_name

text

Name of the node the hard disk belongs to.

cache_size

bigint

Total size of cache files in the hard disk, in bytes.

disk_available

bigint

Available space in the hard disk, in bytes.

disk_size

bigint

Total capacity of the hard drive, in bytes.

disk_use_ratio

double precision

Disk space usage.

Example

Query information about the hard disk used by the file cache.

1
2
3
4
5
6
7
8
9
 
SELECT * FROM pgxc_disk_cache_path_info order by 1;
   path_name    |  node_name   | cache_size | disk_available |  disk_size   |  disk_use_ratio
----------------+--------------+------------+----------------+--------------+------------------
 dn_6001_6002_0 | dn_6001_6002 |      19619 |   137401716736 | 160982630400 | .146481105479564
 dn_6001_6002_1 | dn_6001_6002 |      35968 |   137401716736 | 160982630400 | .146481105479564
 dn_6003_6004_0 | dn_6003_6004 |      27794 |   121600655360 | 160982630400 | .244634933235629
 dn_6003_6004_1 | dn_6003_6004 |      26158 |   121600655360 | 160982630400 | .244634933235629
 dn_6005_6006_0 | dn_6005_6006 |      24533 |   134394839040 | 160982630400 | .165159379579873
 dn_6005_6006_1 | dn_6005_6006 |      31065 |   134394839040 | 160982630400 | .165159379579873
Parent topic: System Views