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

From shreedhar
Subject How can I make note of time taken by each query to execute in Triggers
Date
Msg-id 001001c2c296$babff360$1201a8c0@a4005
Whole thread Raw
Responses Re: How can I make note of time taken by each query to execute in Triggers
Re: How can I make note of time taken by each query to execute in Triggers
List pgsql-admin
Hi All,
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.

Regards,
Sreedhar
"Faith, faith, faith in ourselves, faith, faith in God, this is the secret
of greatness.
If you have faith in all the three hundred and thirty millions of your
mythological gods,
and in all the gods which foreigners have now and again introduced into your
midst,
and still have no faith in yourselves, there is no salvation for you. "
(III. 190)


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Access PGDATA from different servers
Next
From: Andrew Biagioni
Date:
Subject: Re: How can I make note of time taken by each query to execute in Triggers