Skip to content

Instantly share code, notes, and snippets.

@khailey-zz

khailey-zz/pgload.jmx

Created February 27, 2017 22:48
Star
Embed
What would you like to do?
Learn more about clone URLs
Download ZIP
Raw
pgload.jmx
<?xml version="1.0" encoding="UTF-8"?>
<jmeterTestPlan version="1.2" properties="2.9" jmeter="3.0 r1743807">
<hashTree>
<TestPlan guiclass="TestPlanGui" testclass="TestPlan" testname="Test Plan" enabled="true">
<stringProp name="TestPlan.comments"></stringProp>
<boolProp name="TestPlan.functional_mode">false</boolProp>
<boolProp name="TestPlan.serialize_threadgroups">false</boolProp>
<elementProp name="TestPlan.user_defined_variables" elementType="Arguments" guiclass="ArgumentsPanel" testclass="Arguments" testname="User Defined Variables" enabled="true">
<collectionProp name="Arguments.arguments"/>
</elementProp>
<stringProp name="TestPlan.user_define_classpath">/Users/kylelf/rds/jmeter/postgres/postgresql-9.4-jdbc4.jar</stringProp>
</TestPlan>
<hashTree>
<JDBCDataSource guiclass="TestBeanGUI" testclass="JDBCDataSource" testname="setup_connection" enabled="true">
<stringProp name="dataSource">setup_connection</stringProp>
<stringProp name="poolMax">1</stringProp>
<stringProp name="timeout">10000</stringProp>
<stringProp name="trimInterval">60000</stringProp>
<boolProp name="autocommit">true</boolProp>
<stringProp name="transactionIsolation">DEFAULT</stringProp>
<boolProp name="keepAlive">true</boolProp>
<stringProp name="connectionAge">5000</stringProp>
<stringProp name="checkQuery">Select 1</stringProp>
<stringProp name="dbUrl">jdbc:postgresql://kylelf2.c3o7fyskibto.us-east-1-beta.rds.amazonaws.com:5432/postgres</stringProp>
<stringProp name="driver">org.postgresql.Driver</stringProp>
<stringProp name="username">kylelf</stringProp>
<stringProp name="password">Hndrsn13!</stringProp>
</JDBCDataSource>
<hashTree/>
<ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="setup" enabled="true">
<stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
<elementProp name="ThreadGroup.main_controller" elementType="LoopController" guiclass="LoopControlPanel" testclass="LoopController" testname="Loop Controller" enabled="true">
<boolProp name="LoopController.continue_forever">false</boolProp>
<stringProp name="LoopController.loops">1</stringProp>
</elementProp>
<stringProp name="ThreadGroup.num_threads">1</stringProp>
<stringProp name="ThreadGroup.ramp_time">1</stringProp>
<longProp name="ThreadGroup.start_time">1484954304000</longProp>
<longProp name="ThreadGroup.end_time">1484954304000</longProp>
<boolProp name="ThreadGroup.scheduler">false</boolProp>
<stringProp name="ThreadGroup.duration"></stringProp>
<stringProp name="ThreadGroup.delay"></stringProp>
</ThreadGroup>
<hashTree>
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="create_sequence" enabled="true">
<stringProp name="dataSource">setup_connection</stringProp>
<stringProp name="queryType">Select Statement</stringProp>
<stringProp name="query">CREATE SEQUENCE serial START 101;</stringProp>
<stringProp name="queryArguments"></stringProp>
<stringProp name="queryArgumentsTypes"></stringProp>
<stringProp name="variableNames"></stringProp>
<stringProp name="resultVariable"></stringProp>
<stringProp name="queryTimeout"></stringProp>
<stringProp name="resultSetHandler">Store as String</stringProp>
</JDBCSampler>
<hashTree/>
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="create_table" enabled="true">
<stringProp name="dataSource">setup_connection</stringProp>
<stringProp name="queryType">Select Statement</stringProp>
<stringProp name="query">CREATE TABLE authors (id INT, name VARCHAR(20), email VARCHAR(20));</stringProp>
<stringProp name="queryArguments"></stringProp>
<stringProp name="queryArgumentsTypes"></stringProp>
<stringProp name="variableNames"></stringProp>
<stringProp name="resultVariable"></stringProp>
<stringProp name="queryTimeout"></stringProp>
<stringProp name="resultSetHandler">Store as String</stringProp>
</JDBCSampler>
<hashTree/>
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="create_index" enabled="true">
<stringProp name="dataSource">setup_connection</stringProp>
<stringProp name="queryType">Select Statement</stringProp>
<stringProp name="query">CREATE INDEX authors_id ON authors (id);</stringProp>
<stringProp name="queryArguments"></stringProp>
<stringProp name="queryArgumentsTypes"></stringProp>
<stringProp name="variableNames"></stringProp>
<stringProp name="resultVariable"></stringProp>
<stringProp name="queryTimeout"></stringProp>
<stringProp name="resultSetHandler">Store as String</stringProp>
</JDBCSampler>
<hashTree/>
<ResultCollector guiclass="ViewResultsFullVisualizer" testclass="ResultCollector" testname="View Results Tree" enabled="true">
<boolProp name="ResultCollector.error_logging">false</boolProp>
<objProp>
<name>saveConfig</name>
<value class="SampleSaveConfiguration">
<time>true</time>
<latency>true</latency>
<timestamp>true</timestamp>
<success>true</success>
<label>true</label>
<code>true</code>
<message>true</message>
<threadName>true</threadName>
<dataType>true</dataType>
<encoding>false</encoding>
<assertions>true</assertions>
<subresults>true</subresults>
<responseData>false</responseData>
<samplerData>false</samplerData>
<xml>false</xml>
<fieldNames>true</fieldNames>
<responseHeaders>false</responseHeaders>
<requestHeaders>false</requestHeaders>
<responseDataOnError>false</responseDataOnError>
<saveAssertionResultsFailureMessage>true</saveAssertionResultsFailureMessage>
<assertionsResultsToSave>0</assertionsResultsToSave>
<bytes>true</bytes>
<threadCounts>true</threadCounts>
<idleTime>true</idleTime>
</value>
</objProp>
<stringProp name="filename"></stringProp>
</ResultCollector>
<hashTree/>
</hashTree>
<JDBCDataSource guiclass="TestBeanGUI" testclass="JDBCDataSource" testname="JDBC Connection Configuration" enabled="true">
<stringProp name="dataSource">pdbpool</stringProp>
<stringProp name="poolMax">20</stringProp>
<stringProp name="timeout">10000</stringProp>
<stringProp name="trimInterval">60000</stringProp>
<boolProp name="autocommit">true</boolProp>
<stringProp name="transactionIsolation">DEFAULT</stringProp>
<boolProp name="keepAlive">true</boolProp>
<stringProp name="connectionAge">5000</stringProp>
<stringProp name="checkQuery">Select 1</stringProp>
<stringProp name="dbUrl">jdbc:postgresql://host:5432/postgres</stringProp>
<stringProp name="driver">org.postgresql.Driver</stringProp>
<stringProp name="username">kylelf</stringProp>
<stringProp name="password">kylelf</stringProp>
</JDBCDataSource>
<hashTree/>
<ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="postgres" enabled="true">
<stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
<elementProp name="ThreadGroup.main_controller" elementType="LoopController" guiclass="LoopControlPanel" testclass="LoopController" testname="Loop Controller" enabled="true">
<boolProp name="LoopController.continue_forever">false</boolProp>
<stringProp name="LoopController.loops">40000</stringProp>
</elementProp>
<stringProp name="ThreadGroup.num_threads">15</stringProp>
<stringProp name="ThreadGroup.ramp_time">1</stringProp>
<longProp name="ThreadGroup.start_time">1478546001000</longProp>
<longProp name="ThreadGroup.end_time">1478546001000</longProp>
<boolProp name="ThreadGroup.scheduler">false</boolProp>
<stringProp name="ThreadGroup.duration"></stringProp>
<stringProp name="ThreadGroup.delay"></stringProp>
</ThreadGroup>
<hashTree>
<LoopController guiclass="LoopControlPanel" testclass="LoopController" testname="Loop Controller" enabled="true">
<boolProp name="LoopController.continue_forever">true</boolProp>
<stringProp name="LoopController.loops">1</stringProp>
</LoopController>
<hashTree>
<GenericController guiclass="LogicControllerGui" testclass="GenericController" testname="Simple Controller" enabled="true"/>
<hashTree>
<RandomController guiclass="RandomControlGui" testclass="RandomController" testname="Random Controller" enabled="true">
<intProp name="InterleaveControl.style">1</intProp>
</RandomController>
<hashTree>
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="insert" enabled="true">
<stringProp name="dataSource">pdbpool</stringProp>
<stringProp name="queryType">Prepared Update Statement</stringProp>
<stringProp name="query">INSERT INTO authors (id,name,email) VALUES
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;),
( nextval(&apos;serial&apos;) ,&apos;Priya&apos;,&apos;p@gmail.com&apos;);</stringProp>
<stringProp name="queryArguments"></stringProp>
<stringProp name="queryArgumentsTypes"></stringProp>
<stringProp name="variableNames"></stringProp>
<stringProp name="resultVariable"></stringProp>
<stringProp name="queryTimeout"></stringProp>
<stringProp name="resultSetHandler">Store as String</stringProp>
</JDBCSampler>
<hashTree>
<CounterConfig guiclass="CounterConfigGui" testclass="CounterConfig" testname="Counter" enabled="true">
<stringProp name="CounterConfig.start">1</stringProp>
<stringProp name="CounterConfig.end">10000000</stringProp>
<stringProp name="CounterConfig.incr">2</stringProp>
<stringProp name="CounterConfig.name">author_id</stringProp>
<stringProp name="CounterConfig.format">0</stringProp>
<boolProp name="CounterConfig.per_user">false</boolProp>
</CounterConfig>
<hashTree/>
<CounterConfig guiclass="CounterConfigGui" testclass="CounterConfig" testname="Counter" enabled="true">
<stringProp name="CounterConfig.start">2</stringProp>
<stringProp name="CounterConfig.end">10000000</stringProp>
<stringProp name="CounterConfig.incr">2</stringProp>
<stringProp name="CounterConfig.name">author_id2</stringProp>
<stringProp name="CounterConfig.format">0</stringProp>
<boolProp name="CounterConfig.per_user">false</boolProp>
</CounterConfig>
<hashTree/>
</hashTree>
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="delete" enabled="true">
<stringProp name="dataSource">pdbpool</stringProp>
<stringProp name="queryType">Update Statement</stringProp>
<stringProp name="query">delete from authors where id &lt; ( select max(id) - 30 from authors) and id &gt; ( select max(id) - 500 from authors) </stringProp>
<stringProp name="queryArguments"></stringProp>
<stringProp name="queryArgumentsTypes"></stringProp>
<stringProp name="variableNames"></stringProp>
<stringProp name="resultVariable"></stringProp>
<stringProp name="queryTimeout"></stringProp>
<stringProp name="resultSetHandler">Store as String</stringProp>
</JDBCSampler>
<hashTree/>
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="select" enabled="true">
<stringProp name="dataSource">pdbpool</stringProp>
<stringProp name="queryType">Select Statement</stringProp>
<stringProp name="query">select count(*) from authors where id &lt; ( select max(id) - 30 from authors) and id &gt; ( select max(id) - 2500 from authors) ;
select count(*) from authors where id &lt; ( select max(id) - 30 from authors) and id &gt; ( select max(id) - 1500 from authors) ;
select count(*) from authors where id &lt; ( select max(id) - 30 from authors) and id &gt; ( select max(id) - 1500 from authors) ;
select count(*) from authors where id &lt; ( select max(id) - 30 from authors) and id &gt; ( select max(id) - 1500 from authors) ;
select count(*) from authors where id &lt; ( select max(id) - 30 from authors) and id &gt; ( select max(id) - 1500 from authors) ;
select count(*) from authors where id &lt; ( select max(id) - 30 from authors) and id &gt; ( select max(id) - 1500 from authors) ;
select count(*) from authors where id &lt; ( select max(id) - 30 from authors) and id &gt; ( select max(id) - 1500 from authors) ;
select count(*) from authors where id &lt; ( select max(id) - 30 from authors) and id &gt; ( select max(id) - 1500 from authors) ;
select count(*) from authors where id &lt; ( select max(id) - 30 from authors) and id &gt; ( select max(id) - 1500 from authors) ;
select count(*) from authors where id &lt; ( select max(id) - 30 from authors) and id &gt; ( select max(id) - 1500 from authors) ;</stringProp>
<stringProp name="queryArguments"></stringProp>
<stringProp name="queryArgumentsTypes"></stringProp>
<stringProp name="variableNames"></stringProp>
<stringProp name="resultVariable"></stringProp>
<stringProp name="queryTimeout"></stringProp>
<stringProp name="resultSetHandler">Store as String</stringProp>
</JDBCSampler>
<hashTree/>
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="update" enabled="true">
<stringProp name="dataSource">pdbpool</stringProp>
<stringProp name="queryType">Callable Statement</stringProp>
<stringProp name="query">update authors set email = &apos;toto&apos; where id &gt; ( select max(id) - 300 from authors)</stringProp>
<stringProp name="queryArguments"></stringProp>
<stringProp name="queryArgumentsTypes"></stringProp>
<stringProp name="variableNames"></stringProp>
<stringProp name="resultVariable"></stringProp>
<stringProp name="queryTimeout"></stringProp>
<stringProp name="resultSetHandler">Store as String</stringProp>
</JDBCSampler>
<hashTree>
<Arguments guiclass="ArgumentsPanel" testclass="Arguments" testname="User Defined Variables" enabled="true">
<collectionProp name="Arguments.arguments">
<elementProp name="fooct" elementType="Argument">
<stringProp name="Argument.name">fooct</stringProp>
<stringProp name="Argument.value">10000000</stringProp>
<stringProp name="Argument.metadata">=</stringProp>
</elementProp>
</collectionProp>
</Arguments>
<hashTree/>
</hashTree>
</hashTree>
<ConstantTimer guiclass="ConstantTimerGui" testclass="ConstantTimer" testname="Constant Timer" enabled="true">
<stringProp name="ConstantTimer.delay">3</stringProp>
</ConstantTimer>
<hashTree/>
</hashTree>
</hashTree>
<ResultCollector guiclass="StatGraphVisualizer" testclass="ResultCollector" testname="Aggregate Graph" enabled="true">
<boolProp name="ResultCollector.error_logging">false</boolProp>
<objProp>
<name>saveConfig</name>
<value class="SampleSaveConfiguration">
<time>true</time>
<latency>true</latency>
<timestamp>true</timestamp>
<success>true</success>
<label>true</label>
<code>true</code>
<message>true</message>
<threadName>true</threadName>
<dataType>true</dataType>
<encoding>false</encoding>
<assertions>true</assertions>
<subresults>true</subresults>
<responseData>false</responseData>
<samplerData>false</samplerData>
<xml>false</xml>
<fieldNames>true</fieldNames>
<responseHeaders>false</responseHeaders>
<requestHeaders>false</requestHeaders>
<responseDataOnError>false</responseDataOnError>
<saveAssertionResultsFailureMessage>true</saveAssertionResultsFailureMessage>
<assertionsResultsToSave>0</assertionsResultsToSave>
<bytes>true</bytes>
<threadCounts>true</threadCounts>
<idleTime>true</idleTime>
</value>
</objProp>
<stringProp name="filename"></stringProp>
</ResultCollector>
<hashTree/>
</hashTree>
</hashTree>
</hashTree>
</jmeterTestPlan>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment