Re: [PERFORM] parse/bind/execute

2014-06-04 Thread David Johnston
Please do not top-posts on these lists. On Wednesday, June 4, 2014, Huang, Suya wrote: > Thank you David, I copied the detailed activity from the report as below. > As it shows, it has prepare and bind queries. One of the item has > Bind/Prepare pretty high as 439.50. so that looks like a good

Re: [PERFORM] parse/bind/execute

2014-06-04 Thread Huang, Suya
: Thursday, June 05, 2014 11:58 AM To: pgsql-performance@postgresql.org Subject: Re: [PERFORM] parse/bind/execute Huang, Suya wrote > Hello, > > I am using Pgbadger to analyze the postgresql database log recently > and noticed a section "Prepared queries ratio". For my report

Re: [PERFORM] parse/bind/execute

2014-06-04 Thread David G Johnston
Huang, Suya wrote > 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

[PERFORM] parse/bind/execute

2014-06-04 Thread Huang, Suya
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