| From: | "Kai Behncke" <Kai-Behncke(at)gmx(dot)de> | 
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org | 
| Subject: | Getting time of a postgresql-request | 
| Date: | 2009-08-17 16:38:13 | 
| Message-ID: | 20090817163813.167650@gmx.net | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Carroll | 2009-08-17 17:24:36 | Re: Memory reporting on CentOS Linux | 
| Previous Message | Kevin Grittner | 2009-08-17 14:38:59 | Re: freezing tuples ( was: Why is vacuum_freeze_min_age100m? ) |