Thread

1. Re: Response time

   radha.manohar@ndsu.nodak.edu — 2003-11-04T14:49:39Z

   How do we measure the response time in postgresql?
   
   Your response would be very much appreciated.
   
   Thanks and Regards,
   
   Radha
   
   
   
   

2. Re: Response time

   Pavel Stehule <stehule@kix.fsv.cvut.cz> — 2003-11-04T15:02:11Z

   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
   > 
   
   
   

3. Re: Response time

   Neil Conway <neilc@samurai.com> — 2003-11-04T20:12:37Z

   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
   
   
   
   

4. Re: Response time

   radha.manohar@ndsu.nodak.edu — 2003-11-05T17:35:22Z

   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
   
   
   
   
   

5. Re: Response time

   Neil Conway <neilc@samurai.com> — 2003-11-05T17:40:18Z

   <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
   
   
   

6. Re: Response time

   Andrew Sullivan <andrew@libertyrms.info> — 2003-11-05T18:04:22Z

   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