Re: Log connection establishment timings - Mailing list pgsql-hackers

From Jelte Fennema-Nio
Subject Re: Log connection establishment timings
Date
Msg-id CAGECzQQp0kzsgCdkMdFEiqmnVCc8YGKEVSRcqVPyMbRJVb6B_Q@mail.gmail.com
Whole thread Raw
List pgsql-hackers
On Mon, 16 Dec 2024 at 22:00, Melanie Plageman
<melanieplageman@gmail.com> wrote:
> Users wishing to debug slow connection establishment have little
> visibility into which steps take the most time. We don't expose any
> stats and none of the logging includes durations.

Two thoughts:
1. Would it make sense to also expose these timings in some pg_stat_xyz view?
2. As a user I'd be curious to know how much of the time is spent on
the network/client vs inside postgres. For example for the scram/sasl
handshake, how much of the authentication_time is spent waiting on the
first "read" after the server has called sendAuthRequest.



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: FileFallocate misbehaving on XFS
Next
From: Noah Misch
Date:
Subject: Re: WARNING: missing lock on database "postgres" (OID 5) @ TID (0,4)