Olivier de Regis
Hi,
We set up PostgreSQL DB monitoring on our Kubernetes agent (instance "production", AWS Aurora). Two questions:
  1. How do we edit an existing database configuration (coverages, advanced settings)? We can't find it in the UI.
  2. Query performance generates about 20,000 log events per hour. 53% are
    db.server.query_sample
    for
    idle
    sessions: we use a connection pooler, so most connections are idle at any moment. The rest are
    db.server.top_query
    (about 160 per minute). Can we:
- sample only active / idle-in-transaction sessions,
- lower the top N queries and the max rows per sample,
- set a longer interval for query performance than for standard metrics?