Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- test> db.test2.find({}).sort({ts: -1}).limit(1).explain()
- {
- explainVersion: '1',
- queryPlanner: {
- namespace: 'test.test2',
- indexFilterSet: false,
- parsedQuery: {},
- maxIndexedOrSolutionsReached: false,
- maxIndexedAndSolutionsReached: false,
- maxScansToExplodeReached: false,
- winningPlan: {
- stage: 'LIMIT',
- limitAmount: 1,
- inputStage: {
- stage: 'FETCH',
- inputStage: {
- stage: 'IXSCAN',
- keyPattern: { ts: -1 },
- indexName: 'ts_-1',
- isMultiKey: false,
- multiKeyPaths: { ts: [] },
- isUnique: false,
- isSparse: false,
- isPartial: false,
- indexVersion: 2,
- direction: 'forward',
- indexBounds: { ts: [ '[MaxKey, MinKey]' ] }
- }
- }
- },
- rejectedPlans: []
- },
- command: {
- find: 'test2',
- filter: {},
- sort: { ts: -1 },
- limit: 1,
- '$db': 'test'
- },
- serverInfo: {
- host: 'aqua-db',
- port: 27017,
- version: '5.0.5',
- gitVersion: 'd65fd89df3fc039b5c55933c0f71d647a54510ae'
- },
- serverParameters: {
- internalQueryFacetBufferSizeBytes: 104857600,
- internalQueryFacetMaxOutputDocSizeBytes: 104857600,
- internalLookupStageIntermediateDocumentMaxSizeBytes: 104857600,
- internalDocumentSourceGroupMaxMemoryBytes: 104857600,
- internalQueryMaxBlockingSortMemoryUsageBytes: 104857600,
- internalQueryProhibitBlockingMergeOnMongoS: 0,
- internalQueryMaxAddToSetBytes: 104857600,
- internalDocumentSourceSetWindowFieldsMaxMemoryBytes: 104857600
- },
- ok: 1
- }
- test> db.test2.stats()
- {
- ns: 'test.test2',
- size: 58000000,
- count: 1000000,
- avgObjSize: 58,
- storageSize: 27152384,
- freeStorageSize: 147456,
- capped: false,
- wiredTiger: {
- metadata: { formatVersion: 1 },
- 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',
- type: 'file',
- uri: 'statistics:table:collection-1-615623608163548620',
- LSM: {
- 'bloom filter false positives': 0,
- 'bloom filter hits': 0,
- 'bloom filter misses': 0,
- 'bloom filter pages evicted from cache': 0,
- 'bloom filter pages read into cache': 0,
- 'bloom filters in the LSM tree': 0,
- 'chunks in the LSM tree': 0,
- 'highest merge generation in the LSM tree': 0,
- 'queries that could have benefited from a Bloom filter that did not exist': 0,
- 'sleep for LSM checkpoint throttle': 0,
- 'sleep for LSM merge throttle': 0,
- 'total size of bloom filters': 0
- },
- 'block-manager': {
- 'allocations requiring file extension': 962,
- 'blocks allocated': 1119,
- 'blocks freed': 120,
- 'checkpoint size': 26988544,
- 'file allocation unit size': 4096,
- 'file bytes available for reuse': 147456,
- 'file magic number': 120897,
- 'file major version number': 1,
- 'file size in bytes': 27152384,
- 'minor version number': 0
- },
- btree: {
- 'btree checkpoint generation': 28,
- 'btree clean tree checkpoint expiration time': Long("9223372036854775807"),
- 'btree compact pages reviewed': 0,
- 'btree compact pages rewritten': 0,
- 'btree compact pages skipped': 0,
- 'btree skipped by compaction as process would not reduce size': 0,
- 'column-store fixed-size leaf pages': 0,
- 'column-store internal pages': 0,
- 'column-store variable-size RLE encoded values': 0,
- 'column-store variable-size deleted values': 0,
- 'column-store variable-size leaf pages': 0,
- 'fixed-record size': 0,
- 'maximum internal page size': 4096,
- 'maximum leaf page key size': 2867,
- 'maximum leaf page size': 32768,
- 'maximum leaf page value size': 67108864,
- 'maximum tree depth': 3,
- 'number of key/value pairs': 0,
- 'overflow pages': 0,
- 'row-store empty values': 0,
- 'row-store internal pages': 0,
- 'row-store leaf pages': 0
- },
- cache: {
- 'bytes currently in the cache': 78004857,
- 'bytes dirty in the cache cumulative': 7293029,
- 'bytes read into cache': 66484268,
- 'bytes written from cache': 70309193,
- 'checkpoint blocked page eviction': 0,
- 'checkpoint of history store file blocked non-history store page eviction': 0,
- 'data source pages selected for eviction unable to be evicted': 0,
- 'eviction gave up due to detecting an out of order on disk value behind the last update on the chain': 0,
- 'eviction gave up due to detecting an out of order tombstone ahead of the selected on disk update': 0,
- 'eviction gave up due to detecting an out of order tombstone ahead of the selected on disk update after validating the update chain': 0,
- 'eviction gave up due to detecting out of order timestamps on the update chain after the selected on disk update': 0,
- 'eviction walk passes of a file': 11884,
- 'eviction walk target pages histogram - 0-9': 10631,
- 'eviction walk target pages histogram - 10-31': 720,
- 'eviction walk target pages histogram - 128 and higher': 0,
- 'eviction walk target pages histogram - 32-63': 531,
- 'eviction walk target pages histogram - 64-128': 2,
- 'eviction walk target pages reduced due to history store cache pressure': 0,
- 'eviction walks abandoned': 0,
- 'eviction walks gave up because they restarted their walk twice': 2718,
- 'eviction walks gave up because they saw too many pages and found no candidates': 9144,
- 'eviction walks gave up because they saw too many pages and found too few candidates': 2,
- 'eviction walks reached end of tree': 12945,
- 'eviction walks restarted': 0,
- 'eviction walks started from root of tree': 11864,
- 'eviction walks started from saved location in tree': 20,
- 'hazard pointer blocked page eviction': 0,
- 'history store table insert calls': 0,
- 'history store table insert calls that returned restart': 0,
- 'history store table out-of-order resolved updates that lose their durable timestamp': 0,
- 'history store table out-of-order updates that were fixed up by reinserting with the fixed timestamp': 0,
- 'history store table reads': 0,
- 'history store table reads missed': 0,
- 'history store table reads requiring squashed modifies': 0,
- 'history store table truncation by rollback to stable to remove an unstable update': 0,
- 'history store table truncation by rollback to stable to remove an update': 0,
- 'history store table truncation to remove an update': 0,
- 'history store table truncation to remove range of updates due to key being removed from the data page during reconciliation': 0,
- 'history store table truncation to remove range of updates due to out-of-order timestamp update on data page': 0,
- 'history store table writes requiring squashed modifies': 0,
- 'in-memory page passed criteria to be split': 7,
- 'in-memory page splits': 4,
- 'internal pages evicted': 0,
- 'internal pages split during eviction': 0,
- 'leaf pages split during eviction': 56,
- 'modified pages evicted': 80,
- 'overflow pages read into cache': 0,
- 'page split during eviction deepened the tree': 0,
- 'page written requiring history store records': 0,
- 'pages read into cache': 1047,
- 'pages read into cache after truncate': 1,
- 'pages read into cache after truncate in prepare state': 0,
- 'pages requested from the cache': 1006881,
- 'pages seen by eviction walk': 1933759,
- 'pages written from cache': 1097,
- 'pages written requiring in-memory restoration': 33,
- 'the number of times full update inserted to history store': 0,
- 'the number of times reverse modify inserted to history store': 0,
- 'tracked dirty bytes in the cache': 0,
- 'unmodified pages evicted': 229
- },
- cache_walk: {
- 'Average difference between current eviction generation when the page was last considered': 0,
- 'Average on-disk page image size seen': 0,
- 'Average time in cache for pages that have been visited by the eviction server': 0,
- 'Average time in cache for pages that have not been visited by the eviction server': 0,
- 'Clean pages currently in cache': 0,
- 'Current eviction generation': 0,
- 'Dirty pages currently in cache': 0,
- 'Entries in the root page': 0,
- 'Internal pages currently in cache': 0,
- 'Leaf pages currently in cache': 0,
- 'Maximum difference between current eviction generation when the page was last considered': 0,
- 'Maximum page size seen': 0,
- 'Minimum on-disk page image size seen': 0,
- 'Number of pages never visited by eviction server': 0,
- 'On-disk page image sizes smaller than a single allocation unit': 0,
- 'Pages created in memory and never written': 0,
- 'Pages currently queued for eviction': 0,
- 'Pages that could not be queued for eviction': 0,
- 'Refs skipped during cache traversal': 0,
- 'Size of the root page': 0,
- 'Total number of pages currently in cache': 0
- },
- 'checkpoint-cleanup': {
- 'pages added for eviction': 0,
- 'pages removed': 0,
- 'pages skipped during tree walk': 193,
- 'pages visited': 6429
- },
- compression: {
- 'compressed page maximum internal page size prior to compression': 4096,
- 'compressed page maximum leaf page size prior to compression ': 36068,
- 'compressed pages read': 1046,
- 'compressed pages written': 1050,
- 'number of blocks with compress ratio greater than 64': 0,
- 'number of blocks with compress ratio smaller than 16': 0,
- 'number of blocks with compress ratio smaller than 2': 2,
- 'number of blocks with compress ratio smaller than 32': 0,
- 'number of blocks with compress ratio smaller than 4': 1044,
- 'number of blocks with compress ratio smaller than 64': 0,
- 'number of blocks with compress ratio smaller than 8': 0,
- 'page written failed to compress': 0,
- 'page written was too small to compress': 47
- },
- cursor: {
- 'Total number of entries skipped by cursor next calls': 0,
- 'Total number of entries skipped by cursor prev calls': 0,
- 'Total number of entries skipped to position the history store cursor': 0,
- 'Total number of times a search near has exited due to prefix config': 0,
- 'bulk loaded cursor insert calls': 0,
- 'cache cursors reuse count': 2105,
- 'close calls that result in cache': 2108,
- 'create calls': 3,
- 'cursor next calls that skip due to a globally visible history store tombstone': 0,
- 'cursor next calls that skip greater than or equal to 100 entries': 0,
- 'cursor next calls that skip less than 100 entries': 1910006,
- 'cursor prev calls that skip due to a globally visible history store tombstone': 0,
- 'cursor prev calls that skip greater than or equal to 100 entries': 0,
- 'cursor prev calls that skip less than 100 entries': 1,
- 'insert calls': 1000000,
- 'insert key and value bytes': 61917635,
- modify: 0,
- 'modify key and value bytes affected': 0,
- 'modify value bytes modified': 0,
- 'next calls': 1910006,
- 'open cursor count': 0,
- 'operation restarted': 0,
- 'prev calls': 1,
- 'remove calls': 0,
- 'remove key bytes removed': 0,
- 'reserve calls': 0,
- 'reset calls': 6132,
- 'search calls': 3,
- 'search history store calls': 0,
- 'search near calls': 1914,
- 'truncate calls': 0,
- 'update calls': 0,
- 'update key and value bytes': 0,
- 'update value size change': 0
- },
- reconciliation: {
- 'approximate byte size of timestamps in pages written': 0,
- 'approximate byte size of transaction IDs in pages written': 149800,
- 'dictionary matches': 0,
- 'fast-path pages deleted': 0,
- 'internal page key bytes discarded using suffix compression': 2041,
- 'internal page multi-block writes': 10,
- 'leaf page key bytes discarded using prefix compression': 0,
- 'leaf page multi-block writes': 58,
- 'leaf-page overflow keys': 0,
- 'maximum blocks required for a page': 1,
- 'overflow values written': 0,
- 'page checksum matches': 0,
- 'page reconciliation calls': 103,
- 'page reconciliation calls for eviction': 75,
- 'pages deleted': 0,
- 'pages written including an aggregated newest start durable timestamp ': 0,
- 'pages written including an aggregated newest stop durable timestamp ': 0,
- 'pages written including an aggregated newest stop timestamp ': 0,
- 'pages written including an aggregated newest stop transaction ID': 0,
- 'pages written including an aggregated newest transaction ID ': 17,
- 'pages written including an aggregated oldest start timestamp ': 0,
- 'pages written including an aggregated prepare': 0,
- 'pages written including at least one prepare': 0,
- 'pages written including at least one start durable timestamp': 0,
- 'pages written including at least one start timestamp': 0,
- 'pages written including at least one start transaction ID': 31,
- 'pages written including at least one stop durable timestamp': 0,
- 'pages written including at least one stop timestamp': 0,
- 'pages written including at least one stop transaction ID': 0,
- 'records written including a prepare': 0,
- 'records written including a start durable timestamp': 0,
- 'records written including a start timestamp': 0,
- 'records written including a start transaction ID': 18725,
- 'records written including a stop durable timestamp': 0,
- 'records written including a stop timestamp': 0,
- 'records written including a stop transaction ID': 0
- },
- session: {
- 'object compaction': 0,
- 'tiered operations dequeued and processed': 0,
- 'tiered operations scheduled': 0,
- 'tiered storage local retention time (secs)': 0,
- 'tiered storage object size': 0
- },
- transaction: {
- 'race to read prepared update retry': 0,
- 'rollback to stable history store records with stop timestamps older than newer records': 0,
- 'rollback to stable inconsistent checkpoint': 0,
- 'rollback to stable keys removed': 0,
- 'rollback to stable keys restored': 0,
- 'rollback to stable restored tombstones from history store': 0,
- 'rollback to stable restored updates from history store': 0,
- 'rollback to stable skipping delete rle': 0,
- 'rollback to stable skipping stable rle': 0,
- 'rollback to stable sweeping history store keys': 0,
- 'rollback to stable updates removed from history store': 0,
- 'transaction checkpoints due to obsolete pages': 0,
- 'update conflicts': 0
- }
- },
- nindexes: 2,
- indexBuilds: [],
- totalIndexSize: 40337408,
- totalSize: 67489792,
- indexSizes: { _id_: 11087872, 'ts_-1': 29249536 },
- scaleFactor: 1,
- ok: 1
- }
Advertisement
Add Comment
Please, Sign In to add comment