Guest User

Untitled

a guest
Dec 20th, 2021
1,037
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.12 KB | None | 0 0
  1. test> db.test2.find({}).sort({ts: -1}).limit(1).explain()
  2. {
  3. explainVersion: '1',
  4. queryPlanner: {
  5. namespace: 'test.test2',
  6. indexFilterSet: false,
  7. parsedQuery: {},
  8. maxIndexedOrSolutionsReached: false,
  9. maxIndexedAndSolutionsReached: false,
  10. maxScansToExplodeReached: false,
  11. winningPlan: {
  12. stage: 'LIMIT',
  13. limitAmount: 1,
  14. inputStage: {
  15. stage: 'FETCH',
  16. inputStage: {
  17. stage: 'IXSCAN',
  18. keyPattern: { ts: -1 },
  19. indexName: 'ts_-1',
  20. isMultiKey: false,
  21. multiKeyPaths: { ts: [] },
  22. isUnique: false,
  23. isSparse: false,
  24. isPartial: false,
  25. indexVersion: 2,
  26. direction: 'forward',
  27. indexBounds: { ts: [ '[MaxKey, MinKey]' ] }
  28. }
  29. }
  30. },
  31. rejectedPlans: []
  32. },
  33. command: {
  34. find: 'test2',
  35. filter: {},
  36. sort: { ts: -1 },
  37. limit: 1,
  38. '$db': 'test'
  39. },
  40. serverInfo: {
  41. host: 'aqua-db',
  42. port: 27017,
  43. version: '5.0.5',
  44. gitVersion: 'd65fd89df3fc039b5c55933c0f71d647a54510ae'
  45. },
  46. serverParameters: {
  47. internalQueryFacetBufferSizeBytes: 104857600,
  48. internalQueryFacetMaxOutputDocSizeBytes: 104857600,
  49. internalLookupStageIntermediateDocumentMaxSizeBytes: 104857600,
  50. internalDocumentSourceGroupMaxMemoryBytes: 104857600,
  51. internalQueryMaxBlockingSortMemoryUsageBytes: 104857600,
  52. internalQueryProhibitBlockingMergeOnMongoS: 0,
  53. internalQueryMaxAddToSetBytes: 104857600,
  54. internalDocumentSourceSetWindowFieldsMaxMemoryBytes: 104857600
  55. },
  56. ok: 1
  57. }
  58. test> db.test2.stats()
  59. {
  60. ns: 'test.test2',
  61. size: 58000000,
  62. count: 1000000,
  63. avgObjSize: 58,
  64. storageSize: 27152384,
  65. freeStorageSize: 147456,
  66. capped: false,
  67. wiredTiger: {
  68. metadata: { formatVersion: 1 },
  69. 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=snappy,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=q,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',
  70. type: 'file',
  71. uri: 'statistics:table:collection-1-615623608163548620',
  72. LSM: {
  73. 'bloom filter false positives': 0,
  74. 'bloom filter hits': 0,
  75. 'bloom filter misses': 0,
  76. 'bloom filter pages evicted from cache': 0,
  77. 'bloom filter pages read into cache': 0,
  78. 'bloom filters in the LSM tree': 0,
  79. 'chunks in the LSM tree': 0,
  80. 'highest merge generation in the LSM tree': 0,
  81. 'queries that could have benefited from a Bloom filter that did not exist': 0,
  82. 'sleep for LSM checkpoint throttle': 0,
  83. 'sleep for LSM merge throttle': 0,
  84. 'total size of bloom filters': 0
  85. },
  86. 'block-manager': {
  87. 'allocations requiring file extension': 962,
  88. 'blocks allocated': 1119,
  89. 'blocks freed': 120,
  90. 'checkpoint size': 26988544,
  91. 'file allocation unit size': 4096,
  92. 'file bytes available for reuse': 147456,
  93. 'file magic number': 120897,
  94. 'file major version number': 1,
  95. 'file size in bytes': 27152384,
  96. 'minor version number': 0
  97. },
  98. btree: {
  99. 'btree checkpoint generation': 28,
  100. 'btree clean tree checkpoint expiration time': Long("9223372036854775807"),
  101. 'btree compact pages reviewed': 0,
  102. 'btree compact pages rewritten': 0,
  103. 'btree compact pages skipped': 0,
  104. 'btree skipped by compaction as process would not reduce size': 0,
  105. 'column-store fixed-size leaf pages': 0,
  106. 'column-store internal pages': 0,
  107. 'column-store variable-size RLE encoded values': 0,
  108. 'column-store variable-size deleted values': 0,
  109. 'column-store variable-size leaf pages': 0,
  110. 'fixed-record size': 0,
  111. 'maximum internal page size': 4096,
  112. 'maximum leaf page key size': 2867,
  113. 'maximum leaf page size': 32768,
  114. 'maximum leaf page value size': 67108864,
  115. 'maximum tree depth': 3,
  116. 'number of key/value pairs': 0,
  117. 'overflow pages': 0,
  118. 'row-store empty values': 0,
  119. 'row-store internal pages': 0,
  120. 'row-store leaf pages': 0
  121. },
  122. cache: {
  123. 'bytes currently in the cache': 78004857,
  124. 'bytes dirty in the cache cumulative': 7293029,
  125. 'bytes read into cache': 66484268,
  126. 'bytes written from cache': 70309193,
  127. 'checkpoint blocked page eviction': 0,
  128. 'checkpoint of history store file blocked non-history store page eviction': 0,
  129. 'data source pages selected for eviction unable to be evicted': 0,
  130. 'eviction gave up due to detecting an out of order on disk value behind the last update on the chain': 0,
  131. 'eviction gave up due to detecting an out of order tombstone ahead of the selected on disk update': 0,
  132. 'eviction gave up due to detecting an out of order tombstone ahead of the selected on disk update after validating the update chain': 0,
  133. 'eviction gave up due to detecting out of order timestamps on the update chain after the selected on disk update': 0,
  134. 'eviction walk passes of a file': 11884,
  135. 'eviction walk target pages histogram - 0-9': 10631,
  136. 'eviction walk target pages histogram - 10-31': 720,
  137. 'eviction walk target pages histogram - 128 and higher': 0,
  138. 'eviction walk target pages histogram - 32-63': 531,
  139. 'eviction walk target pages histogram - 64-128': 2,
  140. 'eviction walk target pages reduced due to history store cache pressure': 0,
  141. 'eviction walks abandoned': 0,
  142. 'eviction walks gave up because they restarted their walk twice': 2718,
  143. 'eviction walks gave up because they saw too many pages and found no candidates': 9144,
  144. 'eviction walks gave up because they saw too many pages and found too few candidates': 2,
  145. 'eviction walks reached end of tree': 12945,
  146. 'eviction walks restarted': 0,
  147. 'eviction walks started from root of tree': 11864,
  148. 'eviction walks started from saved location in tree': 20,
  149. 'hazard pointer blocked page eviction': 0,
  150. 'history store table insert calls': 0,
  151. 'history store table insert calls that returned restart': 0,
  152. 'history store table out-of-order resolved updates that lose their durable timestamp': 0,
  153. 'history store table out-of-order updates that were fixed up by reinserting with the fixed timestamp': 0,
  154. 'history store table reads': 0,
  155. 'history store table reads missed': 0,
  156. 'history store table reads requiring squashed modifies': 0,
  157. 'history store table truncation by rollback to stable to remove an unstable update': 0,
  158. 'history store table truncation by rollback to stable to remove an update': 0,
  159. 'history store table truncation to remove an update': 0,
  160. 'history store table truncation to remove range of updates due to key being removed from the data page during reconciliation': 0,
  161. 'history store table truncation to remove range of updates due to out-of-order timestamp update on data page': 0,
  162. 'history store table writes requiring squashed modifies': 0,
  163. 'in-memory page passed criteria to be split': 7,
  164. 'in-memory page splits': 4,
  165. 'internal pages evicted': 0,
  166. 'internal pages split during eviction': 0,
  167. 'leaf pages split during eviction': 56,
  168. 'modified pages evicted': 80,
  169. 'overflow pages read into cache': 0,
  170. 'page split during eviction deepened the tree': 0,
  171. 'page written requiring history store records': 0,
  172. 'pages read into cache': 1047,
  173. 'pages read into cache after truncate': 1,
  174. 'pages read into cache after truncate in prepare state': 0,
  175. 'pages requested from the cache': 1006881,
  176. 'pages seen by eviction walk': 1933759,
  177. 'pages written from cache': 1097,
  178. 'pages written requiring in-memory restoration': 33,
  179. 'the number of times full update inserted to history store': 0,
  180. 'the number of times reverse modify inserted to history store': 0,
  181. 'tracked dirty bytes in the cache': 0,
  182. 'unmodified pages evicted': 229
  183. },
  184. cache_walk: {
  185. 'Average difference between current eviction generation when the page was last considered': 0,
  186. 'Average on-disk page image size seen': 0,
  187. 'Average time in cache for pages that have been visited by the eviction server': 0,
  188. 'Average time in cache for pages that have not been visited by the eviction server': 0,
  189. 'Clean pages currently in cache': 0,
  190. 'Current eviction generation': 0,
  191. 'Dirty pages currently in cache': 0,
  192. 'Entries in the root page': 0,
  193. 'Internal pages currently in cache': 0,
  194. 'Leaf pages currently in cache': 0,
  195. 'Maximum difference between current eviction generation when the page was last considered': 0,
  196. 'Maximum page size seen': 0,
  197. 'Minimum on-disk page image size seen': 0,
  198. 'Number of pages never visited by eviction server': 0,
  199. 'On-disk page image sizes smaller than a single allocation unit': 0,
  200. 'Pages created in memory and never written': 0,
  201. 'Pages currently queued for eviction': 0,
  202. 'Pages that could not be queued for eviction': 0,
  203. 'Refs skipped during cache traversal': 0,
  204. 'Size of the root page': 0,
  205. 'Total number of pages currently in cache': 0
  206. },
  207. 'checkpoint-cleanup': {
  208. 'pages added for eviction': 0,
  209. 'pages removed': 0,
  210. 'pages skipped during tree walk': 193,
  211. 'pages visited': 6429
  212. },
  213. compression: {
  214. 'compressed page maximum internal page size prior to compression': 4096,
  215. 'compressed page maximum leaf page size prior to compression ': 36068,
  216. 'compressed pages read': 1046,
  217. 'compressed pages written': 1050,
  218. 'number of blocks with compress ratio greater than 64': 0,
  219. 'number of blocks with compress ratio smaller than 16': 0,
  220. 'number of blocks with compress ratio smaller than 2': 2,
  221. 'number of blocks with compress ratio smaller than 32': 0,
  222. 'number of blocks with compress ratio smaller than 4': 1044,
  223. 'number of blocks with compress ratio smaller than 64': 0,
  224. 'number of blocks with compress ratio smaller than 8': 0,
  225. 'page written failed to compress': 0,
  226. 'page written was too small to compress': 47
  227. },
  228. cursor: {
  229. 'Total number of entries skipped by cursor next calls': 0,
  230. 'Total number of entries skipped by cursor prev calls': 0,
  231. 'Total number of entries skipped to position the history store cursor': 0,
  232. 'Total number of times a search near has exited due to prefix config': 0,
  233. 'bulk loaded cursor insert calls': 0,
  234. 'cache cursors reuse count': 2105,
  235. 'close calls that result in cache': 2108,
  236. 'create calls': 3,
  237. 'cursor next calls that skip due to a globally visible history store tombstone': 0,
  238. 'cursor next calls that skip greater than or equal to 100 entries': 0,
  239. 'cursor next calls that skip less than 100 entries': 1910006,
  240. 'cursor prev calls that skip due to a globally visible history store tombstone': 0,
  241. 'cursor prev calls that skip greater than or equal to 100 entries': 0,
  242. 'cursor prev calls that skip less than 100 entries': 1,
  243. 'insert calls': 1000000,
  244. 'insert key and value bytes': 61917635,
  245. modify: 0,
  246. 'modify key and value bytes affected': 0,
  247. 'modify value bytes modified': 0,
  248. 'next calls': 1910006,
  249. 'open cursor count': 0,
  250. 'operation restarted': 0,
  251. 'prev calls': 1,
  252. 'remove calls': 0,
  253. 'remove key bytes removed': 0,
  254. 'reserve calls': 0,
  255. 'reset calls': 6132,
  256. 'search calls': 3,
  257. 'search history store calls': 0,
  258. 'search near calls': 1914,
  259. 'truncate calls': 0,
  260. 'update calls': 0,
  261. 'update key and value bytes': 0,
  262. 'update value size change': 0
  263. },
  264. reconciliation: {
  265. 'approximate byte size of timestamps in pages written': 0,
  266. 'approximate byte size of transaction IDs in pages written': 149800,
  267. 'dictionary matches': 0,
  268. 'fast-path pages deleted': 0,
  269. 'internal page key bytes discarded using suffix compression': 2041,
  270. 'internal page multi-block writes': 10,
  271. 'leaf page key bytes discarded using prefix compression': 0,
  272. 'leaf page multi-block writes': 58,
  273. 'leaf-page overflow keys': 0,
  274. 'maximum blocks required for a page': 1,
  275. 'overflow values written': 0,
  276. 'page checksum matches': 0,
  277. 'page reconciliation calls': 103,
  278. 'page reconciliation calls for eviction': 75,
  279. 'pages deleted': 0,
  280. 'pages written including an aggregated newest start durable timestamp ': 0,
  281. 'pages written including an aggregated newest stop durable timestamp ': 0,
  282. 'pages written including an aggregated newest stop timestamp ': 0,
  283. 'pages written including an aggregated newest stop transaction ID': 0,
  284. 'pages written including an aggregated newest transaction ID ': 17,
  285. 'pages written including an aggregated oldest start timestamp ': 0,
  286. 'pages written including an aggregated prepare': 0,
  287. 'pages written including at least one prepare': 0,
  288. 'pages written including at least one start durable timestamp': 0,
  289. 'pages written including at least one start timestamp': 0,
  290. 'pages written including at least one start transaction ID': 31,
  291. 'pages written including at least one stop durable timestamp': 0,
  292. 'pages written including at least one stop timestamp': 0,
  293. 'pages written including at least one stop transaction ID': 0,
  294. 'records written including a prepare': 0,
  295. 'records written including a start durable timestamp': 0,
  296. 'records written including a start timestamp': 0,
  297. 'records written including a start transaction ID': 18725,
  298. 'records written including a stop durable timestamp': 0,
  299. 'records written including a stop timestamp': 0,
  300. 'records written including a stop transaction ID': 0
  301. },
  302. session: {
  303. 'object compaction': 0,
  304. 'tiered operations dequeued and processed': 0,
  305. 'tiered operations scheduled': 0,
  306. 'tiered storage local retention time (secs)': 0,
  307. 'tiered storage object size': 0
  308. },
  309. transaction: {
  310. 'race to read prepared update retry': 0,
  311. 'rollback to stable history store records with stop timestamps older than newer records': 0,
  312. 'rollback to stable inconsistent checkpoint': 0,
  313. 'rollback to stable keys removed': 0,
  314. 'rollback to stable keys restored': 0,
  315. 'rollback to stable restored tombstones from history store': 0,
  316. 'rollback to stable restored updates from history store': 0,
  317. 'rollback to stable skipping delete rle': 0,
  318. 'rollback to stable skipping stable rle': 0,
  319. 'rollback to stable sweeping history store keys': 0,
  320. 'rollback to stable updates removed from history store': 0,
  321. 'transaction checkpoints due to obsolete pages': 0,
  322. 'update conflicts': 0
  323. }
  324. },
  325. nindexes: 2,
  326. indexBuilds: [],
  327. totalIndexSize: 40337408,
  328. totalSize: 67489792,
  329. indexSizes: { _id_: 11087872, 'ts_-1': 29249536 },
  330. scaleFactor: 1,
  331. ok: 1
  332. }
Advertisement
Add Comment
Please, Sign In to add comment