AgentM wrote:
> Couldn't the session be explicitly transferred into a special
> analysis mode? Explain analyze could run on every query implicitly
> and point out time and row count discrepancies as HINTs. Multi-column
> joins, for example, could be pointed out and display whether or not
> there are related indexes.
Meet EXPLAIN ANALYZE.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/