On 20 Apr 2011, at 19:11, SUBHAM ROY wrote: > By doing \timing in psql, we enable the timing and then when we type the query we are able to see its execution time. > Similarly, is there any way to view the number I/Os and memory usage by a particular query. You seem to be unfamiliar with the EXPLAIN ANALYSE command. > And also the timing result that gets displayed, in which log file does it get recorded? None, as you're doing your measurements client-side. EXPLAIN ANALYSE is server-side. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,4dafd86711735555731696! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
