Tom,

>       for rec in explain analyze ... loop
>               insert into table values(rec."QUERY PLAN");
>       end loop;

I need to go further than that and parse the results as well.  And preserve 
relationships and nesting levels.   

Hmmmm ... what's the indenting formula for nesting levels?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to