| From: | "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | parse/bind/execute |
| Date: | 2014-06-05 01:32:26 |
| Message-ID: | D83E55F5F4D99B4A9B4C4E259E6227CD0149D128@AUX1EXC01.apac.experian.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G Johnston | 2014-06-05 01:57:56 | Re: parse/bind/execute |
| Previous Message | vlasmarias | 2014-06-05 00:27:27 | CPU load spikes when CentOS tries to reclaim 'cached' memory |