how do i find out how long a query took? - Mailing list pgsql-general

From Andy Kriger
Subject how do i find out how long a query took?
Date
Msg-id OJEFIHHAALOBKKJEOMBDEEIMCBAA.akriger@greaterthanone.com
Whole thread Raw
Responses Re: how do i find out how long a query took?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
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.

thx
andy



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Need Oracle 9 tester. was Re: current_timestamp after queries
Next
From: Bruce Momjian
Date:
Subject: Re: how do i find out how long a query took?