I’m trying to use named queries with long cache times to ease a connection to an old DB (FoxPro).
However, when looking at the DB diagnostics, I have a feeling that some queries are still fired too often.
Is there some way I can monitor the queries send to the server (preferable via some option I can enable for a few minutes, and later investigate the data)?
I would like to find some data like
- source of the query (client hostname or ip)
- Time and duration of the query
- whether it hit the cache or went to the database
- parameters passed on