Skip to content

Instantly share code, notes, and snippets.

@marcellodesales

marcellodesales/iostat -x 2 during db.SondeDataContainer.find( {"observation.pH":4.52, "observation.Battery":1.4} ).explain()

Created December 2, 2009 01:01
Show Gist options
  • Save marcellodesales/246804 to your computer and use it in GitHub Desktop.
Save marcellodesales/246804 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
iostat -x 2 during db.SondeDataContainer.find( {"observation.pH":4.52, "observation.Battery":1.4} ).explain()
> db.SondeDataContainer.find( {"observation.pH":4.52, "observation.Battery":1.4} ).explain()
{
"cursor" : "BasicCursor",
"startKey" : {
},
"endKey" : {
},
"nscanned" : 2419200,
"n" : 28,
"millis" : 51332,
"oldPlan" : {
"cursor" : "BasicCursor",
"startKey" : {
},
"endKey" : {
}
},
"allPlans" : [
{
"cursor" : "BasicCursor",
"startKey" : {
},
"endKey" : {
}
}
]
}
marcello@netbeams-mongo-dev02:~$ iostat -x 2
Linux 2.6.31-14-generic (netbeams-mongo-dev02) 12/01/2009 _x86_64_ (2 CPU)
avg-cpu: %user %nice %system %iowait %steal %idle
1.00 0.00 2.99 1.00 0.00 95.02
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 4.00 0.00 48.00 0.00 12.00 0.04 8.75 8.75 3.50
avg-cpu: %user %nice %system %iowait %steal %idle
3.34 0.00 7.40 6.92 0.00 82.34
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 2.48 0.00 93.07 0.00 22879.21 0.00 245.83 0.44 4.57 3.09 28.71
avg-cpu: %user %nice %system %iowait %steal %idle
6.95 0.00 15.35 27.58 0.00 50.12
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 239.00 0.50 58840.00 4.00 245.70 1.39 5.82 3.30 79.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.33 0.00 10.22 41.61 0.00 41.85
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 57.50 172.00 3.00 42844.00 484.00 247.59 1.10 6.29 3.26 57.00
avg-cpu: %user %nice %system %iowait %steal %idle
8.61 0.00 18.42 32.30 0.00 40.67
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 4.50 259.50 3.50 64124.00 64.00 244.06 0.99 3.78 2.26 59.50
avg-cpu: %user %nice %system %iowait %steal %idle
7.46 0.00 15.85 43.59 0.00 33.10
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 14.93 72.64 249.25 3.48 57209.95 608.96 228.77 1.92 7.60 2.64 66.67
avg-cpu: %user %nice %system %iowait %steal %idle
3.93 0.00 6.28 45.81 0.00 43.98
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 80.00 78.00 7.00 19968.00 696.00 243.11 0.50 5.88 3.35 28.50
avg-cpu: %user %nice %system %iowait %steal %idle
5.83 0.00 14.08 43.45 0.00 36.65
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 28.00 112.00 8.00 28460.00 288.00 239.57 0.23 1.88 1.33 16.00
avg-cpu: %user %nice %system %iowait %steal %idle
8.03 0.00 11.92 40.39 0.00 39.66
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 3.45 0.49 205.91 0.49 52267.98 7.88 253.27 0.36 1.77 1.24 25.62
avg-cpu: %user %nice %system %iowait %steal %idle
7.07 0.00 19.76 38.54 0.00 34.63
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 1.50 185.00 2.00 47360.00 28.00 253.41 0.75 4.01 2.43 45.50
avg-cpu: %user %nice %system %iowait %steal %idle
6.65 0.00 31.77 44.09 0.00 17.49
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 39.80 197.01 3.48 49934.33 346.27 250.78 0.92 4.59 2.36 47.26
avg-cpu: %user %nice %system %iowait %steal %idle
10.92 0.00 29.03 38.21 0.00 21.84
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.50 228.86 0.50 58193.03 7.96 253.76 0.92 4.01 2.49 57.21
avg-cpu: %user %nice %system %iowait %steal %idle
6.76 0.00 13.29 40.34 0.00 39.61
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 3.00 161.50 1.00 41344.00 32.00 254.62 1.60 9.85 4.98 81.00
avg-cpu: %user %nice %system %iowait %steal %idle
5.30 0.00 10.84 59.28 0.00 24.58
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 1.00 93.03 1.99 23669.65 23.88 249.34 1.29 13.56 7.59 72.14
avg-cpu: %user %nice %system %iowait %steal %idle
5.02 0.00 11.96 54.07 0.00 28.95
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 26.00 136.50 2.00 34060.00 224.00 247.54 1.36 9.86 5.52 76.50
avg-cpu: %user %nice %system %iowait %steal %idle
5.12 0.00 39.76 35.85 0.00 19.27
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 3.50 14.00 151.50 2.00 38200.00 128.00 249.69 0.57 3.65 2.12 32.50
avg-cpu: %user %nice %system %iowait %steal %idle
6.86 0.00 11.58 37.12 0.00 44.44
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 24.75 206.44 3.47 51968.32 225.74 248.66 1.10 5.31 3.04 63.86
avg-cpu: %user %nice %system %iowait %steal %idle
4.61 0.00 19.90 51.21 0.00 24.27
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 10.50 90.50 5.00 22668.00 124.00 238.66 0.66 6.91 3.72 35.50
avg-cpu: %user %nice %system %iowait %steal %idle
4.76 0.00 7.86 43.33 0.00 44.05
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 8.50 114.00 5.00 28668.00 108.00 241.82 0.56 4.71 2.69 32.00
avg-cpu: %user %nice %system %iowait %steal %idle
9.36 0.00 18.72 38.18 0.00 33.74
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 8.46 216.92 5.47 54599.00 59.70 245.78 0.79 3.49 2.17 48.26
avg-cpu: %user %nice %system %iowait %steal %idle
7.86 0.00 15.71 35.71 0.00 40.71
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 15.76 213.79 4.43 54120.20 212.81 248.98 0.59 2.73 1.63 35.47
avg-cpu: %user %nice %system %iowait %steal %idle
11.79 0.00 22.11 29.48 0.00 36.61
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 14.00 248.50 2.00 62044.00 128.00 248.19 0.57 2.28 1.52 38.00
avg-cpu: %user %nice %system %iowait %steal %idle
12.38 0.00 24.03 21.36 0.00 42.23
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.50 322.00 2.50 78872.00 24.00 243.13 0.94 2.88 1.65 53.50
avg-cpu: %user %nice %system %iowait %steal %idle
7.32 0.00 17.32 38.54 0.00 36.83
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 46.00 218.00 3.50 54712.00 396.00 248.79 0.56 2.53 1.33 29.50
avg-cpu: %user %nice %system %iowait %steal %idle
7.32 0.00 14.63 34.39 0.00 43.66
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 1.00 235.00 1.50 60160.00 20.00 254.46 0.80 3.38 2.11 50.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 14.39 48.44 0.00 31.18
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 51.00 154.50 6.50 39528.00 460.00 248.37 0.68 4.19 2.42 39.00
avg-cpu: %user %nice %system %iowait %steal %idle
2.43 0.00 17.27 43.80 0.00 36.50
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 51.50 86.00 6.00 22016.00 460.00 244.30 0.28 2.99 1.90 17.50
avg-cpu: %user %nice %system %iowait %steal %idle
1.25 0.00 6.25 19.75 0.00 72.75
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 7.00 9.50 74.50 2.50 11644.00 96.00 152.47 0.40 5.19 2.73 21.00
avg-cpu: %user %nice %system %iowait %steal %idle
0.24 0.00 2.17 4.83 0.00 92.75
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 6.00 1.00 45.50 3.50 2384.00 36.00 49.39 0.35 7.14 2.35 11.50
avg-cpu: %user %nice %system %iowait %steal %idle
0.75 0.00 1.99 1.99 0.00 95.27
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 10.50 0.00 18.50 0.00 956.00 0.00 51.68 0.13 7.03 2.16 4.00
avg-cpu: %user %nice %system %iowait %steal %idle
0.25 0.00 0.74 0.00 0.00 99.01
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
0.00 0.00 2.22 1.23 0.00 96.55
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.50 10.50 2.00 848.00 20.00 69.44 0.07 5.20 2.80 3.50
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment