Re: Time of executed query

From: "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be>
To: "PostgreSQL" <pgsql-sql(at)postgresql(dot)org>
Cc: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
Subject: Re: Time of executed query
Date: 2007-03-06 13:26:18
Message-ID: 45ED7A0A.A3DD.0030.0@indicator.be
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-sql

note the time just before your operation starts
note the time just after it ends
show timeafter - timebefore

>>> "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2007-03-06 13:37:41 Re: Time of executed query
Previous Message Ezequias Rodrigues da Rocha 2007-03-06 13:20:04 Time of executed query

Browse pgsql-sql by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2007-03-06 13:37:41 Re: Time of executed query
Previous Message Ezequias Rodrigues da Rocha 2007-03-06 13:20:04 Time of executed query