The \timing psql command gives different time for the same query executed repeatedly.
So, how can we know the exact response time for any query? Thanks and Regards, Radha > On Tue, 2003-11-04 at 09:49, [EMAIL PROTECTED] wrote: >> How do we measure the response time in postgresql? > > In addition to EXPLAIN ANALYZE, the log_min_duration_statement > configuration variable and the \timing psql command might also be > useful. > > -Neil > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly