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

Reply via email to