Re: Time of executed query - Mailing list pgsql-sql

From Bart Degryse
Subject Re: Time of executed query
Date
Msg-id 45ED7A0A.A3DD.0030.0@indicator.be
Whole thread Raw
In response to Time of executed query  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
Responses Re: Time of executed query  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
List pgsql-sql
note the time just before your operation starts
note the time just after it ends
show timeafter - timebefore

>>> "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> 2007-03-06 14:20 >>>
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/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

pgsql-sql by date:

Previous
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Time of executed query
Next
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Re: Time of executed query