Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id F230D63401B for ; Tue, 31 Aug 2010 14:42:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 67461-08 for ; Tue, 31 Aug 2010 17:42:18 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n1-vm1.bullet.mail.gq1.yahoo.com (n1-vm1.bullet.mail.gq1.yahoo.com [67.195.23.153]) by mail.postgresql.org (Postfix) with SMTP id 88B89633F94 for ; Tue, 31 Aug 2010 14:42:18 -0300 (ADT) Received: from [98.137.27.132] by n1.bullet.mail.gq1.yahoo.com with NNFMP; 31 Aug 2010 17:42:17 -0000 Received: from [98.137.27.210] by t4.bullet.mail.gq1.yahoo.com with NNFMP; 31 Aug 2010 17:42:17 -0000 Received: from [127.0.0.1] by omp120.mail.gq1.yahoo.com with NNFMP; 31 Aug 2010 17:42:17 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 220208.58168.bm@omp120.mail.gq1.yahoo.com Received: (qmail 21610 invoked by uid 60001); 31 Aug 2010 17:42:16 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1283276536; bh=A4M8DOTgEa+P1puOvSP8XUKWNmoJvmH8dfIr1Jlu6sc=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=AJKd+5cxE443NdF8Bir8gWHMvaEdFhiHY+iI59CHsNScSK/iIII9i83w0S2bRk5o0Q5Z7QGj4un4Jhoin25x/jG260CCEtyI7srpjMRyhUEFf26QF0EOdPHR9mLeIyxa6qDwlbLloBkti4f6bOLP+18JE8HtkeKXnKud13id+sg= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=RAVuRGlZvburmC4t9ooUuIB07GyR7CX8D8oWJqenXHYMt0Y08fJwXUk3NzOXtstMcHebxneGdHyLEYtyd5ycderGeiB7PMTl28xXAFmSUAPf7a+gFVllvKuvl8dxyJGRHFoAYmIFIOO1WopJEdl6/6UKEx9QM+DnC5RsGBn+8N8=; Message-ID: <788866.21140.qm@web120020.mail.ne1.yahoo.com> X-YMail-OSG: IOJiFQwVM1mNrAr.6Jc7xBXNUH5rYImpLqrLsS5WO03y9IR vYkHJHjCOJyXSUxzIBSSZZJFoYE3Tz0eUDk5rcsunQd3CfiniJNhNSGoih7N I11B7pI_oMI8V0gung_mStR366aURJPnLlSNNJu76xB1LSkhdci..PEspnV7 Qz13_EA6yLjBtGAIPL7r_uOc2z46GnxoL6kGmZw-- Received: from [129.44.63.215] by web120020.mail.ne1.yahoo.com via HTTP; Tue, 31 Aug 2010 10:42:16 PDT X-Mailer: YahooMailRC/470 YahooMailWebService/0.8.105.279950 Date: Tue, 31 Aug 2010 10:42:16 -0700 (PDT) From: A J Subject: Confused by 'timing' results To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1100314139-1283276536=:21140" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.791 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/287 X-Sequence-Number: 35536 --0-1100314139-1283276536=:21140 Content-Type: text/plain; charset=us-ascii time echo '\timing \\select * from table1 where id = 123;' | psql I am trying to time a simple select statement from different clients located at different places. The database is on US east-coast. In the above query. the 'timing' will time the database time and the 'time' command at the very start will time the complete time for the query including network time. When I run the query on the database, I get: Time: 2.357 ms real 0m0.010s