[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] parse/bind/execute
From:       David Johnston <david.g.johnston () gmail ! com>
Date:       2014-06-05 2:34:31
Message-ID: CAKFQuwYD1-n5V=yKCDajQSVsuC2MeOzKXXPy1N4N2x0dm41yTA () mail ! gmail ! com
[Download RAW message or body]

Please do not top-posts on these lists.

On Wednesday, June 4, 2014, Huang, Suya <Suya.Huang@au.experian.com> 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 value?
>
> Another question is if bind only happens in a prepared statement?
>
> Day     Hour    Prepare         Bind    Bind/Prepare    Percentage of
> prepare
> Jun 03  00      205     209     1.02    1.27%
>         01      19      19      1.00    0.17%
>         02      0       0       0.00    0.00%
>         03      0       0       0.00    0.00%
>         04      6       6       1.00    0.00%
>         05      2       879     439.50  0.02%
>         06      839     1,323   1.58    7.01%
>         07      0       0       0.00    0.00%
>
>
>
Yes. Something that high usual involves batch inserting into a table.  To
be honest, a global picture is of limited value for this very reason.
 Representing all of your usage as a single number is problematic.
 Breaking it down by hour as done here increases the likelihood of seeing
something useful but typically that would be by chance.  In this case
because batch processing is done in the early morning and few users are
probably on the system (a common source of one-off statements) the numbers
here are dominated by the special case of bulk inserts and are not typical
of normal activity and performance.

David J.

[Attachment #3 (text/html)]

Please do not top-posts on these lists.<br><br>On Wednesday, June 4, 2014, Huang, \
Suya &lt;<a href="mailto:Suya.Huang@au.experian.com">Suya.Huang@au.experian.com</a>&gt; \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"> 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 value?<br> <br>
Another question is if bind only happens in a prepared statement?<br>
<br>
Day       Hour      Prepare             Bind      Bind/Prepare      Percentage of \
prepare<br> Jun 03   00         205       209       1.02      1.27%<br>
            01         19         19         1.00      0.17%<br>
            02         0          0          0.00      0.00%<br>
            03         0          0          0.00      0.00%<br>
            04         6          6          1.00      0.00%<br>
            05         2          879       439.50   0.02%<br>
            06         839       1,323    1.58      7.01%<br>
            07         0          0          0.00      0.00%<br>
<br><br>
</blockquote><div><br></div><div>Yes. Something that high usual involves batch \
inserting into a table.   To be honest, a global picture is of limited value for this \
very reason.   Representing all of your usage as a single number is problematic.   \
Breaking it down by hour as done here increases the likelihood of seeing something \
useful but typically that would be by chance.   In this case because batch processing \
is done in the early morning and few users are probably on the system (a common \
source of one-off statements) the numbers here are dominated by the special case of \
bulk inserts and are not typical of normal activity and performance.</div> \
<div><br></div><div>David J.</div><div><br></div><div><br></div><div><br></div><div>  \
<br></div>



[prev in list] [next in list] [prev in thread] [next in thread]