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