launchpad-dev team mailing list archive

[Stuart Bishop <stuart.bishop@xxxxxxxxxxxxx>]

On Mon, Sep 6, 2010 at 11:39 AM, Martin Pool <mbp@xxxxxxxxxxxxx> wrote:
> On 6 September 2010 13:45, Stuart Bishop <stuart.bishop@xxxxxxxxxxxxx> wrote:
>> We could turn on the logging for a single request. The problem is that
>> the output goes to the PostgreSQL logs, not somewhere we can easily
>> extract them.
>
> To judge from the documentation, we can tell it to send logs to the
> client (ie the web app) and then that could put them into either an
> oops or a comment at the end of a request or something else.

Didn't realize that. Yes, we can get the output to the client. It is
in a particularly unreadable format so we would need to render it like
EXPLAIN does, and big so we certainly won't want to do this for all
requests, but it looks doable. I also notice we can inform the client
when it has waited for a lock longer than 1 second, which would be
cool to log.





-- 
Stuart Bishop <stuart@xxxxxxxxxxxxxxxx>
http://www.stuartbishop.net/