|
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 |
