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: (view raw, whole thread or download thread mbox)
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:

 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


(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


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-2017 The PostgreSQL Global Development Group