Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Trying to tune our application and would like to know if the stats data that pgBouncer shows as avg_query, according to the PgBouncer docs on usage:

    Average query duration in microseconds.

includes the average duration for INSERTs and UPDATEs as well as SELECTs.

Thanks very much!

share|improve this question

Yes - pgbouncer does not know what type a query is, it just passes it through to the backend. Therefor, avg_query is across all queries, including both INSERT, UPDATE and DDL statements.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.