alpenfritz · November 5, 2020 07:15 · Aug 25, 2012 · Aug 25, 2012 · Aug 25, 2012 · Aug 25, 2012
diff --git a/README.md b/README.md
@@ -18,7 +18,8 @@ This presents a histogram of slow collections
 
 Histogram of the slowest collections (collections with the slowest queries) - number of millies spent in each collection
 ---
-> db.system.profile.group({key: {ns: true}, initial: {millis: 0}, reduce: function(obj, prev){ prev.millis += obj.millis;}})
+
+    > db.system.profile.group({key: {ns: true}, initial: {millis: 0}, reduce: function(obj, prev){ prev.millis += obj.millis;}})
 
 Find the most recent slow query
 ---

diff --git a/README.md b/README.md
@@ -10,14 +10,23 @@ First, you have to enable profiling
 Now let it run for a while. It collects the slow queries ( > 100ms) into a capped collections, so queries go in and if it's full, old queries go out, so don't be surprised that it's a moving target...
 
 
-Find the slowest collections (collections with the slowest queries)
+Histogram of the slowest collections (collections with the slowest queries) - number of queries per collection
 ---
 This presents a histogram of slow collections
 
     > db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}})
 
+Histogram of the slowest collections (collections with the slowest queries) - number of millies spent in each collection
+---
+> db.system.profile.group({key: {ns: true}, initial: {millis: 0}, reduce: function(obj, prev){ prev.millis += obj.millis;}})
+
 Find the most recent slow query
 ---
 
     > db.system.profile.find().sort({$natural: -1}).limit(1)
 
+Find the single slowest query in the capped system.profile collection right now
+---
+
+    > db.system.profile.find().sort({millis: -1}).limit(1)
+
diff --git a/README.md b/README.md
@@ -1,7 +1,8 @@
 A few show tricks to find slow queries in mongodb
+===
 
 Enable profiling
-==============
+---
 First, you have to enable profiling
 
     > db.setProfilingLevel(1)
@@ -10,7 +11,7 @@ Now let it run for a while. It collects the slow queries ( > 100ms) into a cappe
 
 
 Find the slowest collections (collections with the slowest queries)
-===
+---
 This presents a histogram of slow collections
 
     > db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}})

diff --git a/README.md b/README.md
@@ -9,12 +9,14 @@ First, you have to enable profiling
 Now let it run for a while. It collects the slow queries ( > 100ms) into a capped collections, so queries go in and if it's full, old queries go out, so don't be surprised that it's a moving target...
 
 
-== Find the slowest collections (collections with the slowest queries)
+Find the slowest collections (collections with the slowest queries)
+===
 This presents a histogram of slow collections
 
     > db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}})
 
-== Find the most recent slow query
+Find the most recent slow query
+---
 
     > db.system.profile.find().sort({$natural: -1}).limit(1)
 
diff --git a/README.md b/README.md
@@ -1,6 +1,7 @@
 A few show tricks to find slow queries in mongodb
 
-=Enable profiling
+Enable profiling
+==============
 First, you have to enable profiling
 
     > db.setProfilingLevel(1)

diff --git a/README.md b/README.md
@@ -1,6 +1,6 @@
 A few show tricks to find slow queries in mongodb
 
-== Enable profiling
+=Enable profiling
 First, you have to enable profiling
 
     > db.setProfilingLevel(1)

diff --git a/README.md b/README.md
@@ -0,0 +1,19 @@
+A few show tricks to find slow queries in mongodb
+
+== Enable profiling
+First, you have to enable profiling
+
+    > db.setProfilingLevel(1)
+
+Now let it run for a while. It collects the slow queries ( > 100ms) into a capped collections, so queries go in and if it's full, old queries go out, so don't be surprised that it's a moving target...
+
+
+== Find the slowest collections (collections with the slowest queries)
+This presents a histogram of slow collections
+
+    > db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}})
+
+== Find the most recent slow query
+
+    > db.system.profile.find().sort({$natural: -1}).limit(1)
+
diff --git a/mongo-shell.js b/mongo-shell.js
@@ -1,11 +0,0 @@
-// enable profiling
-> db.setProfilingLevel(1)
-
-// let it run for a while
-
-// then find the slowest collections (collections with the slowest queries)
-// This presents a histogram of slow collections
-> db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}})
-
-// find the most recent slow query:
-> db.system.profile.find().sort({$natural: -1}).limit(1) 

diff --git a/mongo-shell.js b/mongo-shell.js
@@ -5,7 +5,7 @@
 
 // then find the slowest collections (collections with the slowest queries)
 // This presents a histogram of slow collections
-> db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}}
+> db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}})
 
 // find the most recent slow query:
 > db.system.profile.find().sort({$natural: -1}).limit(1) 
diff --git a/mongo-shell.js b/mongo-shell.js
@@ -4,4 +4,8 @@
 // let it run for a while
 
 // then find the slowest collections (collections with the slowest queries)
+// This presents a histogram of slow collections
 > db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}}
+
+// find the most recent slow query:
+> db.system.profile.find().sort({$natural: -1}).limit(1) 
diff --git a/gistfile1 b/gistfile1
@@ -1 +0,0 @@
-> db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}}

diff --git a/mongo-shell.js b/mongo-shell.js
@@ -0,0 +1,7 @@
+// enable profiling
+> db.setProfilingLevel(1)
+
+// let it run for a while
+
+// then find the slowest collections (collections with the slowest queries)
+> db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}}
diff --git a/gistfile1 b/gistfile1
@@ -0,0 +1 @@
+> db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}}
Original file line number	Diff line number	Diff line change
		@@ -1 +0,0 @@
		> db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}}
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1 @@
		> db.system.profile.group({key: {ns: true}, initial: {count: 0}, reduce: function(obj,prev){ prev.count++;}}