From: Anibal David Acosta <aa@devshock.com>
To: pgsql-performance@postgresql.org
Subject: query performance, where goes time?
Date: Wed, 5 Sep 2012 17:48:16 -0400
Message-ID: <00c801cd8bb0$2a0bbe10$7e233a30$@devshock.com> (raw)
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: aa@devshock.com
Subject: Re: query performance, where goes time?
In-Reply-To: <00c801cd8bb0$2a0bbe10$7e233a30$@devshock.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox