Function planer related parameters helps in giving the planner information about the function execution cost, this helps the planner to generate a good execution plans. The following three parameters are used by the planner to determine the cost of executing the function, the number of rows that are expected to be returned, and whether the function pushes down when evaluating predicates. These parameters are:
- Leakproof: Leakproof means that the function has no side effects. It does not reveal any information about its argument. For example, it does not throw error messages about its argument. This parameter affects views with the security_barrier parameter.
- Cost: Declares the execution cost per row; the ...
