Re: Sending Explain output to a perl client

Thanks Tom. Guess I should have tried it before I posted. Turns out the
explain output goes both in my Apache error log (the script was running under
mod_perl) and my postgresql log, without doing anything special. DBD::Pg must be
treating it like an error message, which seems to work out fine.

At least I learned from finally looking at the pgsql log that I needed to
increase my WAL_FILES parameter. And I figured out which version of the query to
use. Thanks,

Wes Sheldahl

Tom Lane <tgl%sss(dot)pgh(dot)pa(dot)us(at)interlock(dot)lexmark(dot)com> on 12/04/2001 01:38:23 PM

To: "Wesley_Sheldahl/Lex/Lexmark.LEXMARK"@sweeper.lex.lexmark.com
cc: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com (bcc: Wesley
Sheldahl/Lex/Lexmark)
Subject: Re: [GENERAL] Sending Explain output to a perl client

wsheldah(at)lexmark(dot)com writes:
> or is there another way to capture the EXPLAIN output from
> a perl client?

If you don't want to tweak the DBD driver, you could just read the
explain results in the postmaster's log.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)