Re: Response time
radha.manohar@ndsu.nodak.edu
From: <radha.manohar@ndsu.nodak.edu>
To: <neilc@samurai.com>
Cc: <pgsql-performance@postgresql.org>
Date: 2003-11-05T17:35:22Z
Lists: pgsql-performance
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, radha.manohar@ndsu.nodak.edu 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