Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Jeremy CarrollDate: 2009-08-17 17:24:36
Subject: Re: Memory reporting on CentOS Linux
Previous:From: Kevin GrittnerDate: 2009-08-17 14:38:59
Subject: Re: freezing tuples ( was: Why is vacuum_freeze_min_age100m? )

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group