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