From: Bart Degryse <Bart.Degryse@indicator.be>
To: PostgreSQL <pgsql-sql@postgresql.org>
Cc: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
Subject: Re: Time of executed query
Date: Tue, 06 Mar 2007 14:45:01 +0100
Message-ID: <45ED7E6D.A3DD.0030.0@indicator.be> (raw)
In-Reply-To: <55c095e90703060537q5f620430wbac3d3a8197673f4@mail.gmail.com>
References: <55c095e90703060520s3e4a1feej65f56cee46fd6700@mail.gmail.com>
<45 ED7A0A.A3DD.0030.0@indicator.be>
<55c095e90703060537q5f620430wbac3d3a8197673 f4@mail.gmail.com>
Assuming you're using stored procedures...
Start procedure with logging current time, name of procedure,...
Perform whatever must be performed
End procedure with logging current time, name of procedure,...
Query logging table to get time spent
Alternative, still assuming you're using stored procedures...
Start procedure with noting current time, name of procedure,...
Perform whatever must be performed
End procedure with logging current time - start time, name of procedure,...
Query logging table to get time spent
>>> "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> 2007-03-06 14:37 >>>
I preffer that the database give me this information. I don't know if
it is possible becouse if we retrieve many rows and if we want to put
this result in a new column the same time will be replicated many
times and consuming more processing.
Any other suggestion ?
Ezequias
2007/3/6, Bart Degryse <Bart.Degryse@indicator.be>:
>
>
> note the time just before your operation starts
> note the time just after it ends
> show timeafter - timebefore
>
> >>> "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> 2007-03-06
> 14:20 >>>
>
> Hi list,
>
> It is possible to retrieve the time of a SQL statement leads to
> execute ? I would like to put in my application how much time each
> operation leads to finish.
>
> Any suggestion ?
>
> --
> Ezequias Rodrigues da Rocha
> http://ezequiasrocha.blogspot.com/
> use Mozilla Firefox:http://br.mozdev.org/firefox/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bart.Degryse@indicator.be, ezequias.rocha@gmail.com
Subject: Re: Time of executed query
In-Reply-To: <45ED7E6D.A3DD.0030.0@indicator.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox