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(at)sympatico(dot)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(dot)andersson(at)embryo(dot)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