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 > > > >
