Re: Tuning planner cost estimates - Mailing list pgsql-performance

Josh Berkus <josh@agliodbs.com> writes:
> I think a first step would be, in fact, to develop a tool that allows us to
> put EXPLAIN ANALYZE results in a database table.  Without that, there is no
> possibility of statistical-scale analysis.

AFAIK you can do that today using, eg, plpgsql:

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

            regards, tom lane