Query Cache

Summary

It is possible to cache the SELECT query, if enable_query_cache of pgpool.conf is true.

Feature

It is possible to search for the data that exists in the query cache. It searches for the query string and the database name, and it processes it by the partial agreement retrieval. It becomes a search for the logical product with the query string and the database name.

Query
Database

Query cache list

The query string, database name and create time which existing in cache is displayed. When "Query", "Database" and "Create Time" clicked, the records is sorted. Whenever clicking, it is sorted in the ascending order or the descending order.

When the check is put in the check box in the left of the data that wants to be deleted, and the deletion button is pushed, it is deleted.

Query Database Create Time