auto-explain does not work with JSON & csvlog - Mailing list pgsql-bugs

From Josh Berkus
Subject auto-explain does not work with JSON & csvlog
Date
Msg-id 4C431261.2060609@agliodbs.com
Whole thread Raw
Responses Re: auto-explain does not work with JSON & csvlog  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: auto-explain does not work with JSON & csvlog  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Version: 9.0 beta 3
Severity: Contrib feature broken
Platform: Ubuntu Netbook Remix, Dell 10 Mini laptop
Workaround Possible?  No.

With 9.0, the obvious thing to do with autoexplain is to log JSON or XML
explain plans to a csvlog and then automatically process them.

However, when I attempt to do this, I get the following warning at
PostgreSQL startup time:

Loaded module "auto_explain"
Not safe to send CSV data

And on checking, auto-explain is indeed NOT sending anything to the
csvlog.  It's not sending anything to the regular log, either.

--
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com

pgsql-bugs by date:

Previous
From: "Daniel Grace"
Date:
Subject: BUG #5564: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)
Next
From: Tom Lane
Date:
Subject: Re: auto-explain does not work with JSON & csvlog