Re: How long does it take?

Do realize that you're timing the psql frontend with this, not the 
postgresql backend: the only number from that with any meaning is 
the 'real' wallclock time, and that will be affected by other loads
on either system, or the network between them.

Ross


On Thu, Feb 14, 2002 at 11:18:06AM +0100, Torbj?rn Andersson wrote:
> Den 02-02-14 03.12 skrev Frank Bax fr?n  fbax@sympatico.ca f?ljande:
> 
> > time psql -c "select now()"
> >         now
> > ------------------------
> > 2002-02-13 21:21:17-05
> > (1 row)
> > 
> >   0.09s real     0.05s user     0.01s system
> 
> Thanx!
> 
> Exactly what I needed.
> 
> Regards
> 
> Torbj?rn Andersson
> ---------------------------------------------------
> Embryo Communication      phone: +46 (0) 31-774 39 11(00)
> Kungsgatan 7a             fax: +46 (0)31 774 07 80
> S-411 19 G?teborg         mobile: 0708-30 70 04
> Sweden                    home: http://www.embryo.se/
>         mail: torbjorn.andersson@embryo.se
> ---------------------------------------------------
> "Att idag t?nka annorlunda ?n ig?r skiljer den vise fr?n den envise." ? John
> Steinbeck
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster