| servers=S1 | |
| gemfirexdclusters=C1 | |
| regions=R1 R2 R3 | |
| tables=R1 R2 | |
| members=M1 M2 M3 | |
| gemfirexdmembers=M1 M2 M3 | |
| aggregatequeries=Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21 Q22 Q23 Q24 Q25 | |
| server.S1.listCacheServers=true | |
| server.S1.memberCount=3 | |
| server.S1.numClients=2 | |
| server.S1.distributedSystemId=1222 | |
| server.S1.locatorCount=1 | |
| server.S1.totalRegionCount=2 | |
| server.S1.numRunningFunctions=12 | |
| server.S1.registeredCQCount=10 | |
| server.S1.numSubscriptions=9 | |
| server.S1.TransactionCommitted=101 | |
| server.S1.TransactionRolledBack=11 | |
| server.S1.totalHeapSize=23222 | |
| server.S1.usedHeapSize=10200 | |
| server.S1.MaxMemory=24242 | |
| server.S1.UsedMemory=10201 | |
| server.S1.totalRegionEntryCount=2344 | |
| server.S1.currentQueryCount=2 | |
| server.S1.totalDiskUsage=23929 | |
| server.S1.diskWritesRate=230 | |
| server.S1.averageWrites=10.23 | |
| server.S1.averageReads=90.92 | |
| server.S1.queryRequestRate=10.29 | |
| server.S1.diskReadsRate=56.00 | |
| server.S1.jvmPauses=233345 | |
| server.S1.wanInfo=C1 true C2 false | |
| gemfirexd.C1.ProcedureCallsCompleted=4 | |
| gemfirexd.C1.ProcedureCallsInProgress=13 | |
| gemfirexd.C1.NetworkServerClientConnectionStats=13,1,5,4 | |
| member.M1.manager=true | |
| member.M1.totalRegionCount=2 | |
| member.M1.locator=false | |
| member.M1.totalDiskUsage=199302 | |
| member.M1.server=false | |
| member.M1.totalFileDescriptorOpen=299 | |
| member.M1.loadAverage=12.221 | |
| member.M1.diskWritesRate=23.92 | |
| member.M1.JVMPauses=232221 | |
| member.M1.currentHeapSize=2322 | |
| member.M1.maximumHeapSize=700000 | |
| member.M1.UsedMemory=23232 | |
| member.M1.MaxMemory=710000 | |
| member.M1.numThreads=4 | |
| member.M1.memberUpTime=1123333 | |
| member.M1.host=h1 | |
| member.M1.totalBytesOnDisk=199392 | |
| member.M1.cpuUsage=15.23 | |
| member.M1.member=M1 | |
| member.M1.id=M1 | |
| member.M1.averageReads=29.2921 | |
| member.M1.averageWrites=92.22 | |
| member.M1.port=8821 | |
| member.M1.OffHeapFreeSize=12325 | |
| member.M1.OffHeapUsedSize=6532 | |
| member.M1.OffHeapFreeMemory=54321 | |
| member.M1.OffHeapUsedMemory=2356 | |
| member.M1.Groups=SG1 SG2 | |
| member.M1.RedundancyZone=RZ1 RZ2 | |
| member.M1.Version=Java version: 7.5.Beta build 46879 04/28/2014 08:04:10 PDT | |
| gemfirexdmember.M1.DataStore=true | |
| gemfirexdmember.M1.NetworkServerClientConnectionStats=10,3,5,2 | |
| member.M2.manager=false | |
| member.M2.totalRegionCount=2 | |
| member.M2.locator=true | |
| member.M2.totalDiskUsage=199302 | |
| member.M2.server=false | |
| member.M2.totalFileDescriptorOpen=299 | |
| member.M2.loadAverage=12.221 | |
| member.M2.diskWritesRate=23.92 | |
| member.M2.JVMPauses=232221 | |
| member.M2.currentHeapSize=1322 | |
| member.M2.maximumHeapSize=700000 | |
| member.M2.UsedMemory=23232 | |
| member.M2.MaxMemory=710000 | |
| member.M2.numThreads=3 | |
| member.M2.memberUpTime=1123333 | |
| member.M2.host=h2 | |
| member.M2.totalBytesOnDisk=199392 | |
| member.M2.cpuUsage=18.31 | |
| member.M2.member=M2 | |
| member.M2.id=M2 | |
| member.M2.averageReads=29.2921 | |
| member.M2.averageWrites=92.22 | |
| member.M2.port=8822 | |
| member.M2.OffHeapFreeSize=11234 | |
| member.M2.OffHeapUsedSize=5436 | |
| member.M2.OffHeapFreeMemory=65432 | |
| member.M2.OffHeapUsedMemory=1235 | |
| member.M2.Groups=SG1 SG2 | |
| member.M2.RedundancyZone=RZ1 RZ2 | |
| member.M2.Version=Java version: 7.5.Beta build 46879 04/28/2014 08:04:10 PDT | |
| gemfirexdmember.M2.DataStore=true | |
| gemfirexdmember.M2.NetworkServerClientConnectionStats=15,2,6,7 | |
| member.M3.manager=false | |
| member.M3.totalRegionCount=1 | |
| member.M3.locator=false | |
| member.M3.totalDiskUsage=199302 | |
| member.M3.server=false | |
| member.M3.totalFileDescriptorOpen=299 | |
| member.M3.loadAverage=12.221 | |
| member.M3.diskWritesRate=23.92 | |
| member.M3.JVMPauses=232221 | |
| member.M3.currentHeapSize=2312 | |
| member.M3.maximumHeapSize=700000 | |
| member.M3.UsedMemory=23232 | |
| member.M3.MaxMemory=710000 | |
| member.M3.numThreads=4 | |
| member.M3.memberUpTime=1123333 | |
| member.M3.host=h3 | |
| member.M3.totalBytesOnDisk=199392 | |
| member.M3.cpuUsage=16.02 | |
| member.M3.member=M3 | |
| member.M3.id=M3 | |
| member.M3.averageReads=29.2921 | |
| member.M3.averageWrites=92.22 | |
| member.M3.port=8823 | |
| member.M3.OffHeapFreeSize=21321 | |
| member.M3.OffHeapUsedSize=3456 | |
| member.M3.OffHeapFreeMemory=76543 | |
| member.M3.OffHeapUsedMemory=2468 | |
| member.M3.Groups=SG1 SG3 | |
| member.M3.RedundancyZone=RZ2 | |
| member.M3.Version=Java version: 7.5.Beta build 46879 04/28/2014 08:04:10 PDT | |
| gemfirexdmember.M3.DataStore=false | |
| gemfirexdmember.M3.NetworkServerClientConnectionStats=9,5,4,0 | |
| table.R1.EntrySize=1234 | |
| table.R1.NumberOfRows=23 | |
| region.R1.members=M1 M2 M3 | |
| region.R1.fullPath=/R1 | |
| region.R1.diskReadsRate=21.32 | |
| region.R1.diskWritesRate=26.32 | |
| region.R1.emptyNodes=0 | |
| region.R1.getsRate=20.33 | |
| region.R1.lruEvictionRate=23.44 | |
| region.R1.putsRate=30.22 | |
| region.R1.regionType=PERSISTENT | |
| region.R1.entrySize=23399200 | |
| region.R1.systemRegionEntryCount=20020 | |
| region.R1.memberCount=3 | |
| region.R1.persistentEnabled=true | |
| region.R1.name=/R1 | |
| region.R1.gatewayEnabled=false | |
| region.R1.diskUsage=200200 | |
| #region.R1.scope=local | |
| #region.R1.diskStoreName=TestDiskStore | |
| #region.R1.diskSynchronous=false | |
| # operations | |
| # listRegionAttributes operation should values for return | |
| # String compressionCodec, boolean enableOffHeapMemory, boolean hdfsWriteOnly, | |
| # String scope, String diskStoreName, boolean diskSynchronous | |
| region.R1.listRegionAttributes=comp-Codec,true,true,local,TestDiskStoreLcl,false | |
| regionOnMember./R1.fullPath=/R1 | |
| regionOnMember./R1.memberName=M1 | |
| regionOnMember./R1.entrySize=21 | |
| regionOnMember./R1.entryCount=26 | |
| regionOnMember./R1.getsRate=10.50 | |
| regionOnMember./R1.putsRate=20.33 | |
| regionOnMember./R1.diskGetsRate=23.44 | |
| regionOnMember./R1.diskPutsRate=30.22 | |
| regionOnMember./R1.localMaxMemory=0 | |
| regionOnMember./R1.fullPath=/R1 | |
| regionOnMember./R1.memberName=M2 | |
| regionOnMember./R1.entrySize=215 | |
| regionOnMember./R1.entryCount=30 | |
| regionOnMember./R1.getsRate=15.50 | |
| regionOnMember./R1.putsRate=25.33 | |
| regionOnMember./R1.diskGetsRate=33.44 | |
| regionOnMember./R1.diskPutsRate=55.22 | |
| regionOnMember./R1.localMaxMemory=10 | |
| regionOnMember./R1.fullPath=/R1 | |
| regionOnMember./R1.memberName=M3 | |
| regionOnMember./R1.entrySize=28 | |
| regionOnMember./R1.entryCount=70 | |
| regionOnMember./R1.getsRate=19.50 | |
| regionOnMember./R1.putsRate=21.33 | |
| regionOnMember./R1.diskGetsRate=20.44 | |
| regionOnMember./R1.diskPutsRate=32.22 | |
| regionOnMember./R1.localMaxMemory=0 | |
| table.R2.EntrySize=4321 | |
| table.R2.NumberOfRows=32 | |
| region.R2.members=M1 M2 | |
| region.R2.fullPath=/R2 | |
| region.R2.diskReadsRate=21.32 | |
| region.R2.diskWritesRate=26.32 | |
| region.R2.emptyNodes=0 | |
| region.R2.getsRate=20.33 | |
| region.R2.lruEvictionRate=23.44 | |
| region.R2.putsRate=30.22 | |
| region.R2.regionType=REPLICATED | |
| region.R2.entrySize=23399200 | |
| region.R2.systemRegionEntryCount=20020 | |
| region.R2.memberCount=2 | |
| region.R2.persistentEnabled=true | |
| region.R2.name=/R2 | |
| region.R2.gatewayEnabled=false | |
| region.R2.diskUsage=200200 | |
| #region.R2.scope=global | |
| #region.R2.diskStoreName=TestDiskStore | |
| #region.R2.diskSynchronous=true | |
| # operations | |
| # listRegionAttributes operation should values for return | |
| # string compressionCodec, boolean enableOffHeapMemory, boolean hdfsWriteOnly | |
| # String scope, String diskStoreName, boolean diskSynchronous | |
| region.R2.listRegionAttributes=comp-Codec,true,false,global,TestDiskStoreGbl,true | |
| regionOnMember./R2.fullPath=/R2 | |
| regionOnMember./R2.memberName=M1 | |
| regionOnMember./R2.entrySize=21 | |
| regionOnMember./R2.entryCount=26 | |
| regionOnMember./R2.getsRate=10.50 | |
| regionOnMember./R2.putsRate=20.33 | |
| regionOnMember./R2.diskGetsRate=23.44 | |
| regionOnMember./R2.diskPutsRate=30.22 | |
| regionOnMember./R2.localMaxMemory=0 | |
| regionOnMember./R2.fullPath=/R2 | |
| regionOnMember./R2.memberName=M2 | |
| regionOnMember./R2.entrySize=215 | |
| regionOnMember./R2.entryCount=30 | |
| regionOnMember./R2.getsRate=15.50 | |
| regionOnMember./R2.putsRate=25.33 | |
| regionOnMember./R2.diskGetsRate=33.44 | |
| regionOnMember./R2.diskPutsRate=55.22 | |
| regionOnMember./R2.localMaxMemory=10 | |
| region.R3.members=M1 M2 | |
| region.R3.fullPath=/R3 | |
| region.R3.diskReadsRate=21.32 | |
| region.R3.diskWritesRate=26.32 | |
| region.R3.emptyNodes=0 | |
| region.R3.getsRate=20.33 | |
| region.R3.lruEvictionRate=23.44 | |
| region.R3.putsRate=30.22 | |
| region.R3.regionType=PERSISTENT | |
| region.R3.entrySize=23399200 | |
| region.R3.systemRegionEntryCount=20 | |
| region.R3.memberCount=2 | |
| region.R3.persistentEnabled=true | |
| region.R3.name=/R3 | |
| region.R3.gatewayEnabled=false | |
| region.R3.diskUsage=200200 | |
| #region.R3.scope=local | |
| #region.R3.diskStoreName=TestDiskStore | |
| #region.R3.diskSynchronous=false | |
| # operations | |
| # listRegionAttributes operation should values for return | |
| # String compressionCodec, boolean enableOffHeapMemory, boolean hdfsWriteOnly, | |
| # String scope, String diskStoreName, boolean diskSynchronous | |
| region.R3.listRegionAttributes=comp-Codec,true,true,local,TestDiskStoreLcl,false | |
| regionOnMember./R3.fullPath=/R3 | |
| regionOnMember./R3.memberName=M1 | |
| regionOnMember./R3.entrySize=21 | |
| regionOnMember./R3.entryCount=26 | |
| regionOnMember./R3.getsRate=10.50 | |
| regionOnMember./R3.putsRate=20.33 | |
| regionOnMember./R3.diskGetsRate=23.44 | |
| regionOnMember./R3.diskPutsRate=30.22 | |
| regionOnMember./R3.localMaxMemory=20 | |
| regionOnMember./R3.fullPath=/R3 | |
| regionOnMember./R3.memberName=M2 | |
| regionOnMember./R3.entrySize=215 | |
| regionOnMember./R3.entryCount=30 | |
| regionOnMember./R3.getsRate=18.6 | |
| regionOnMember./R3.putsRate=45.33 | |
| regionOnMember./R3.diskGetsRate=38.44 | |
| regionOnMember./R3.diskPutsRate=50.22 | |
| regionOnMember./R3.localMaxMemory=10 | |
| aggregatestatement.Q1.name=Q1 | |
| aggregatestatement.Q1.queryDefinition=select * from clients; | |
| aggregatestatement.Q1.numTimesCompiled=10 | |
| aggregatestatement.Q1.numExecution=25 | |
| aggregatestatement.Q1.numExecutionsInProgress=2 | |
| aggregatestatement.Q1.numTimesGlobalIndexLookup=1 | |
| aggregatestatement.Q1.numRowsModified=100 | |
| aggregatestatement.Q1.parseTime=600 | |
| aggregatestatement.Q1.bindTime=250 | |
| aggregatestatement.Q1.optimizeTime=590 | |
| aggregatestatement.Q1.routingInfoTime=100 | |
| aggregatestatement.Q1.generateTime=380 | |
| aggregatestatement.Q1.totalCompilationTime=400 | |
| aggregatestatement.Q1.executionTime=20 | |
| aggregatestatement.Q1.projectionTime=80 | |
| aggregatestatement.Q1.totalExecutionTime=3000 | |
| aggregatestatement.Q1.rowsModificationTime=1200 | |
| aggregatestatement.Q1.qnNumRowsSeen=230 | |
| aggregatestatement.Q1.qnMsgSendTime=370 | |
| aggregatestatement.Q1.qnMsgSerTime=540 | |
| aggregatestatement.Q1.qnRespDeSerTime=450 | |
| aggregatestatement.Q2.name=Q2 | |
| aggregatestatement.Q2.queryDefinition=select member name, member type from members where cluster id = id; | |
| aggregatestatement.Q2.numTimesCompiled=24 | |
| aggregatestatement.Q2.numExecution=30 | |
| aggregatestatement.Q2.numExecutionsInProgress=1 | |
| aggregatestatement.Q2.numTimesGlobalIndexLookup=2 | |
| aggregatestatement.Q2.numRowsModified=120 | |
| aggregatestatement.Q2.parseTime=700 | |
| aggregatestatement.Q2.bindTime=260 | |
| aggregatestatement.Q2.optimizeTime=580 | |
| aggregatestatement.Q2.routingInfoTime=110 | |
| aggregatestatement.Q2.generateTime=370 | |
| aggregatestatement.Q2.totalCompilationTime=410 | |
| aggregatestatement.Q2.executionTime=20 | |
| aggregatestatement.Q2.projectionTime=80 | |
| aggregatestatement.Q2.totalExecutionTime=3000 | |
| aggregatestatement.Q2.rowsModificationTime=1100 | |
| aggregatestatement.Q2.qnNumRowsSeen=700 | |
| aggregatestatement.Q2.qnMsgSendTime=380 | |
| aggregatestatement.Q2.qnMsgSerTime=530 | |
| aggregatestatement.Q2.qnRespDeSerTime=450 | |
| aggregatestatement.Q3.name=Q3 | |
| aggregatestatement.Q3.queryDefinition=select region name, member name from regions where entrycount = 20; | |
| aggregatestatement.Q3.numTimesCompiled=13 | |
| aggregatestatement.Q3.numExecution=12 | |
| aggregatestatement.Q3.numExecutionsInProgress=6 | |
| aggregatestatement.Q3.numTimesGlobalIndexLookup=3 | |
| aggregatestatement.Q3.numRowsModified=110 | |
| aggregatestatement.Q3.parseTime=800 | |
| aggregatestatement.Q3.bindTime=270 | |
| aggregatestatement.Q3.optimizeTime=570 | |
| aggregatestatement.Q3.routingInfoTime=120 | |
| aggregatestatement.Q3.generateTime=370 | |
| aggregatestatement.Q3.totalCompilationTime=450 | |
| aggregatestatement.Q3.executionTime=20 | |
| aggregatestatement.Q3.projectionTime=80 | |
| aggregatestatement.Q3.totalExecutionTime=3500 | |
| aggregatestatement.Q3.rowsModificationTime=1300 | |
| aggregatestatement.Q3.qnNumRowsSeen=3000 | |
| aggregatestatement.Q3.qnMsgSendTime=350 | |
| aggregatestatement.Q3.qnMsgSerTime=520 | |
| aggregatestatement.Q3.qnRespDeSerTime=-89 | |
| aggregatestatement.Q4.name=Q4 | |
| aggregatestatement.Q4.queryDefinition=select * from members | |
| aggregatestatement.Q4.numTimesCompiled=70 | |
| aggregatestatement.Q4.numExecution=60 | |
| aggregatestatement.Q4.numExecutionsInProgress=0 | |
| aggregatestatement.Q4.numTimesGlobalIndexLookup=4 | |
| aggregatestatement.Q4.numRowsModified=10 | |
| aggregatestatement.Q4.parseTime=900 | |
| aggregatestatement.Q4.bindTime=280 | |
| aggregatestatement.Q4.optimizeTime=560 | |
| aggregatestatement.Q4.routingInfoTime=130 | |
| aggregatestatement.Q4.generateTime=370 | |
| aggregatestatement.Q4.totalCompilationTime=450 | |
| aggregatestatement.Q4.executionTime=20 | |
| aggregatestatement.Q4.projectionTime=80 | |
| aggregatestatement.Q4.totalExecutionTime=5670 | |
| aggregatestatement.Q4.rowsModificationTime=1400 | |
| aggregatestatement.Q4.qnNumRowsSeen=910 | |
| aggregatestatement.Q4.qnMsgSendTime=330 | |
| aggregatestatement.Q4.qnMsgSerTime=510 | |
| aggregatestatement.Q4.qnRespDeSerTime=60 | |
| aggregatestatement.Q5.name=Q5 | |
| aggregatestatement.Q5.queryDefinition=select region name, member name from regions where entrycount > 100; | |
| aggregatestatement.Q5.numTimesCompiled=1 | |
| aggregatestatement.Q5.numExecution=34 | |
| aggregatestatement.Q5.numExecutionsInProgress=3 | |
| aggregatestatement.Q5.numTimesGlobalIndexLookup=5 | |
| aggregatestatement.Q5.numRowsModified=1 | |
| aggregatestatement.Q5.parseTime=1000 | |
| aggregatestatement.Q5.bindTime=290 | |
| aggregatestatement.Q5.optimizeTime=550 | |
| aggregatestatement.Q5.routingInfoTime=130 | |
| aggregatestatement.Q5.generateTime=360 | |
| aggregatestatement.Q5.totalCompilationTime=450 | |
| aggregatestatement.Q5.executionTime=20 | |
| aggregatestatement.Q5.projectionTime=80 | |
| aggregatestatement.Q5.totalExecutionTime=5080 | |
| aggregatestatement.Q5.rowsModificationTime=1500 | |
| aggregatestatement.Q5.qnNumRowsSeen=9 | |
| aggregatestatement.Q5.qnMsgSendTime=300 | |
| aggregatestatement.Q5.qnMsgSerTime=500 | |
| aggregatestatement.Q5.qnRespDeSerTime=98 | |
| aggregatestatement.Q6.name=Q6 | |
| aggregatestatement.Q6.queryDefinition=select region name from regions where regionid in ( select * from region id where entry count <= 700); | |
| aggregatestatement.Q6.numTimesCompiled=90 | |
| aggregatestatement.Q6.numExecution=1 | |
| aggregatestatement.Q6.numExecutionsInProgress=10 | |
| aggregatestatement.Q6.numTimesGlobalIndexLookup=6 | |
| aggregatestatement.Q6.numRowsModified=25 | |
| aggregatestatement.Q6.parseTime=1100 | |
| aggregatestatement.Q6.bindTime=300 | |
| aggregatestatement.Q6.optimizeTime=540 | |
| aggregatestatement.Q6.routingInfoTime=130 | |
| aggregatestatement.Q6.generateTime=350 | |
| aggregatestatement.Q6.totalCompilationTime=470 | |
| aggregatestatement.Q6.executionTime=20 | |
| aggregatestatement.Q6.projectionTime=80 | |
| aggregatestatement.Q6.totalExecutionTime=5000 | |
| aggregatestatement.Q6.rowsModificationTime=1600 | |
| aggregatestatement.Q6.qnNumRowsSeen=900 | |
| aggregatestatement.Q6.qnMsgSendTime=320 | |
| aggregatestatement.Q6.qnMsgSerTime=490 | |
| aggregatestatement.Q6.qnRespDeSerTime=76 | |
| aggregatestatement.Q7.name=Q7 | |
| aggregatestatement.Q7.queryDefinition=select region name, member name from regions where entrycount < 25; | |
| aggregatestatement.Q7.numTimesCompiled=15 | |
| aggregatestatement.Q7.numExecution=30 | |
| aggregatestatement.Q7.numExecutionsInProgress=20 | |
| aggregatestatement.Q7.numTimesGlobalIndexLookup=7 | |
| aggregatestatement.Q7.numRowsModified=35 | |
| aggregatestatement.Q7.parseTime=1200 | |
| aggregatestatement.Q7.bindTime=300 | |
| aggregatestatement.Q7.optimizeTime=530 | |
| aggregatestatement.Q7.routingInfoTime=140 | |
| aggregatestatement.Q7.generateTime=340 | |
| aggregatestatement.Q7.totalCompilationTime=470 | |
| aggregatestatement.Q7.executionTime=20 | |
| aggregatestatement.Q7.projectionTime=80 | |
| aggregatestatement.Q7.totalExecutionTime=6050 | |
| aggregatestatement.Q7.rowsModificationTime=1700 | |
| aggregatestatement.Q7.qnNumRowsSeen=140 | |
| aggregatestatement.Q7.qnMsgSendTime=370 | |
| aggregatestatement.Q7.qnMsgSerTime=480 | |
| aggregatestatement.Q7.qnRespDeSerTime=40 | |
| aggregatestatement.Q8.name=Q8 | |
| aggregatestatement.Q8.queryDefinition=select cluster name from clustertoplogy where membercount > 5000; | |
| aggregatestatement.Q8.numTimesCompiled=35 | |
| aggregatestatement.Q8.numExecution=25 | |
| aggregatestatement.Q8.numExecutionsInProgress=4 | |
| aggregatestatement.Q8.numTimesGlobalIndexLookup=8 | |
| aggregatestatement.Q8.numRowsModified=40 | |
| aggregatestatement.Q8.parseTime=1300 | |
| aggregatestatement.Q8.bindTime=350 | |
| aggregatestatement.Q8.optimizeTime=520 | |
| aggregatestatement.Q8.routingInfoTime=160 | |
| aggregatestatement.Q8.generateTime=330 | |
| aggregatestatement.Q8.totalCompilationTime=470 | |
| aggregatestatement.Q8.executionTime=20 | |
| aggregatestatement.Q8.projectionTime=80 | |
| aggregatestatement.Q8.totalExecutionTime=6080 | |
| aggregatestatement.Q8.rowsModificationTime=1800 | |
| aggregatestatement.Q8.qnNumRowsSeen=130 | |
| aggregatestatement.Q8.qnMsgSendTime=390 | |
| aggregatestatement.Q8.qnMsgSerTime=470 | |
| aggregatestatement.Q8.qnRespDeSerTime=450 | |
| aggregatestatement.Q9.name=Q9 | |
| aggregatestatement.Q9.queryDefinition=select * from clients where member memory is not null | |
| aggregatestatement.Q9.numTimesCompiled=65 | |
| aggregatestatement.Q9.numExecution=25 | |
| aggregatestatement.Q9.numExecutionsInProgress=9 | |
| aggregatestatement.Q9.numTimesGlobalIndexLookup=9 | |
| aggregatestatement.Q9.numRowsModified=21 | |
| aggregatestatement.Q9.parseTime=1440 | |
| aggregatestatement.Q9.bindTime=360 | |
| aggregatestatement.Q9.optimizeTime=510 | |
| aggregatestatement.Q9.routingInfoTime=170 | |
| aggregatestatement.Q9.generateTime=320 | |
| aggregatestatement.Q9.totalCompilationTime=470 | |
| aggregatestatement.Q9.executionTime=20 | |
| aggregatestatement.Q9.projectionTime=80 | |
| aggregatestatement.Q9.totalExecutionTime=6006 | |
| aggregatestatement.Q9.rowsModificationTime=1900 | |
| aggregatestatement.Q9.qnNumRowsSeen=110 | |
| aggregatestatement.Q9.qnMsgSendTime=310 | |
| aggregatestatement.Q9.qnMsgSerTime=460 | |
| aggregatestatement.Q9.qnRespDeSerTime=450 | |
| aggregatestatement.Q10.name=Q22 | |
| aggregatestatement.Q10.queryDefinition=select name from clients where member='Client35'; | |
| aggregatestatement.Q10.numTimesCompiled=11 | |
| aggregatestatement.Q10.numExecution=70 | |
| aggregatestatement.Q10.numExecutionsInProgress=5 | |
| aggregatestatement.Q10.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q10.numRowsModified=64 | |
| aggregatestatement.Q10.parseTime=1500 | |
| aggregatestatement.Q10.bindTime=370 | |
| aggregatestatement.Q10.optimizeTime=500 | |
| aggregatestatement.Q10.routingInfoTime=190 | |
| aggregatestatement.Q10.generateTime=300 | |
| aggregatestatement.Q10.totalCompilationTime=500 | |
| aggregatestatement.Q10.executionTime=20 | |
| aggregatestatement.Q10.projectionTime=210 | |
| aggregatestatement.Q10.totalExecutionTime=600 | |
| aggregatestatement.Q10.rowsModificationTime=2000 | |
| aggregatestatement.Q10.qnNumRowsSeen=100 | |
| aggregatestatement.Q10.qnMsgSendTime=312 | |
| aggregatestatement.Q10.qnMsgSerTime=450 | |
| aggregatestatement.Q10.qnRespDeSerTime=150 | |
| aggregatestatement.Q11.name=Q11 | |
| aggregatestatement.Q11.queryDefinition=select name from clients where member='C1'; | |
| aggregatestatement.Q11.numTimesCompiled=11 | |
| aggregatestatement.Q11.numExecution=70 | |
| aggregatestatement.Q11.numExecutionsInProgress=5 | |
| aggregatestatement.Q11.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q11.numRowsModified=64 | |
| aggregatestatement.Q11.parseTime=1500 | |
| aggregatestatement.Q11.bindTime=370 | |
| aggregatestatement.Q11.optimizeTime=500 | |
| aggregatestatement.Q11.routingInfoTime=190 | |
| aggregatestatement.Q11.generateTime=300 | |
| aggregatestatement.Q11.totalCompilationTime=500 | |
| aggregatestatement.Q11.executionTime=20 | |
| aggregatestatement.Q11.projectionTime=210 | |
| aggregatestatement.Q11.totalExecutionTime=600 | |
| aggregatestatement.Q11.rowsModificationTime=2000 | |
| aggregatestatement.Q11.qnNumRowsSeen=100 | |
| aggregatestatement.Q11.qnMsgSendTime=312 | |
| aggregatestatement.Q11.qnMsgSerTime=450 | |
| aggregatestatement.Q11.qnRespDeSerTime=4 | |
| aggregatestatement.Q12.name=Q12 | |
| aggregatestatement.Q12.queryDefinition=select name from clients where member='C16'; | |
| aggregatestatement.Q12.numTimesCompiled=11 | |
| aggregatestatement.Q12.numExecution=70 | |
| aggregatestatement.Q12.numExecutionsInProgress=5 | |
| aggregatestatement.Q12.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q12.numRowsModified=64 | |
| aggregatestatement.Q12.parseTime=1500 | |
| aggregatestatement.Q12.bindTime=370 | |
| aggregatestatement.Q12.optimizeTime=500 | |
| aggregatestatement.Q12.routingInfoTime=190 | |
| aggregatestatement.Q12.generateTime=300 | |
| aggregatestatement.Q12.totalCompilationTime=500 | |
| aggregatestatement.Q12.executionTime=20 | |
| aggregatestatement.Q12.projectionTime=210 | |
| aggregatestatement.Q12.totalExecutionTime=600 | |
| aggregatestatement.Q12.rowsModificationTime=2000 | |
| aggregatestatement.Q12.qnNumRowsSeen=100 | |
| aggregatestatement.Q12.qnMsgSendTime=312 | |
| aggregatestatement.Q12.qnMsgSerTime=450 | |
| aggregatestatement.Q12.qnRespDeSerTime=175 | |
| aggregatestatement.Q13.name=Q13 | |
| aggregatestatement.Q13.queryDefinition=select name from clients where member='C89'; | |
| aggregatestatement.Q13.numTimesCompiled=11 | |
| aggregatestatement.Q13.numExecution=70 | |
| aggregatestatement.Q13.numExecutionsInProgress=5 | |
| aggregatestatement.Q13.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q13.numRowsModified=64 | |
| aggregatestatement.Q13.parseTime=1500 | |
| aggregatestatement.Q13.bindTime=370 | |
| aggregatestatement.Q13.optimizeTime=500 | |
| aggregatestatement.Q13.routingInfoTime=190 | |
| aggregatestatement.Q13.generateTime=300 | |
| aggregatestatement.Q13.totalCompilationTime=500 | |
| aggregatestatement.Q13.executionTime=20 | |
| aggregatestatement.Q13.projectionTime=210 | |
| aggregatestatement.Q13.totalExecutionTime=600 | |
| aggregatestatement.Q13.rowsModificationTime=2000 | |
| aggregatestatement.Q13.qnNumRowsSeen=100 | |
| aggregatestatement.Q13.qnMsgSendTime=312 | |
| aggregatestatement.Q13.qnMsgSerTime=450 | |
| aggregatestatement.Q13.qnRespDeSerTime=-78 | |
| aggregatestatement.Q14.name=Q14 | |
| aggregatestatement.Q14.queryDefinition=select * from regions where name='R90'; | |
| aggregatestatement.Q14.numTimesCompiled=11 | |
| aggregatestatement.Q14.numExecution=70 | |
| aggregatestatement.Q14.numExecutionsInProgress=5 | |
| aggregatestatement.Q14.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q14.numRowsModified=64 | |
| aggregatestatement.Q14.parseTime=1500 | |
| aggregatestatement.Q14.bindTime=370 | |
| aggregatestatement.Q14.optimizeTime=500 | |
| aggregatestatement.Q14.routingInfoTime=190 | |
| aggregatestatement.Q14.generateTime=300 | |
| aggregatestatement.Q14.totalCompilationTime=500 | |
| aggregatestatement.Q14.executionTime=20 | |
| aggregatestatement.Q14.projectionTime=210 | |
| aggregatestatement.Q14.totalExecutionTime=600 | |
| aggregatestatement.Q14.rowsModificationTime=2000 | |
| aggregatestatement.Q14.qnNumRowsSeen=100 | |
| aggregatestatement.Q14.qnMsgSendTime=312 | |
| aggregatestatement.Q14.qnMsgSerTime=450 | |
| aggregatestatement.Q14.qnRespDeSerTime=90 | |
| aggregatestatement.Q15.name=Q15 | |
| aggregatestatement.Q15.queryDefinition=select * from regions where name='R17'; | |
| aggregatestatement.Q15.numTimesCompiled=11 | |
| aggregatestatement.Q15.numExecution=70 | |
| aggregatestatement.Q15.numExecutionsInProgress=5 | |
| aggregatestatement.Q15.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q15.numRowsModified=64 | |
| aggregatestatement.Q15.parseTime=1500 | |
| aggregatestatement.Q15.bindTime=370 | |
| aggregatestatement.Q15.optimizeTime=500 | |
| aggregatestatement.Q15.routingInfoTime=190 | |
| aggregatestatement.Q15.generateTime=300 | |
| aggregatestatement.Q15.totalCompilationTime=500 | |
| aggregatestatement.Q15.executionTime=20 | |
| aggregatestatement.Q15.projectionTime=210 | |
| aggregatestatement.Q15.totalExecutionTime=600 | |
| aggregatestatement.Q15.rowsModificationTime=2000 | |
| aggregatestatement.Q15.qnNumRowsSeen=100 | |
| aggregatestatement.Q15.qnMsgSendTime=312 | |
| aggregatestatement.Q15.qnMsgSerTime=450 | |
| aggregatestatement.Q15.qnRespDeSerTime=24 | |
| aggregatestatement.Q16.name=Q16 | |
| aggregatestatement.Q16.queryDefinition=select * from members where name='M15'; | |
| aggregatestatement.Q16.numTimesCompiled=11 | |
| aggregatestatement.Q16.numExecution=70 | |
| aggregatestatement.Q16.numExecutionsInProgress=5 | |
| aggregatestatement.Q16.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q16.numRowsModified=64 | |
| aggregatestatement.Q16.parseTime=1500 | |
| aggregatestatement.Q16.bindTime=370 | |
| aggregatestatement.Q16.optimizeTime=500 | |
| aggregatestatement.Q16.routingInfoTime=190 | |
| aggregatestatement.Q16.generateTime=300 | |
| aggregatestatement.Q16.totalCompilationTime=500 | |
| aggregatestatement.Q16.executionTime=20 | |
| aggregatestatement.Q16.projectionTime=210 | |
| aggregatestatement.Q16.totalExecutionTime=600 | |
| aggregatestatement.Q16.rowsModificationTime=2000 | |
| aggregatestatement.Q16.qnNumRowsSeen=100 | |
| aggregatestatement.Q16.qnMsgSendTime=312 | |
| aggregatestatement.Q16.qnMsgSerTime=450 | |
| aggregatestatement.Q16.qnRespDeSerTime=210 | |
| aggregatestatement.Q17.name=Q17 | |
| aggregatestatement.Q17.queryDefinition=select * from members where name='M5'; | |
| aggregatestatement.Q17.numTimesCompiled=11 | |
| aggregatestatement.Q17.numExecution=70 | |
| aggregatestatement.Q17.numExecutionsInProgress=5 | |
| aggregatestatement.Q17.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q17.numRowsModified=64 | |
| aggregatestatement.Q17.parseTime=1500 | |
| aggregatestatement.Q17.bindTime=370 | |
| aggregatestatement.Q17.optimizeTime=500 | |
| aggregatestatement.Q17.routingInfoTime=190 | |
| aggregatestatement.Q17.generateTime=300 | |
| aggregatestatement.Q17.totalCompilationTime=500 | |
| aggregatestatement.Q17.executionTime=20 | |
| aggregatestatement.Q17.projectionTime=210 | |
| aggregatestatement.Q17.totalExecutionTime=600 | |
| aggregatestatement.Q17.rowsModificationTime=2000 | |
| aggregatestatement.Q17.qnNumRowsSeen=100 | |
| aggregatestatement.Q17.qnMsgSendTime=312 | |
| aggregatestatement.Q17.qnMsgSerTime=450 | |
| aggregatestatement.Q17.qnRespDeSerTime=45 | |
| aggregatestatement.Q18.name=Q18 | |
| aggregatestatement.Q18.queryDefinition=select * from members where name='M12'; | |
| aggregatestatement.Q18.numTimesCompiled=11 | |
| aggregatestatement.Q18.numExecution=70 | |
| aggregatestatement.Q18.numExecutionsInProgress=5 | |
| aggregatestatement.Q18.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q18.numRowsModified=64 | |
| aggregatestatement.Q18.parseTime=1500 | |
| aggregatestatement.Q18.bindTime=370 | |
| aggregatestatement.Q18.optimizeTime=500 | |
| aggregatestatement.Q18.routingInfoTime=190 | |
| aggregatestatement.Q18.generateTime=300 | |
| aggregatestatement.Q18.totalCompilationTime=500 | |
| aggregatestatement.Q18.executionTime=20 | |
| aggregatestatement.Q18.projectionTime=210 | |
| aggregatestatement.Q18.totalExecutionTime=600 | |
| aggregatestatement.Q18.rowsModificationTime=2000 | |
| aggregatestatement.Q18.qnNumRowsSeen=100 | |
| aggregatestatement.Q18.qnMsgSendTime=312 | |
| aggregatestatement.Q18.qnMsgSerTime=450 | |
| aggregatestatement.Q18.qnRespDeSerTime=180 | |
| aggregatestatement.Q19.name=Q19 | |
| aggregatestatement.Q19.queryDefinition=select * from members where name='M11'; | |
| aggregatestatement.Q19.numTimesCompiled=11 | |
| aggregatestatement.Q19.numExecution=70 | |
| aggregatestatement.Q19.numExecutionsInProgress=5 | |
| aggregatestatement.Q19.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q19.numRowsModified=64 | |
| aggregatestatement.Q19.parseTime=1500 | |
| aggregatestatement.Q19.bindTime=370 | |
| aggregatestatement.Q19.optimizeTime=500 | |
| aggregatestatement.Q19.routingInfoTime=190 | |
| aggregatestatement.Q19.generateTime=300 | |
| aggregatestatement.Q19.totalCompilationTime=500 | |
| aggregatestatement.Q19.executionTime=20 | |
| aggregatestatement.Q19.projectionTime=210 | |
| aggregatestatement.Q19.totalExecutionTime=600 | |
| aggregatestatement.Q19.rowsModificationTime=2000 | |
| aggregatestatement.Q19.qnNumRowsSeen=100 | |
| aggregatestatement.Q19.qnMsgSendTime=312 | |
| aggregatestatement.Q19.qnMsgSerTime=450 | |
| aggregatestatement.Q19.qnRespDeSerTime=-100 | |
| aggregatestatement.Q20.name=Q20 | |
| aggregatestatement.Q20.queryDefinition=select * from regions where name='R6'; | |
| aggregatestatement.Q20.numTimesCompiled=11 | |
| aggregatestatement.Q20.numExecution=70 | |
| aggregatestatement.Q20.numExecutionsInProgress=5 | |
| aggregatestatement.Q20.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q20.numRowsModified=64 | |
| aggregatestatement.Q20.parseTime=1500 | |
| aggregatestatement.Q20.bindTime=370 | |
| aggregatestatement.Q20.optimizeTime=500 | |
| aggregatestatement.Q20.routingInfoTime=190 | |
| aggregatestatement.Q20.generateTime=300 | |
| aggregatestatement.Q20.totalCompilationTime=500 | |
| aggregatestatement.Q20.executionTime=20 | |
| aggregatestatement.Q20.projectionTime=210 | |
| aggregatestatement.Q20.totalExecutionTime=600 | |
| aggregatestatement.Q20.rowsModificationTime=2000 | |
| aggregatestatement.Q20.qnNumRowsSeen=100 | |
| aggregatestatement.Q20.qnMsgSendTime=312 | |
| aggregatestatement.Q20.qnMsgSerTime=450 | |
| aggregatestatement.Q20.qnRespDeSerTime=50 | |
| aggregatestatement.Q21.name=Q21 | |
| aggregatestatement.Q21.queryDefinition=select * from regions where name='R5'; | |
| aggregatestatement.Q21.numTimesCompiled=11 | |
| aggregatestatement.Q21.numExecution=70 | |
| aggregatestatement.Q21.numExecutionsInProgress=5 | |
| aggregatestatement.Q21.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q21.numRowsModified=64 | |
| aggregatestatement.Q21.parseTime=1500 | |
| aggregatestatement.Q21.bindTime=370 | |
| aggregatestatement.Q21.optimizeTime=500 | |
| aggregatestatement.Q21.routingInfoTime=190 | |
| aggregatestatement.Q21.generateTime=300 | |
| aggregatestatement.Q21.totalCompilationTime=500 | |
| aggregatestatement.Q21.executionTime=20 | |
| aggregatestatement.Q21.projectionTime=210 | |
| aggregatestatement.Q21.totalExecutionTime=600 | |
| aggregatestatement.Q21.rowsModificationTime=2000 | |
| aggregatestatement.Q21.qnNumRowsSeen=100 | |
| aggregatestatement.Q21.qnMsgSendTime=312 | |
| aggregatestatement.Q21.qnMsgSerTime=450 | |
| aggregatestatement.Q21.qnRespDeSerTime=40 | |
| aggregatestatement.Q22.name=Q22 | |
| aggregatestatement.Q22.queryDefinition=select * from regions where name='R4'; | |
| aggregatestatement.Q22.numTimesCompiled=11 | |
| aggregatestatement.Q22.numExecution=70 | |
| aggregatestatement.Q22.numExecutionsInProgress=5 | |
| aggregatestatement.Q22.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q22.numRowsModified=64 | |
| aggregatestatement.Q22.parseTime=1500 | |
| aggregatestatement.Q22.bindTime=370 | |
| aggregatestatement.Q22.optimizeTime=500 | |
| aggregatestatement.Q22.routingInfoTime=190 | |
| aggregatestatement.Q22.generateTime=300 | |
| aggregatestatement.Q22.totalCompilationTime=500 | |
| aggregatestatement.Q22.executionTime=20 | |
| aggregatestatement.Q22.projectionTime=210 | |
| aggregatestatement.Q22.totalExecutionTime=600 | |
| aggregatestatement.Q22.rowsModificationTime=2000 | |
| aggregatestatement.Q22.qnNumRowsSeen=100 | |
| aggregatestatement.Q22.qnMsgSendTime=312 | |
| aggregatestatement.Q22.qnMsgSerTime=450 | |
| aggregatestatement.Q22.qnRespDeSerTime=250 | |
| aggregatestatement.Q23.name=Q23 | |
| aggregatestatement.Q23.queryDefinition=select * from regions where name='R3'; | |
| aggregatestatement.Q23.numTimesCompiled=11 | |
| aggregatestatement.Q23.numExecution=70 | |
| aggregatestatement.Q23.numExecutionsInProgress=5 | |
| aggregatestatement.Q23.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q23.numRowsModified=64 | |
| aggregatestatement.Q23.parseTime=1500 | |
| aggregatestatement.Q23.bindTime=370 | |
| aggregatestatement.Q23.optimizeTime=500 | |
| aggregatestatement.Q23.routingInfoTime=190 | |
| aggregatestatement.Q23.generateTime=300 | |
| aggregatestatement.Q23.totalCompilationTime=500 | |
| aggregatestatement.Q23.executionTime=20 | |
| aggregatestatement.Q23.projectionTime=210 | |
| aggregatestatement.Q23.totalExecutionTime=600 | |
| aggregatestatement.Q23.rowsModificationTime=2000 | |
| aggregatestatement.Q23.qnNumRowsSeen=100 | |
| aggregatestatement.Q23.qnMsgSendTime=312 | |
| aggregatestatement.Q23.qnMsgSerTime=450 | |
| aggregatestatement.Q23.qnRespDeSerTime=-200 | |
| aggregatestatement.Q24.name=Q24 | |
| aggregatestatement.Q24.queryDefinition=select * from regions where name='R2'; | |
| aggregatestatement.Q24.numTimesCompiled=11 | |
| aggregatestatement.Q24.numExecution=70 | |
| aggregatestatement.Q24.numExecutionsInProgress=5 | |
| aggregatestatement.Q24.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q24.numRowsModified=64 | |
| aggregatestatement.Q24.parseTime=1500 | |
| aggregatestatement.Q24.bindTime=370 | |
| aggregatestatement.Q24.optimizeTime=500 | |
| aggregatestatement.Q24.routingInfoTime=190 | |
| aggregatestatement.Q24.generateTime=300 | |
| aggregatestatement.Q24.totalCompilationTime=500 | |
| aggregatestatement.Q24.executionTime=20 | |
| aggregatestatement.Q24.projectionTime=210 | |
| aggregatestatement.Q24.totalExecutionTime=600 | |
| aggregatestatement.Q24.rowsModificationTime=2000 | |
| aggregatestatement.Q24.qnNumRowsSeen=100 | |
| aggregatestatement.Q24.qnMsgSendTime=312 | |
| aggregatestatement.Q24.qnMsgSerTime=450 | |
| aggregatestatement.Q24.qnRespDeSerTime=40 | |
| aggregatestatement.Q25.name=Q25 | |
| aggregatestatement.Q25.queryDefinition=select * from regions where name='R1'; | |
| aggregatestatement.Q25.numTimesCompiled=11 | |
| aggregatestatement.Q25.numExecution=70 | |
| aggregatestatement.Q25.numExecutionsInProgress=5 | |
| aggregatestatement.Q25.numTimesGlobalIndexLookup=10 | |
| aggregatestatement.Q25.numRowsModified=64 | |
| aggregatestatement.Q25.parseTime=1500 | |
| aggregatestatement.Q25.bindTime=370 | |
| aggregatestatement.Q25.optimizeTime=500 | |
| aggregatestatement.Q25.routingInfoTime=190 | |
| aggregatestatement.Q25.generateTime=300 | |
| aggregatestatement.Q25.totalCompilationTime=500 | |
| aggregatestatement.Q25.executionTime=20 | |
| aggregatestatement.Q25.projectionTime=210 | |
| aggregatestatement.Q25.totalExecutionTime=600 | |
| aggregatestatement.Q25.rowsModificationTime=2000 | |
| aggregatestatement.Q25.qnNumRowsSeen=100 | |
| aggregatestatement.Q25.qnMsgSendTime=312 | |
| aggregatestatement.Q25.qnMsgSerTime=450 | |
| aggregatestatement.Q25.qnRespDeSerTime=450 |