"shreedhar" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
