Take the 2-minute tour ×
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. It's 100% free, no registration required.

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:

avg_query
    Average query duration in microseconds.

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

Thanks very much!

share|improve this question
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.