[DOCS-9722] collStats histogram shows operations taking 38-76 hours Created: 04/Jan/17  Updated: 05/Jan/17  Resolved: 05/Jan/17

Status: Closed
Project: Documentation
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor - P4
Reporter: Kevin Arhelger Assignee: Allison Reinheimer Moore
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:
Days since reply: 7 years, 5 weeks, 6 days ago

 Description   

https://docs.mongodb.com/master/reference/operator/aggregation/collStats/#latencystats-document

  { micros: NumberLong(137438953472), count: NumberLong(1000) },
  { micros: NumberLong(274877906944), count: NumberLong(100) }

and

1000 operations in the range (68719476736, 137438953472], and
100 operations in the range (137438953472, 274877906944].

137438953472 microseconds = 38 hours
274877906944 microseconds = 78 hours

I'm not sure where these numbers were generated but it takes considerable effort to generate an optimized query that takes this long to complete.

Here is an example document from a quick test I ran if we would like to use these values instead.

{
	"ns" : "test.foo",
	"localTime" : ISODate("2017-01-04T23:05:27.655Z"),
	"latencyStats" : {
		"reads" : {
			"histogram" : [
				{
					"micros" : NumberLong(0),
					"count" : NumberLong(1)
				},
				{
					"micros" : NumberLong(8),
					"count" : NumberLong(63523)
				},
				{
					"micros" : NumberLong(16),
					"count" : NumberLong(2204)
				},
				{
					"micros" : NumberLong(32),
					"count" : NumberLong(173)
				},
				{
					"micros" : NumberLong(64),
					"count" : NumberLong(9)
				},
				{
					"micros" : NumberLong(256),
					"count" : NumberLong(1)
				}
			],
			"latency" : NumberLong(711472),
			"ops" : NumberLong(65911)
		},
		"writes" : {
			"histogram" : [
				{
					"micros" : NumberLong(0),
					"count" : NumberLong(2)
				},
				{
					"micros" : NumberLong(2),
					"count" : NumberLong(2)
				},
				{
					"micros" : NumberLong(8),
					"count" : NumberLong(55375)
				},
				{
					"micros" : NumberLong(16),
					"count" : NumberLong(137587)
				},
				{
					"micros" : NumberLong(32),
					"count" : NumberLong(4278)
				},
				{
					"micros" : NumberLong(64),
					"count" : NumberLong(227)
				},
				{
					"micros" : NumberLong(128),
					"count" : NumberLong(84)
				},
				{
					"micros" : NumberLong(256),
					"count" : NumberLong(1)
				},
				{
					"micros" : NumberLong(512),
					"count" : NumberLong(3)
				},
				{
					"micros" : NumberLong(1024),
					"count" : NumberLong(126)
				},
				{
					"micros" : NumberLong(2048),
					"count" : NumberLong(3)
				},
				{
					"micros" : NumberLong(3072),
					"count" : NumberLong(1)
				},
				{
					"micros" : NumberLong(4096),
					"count" : NumberLong(6)
				},
				{
					"micros" : NumberLong(6144),
					"count" : NumberLong(4)
				},
				{
					"micros" : NumberLong(8192),
					"count" : NumberLong(15)
				},
				{
					"micros" : NumberLong(12288),
					"count" : NumberLong(6)
				},
				{
					"micros" : NumberLong(16384),
					"count" : NumberLong(1)
				},
				{
					"micros" : NumberLong(49152),
					"count" : NumberLong(1)
				}
			],
			"latency" : NumberLong(4327980),
			"ops" : NumberLong(197722)
		},
		"commands" : {
			"histogram" : [ ],
			"latency" : NumberLong(0),
			"ops" : NumberLong(0)
		}
	}
}



 Comments   
Comment by Githook User [ 05/Jan/17 ]

Author:

{u'username': u'schmalliso', u'name': u'Allison Moore', u'email': u'allison.moore@10gen.com'}

Message: DOCS-9722: updates collStats histo numbers
Branch: master
https://github.com/mongodb/docs/commit/88e2c54e9f93460d9f8f4dbe70447eb0c82cad16

Generated at Thu Feb 08 07:59:00 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.