Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uxf9x-0003X8-JK for pgsql-admin@arkaria.postgresql.org; Fri, 12 Jul 2013 15:21:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Uxf9w-0006JH-VD for pgsql-admin@arkaria.postgresql.org; Fri, 12 Jul 2013 15:21:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uxf9w-0006JB-6K for pgsql-admin@postgresql.org; Fri, 12 Jul 2013 15:21:24 +0000 Received: from asbnvacz-mailrelay01.megapath.net ([207.145.128.243]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uxf9n-0004Yq-RU for pgsql-admin@postgresql.org; Fri, 12 Jul 2013 15:21:21 +0000 Received: from mail7.sea5.speakeasy.net (mail7.sea5.speakeasy.net [69.17.117.52]) by asbnvacz-mailrelay01.megapath.net (Postfix) with ESMTP id 0015F1EE562D for ; Fri, 12 Jul 2013 11:21:11 -0400 (EDT) Received: (qmail 8681 invoked from network); 12 Jul 2013 15:21:11 -0000 Received: by simscan 1.4.0 ppid: 15362, pid: 29431, t: 0.3562s scanners: clamav: 0.88.2/m:52/d:13513 spam: 3.0.4 Received: from 205-168-220-137.dia.static.qwest.net (HELO [192.168.4.17]) (sribe@elevated-dev.com@[205.168.220.137]) (envelope-sender ) by mail7.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 12 Jul 2013 15:21:11 -0000 Subject: Re: logging or debugging to report time to establish a database connection Mime-Version: 1.0 (Apple Message framework v1085) Content-Type: text/plain; charset=us-ascii From: Scott Ribe In-Reply-To: Date: Fri, 12 Jul 2013 09:21:09 -0600 Cc: "pgsql-admin@postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Mike Broers X-Mailer: Apple Mail (2.1085) X-Spam-Checker-Version: SpamAssassin 3.0.4 (2005-06-05) on mail7.sea5 X-Spam-Level: X-Spam-Status: No, score=0.0 required=8.0 tests=none autolearn=disabled version=3.0.4 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Jul 12, 2013, at 9:00 AM, Mike Broers wrote: > Is there something I am overlooking in postgres logging or psql client sw= itches that would make this information available or am I stuck with lower = level tools? Well, if you want to log how long pgbouncer takes to hand out a connection = from a pool, you're certainly not going to find that answer anywhere in pos= tgresql logging ;-) Unfortunately, it doesn't look to me as though the pgbouncer console will s= how you exactly that. Maybe using -v or -vv options would help? But yes, av= erage/max/min maybe even stddev of time to hand out a connection would seem= to be information that would be good to collect, so perhaps a feature requ= est is in order... Of course there will also be overhead in the libraries that will vary from = one database manager to another, so in my opinion the only way to really be= nchmark this would be from the client side anyway. Which is maybe what you = were thinking when asking about psql switches? Again, a feature request mig= ht be in order--I can think of two possibilities: 1) a command-line verbose= -mode switch that would provide details of the connection process, which co= uld be good also for debugging connection problems, showing what host is be= ing attempted, what the resolution (if any) of the host name is, connection= opened or not, authentication passed or not, and so on; 2) enhancements to= the /conninfo command to provide more details. --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin