Re: Time of executed query
От | Ezequias Rodrigues da Rocha |
---|---|
Тема | Re: Time of executed query |
Дата | |
Msg-id | 55c095e90703060537q5f620430wbac3d3a8197673f4@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Time of executed query ("Bart Degryse" <Bart.Degryse@indicator.be>) |
Ответы |
Re: Time of executed query
Re: Time of executed query |
Список | pgsql-sql |
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/
В списке pgsql-sql по дате отправления: