> - 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.