Getting time of a postgresql-request

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-performance by date

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