phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From William Shen <wills...@marinsoftware.com>
Subject How to set up PHERF to execute the same query multiple times?
Date Sat, 15 Dec 2018 00:06:33 GMT
Hi there,

I am setting up Pherf to do some simple benchmarking to compare different
queries. The instruction seems straightforward, however I noticed that even
though I had added the NO_CACHE hint, only the first execution of the query
seems to run with an expected duration, and the subsequent executions for
that same query took no time at all. I am not sure if I had configured the
scenario incorrectly, but I had expected to see all executions of the same
to hover around the same time (50 executions to be independent of each
other for each query).

Can someone let me know what I am doing incorrectly? Thanks!

Here is the setup/result of the Pherf scenario:

<querySetResult concurrency="1" executionDurationInMs="10000000"
executionType="PARALLEL" numberOfExecutions="50">
            <queryResults id="fetchLimit100k" queryGroup="100k Limit"
statement="SELECT /*+ NO_CACHE */ * FROM PHERF.KEYWORDS_NOIDX WHERE (CSTID,
CLTID, PUBID, ACCID, CPGNID, ADGRPID) IN ((100, 100, 7, 374,104, 850))
LIMIT 100000">
                <threadTimes threadName="1,1">
                    <runTimesInMs elapsedDurationInMs="177"
resultRowCount="1" startTime="2018-12-14T23:57:08.181Z"/>
                    <runTimesInMs elapsedDurationInMs="47"
resultRowCount="1" startTime="2018-12-14T23:57:08.484Z"/>
                    <runTimesInMs elapsedDurationInMs="27"
resultRowCount="1" startTime="2018-12-14T23:57:08.531Z"/>
                    <runTimesInMs elapsedDurationInMs="23"
resultRowCount="1" startTime="2018-12-14T23:57:08.558Z"/>
                    <runTimesInMs elapsedDurationInMs="22"
resultRowCount="1" startTime="2018-12-14T23:57:08.581Z"/>
                    <runTimesInMs elapsedDurationInMs="21"
resultRowCount="1" startTime="2018-12-14T23:57:08.603Z"/>
                    <runTimesInMs elapsedDurationInMs="20"
resultRowCount="1" startTime="2018-12-14T23:57:08.624Z"/>
                    <runTimesInMs elapsedDurationInMs="20"
resultRowCount="1" startTime="2018-12-14T23:57:08.644Z"/>
                    <runTimesInMs elapsedDurationInMs="20"
resultRowCount="1" startTime="2018-12-14T23:57:08.664Z"/>
                    <runTimesInMs elapsedDurationInMs="20"
resultRowCount="1" startTime="2018-12-14T23:57:08.684Z"/>
                    <runTimesInMs elapsedDurationInMs="17"
resultRowCount="1" startTime="2018-12-14T23:57:08.704Z"/>
                    <runTimesInMs elapsedDurationInMs="19"
resultRowCount="1" startTime="2018-12-14T23:57:08.721Z"/>
                    <runTimesInMs elapsedDurationInMs="19"
resultRowCount="1" startTime="2018-12-14T23:57:08.740Z"/>
                    <runTimesInMs elapsedDurationInMs="17"
resultRowCount="1" startTime="2018-12-14T23:57:08.759Z"/>
                    <runTimesInMs elapsedDurationInMs="17"
resultRowCount="1" startTime="2018-12-14T23:57:08.776Z"/>
                    <runTimesInMs elapsedDurationInMs="18"
resultRowCount="1" startTime="2018-12-14T23:57:08.793Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.811Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:08.827Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:08.842Z"/>
                    <runTimesInMs elapsedDurationInMs="17"
resultRowCount="1" startTime="2018-12-14T23:57:08.857Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:08.874Z"/>
                    <runTimesInMs elapsedDurationInMs="14"
resultRowCount="1" startTime="2018-12-14T23:57:08.889Z"/>
                    <runTimesInMs elapsedDurationInMs="17"
resultRowCount="1" startTime="2018-12-14T23:57:08.903Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.920Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.936Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.952Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.968Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.984Z"/>
                    <runTimesInMs elapsedDurationInMs="14"
resultRowCount="1" startTime="2018-12-14T23:57:09Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.014Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.029Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.044Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.060Z"/>
                    <runTimesInMs elapsedDurationInMs="14"
resultRowCount="1" startTime="2018-12-14T23:57:09.075Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.089Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.105Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.121Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.136Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.152Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.168Z"/>
                    <runTimesInMs elapsedDurationInMs="17"
resultRowCount="1" startTime="2018-12-14T23:57:09.184Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.201Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.216Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.231Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.247Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.264Z"/>
                    <runTimesInMs elapsedDurationInMs="14"
