> 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?
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Anjan Dave||Date: 2005-05-19 18:12:29|
|Subject: Re: PostgreSQL strugling during high load|
|Previous:||From: Tom Lane||Date: 2005-05-19 17:16:21|
|Subject: Re: Tuning planner cost estimates |