Postgres Pro
Downloads
Home   >   mailing lists

logging or debugging to report time to establish a database connection - Mailing list pgsql-admin

From Mike Broers
Subject logging or debugging to report time to establish a database connection
Date
Msg-id CAB9893hsCadfaG6onDKknE5q+A+Mh4hEsjW9WD7s3WfPPcHpTA@mail.gmail.com
Whole thread Raw
Responses Re: logging or debugging to report time to establish a database connection  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
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?

pgsql-admin by date:

Previous
From: Giuseppe Broccolo
Date:
Subject: Re: Couldn't start postgres, got no logging, ran postgres manually for info-- help?
Next
From: Scott Ribe
Date:
Subject: Re: logging or debugging to report time to establish a database connection