Ref:
http://archives.postgresql.org/pgsql-performance/2005-03/msg00190.php
In the above referenced thread, I bring up an observation re the timing of pgAdmin results. Essentially I observed that the query execution times as reported by pgAdmin "inflate" much more than the data retrieval times.
Per pgAdmin help,
"The status line will show how long the last query took to complete. If a dataset was returned, not only the elapsed time for server execution is displayed, but also the time to retrieve the data from the server to the Data Output page."
I've been told in that thread that pgSQL doesn't track or report the times to execute the query separately than the time to transport the data.
If this is the case, then I would assume that pgAdmin uses the time sent, the time of first data arrival, and the time of query completion to calculate and display the times on the status line.
Is anyone aware of any pgAdmin ideosyncrosy that would explain slow pgAdmin reported execution times when data is transferred over the relatively slow internet?
Thanks
Lou