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

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)

One of the options you can specify in postgresql.conf, is to write to log the
amount of time of each query.  That should give you the precision you need,
although of course you need to look at a log file and not at a DB table...

If you try this approach, I recommend you specify printing out the queries as
well, that will allow you to distinguish what is taking how long.

        Andrew


1/22/03 11:20:15 PM, "shreedhar" <shreedhar@lucidindia.net> wrote:

>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)
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>

"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