pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Response time
6+ messages / 4 participants
[nested] [flat]

* Re: Response time
@ 2003-11-04 14:49 radha.manohar@ndsu.nodak.edu
  2003-11-04 15:02 ` Re: Response time Pavel Stehule <stehule@kix.fsv.cvut.cz>
  2003-11-04 20:12 ` Re: Response time Neil Conway <neilc@samurai.com>
  0 siblings, 2 replies; 6+ messages in thread

From: radha.manohar@ndsu.nodak.edu @ 2003-11-04 14:49 UTC (permalink / raw)
  To: pgsql-performance

How do we measure the response time in postgresql?

Your response would be very much appreciated.

Thanks and Regards,

Radha





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Response time
  2003-11-04 14:49 Re: Response time radha.manohar@ndsu.nodak.edu
@ 2003-11-04 15:02 ` Pavel Stehule <stehule@kix.fsv.cvut.cz>
  1 sibling, 0 replies; 6+ messages in thread

From: Pavel Stehule @ 2003-11-04 15:02 UTC (permalink / raw)
  To: radha.manohar@ndsu.nodak.edu; +Cc: pgsql-performance

Hello

explain analyse select * from lidi;
                                          QUERY PLAN

-----------------------------------------------------------------------------------------------
 Seq Scan on lidi  (cost=0.00..1.04 rows=4 width=96) (actual 
time=0.046..0.092 rows=4 loops=1)
 Total runtime: 0.369 ms

Regards
Pavel




On Tue, 4 Nov 2003 radha.manohar@ndsu.nodak.edu wrote:

> How do we measure the response time in postgresql?
> 
> Your response would be very much appreciated.
> 
> Thanks and Regards,
> 
> Radha
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Response time
  2003-11-04 14:49 Re: Response time radha.manohar@ndsu.nodak.edu
@ 2003-11-04 20:12 ` Neil Conway <neilc@samurai.com>
  2003-11-05 17:35   ` Re: Response time radha.manohar@ndsu.nodak.edu
  1 sibling, 1 reply; 6+ messages in thread

From: Neil Conway @ 2003-11-04 20:12 UTC (permalink / raw)
  To: radha.manohar@ndsu.nodak.edu; +Cc: pgsql-performance

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





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Response time
  2003-11-04 14:49 Re: Response time radha.manohar@ndsu.nodak.edu
  2003-11-04 20:12 ` Re: Response time Neil Conway <neilc@samurai.com>
@ 2003-11-05 17:35   ` radha.manohar@ndsu.nodak.edu
  2003-11-05 17:40     ` Re: Response time Neil Conway <neilc@samurai.com>
  2003-11-05 18:04     ` Re: Response time Andrew Sullivan <andrew@libertyrms.info>
  0 siblings, 2 replies; 6+ messages in thread

From: radha.manohar@ndsu.nodak.edu @ 2003-11-05 17:35 UTC (permalink / raw)
  To: neilc@samurai.com; +Cc: 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






^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Response time
  2003-11-04 14:49 Re: Response time radha.manohar@ndsu.nodak.edu
  2003-11-04 20:12 ` Re: Response time Neil Conway <neilc@samurai.com>
  2003-11-05 17:35   ` Re: Response time radha.manohar@ndsu.nodak.edu
@ 2003-11-05 17:40     ` Neil Conway <neilc@samurai.com>
  1 sibling, 0 replies; 6+ messages in thread

From: Neil Conway @ 2003-11-05 17:40 UTC (permalink / raw)
  To: radha.manohar@ndsu.nodak.edu; +Cc: pgsql-performance

<radha.manohar@ndsu.nodak.edu> writes:
> The \timing psql command gives different time for the same query executed
> repeatedly.

That's probably because executing the query repeatedly results in
different execution times, as one would expect. \timing returns the
"exact" query response time, nevertheless.

-Neil




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Response time
  2003-11-04 14:49 Re: Response time radha.manohar@ndsu.nodak.edu
  2003-11-04 20:12 ` Re: Response time Neil Conway <neilc@samurai.com>
  2003-11-05 17:35   ` Re: Response time radha.manohar@ndsu.nodak.edu
@ 2003-11-05 18:04     ` Andrew Sullivan <andrew@libertyrms.info>
  1 sibling, 0 replies; 6+ messages in thread

From: Andrew Sullivan @ 2003-11-05 18:04 UTC (permalink / raw)
  To: pgsql-performance

On Wed, Nov 05, 2003 at 11:35:22AM -0600, radha.manohar@ndsu.nodak.edu wrote:
> The \timing psql command gives different time for the same query executed
> repeatedly.

Why do you believe that the same query will always take the same time
to execute?

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110




^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2003-11-05 18:04 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-11-04 14:49 Re: Response time radha.manohar@ndsu.nodak.edu
2003-11-04 15:02 ` Pavel Stehule <stehule@kix.fsv.cvut.cz>
2003-11-04 20:12 ` Neil Conway <neilc@samurai.com>
2003-11-05 17:35   ` radha.manohar@ndsu.nodak.edu
2003-11-05 17:40     ` Neil Conway <neilc@samurai.com>
2003-11-05 18:04     ` Andrew Sullivan <andrew@libertyrms.info>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox