Re: Response time

From: <radha(dot)manohar(at)ndsu(dot)nodak(dot)edu>
To: <neilc(at)samurai(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Response time
Date: 2003-11-05 17:35:22
Message-ID: 1706.134.129.92.208.1068053722.squirrel@webmail.ndsu.nodak.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(dot)manohar(at)ndsu(dot)nodak(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Conway 2003-11-05 17:40:18 Re: Response time
Previous Message Franco Bruno Borghesi 2003-11-05 14:05:46 Re: Interbase/Firebird - any users out there - what's