resultRowCount="1" startTime="2018-12-14T23:57:09.279Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.293Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.309Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.325Z"/>
                </threadTimes>
            </queryResults>
            <queryResults id="fetchNormal" queryGroup="No Limit"
statement="SELECT /*+ NO_CACHE */ * FROM PHERF.KEYWORDS_NOIDX WHERE (CSTID,
CLTID, PUBID, ACCID, CPGNID, ADGRPID) IN ((100, 100, 7, 374,104, 850))">
                <threadTimes threadName="1,1">
                    <runTimesInMs elapsedDurationInMs="153"
resultRowCount="1" startTime="2018-12-14T23:57:08.181Z"/>
                    <runTimesInMs elapsedDurationInMs="17"
resultRowCount="1" startTime="2018-12-14T23:57:08.461Z"/>
                    <runTimesInMs elapsedDurationInMs="14"
resultRowCount="1" startTime="2018-12-14T23:57:08.478Z"/>
                    <runTimesInMs elapsedDurationInMs="27"
resultRowCount="1" startTime="2018-12-14T23:57:08.492Z"/>
                    <runTimesInMs elapsedDurationInMs="14"
resultRowCount="1" startTime="2018-12-14T23:57:08.519Z"/>
                    <runTimesInMs elapsedDurationInMs="11"
resultRowCount="1" startTime="2018-12-14T23:57:08.533Z"/>
                    <runTimesInMs elapsedDurationInMs="10"
resultRowCount="1" startTime="2018-12-14T23:57:08.544Z"/>
                    <runTimesInMs elapsedDurationInMs="9"
resultRowCount="1" startTime="2018-12-14T23:57:08.554Z"/>
                    <runTimesInMs elapsedDurationInMs="11"
resultRowCount="1" startTime="2018-12-14T23:57:08.563Z"/>
                    <runTimesInMs elapsedDurationInMs="8"
resultRowCount="1" startTime="2018-12-14T23:57:08.574Z"/>
                    <runTimesInMs elapsedDurationInMs="9"
resultRowCount="1" startTime="2018-12-14T23:57:08.582Z"/>
                    <runTimesInMs elapsedDurationInMs="11"
resultRowCount="1" startTime="2018-12-14T23:57:08.591Z"/>
                    <runTimesInMs elapsedDurationInMs="8"
resultRowCount="1" startTime="2018-12-14T23:57:08.602Z"/>
                    <runTimesInMs elapsedDurationInMs="8"
resultRowCount="1" startTime="2018-12-14T23:57:08.610Z"/>
                    <runTimesInMs elapsedDurationInMs="8"
resultRowCount="1" startTime="2018-12-14T23:57:08.618Z"/>
                    <runTimesInMs elapsedDurationInMs="7"
resultRowCount="1" startTime="2018-12-14T23:57:08.626Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.633Z"/>
                    <runTimesInMs elapsedDurationInMs="8"
resultRowCount="1" startTime="2018-12-14T23:57:08.639Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.647Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.653Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.659Z"/>
                    <runTimesInMs elapsedDurationInMs="7"
resultRowCount="1" startTime="2018-12-14T23:57:08.665Z"/>
                    <runTimesInMs elapsedDurationInMs="5"
resultRowCount="1" startTime="2018-12-14T23:57:08.672Z"/>
                    <runTimesInMs elapsedDurationInMs="5"
resultRowCount="1" startTime="2018-12-14T23:57:08.678Z"/>
                    <runTimesInMs elapsedDurationInMs="7"
resultRowCount="1" startTime="2018-12-14T23:57:08.683Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.690Z"/>
                    <runTimesInMs elapsedDurationInMs="7"
resultRowCount="1" startTime="2018-12-14T23:57:08.696Z"/>
                    <runTimesInMs elapsedDurationInMs="7"
resultRowCount="1" startTime="2018-12-14T23:57:08.703Z"/>
                    <runTimesInMs elapsedDurationInMs="5"
resultRowCount="1" startTime="2018-12-14T23:57:08.710Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.715Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.721Z"/>
                    <runTimesInMs elapsedDurationInMs="7"
resultRowCount="1" startTime="2018-12-14T23:57:08.727Z"/>
                    <runTimesInMs elapsedDurationInMs="7"
resultRowCount="1" startTime="2018-12-14T23:57:08.734Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.741Z"/>
                    <runTimesInMs elapsedDurationInMs="7"
resultRowCount="1" startTime="2018-12-14T23:57:08.747Z"/>
                    <runTimesInMs elapsedDurationInMs="5"
resultRowCount="1" startTime="2018-12-14T23:57:08.754Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.759Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.765Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.771Z"/>
                    <runTimesInMs elapsedDurationInMs="5"
resultRowCount="1" startTime="2018-12-14T23:57:08.777Z"/>
                    <runTimesInMs elapsedDurationInMs="5"
