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

Re: auto_explain contrib moudle

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: auto_explain contrib moudle
Date: 2008-11-11 17:54:44
Message-ID: 1226426084.3002.76.camel@jdavis (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Mon, 2008-11-10 at 18:02 +0900, ITAGAKI Takahiro wrote:
> That's because explain.log_analyze requires executor instruments,
> and it's not free. I think we'd better to have an option to avoid
> the overheads... Oops, I found my bug when force_instrument is
> turned on. It should be enabled only when
> (explain_log_min_duration >= 0 && explain_log_analyze).
> I send a new patch to fix it. A documentation about
> explain.log_nested_statements is also added to the sgml file.

Great. I attached a patch with some minor documentation changes.

There seems to be no auto_explain view, so I assumed that section of the
docs was old, and I removed it. Let me know if you intend to include the

Thanks! This patch is ready to go, as far as I'm concerned.

	Jeff Davis

Attachment: auto-explain.1111.patch
Description: text/x-patch (23.1 KB)

In response to


pgsql-hackers by date

Next:From: Sam MasonDate: 2008-11-11 18:01:59
Subject: Re: Question about SPI_prepare
Previous:From: Tim KeittDate: 2008-11-11 17:33:41
Subject: Question about SPI_prepare

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