Very Computer

Hi,

I'm trying to tune a query that includes a correlated subquery, by moving the
subquery to a temporary table and joining on that, hoping to improve things by
not executing the subquery for every row. My immediate problem is that since the
temporary table is session specific and I'm running it from perl, I can't paste
the SQL into a psql session to run EXPLAIN on it. Can I treat the EXPLAIN
results like a column from a regular result set and have perl retrieve it like a
regular column value, or is there another way to capture the EXPLAIN output from
a perl client?

Many thanks,

Wes Sheldahl

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command