resultRowCount="1" startTime="2018-12-14T23:57:08.782Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.787Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.793Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.799Z"/>
                    <runTimesInMs elapsedDurationInMs="8"
resultRowCount="1" startTime="2018-12-14T23:57:08.805Z"/>
                    <runTimesInMs elapsedDurationInMs="5"
resultRowCount="1" startTime="2018-12-14T23:57:08.813Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.818Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.824Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.830Z"/>
                    <runTimesInMs elapsedDurationInMs="6"
resultRowCount="1" startTime="2018-12-14T23:57:08.836Z"/>
                </threadTimes>
            </queryResults>
            <queryResults id="fetchLimit10k" queryGroup="10k Limit"
statement="SELECT /*+ NO_CACHE */ * FROM PHERF.KEYWORDS_NOIDX WHERE (CSTID,
CLTID, PUBID, ACCID, CPGNID, ADGRPID) IN ((100, 100, 7, 374,104, 850))
LIMIT 10000">
                <threadTimes threadName="1,1">
                    <runTimesInMs elapsedDurationInMs="177"
resultRowCount="1" startTime="2018-12-14T23:57:08.181Z"/>
                    <runTimesInMs elapsedDurationInMs="51"
resultRowCount="1" startTime="2018-12-14T23:57:08.461Z"/>
                    <runTimesInMs elapsedDurationInMs="32"
resultRowCount="1" startTime="2018-12-14T23:57:08.513Z"/>
                    <runTimesInMs elapsedDurationInMs="23"
resultRowCount="1" startTime="2018-12-14T23:57:08.545Z"/>
                    <runTimesInMs elapsedDurationInMs="23"
resultRowCount="1" startTime="2018-12-14T23:57:08.568Z"/>
                    <runTimesInMs elapsedDurationInMs="21"
resultRowCount="1" startTime="2018-12-14T23:57:08.592Z"/>
                    <runTimesInMs elapsedDurationInMs="22"
resultRowCount="1" startTime="2018-12-14T23:57:08.613Z"/>
                    <runTimesInMs elapsedDurationInMs="21"
resultRowCount="1" startTime="2018-12-14T23:57:08.635Z"/>
                    <runTimesInMs elapsedDurationInMs="21"
resultRowCount="1" startTime="2018-12-14T23:57:08.656Z"/>
                    <runTimesInMs elapsedDurationInMs="17"
resultRowCount="1" startTime="2018-12-14T23:57:08.677Z"/>
                    <runTimesInMs elapsedDurationInMs="18"
resultRowCount="1" startTime="2018-12-14T23:57:08.694Z"/>
                    <runTimesInMs elapsedDurationInMs="18"
resultRowCount="1" startTime="2018-12-14T23:57:08.712Z"/>
                    <runTimesInMs elapsedDurationInMs="21"
resultRowCount="1" startTime="2018-12-14T23:57:08.730Z"/>
                    <runTimesInMs elapsedDurationInMs="18"
resultRowCount="1" startTime="2018-12-14T23:57:08.751Z"/>
                    <runTimesInMs elapsedDurationInMs="18"
resultRowCount="1" startTime="2018-12-14T23:57:08.769Z"/>
                    <runTimesInMs elapsedDurationInMs="18"
resultRowCount="1" startTime="2018-12-14T23:57:08.787Z"/>
                    <runTimesInMs elapsedDurationInMs="18"
resultRowCount="1" startTime="2018-12-14T23:57:08.805Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.823Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:08.839Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.854Z"/>
                    <runTimesInMs elapsedDurationInMs="17"
resultRowCount="1" startTime="2018-12-14T23:57:08.870Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.887Z"/>
                    <runTimesInMs elapsedDurationInMs="17"
resultRowCount="1" startTime="2018-12-14T23:57:08.903Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.920Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.936Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.952Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.968Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:08.984Z"/>
                    <runTimesInMs elapsedDurationInMs="14"
resultRowCount="1" startTime="2018-12-14T23:57:09Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.014Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.029Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.044Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.060Z"/>
                    <runTimesInMs elapsedDurationInMs="14"
resultRowCount="1" startTime="2018-12-14T23:57:09.075Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.089Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.105Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.121Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.136Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.152Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.168Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.184Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.200Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.216Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.231Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.247Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.263Z"/>
                    <runTimesInMs elapsedDurationInMs="14"
resultRowCount="1" startTime="2018-12-14T23:57:09.279Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.293Z"/>
                    <runTimesInMs elapsedDurationInMs="16"
resultRowCount="1" startTime="2018-12-14T23:57:09.309Z"/>
                    <runTimesInMs elapsedDurationInMs="15"
resultRowCount="1" startTime="2018-12-14T23:57:09.325Z"/>
                </threadTimes>
            </queryResults>
        </querySetResult>

Mime
View raw message