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