Scroll to navigation

SHOW POOL_CACHE(1) pgpool-II 4.3.5 Documentation SHOW POOL_CACHE(1)

NAME

SHOW_POOL_CACHE - displays cache storage statistics

SYNOPSIS



   SHOW POOL_CACHE

DESCRIPTION

SHOW POOL_CACHE displays in memory query cache statistics if in memory query cache is enabled. Here is an example session:



    test=# \x


    \x


    Expanded display is on.


    test=# show pool_cache;


    show pool_cache;


    -[ RECORD 1 ]---------------+---------


    num_cache_hits              | 891703


    num_selects                 | 99995


    cache_hit_ratio             | 0.90


    num_hash_entries            | 131072


    used_hash_entries           | 99992


    num_cache_entries           | 99992


    used_cache_entries_size     | 12482600


    free_cache_entries_size     | 54626264


    fragment_cache_entries_size | 0


Note

If the cache storage is memcached, values for all columns except num_cache_hits, num_selects and cache_hit_ratio show 0.

2023 pgpool-II 4.3.5