Re: [SQL] How to start the "auto_explain" module

In response to aymen marouani : > Hi, > In order to profile my Postgres queries, I used > the "auto_explain.log_min_duration (integer)". > How can I load the auto_explain module ? > Thanks in advance. http://www.depesz.com/index.php/2008/11/23/waiting-for-84-auto-explain/ Read that. Andreas --

Re: [SQL] Profiling tool for postgres under win32

On 26/11/2009 5:48 PM, aymen marouani wrote: > Hi, > I'm using the Postgres database system version 8.3 for a J2EE application. > I'd like to profile and monitor in "real time" the status of my queries > because I notice some slow loading. > Can anyone tell how to get a "good" profiling tool for t

[SQL] How to start the "auto_explain" module

Hi, In order to profile my Postgres queries, I used the "auto_explain.lo g_min_duration (integer)". How can I load the auto_explain module ? Thanks in advance.

Re: [SQL] CREATE SERVER - what is this?

Le mardi 24 novembre 2009 à 16:45:27, Richard Broersma a écrit : > I noticed a few new SQL references in the manual: > > CREATE SERVER > CREATE FOREIGN DATA WRAPPER, > CREATE USER MAPPING > > Is this similar to DBI-Link? > They appear on the 8.4 release. They were added to support the use of SQ

Re: [SQL] Profiling tool for postgres under win32

In response to aymen marouani : > Hi, > I'm using the Postgres database system version 8.3 for a J2EE application. > I'd  like to profile and monitor in "real time" the status of my queries > because I notice some slow loading. > Can anyone tell how to get a "good" profiling tool for the Postgres d

[SQL] Profiling tool for postgres under win32

Hi, I'm using the Postgres database system version 8.3 for a J2EE application. I'd like to profile and monitor in "real time" the status of my queries because I notice some slow loading. Can anyone tell how to get a "good" profiling tool for the Postgres database system ? Thanks in advance.