pgbouncer logs and its efficiency

From: Victor Sudakov <vas(at)sibptus(dot)ru>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pgbouncer logs and its efficiency
Date: 2022-01-28 04:14:42
Message-ID: YfNtsr+D6JKPmncK@admin.sibptus.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear Colleages,

I have two questions about pgbouncer logs, can you please share your
knowledge.

1. What is the meaning of those IDs in the log like
"S-0xaaaae460fcb0", "C-0xaaaae45d9fb0" ? I suspect that "S-" and "C-"
mean "server" and "client", but what are those HEX numbers?

2. How would you calculate the efficiency of pgbouncer, like
client_conns/server_conns ratio (current and average over over time)?

I have a case where pgbouncer is probably doing more bad than good,
but I would like to be able to prove or disprove it.

--
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49(at)fidonet

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jiankang Ji 2022-02-01 13:46:07 Re: Determine potential change in table size after a column dropped?
Previous Message Joe Conway 2022-01-27 15:56:22 Re: Is PG CE is FIPS Aware?