Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T9NSS-0002lW-I4 for pgsql-performance@postgresql.org; Wed, 05 Sep 2012 21:48:24 +0000 Received: from mail-yx0-f174.google.com ([209.85.213.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T9NSQ-0007Nx-1U for pgsql-performance@postgresql.org; Wed, 05 Sep 2012 21:48:24 +0000 Received: by yenl14 with SMTP id l14so194065yen.19 for ; Wed, 05 Sep 2012 14:48:20 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=from:to:subject:date:message-id:mime-version:content-type:x-mailer :thread-index:content-language:x-gm-message-state; bh=3caduN9K+4m6SjBzOfIoWygJalRRZoRHGFVH2s3ZkaQ=; b=m1ZmVZZ6kjUoru0cFAbFrkkUFjMwF5YXNFhZC54AHZgzam2Isy23gK5GGjhHR3JWms aLpuHuosW8FIlaB7JPiBkDFhbeYzu2V2lvO3tGeb4KTvxHZRjXEIfraSnL4GkK8ecW3/ qOmJhpxvnmijMG5dA4hDGn+CsvnL4DsTbs4i2MC4qu8nGw8YXYn+LiuwbGbWq3ExIGkk UXdxv7QgJm8NeBfxHUCMyftSzfZNHwE6AEu2gYrhdtNfuA8zDNS/e0o6J9uaxiQ69aBm x+iMNNOUtXwu1GPWWXIUaN/Esu+nuw8bRzg4LkQzLcQjMsxtykCof3YTjdrxe/KYQIXT Hy7A== Received: by 10.236.115.138 with SMTP id e10mr24031161yhh.79.1346881700456; Wed, 05 Sep 2012 14:48:20 -0700 (PDT) Received: from AnibalVAIO ([190.128.222.90]) by mx.google.com with ESMTPS id y13sm194151anj.5.2012.09.05.14.48.18 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 05 Sep 2012 14:48:19 -0700 (PDT) From: "Anibal David Acosta" To: Subject: query performance, where goes time? Date: Wed, 5 Sep 2012 17:48:16 -0400 Message-ID: <00c801cd8bb0$2a0bbe10$7e233a30$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C9_01CD8B8E.A2FB0870" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac2LrzHnqhQSG7oSSRSw1C2xo8VF6g== Content-Language: es-py X-Gm-Message-State: ALoCoQmjQq1cwPOzV2uXP56hoiRwTLwdnkIMQ5tat9n0sBVRuFf+nKIm4G/PE8T1x/jbQIdVCxg5 X-Pg-Spam-Score: -1.2 (-) X-Archive-Number: 201209/11 X-Sequence-Number: 47757 This is a multipart message in MIME format. ------=_NextPart_000_00C9_01CD8B8E.A2FB0870 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Using explain analyze I saw that many of my queries run really fast, less than 1 milliseconds, for example the analyze output of a simple query over a table with 5millions of records return "Total runtime: 0.078 ms" But the real time is a lot more, about 15 ms, in fact the pgadmin show this value. So, where goes the others 14.2 ms? Network transfer (TCP)? Or analyze Total runtime don't represent the query runtime? Thanks! ------=_NextPart_000_00C9_01CD8B8E.A2FB0870 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Using = explain analyze I saw that many of my queries run really fast, less than = 1 milliseconds, for example the analyze output of a simple query over a = table with 5millions of records return  "Total runtime: 0.078 = ms"

 

But the real time is a lot  more, about 15 ms, in = fact the pgadmin show this value.

 

So, where = goes the others 14.2 ms?

 

Network = transfer (TCP)?

 

Or analyze = Total runtime don’t represent the query runtime?

 

Thanks!

------=_NextPart_000_00C9_01CD8B8E.A2FB0870--