How can I make note of time taken by each query to execute in Triggers

From: "shreedhar" <shreedhar(at)lucidindia(dot)net>
To: "Postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: How can I make note of time taken by each query to execute in Triggers
Date: 2003-01-23 04:20:15
Message-ID: 001001c2c296$babff360$1201a8c0@a4005
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Biagioni 2003-01-23 04:50:48 Re: How can I make note of time taken by each query to execute in Triggers
Previous Message Tom Lane 2003-01-22 21:58:00 Re: Access PGDATA from different servers