PGXC_DISK_CACHE_PATH_INFO

Records the information about the hard disk where the file cache is located. This system view is supported only by DWS 3.0.

**Table 1** PGXC_DISK_CACHE_PATH_INFO columns
Column	Type	Description
path_name	text	Path name.
node_name	text	Name of the node to which the hard disk belongs
cache_size	bigint	Total size of cache files on the hard disk (bytes)
disk_available	bigint	Available space of the hard disk (bytes)
disk_size	bigint	Total capacity of the hard disk (bytes)
disk_use_ratio	double precision	Disk space usage

Example

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

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

Previous topic: PGXC_DISK_CACHE_STATS

Next topic: PGXC_DISK_CACHE_ALL_STATS