Advertisement
Guest User

Untitled

a guest
Dec 20th, 2021
524
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.94 KB | None | 0 0
  1. test> db.test1.find({}).sort({ts: -1}).limit(1).explain()
  2. {
  3. explainVersion: '1',
  4. stages: [
  5. {
  6. '$cursor': {
  7. queryPlanner: {
  8. namespace: 'test.system.buckets.test1',
  9. indexFilterSet: false,
  10. parsedQuery: {},
  11. queryHash: '8B3D4AB8',
  12. planCacheKey: 'D542626C',
  13. maxIndexedOrSolutionsReached: false,
  14. maxIndexedAndSolutionsReached: false,
  15. maxScansToExplodeReached: false,
  16. winningPlan: { stage: 'COLLSCAN', direction: 'forward' },
  17. rejectedPlans: []
  18. },
  19. executionStats: {
  20. executionSuccess: true,
  21. nReturned: 979611,
  22. executionTimeMillis: 1560,
  23. totalKeysExamined: 0,
  24. totalDocsExamined: 979611,
  25. executionStages: {
  26. stage: 'COLLSCAN',
  27. nReturned: 979611,
  28. executionTimeMillisEstimate: 40,
  29. works: 979613,
  30. advanced: 979611,
  31. needTime: 1,
  32. needYield: 0,
  33. saveState: 1123,
  34. restoreState: 1123,
  35. isEOF: 1,
  36. direction: 'forward',
  37. docsExamined: 979611
  38. },
  39. allPlansExecution: []
  40. }
  41. },
  42. nReturned: Long("979611"),
  43. executionTimeMillisEstimate: Long("1002")
  44. },
  45. {
  46. '$_internalUnpackBucket': {
  47. exclude: [],
  48. timeField: 'ts',
  49. metaField: 'md',
  50. bucketMaxSpanSeconds: 3600
  51. },
  52. nReturned: Long("1000000"),
  53. executionTimeMillisEstimate: Long("1487")
  54. },
  55. {
  56. '$sort': { sortKey: { ts: -1 }, limit: Long("1") },
  57. totalDataSizeSortedBytesEstimate: Long("0"),
  58. usedDisk: false,
  59. nReturned: Long("1"),
  60. executionTimeMillisEstimate: Long("1559")
  61. }
  62. ],
  63. serverInfo: {
  64. host: 'aqua-db',
  65. port: 27017,
  66. version: '5.0.5',
  67. gitVersion: 'd65fd89df3fc039b5c55933c0f71d647a54510ae'
  68. },
  69. serverParameters: {
  70. internalQueryFacetBufferSizeBytes: 104857600,
  71. internalQueryFacetMaxOutputDocSizeBytes: 104857600,
  72. internalLookupStageIntermediateDocumentMaxSizeBytes: 104857600,
  73. internalDocumentSourceGroupMaxMemoryBytes: 104857600,
  74. internalQueryMaxBlockingSortMemoryUsageBytes: 104857600,
  75. internalQueryProhibitBlockingMergeOnMongoS: 0,
  76. internalQueryMaxAddToSetBytes: 104857600,
  77. internalDocumentSourceSetWindowFieldsMaxMemoryBytes: 104857600
  78. },
  79. command: {
  80. aggregate: 'system.buckets.test1',
  81. pipeline: [
  82. {
  83. '$_internalUnpackBucket': {
  84. timeField: 'ts',
  85. metaField: 'md',
  86. bucketMaxSpanSeconds: 3600,
  87. exclude: []
  88. }
  89. },
  90. { '$sort': { ts: -1 } },
  91. { '$limit': Long("1") }
  92. ],
  93. cursor: {},
  94. collation: { locale: 'simple' }
  95. },
  96. ok: 1
  97. }
  98. test> db.test1.stats()
  99. {
  100. ns: 'test.test1',
  101. size: 242718310,
  102. timeseries: {
  103. bucketsNs: 'test.system.buckets.test1',
  104. bucketCount: 979611,
  105. avgBucketSize: 247,
  106. numBucketInserts: 979611,
  107. numBucketUpdates: 30,
  108. numBucketsOpenedDueToMetadata: 1,
  109. numBucketsClosedDueToCount: 0,
  110. numBucketsClosedDueToSize: 0,
  111. numBucketsClosedDueToTimeForward: 480653,
  112. numBucketsClosedDueToTimeBackward: 498957,
  113. numBucketsClosedDueToMemoryThreshold: 0,
  114. numCommits: 979641,
  115. numWaits: 0,
  116. numMeasurementsCommitted: 1000000,
  117. avgNumMeasurementsPerCommit: 1
  118. },
  119. storageSize: 77029376,
  120. freeStorageSize: 38363136,
  121. capped: false,
  122. wiredTiger: {
  123. metadata: { formatVersion: 1 },
  124. creationString: 'access_pattern_hint=none,allocation_size=4KB,app_metadata=(formatVersion=1),assert=(commit_timestamp=none,durable_timestamp=none,read_timestamp=none,write_timestamp=off),block_allocation=best,block_compressor=zstd,cache_resident=false,checksum=on,colgroups=,collator=,columns=,dictionary=0,encryption=(keyid=,name=),exclusive=false,extractor=,format=btree,huffman_key=,huffman_value=,ignore_in_memory_cache_size=false,immutable=false,import=(enabled=false,file_metadata=,repair=false),internal_item_max=0,internal_key_max=0,internal_key_truncate=true,internal_page_max=4KB,key_format=u,key_gap=10,leaf_item_max=0,leaf_key_max=0,leaf_page_max=32KB,leaf_value_max=64MB,log=(enabled=true),lsm=(auto_throttle=true,bloom=true,bloom_bit_count=16,bloom_config=,bloom_hash_count=8,bloom_oldest=false,chunk_count_limit=0,chunk_max=5GB,chunk_size=10MB,merge_custom=(prefix=,start_generation=0,suffix=),merge_max=15,merge_min=0),memory_page_image_max=0,memory_page_max=10m,os_cache_dirty_max=0,os_cache_max=0,prefix_compression=false,prefix_compression_min=4,readonly=false,source=,split_deepen_min_child=0,split_deepen_per_child=0,split_pct=90,tiered_object=false,tiered_storage=(auth_token=,bucket=,bucket_prefix=,cache_directory=,local_retention=300,name=,object_target_size=10M),type=file,value_format=u,verbose=[],write_timestamp_usage=none',
  125. type: 'file',
  126. uri: 'statistics:table:collection-0-615623608163548620',
  127. LSM: {
  128. 'bloom filter false positives': 0,
  129. 'bloom filter hits': 0,
  130. 'bloom filter misses': 0,
  131. 'bloom filter pages evicted from cache': 0,
  132. 'bloom filter pages read into cache': 0,
  133. 'bloom filters in the LSM tree': 0,
  134. 'chunks in the LSM tree': 0,
  135. 'highest merge generation in the LSM tree': 0,
  136. 'queries that could have benefited from a Bloom filter that did not exist': 0,
  137. 'sleep for LSM checkpoint throttle': 0,
  138. 'sleep for LSM merge throttle': 0,
  139. 'total size of bloom filters': 0
  140. },
  141. 'block-manager': {
  142. 'allocations requiring file extension': 5091,
  143. 'blocks allocated': 364058,
  144. 'blocks freed': 361124,
  145. 'checkpoint size': 38645760,
  146. 'file allocation unit size': 4096,
  147. 'file bytes available for reuse': 38363136,
  148. 'file magic number': 120897,
  149. 'file major version number': 1,
  150. 'file size in bytes': 77029376,
  151. 'minor version number': 0
  152. },
  153. btree: {
  154. 'btree checkpoint generation': 28,
  155. 'btree clean tree checkpoint expiration time': Long("9223372036854775807"),
  156. 'btree compact pages reviewed': 0,
  157. 'btree compact pages rewritten': 0,
  158. 'btree compact pages skipped': 0,
  159. 'btree skipped by compaction as process would not reduce size': 0,
  160. 'column-store fixed-size leaf pages': 0,
  161. 'column-store internal pages': 0,
  162. 'column-store variable-size RLE encoded values': 0,
  163. 'column-store variable-size deleted values': 0,
  164. 'column-store variable-size leaf pages': 0,
  165. 'fixed-record size': 0,
  166. 'maximum internal page size': 4096,
  167. 'maximum leaf page key size': 2867,
  168. 'maximum leaf page size': 32768,
  169. 'maximum leaf page value size': 67108864,
  170. 'maximum tree depth': 3,
  171. 'number of key/value pairs': 0,
  172. 'overflow pages': 0,
  173. 'row-store empty values': 0,
  174. 'row-store internal pages': 0,
  175. 'row-store leaf pages': 0
  176. },
  177. cache: {
  178. 'bytes currently in the cache': 278016709,
  179. 'bytes dirty in the cache cumulative': Long("72305928370"),
  180. 'bytes read into cache': Long("31436761817"),
  181. 'bytes written from cache': Long("33005096700"),
  182. 'checkpoint blocked page eviction': 2598,
  183. 'checkpoint of history store file blocked non-history store page eviction': 0,
  184. 'data source pages selected for eviction unable to be evicted': 3076,
  185. 'eviction gave up due to detecting an out of order on disk value behind the last update on the chain': 0,
  186. 'eviction gave up due to detecting an out of order tombstone ahead of the selected on disk update': 0,
  187. 'eviction gave up due to detecting an out of order tombstone ahead of the selected on disk update after validating the update chain': 0,
  188. 'eviction gave up due to detecting out of order timestamps on the update chain after the selected on disk update': 0,
  189. 'eviction walk passes of a file': 326501,
  190. 'eviction walk target pages histogram - 0-9': 15726,
  191. 'eviction walk target pages histogram - 10-31': 35406,
  192. 'eviction walk target pages histogram - 128 and higher': 0,
  193. 'eviction walk target pages histogram - 32-63': 54257,
  194. 'eviction walk target pages histogram - 64-128': 221112,
  195. 'eviction walk target pages reduced due to history store cache pressure': 0,
  196. 'eviction walks abandoned': 9,
  197. 'eviction walks gave up because they restarted their walk twice': 10049,
  198. 'eviction walks gave up because they saw too many pages and found no candidates': 393,
  199. 'eviction walks gave up because they saw too many pages and found too few candidates': 32,
  200. 'eviction walks reached end of tree': 89921,
  201. 'eviction walks restarted': 0,
  202. 'eviction walks started from root of tree': 10799,
  203. 'eviction walks started from saved location in tree': 315702,
  204. 'hazard pointer blocked page eviction': 478,
  205. 'history store table insert calls': 0,
  206. 'history store table insert calls that returned restart': 0,
  207. 'history store table out-of-order resolved updates that lose their durable timestamp': 0,
  208. 'history store table out-of-order updates that were fixed up by reinserting with the fixed timestamp': 0,
  209. 'history store table reads': 0,
  210. 'history store table reads missed': 0,
  211. 'history store table reads requiring squashed modifies': 0,
  212. 'history store table truncation by rollback to stable to remove an unstable update': 0,
  213. 'history store table truncation by rollback to stable to remove an update': 0,
  214. 'history store table truncation to remove an update': 0,
  215. 'history store table truncation to remove range of updates due to key being removed from the data page during reconciliation': 0,
  216. 'history store table truncation to remove range of updates due to out-of-order timestamp update on data page': 0,
  217. 'history store table writes requiring squashed modifies': 0,
  218. 'in-memory page passed criteria to be split': 0,
  219. 'in-memory page splits': 0,
  220. 'internal pages evicted': 0,
  221. 'internal pages split during eviction': 0,
  222. 'leaf pages split during eviction': 2826,
  223. 'modified pages evicted': 677223,
  224. 'overflow pages read into cache': 0,
  225. 'page split during eviction deepened the tree': 0,
  226. 'page written requiring history store records': 0,
  227. 'pages read into cache': 346668,
  228. 'pages read into cache after truncate': 1,
  229. 'pages read into cache after truncate in prepare state': 0,
  230. 'pages requested from the cache': 1027047,
  231. 'pages seen by eviction walk': 67904709,
  232. 'pages written from cache': 364036,
  233. 'pages written requiring in-memory restoration': 333782,
  234. 'the number of times full update inserted to history store': 0,
  235. 'the number of times reverse modify inserted to history store': 0,
  236. 'tracked dirty bytes in the cache': 0,
  237. 'unmodified pages evicted': 1139
  238. },
  239. cache_walk: {
  240. 'Average difference between current eviction generation when the page was last considered': 0,
  241. 'Average on-disk page image size seen': 0,
  242. 'Average time in cache for pages that have been visited by the eviction server': 0,
  243. 'Average time in cache for pages that have not been visited by the eviction server': 0,
  244. 'Clean pages currently in cache': 0,
  245. 'Current eviction generation': 0,
  246. 'Dirty pages currently in cache': 0,
  247. 'Entries in the root page': 0,
  248. 'Internal pages currently in cache': 0,
  249. 'Leaf pages currently in cache': 0,
  250. 'Maximum difference between current eviction generation when the page was last considered': 0,
  251. 'Maximum page size seen': 0,
  252. 'Minimum on-disk page image size seen': 0,
  253. 'Number of pages never visited by eviction server': 0,
  254. 'On-disk page image sizes smaller than a single allocation unit': 0,
  255. 'Pages created in memory and never written': 0,
  256. 'Pages currently queued for eviction': 0,
  257. 'Pages that could not be queued for eviction': 0,
  258. 'Refs skipped during cache traversal': 0,
  259. 'Size of the root page': 0,
  260. 'Total number of pages currently in cache': 0
  261. },
  262. 'checkpoint-cleanup': {
  263. 'pages added for eviction': 0,
  264. 'pages removed': 0,
  265. 'pages skipped during tree walk': 1516,
  266. 'pages visited': 21581
  267. },
  268. compression: {
  269. 'compressed page maximum internal page size prior to compression': 4096,
  270. 'compressed page maximum leaf page size prior to compression ': 131072,
  271. 'compressed pages read': 346668,
  272. 'compressed pages written': 363873,
  273. 'number of blocks with compress ratio greater than 64': 0,
  274. 'number of blocks with compress ratio smaller than 16': 3451,
  275. 'number of blocks with compress ratio smaller than 2': 0,
  276. 'number of blocks with compress ratio smaller than 32': 0,
  277. 'number of blocks with compress ratio smaller than 4': 0,
  278. 'number of blocks with compress ratio smaller than 64': 0,
  279. 'number of blocks with compress ratio smaller than 8': 343217,
  280. 'page written failed to compress': 0,
  281. 'page written was too small to compress': 163
  282. },
  283. cursor: {
  284. 'Total number of entries skipped by cursor next calls': 3775,
  285. 'Total number of entries skipped by cursor prev calls': 0,
  286. 'Total number of entries skipped to position the history store cursor': 0,
  287. 'Total number of times a search near has exited due to prefix config': 0,
  288. 'bulk loaded cursor insert calls': 0,
  289. 'cache cursors reuse count': 1142,
  290. 'close calls that result in cache': 1145,
  291. 'create calls': 3,
  292. 'cursor next calls that skip due to a globally visible history store tombstone': 0,
  293. 'cursor next calls that skip greater than or equal to 100 entries': 0,
  294. 'cursor next calls that skip less than 100 entries': 8118637,
  295. 'cursor prev calls that skip due to a globally visible history store tombstone': 0,
  296. 'cursor prev calls that skip greater than or equal to 100 entries': 0,
  297. 'cursor prev calls that skip less than 100 entries': 0,
  298. 'insert calls': 979641,
  299. 'insert key and value bytes': 255461090,
  300. modify: 0,
  301. 'modify key and value bytes affected': 0,
  302. 'modify value bytes modified': 0,
  303. 'next calls': 8118637,
  304. 'open cursor count': 0,
  305. 'operation restarted': 0,
  306. 'prev calls': 0,
  307. 'remove calls': 0,
  308. 'remove key bytes removed': 0,
  309. 'reserve calls': 0,
  310. 'reset calls': 11550,
  311. 'search calls': 60,
  312. 'search history store calls': 0,
  313. 'search near calls': 9228,
  314. 'truncate calls': 0,
  315. 'update calls': 0,
  316. 'update key and value bytes': 0,
  317. 'update value size change': 0
  318. },
  319. reconciliation: {
  320. 'approximate byte size of timestamps in pages written': 0,
  321. 'approximate byte size of transaction IDs in pages written': 12072,
  322. 'dictionary matches': 0,
  323. 'fast-path pages deleted': 0,
  324. 'internal page key bytes discarded using suffix compression': 1584831,
  325. 'internal page multi-block writes': 11,
  326. 'leaf page key bytes discarded using prefix compression': 0,
  327. 'leaf page multi-block writes': 2866,
  328. 'leaf-page overflow keys': 0,
  329. 'maximum blocks required for a page': 1,
  330. 'overflow values written': 0,
  331. 'page checksum matches': 0,
  332. 'page reconciliation calls': 684434,
  333. 'page reconciliation calls for eviction': 677027,
  334. 'pages deleted': 0,
  335. 'pages written including an aggregated newest start durable timestamp ': 0,
  336. 'pages written including an aggregated newest stop durable timestamp ': 0,
  337. 'pages written including an aggregated newest stop timestamp ': 0,
  338. 'pages written including an aggregated newest stop transaction ID': 0,
  339. 'pages written including an aggregated newest transaction ID ': 148,
  340. 'pages written including an aggregated oldest start timestamp ': 0,
  341. 'pages written including an aggregated prepare': 0,
  342. 'pages written including at least one prepare': 0,
  343. 'pages written including at least one start durable timestamp': 0,
  344. 'pages written including at least one start timestamp': 0,
  345. 'pages written including at least one start transaction ID': 1126,
  346. 'pages written including at least one stop durable timestamp': 0,
  347. 'pages written including at least one stop timestamp': 0,
  348. 'pages written including at least one stop transaction ID': 0,
  349. 'records written including a prepare': 0,
  350. 'records written including a start durable timestamp': 0,
  351. 'records written including a start timestamp': 0,
  352. 'records written including a start transaction ID': 1509,
  353. 'records written including a stop durable timestamp': 0,
  354. 'records written including a stop timestamp': 0,
  355. 'records written including a stop transaction ID': 0
  356. },
  357. session: {
  358. 'object compaction': 0,
  359. 'tiered operations dequeued and processed': 0,
  360. 'tiered operations scheduled': 0,
  361. 'tiered storage local retention time (secs)': 0,
  362. 'tiered storage object size': 0
  363. },
  364. transaction: {
  365. 'race to read prepared update retry': 0,
  366. 'rollback to stable history store records with stop timestamps older than newer records': 0,
  367. 'rollback to stable inconsistent checkpoint': 0,
  368. 'rollback to stable keys removed': 0,
  369. 'rollback to stable keys restored': 0,
  370. 'rollback to stable restored tombstones from history store': 0,
  371. 'rollback to stable restored updates from history store': 0,
  372. 'rollback to stable skipping delete rle': 0,
  373. 'rollback to stable skipping stable rle': 0,
  374. 'rollback to stable sweeping history store keys': 0,
  375. 'rollback to stable updates removed from history store': 0,
  376. 'transaction checkpoints due to obsolete pages': 0,
  377. 'update conflicts': 0
  378. }
  379. },
  380. nindexes: 1,
  381. indexBuilds: [],
  382. totalIndexSize: 81256448,
  383. totalSize: 158285824,
  384. indexSizes: { 'ts_-1': 81256448 },
  385. scaleFactor: 1,
  386. ok: 1
  387. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement