pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Response time
6+ messages / 4 participants
[nested] [flat]
* Re: Response time
@ 2003-11-04 14:49 radha.manohar@ndsu.nodak.edu
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 15:02 Pavel Stehule <stehule@kix.fsv.cvut.cz>
parent: radha.manohar@ndsu.nodak.edu
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 20:12 Neil Conway <neilc@samurai.com>
parent: 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-05 17:35 radha.manohar@ndsu.nodak.edu
parent: Neil Conway <neilc@samurai.com>
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-05 17:40 Neil Conway <neilc@samurai.com>
parent: radha.manohar@ndsu.nodak.edu
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-05 18:04 Andrew Sullivan <andrew@libertyrms.info>
parent: radha.manohar@ndsu.nodak.edu
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