> - EXPLAIN does not work with functions.
+1
and one more about explain - it would be great to have smth like:
EXPLAIN ANALYZE FULL - that would show details about the plan chosen
with detailed explanation and other plans considered.
It would reduce a few posts a week in style:
- 'why the query A doesn't use index B'
with answer
- '... planner .... estimated cost ....'
I think it would help a lot of people if the community don't want to
have hints.
In response to
pgsql-general by date
| Next: | From: David Fetter | Date: 2009-02-02 22:08:26 |
| Subject: Re: Is dropping pg_ts_* harmful? |
| Previous: | From: Martijn van Oosterhout | Date: 2009-02-02 22:00:08 |
| Subject: Re: plpgsql and control structures |