From: | Darren Ferguson <darren(at)crystalballinc(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Andy Kriger <akriger(at)greaterthanone(dot)com>, Pgsql-General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: how do i find out how long a query took? |
Date: | 2002-09-30 16:52:43 |
Message-ID: | Pine.LNX.4.44.0209301251190.9811-100000@thread.crystalballinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
select version();
version
-------------------------------------------------------------
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
\timing does not work gives following
oss=> \timing
Showing only tuples.
\t: extra argument 'iming' ignored
Any ideas ??? or was it just 7.2.2??
On Mon, 30 Sep 2002, Bruce Momjian wrote:
> Andy Kriger wrote:
> > Is there a psql function I can call after making a query to find out how
> > long the last query took? (e.g. after running a create index on a table with
> > a lot of records, I would like to know how long it took). I know I could do
> > this using JDBC and wrapping the query in getTimeMillis() but I'm curious if
> > psql has a built-in function or if the client has a utility cmd.
>
> Yes, you can use \timing in psql:
>
> test=> \timing
> Timing is on.
> test=> select * from pg_language;
> lanname | lanispl | lanpltrusted | lanplcallfoid | lanvalidator |
> lanacl
> ----------+---------+--------------+---------------+--------------+--------
>
> sql | f | t | 0 | 2248 | {=U}
> internal | f | f | 0 | 2246 | {=}
> c | f | f | 0 | 2247 | {=}
> (3 rows)
>
> Time: 76.83 ms
>
> and in 7.3 we will have log_duration which will send all query
> durations to the server logs.
>
>
--
Darren Ferguson
From | Date | Subject | |
---|---|---|---|
Next Message | Johnson, Shaunn | 2002-09-30 16:53:09 | pg_* description |
Previous Message | Josh Berkus | 2002-09-30 16:30:33 | Re: [GENERAL] arrays |