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


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Reply via email to