Skip site navigation (1) Skip section navigation (2)

Re: Tuning planner cost estimates

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Tuning planner cost estimates
Date: 2005-05-19 17:16:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Josh Berkus <josh(at)agliodbs(dot)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

In response to


pgsql-performance by date

Next:From: Josh BerkusDate: 2005-05-19 17:21:05
Subject: Re: Tuning planner cost estimates
Previous:From: Donald CourtneyDate: 2005-05-19 16:54:03
Subject: Re: PostgreSQL strugling during high load

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group