8.2.6 Retrieving Statistics from Infinite Cache

Table of Contents Previous Next


8 Performance Analysis and Tuning : 8.2 Infinite Cache : 8.2.6 Retrieving Statistics from Infinite Cache

You can view Infinite Cache statistics by using the edb_icache_stats() function at the edb-psql command line (or any other query tool). The edb_icache_stats() function returns a result set that reflects the state of an Infinite Cache node or nodes and the related usage statistics. The result set includes:
The edb_icache_server_list view exposes information about the status and health of all Infinite Cache servers listed in the edb_icache_servers GUC. The edb_icache_server_list view is created using the edb_icache stats() API. The view exposes the following information for each server:
The state column will contain one of the following four values, reflecting the health of the given server:
Use the following SELECT statement to return the health of each node in the Infinite Cache server farm:

8 Performance Analysis and Tuning : 8.2 Infinite Cache : 8.2.6 Retrieving Statistics from Infinite Cache

Table of Contents Previous Next