Ken Tanzer <ken.tanzer@gmail.com> writes: > Hi Adrian. Happy to provide this info. Though on a side note, I don't > understand why it should matter, if functions are black box optimization > fences.
They aren't, at least not when they are SQL-language functions that meet the conditions for inlining.
Yeah, I kinda realized after I sent this that I wasn't really making much sense. :) I appreciate your explanation though.
The reason that EXPLAIN VERBOSE is helpful here is that you can see whether the function got inlined or not: do you see a call to the function, or a representation of its body?
I wasn't able to get anything more VERBOSE than what I sent before. I re-copied it below. (If there's another command or option I should be using, please advise.)
There is the difference in the two output lines, which I guess suggests that the stable one got inlined and the immutable one didn't?