Re: sequential explain analyze command execution

Your first email was arrived correctly. There was no need for a second one.

As for the query you could do something like

explain analyze select *
from (query1) as q1, (query2) as q2, ... (queryN) as qN;

But that might incur in a lot of memory swapping if you select a bunch of rows in some of these queries.

An alternative is doing something like

create function myquerytest() returning integer as $$
   query1
   query2
   ...
   queryN
   select 1;
$$ language sql;

explain analyze select myquerytest();

drop function myquerytest();

In either case I would put the code in a file and then "give" it to psql using the -f option and set the -o option to the desired output file . Since you are using pgadmin3 I have no idea.

good luck,
Marcelo Lacerda