Hello,
I am using Pgbadger to analyze the postgresql database log recently and noticed a section “Prepared queries ratio”. For my report, it has:
1.03 as Ratio of bind vs prepare
0.12% Ratio between prepared and “usual” statements
I’m trying to understand what the above metrics mean and if it’s a problem. I found people can clearly clarify the parse/bind/execute time of a query. To my limited knowledge of Postgres, using explain analyze, I can only get the total execution time.
Can someone shed me some light on this subject? How to interpret the ratios?
Thanks,
Suya