Re: [SQL] Time of executed query - Mailing list pgadmin-support

On 3/6/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> Hi list,
>
> It is possible to retrieve the time of a SQL statement leads to
> execute ? I would like to put in my application how much time each
> operation leads to finish.
>
> Any suggestion ?
>
> --
> Ezequias Rodrigues da Rocha
> http://ezequiasrocha.blogspot.com/
> use Mozilla Firefox:http://br.mozdev.org/firefox/

Sorry, didn't see the app part.

Use clock_timestamp().

See:

http://www.postgresql.org/docs/8.2/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT