>> time echo '\timing \\select * from table1 where id = 123;' | psql >> In the above query. the 'timing' will time the database time and >> the 'time' command at the very start will time the complete time >> for the query including network time. > > No, the 'timing' will say how long it took to send the query from > psql to the server and get the complete response back from the > server. The 'time' command will also include the time to start > psql, establish the connection to the database, read from the pipe, > and close the connection to the database.
if you'd want to get the real execution time for the query from a faraway client (without network latency), you could open an ssh session and start psql on the database server. -- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin