From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Subject: Re: pgbouncer logs and its efficiency
Date: Wed, 2 Feb 2022 08:08:40 +0100
Message-ID: <2d4321bd-0174-42c9-3671-fa9626326d10@enterprisedb.com> (raw)
In-Reply-To: <YfNtsr+D6JKPmncK@admin.sibptus.ru>
References: <YfNtsr+D6JKPmncK@admin.sibptus.ru>
On 28.01.22 05:14, Victor Sudakov wrote:
> 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?
These are the internal addresses of the server and client structures.
You can use those to track a particular server or client connection
through the logs and through SHOW SERVERS and SHOW SERVERS.
> 2. How would you calculate the efficiency of pgbouncer, like
> client_conns/server_conns ratio (current and average over over time)?
This depends heavily on what you are using pgbouncer for and what
metrics are relevant for your application.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peter.eisentraut@enterprisedb.com, vas@sibptus.ru, pgsql-admin@lists.postgresql.org
Subject: Re: pgbouncer logs and its efficiency
In-Reply-To: <2d4321bd-0174-42c9-3671-fa9626326d10@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox