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!