Thread: Time of executed query

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/

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/

EXPLAIN ANALYZE Is perfect but i have no idea of how to use it. My
resultset is retrieving my rows.

Another question that cames with the Analyze. PgAdmin return the time
to retrieve the data or all time to fill the grid on the "SQL Editor".

-- 
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/


2007/3/6, Shoaib Mir <shoaibmir@gmail.com>:
> Did you try EXPLAIN ANALYZE <SQL Query>?
>
> ---
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
>
> On 3/6/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> > 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/
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 5: don't forget to increase your free space map settings
> >
>
>

On 3/6/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> 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/

Use psql:

t=# \timing
t=# SELECT * FROM generate_series(1,100000) WHERE random() = 0.234;generate_series
-----------------
(0 rows)

Time: 125.000 ms
t=#

See:

http://www.postgresql.org/docs/8.2/static/app-psql.html

On 3/6/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> 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/

Sorry, didn't see the app part.

Use clock_timestamp().

See:

http://www.postgresql.org/docs/8.2/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT