Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
max_recursive_iterations limits the amount of iterations, but currently it is not possible
to monitor the current amount of iteration to estimate a reasonable limit.
I suggest to introduce 3 new status variables on global and session base.
recursive_iterations_avg
- average amount of iterations of all recursive cte statements.
recursive_iterations_max
- highest amount of iterations of all recursive cte statements.
recursive_iterations_reached_max
- how often the max_recursive_iterations limit was reached