[OSM-dev] Problem With Tirex Render Stack

[Stefan Menzel]

HI Peter,
this shows me the currently working queries. Is there a way to see which
query was not successfully or how much time which query took?

Best regards 

Stefan


-----Ursprüngliche Nachricht-----
Von: Peter Körner [mailto:osm-lists at mazdermind.de] 
Gesendet: Dienstag, 14. Juni 2011 17:21
An: Stefan Menzel
Cc: dev at openstreetmap.org
Betreff: Re: [OSM-dev] Problem With Tirex Render Stack

Am 14.06.2011 17:05, schrieb Stefan Menzel:
> Each querry process took already has
> 1GB Ram but it still don’t work. The jobs.log doesn’t give any hints. So
> what can I do?

You could take a look at the pg_stat_activity table:

http://www.question-defense.com/2008/11/12/postgres-table-pg_stat_activity-t
able-fields-explained

Peter