I was recently asked how long it takes for postgres (or in my case pgbouncer) to create a database connection and could not find a way within postgres logging or psql to report this information.
I came across depesz's great article on pgbouncer utilizing tcpdump: http://www.depesz.com/2012/12/02/what-is-the-point-of-bouncing/ but Im not familiar with tcpdump and was hoping there was a way to see this using postgres tools.
Is there something I am overlooking in postgres logging or psql client switches that would make this information available or am I stuck with lower level tools?