Getting time of a postgresql-request

Поиск
Список
Период
Сортировка
От Kai Behncke
Тема Getting time of a postgresql-request
Дата
Msg-id 20090817163813.167650@gmx.net
обсуждение исходный текст
Ответы Re: Getting time of a postgresql-request  (Russell Smith <mr-russ@pws.com.au>)
Number of tables  (Fabio La Farcioli <fabio.lafarcioli@molinoalimonti.com>)
Список pgsql-performance
Dear users,

I try to optimize the time of my Postgresql-requests, but for that, the first step,
I of course need to get that time.

I know that with:

EXPLAIN ANALYSE SELECT bundesland from
 bundesland WHERE ST_Contains(the_geom, $punktgeometrie_start) AND
 ST_Contains(the_geom, $punktgeometrie_ende)

I can get that time on command line.

But I would like to get it in a php-script, like

$timerequest_result=pg_result($timerequest,0);

(well, that does not work).

I wonder: Is there another way to get the time a request needs?
How do you handle this?

Thank you very much, Kai

--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01

В списке pgsql-performance по дате отправления:

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Re: Memory reporting on CentOS Linux
Следующее
От: Jeremy Carroll
Дата:
Сообщение: Re: Memory reporting on CentOS Linux