Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W5gUO-0002Uu-Da for pgsql-performance@arkaria.postgresql.org; Tue, 21 Jan 2014 18:55:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W5gUN-000697-Q5 for pgsql-performance@arkaria.postgresql.org; Tue, 21 Jan 2014 18:55:55 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W5gUM-000691-TC for pgsql-performance@postgresql.org; Tue, 21 Jan 2014 18:55:55 +0000 Received: from smtp.01.com ([199.36.142.181]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W5gUJ-0004g4-SP for pgsql-performance@postgresql.org; Tue, 21 Jan 2014 18:55:54 +0000 Received: from localhost (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id AF191390E02 for ; Tue, 21 Jan 2014 12:55:51 -0600 (CST) X-Virus-Scanned: amavisd-new at smtp-out-2.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-2.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 1YBKc2Abkpom for ; Tue, 21 Jan 2014 12:55:51 -0600 (CST) Received: from smtp.01.com (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id 93FF3390E05 for ; Tue, 21 Jan 2014 12:55:51 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id 87F3F390E03 for ; Tue, 21 Jan 2014 12:55:51 -0600 (CST) X-Virus-Scanned: amavisd-new at smtp-out-2.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-2.01.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id b_V5NpdEu0Ht for ; Tue, 21 Jan 2014 12:55:51 -0600 (CST) Received: from [172.47.23.102] (50-0-190-100.dsl.dynamic.sonic.net [50.0.190.100]) by smtp-out-2.01.com (Postfix) with ESMTPSA id 05844390E02 for ; Tue, 21 Jan 2014 12:55:50 -0600 (CST) Message-ID: <52DEC2B5.9090700@agliodbs.com> Date: Tue, 21 Jan 2014 10:55:49 -0800 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.1.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Time of query result delivery References: In-Reply-To: X-Enigmail-Version: 1.6 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 01/20/2014 05:55 AM, ARCEnergo wrote: > Time: 1.211 ms > | Physical | Virtaul > -------------------------------------------------- > from PC "Total runtime" | 0.05x ms | 0.05x ms > -------------------------------------------------- > from PC timing | 0.7 ms | 1.211 ms <-- strange > -------------------------------------------------- > from server "Total runtime"| 0.05x ms | 0.05x ms > -------------------------------------------------- > from server timing | 0.55 ms | 0.6 ms I'm really not clear on what you're trying to measure here. If you're doing "time" from your PC, then network transmission time completely dominates your reponse time ... and that can be affected by all kinds of random variables. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance