Re: How can I make note of time taken by each query to execute in Triggers - Mailing list pgsql-admin

"shreedhar" <shreedhar@lucidindia.net> writes:
> I would like read time taken by each query in my triggers.
> so i created a temporary table and inserted timestamp before i start qurey
> and inserted again timestamp after completion of the query. But i am getting
> same time. How can I get the time taken by each query.

timeofday().  See
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

            regards, tom lane