"J. Greg Davidson" <jgd@xxxxxxxx> writes: > (1) What are the current criteria for when an SQL function called > within another SQL function will be inlined? It depends on a number of things, not least which PG version you're talking about. When in doubt, consult the source code (see inline_function or inline_set_returning_function in src/backend/optimizer/util/clauses.c) > (2) Is there some easy way to tell without massive logging whether > a particular function has been inlined? I've tried doing various > EXPLAIN ... SELECT foo(...); > kinds of things where foo() calls bar() and I don't see that I can > tell anything about the inline status of either function. Try EXPLAIN VERBOSE. You should see either the function or its expansion. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
