Обсуждение: runtime timings psql vs pgadmin

When comparing runtimes (via the last line of EXPLAIN ANALYZE output) of a particular query, I
notice that pgadmin consistently reports a smaller value than psql does.

The 8.4.4 db server is Centos 5.2.

The (windows) pgadmin session is connected via an ssh tunnel to the db server.
The psql session is a screen'ed ssh xterm session on the db server (via cygwin).

psql reports:  Total runtime: 13.451 ms

pgadmin reports:  Total runtime: 5.375 ms

This difference is consistent and repeatable.

Is this difference expected?   Could someone explain it?


Thank you,


Erik Rijkers

Le 02/11/2010 07:20, Erik Rijkers a écrit :
> When comparing runtimes (via the last line of EXPLAIN ANALYZE output) of a particular query, I
> notice that pgadmin consistently reports a smaller value than psql does.
> 
> The 8.4.4 db server is Centos 5.2.
> 
> The (windows) pgadmin session is connected via an ssh tunnel to the db server.
> The psql session is a screen'ed ssh xterm session on the db server (via cygwin).
> 
> psql reports:
>    Total runtime: 13.451 ms
> 
> pgadmin reports:
>    Total runtime: 5.375 ms
> 
> This difference is consistent and repeatable.
> 
> Is this difference expected?

Nope.

> Could someone explain it?

Nope. You should try psql with the same connection (ssh tunnel from the
same computer).

On the pgAdmin part, the ouput from EXPLAIN ANALYZE is not modified.
It's exactly what the PostgreSQL server sent to pgAdmin.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com