Re: Response time - Mailing list pgsql-performance

From
Subject Re: Response time
Date
Msg-id 1706.134.129.92.208.1068053722.squirrel@webmail.ndsu.nodak.edu
Whole thread Raw
In response to Re: Response time  (Neil Conway <neilc@samurai.com>)
Responses Re: Response time  (Neil Conway <neilc@samurai.com>)
Re: Response time  (Andrew Sullivan <andrew@libertyrms.info>)
List 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




pgsql-performance by date:

Previous
From: Franco Bruno Borghesi
Date:
Subject: Re: Interbase/Firebird - any users out there - what's
Next
From: Neil Conway
Date:
Subject: Re: Response time