printCollectionStats()
This method provides a wrapper around the db.collection.stats() method. This method returns statistics from every collection separated by three hyphen characters.
Syntax:
db.printCollectionStats()
Example
use local
db.printCollectionStats()
MongoDB
db.printCollectionStats()
Output:
startup_log{"ns" : "local.startup_log","size" : 36128,"count" : 16,"avgObjSize" : 2258,"storageSize" : 36864,"freeStorageSize" : 16384,"capped" : true,"max" : 0,"maxSize" : 10485760,"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-2-2850471386552224837","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" : 2,"blocks allocated" : 4,"blocks freed" : 1,"checkpoint size" : 4096,"file allocation unit size" : 4096,"file bytes available for reuse" : 16384,"file magic number" : 120897,"file major version number" : 1,"file size in bytes" : 36864,"minor version number" : 0},"btree" : {"btree checkpoint generation" : 2287,"btree clean tree checkpoint expiration time" : NumberLong("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" : 40571,"bytes dirty in the cache cumulative" : 40571,"bytes read into cache" : 34037,"bytes written from cache" : 36300,"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" : 0,"eviction walk target pages histogram - 0-9" : 0,"eviction walk target pages histogram - 10-31" : 0,"eviction walk target pages histogram - 128 and higher" : 0,"eviction walk target pages histogram - 32-63" : 0,"eviction walk target pages histogram - 64-128" : 0,"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" : 0,"eviction walks gave up because they saw too many pages and found no candidates" : 0,"eviction walks gave up because they saw too many pages and found too few candidates" : 0,"eviction walks reached end of tree" : 0,"eviction walks restarted" : 0,"eviction walks started from root of tree" : 0,"eviction walks started from saved location in tree" : 0,"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" : 0,"in-memory page splits" : 0,"internal pages evicted" : 0,"internal pages split during eviction" : 0,"leaf pages split during eviction" : 0,"modified pages evicted" : 0,"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" : 2,"pages read into cache after truncate" : 0,"pages read into cache after truncate in prepare state" : 0,"pages requested from the cache" : 3,"pages seen by eviction walk" : 0,"pages written from cache" : 2,"pages written requiring in-memory restoration" : 0,"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" : 0},"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" : 0,"pages visited" : 1},"compression" : {"compressed page maximum internal page size prior to compression" : 4096,"compressed page maximum leaf page size prior to compression " : 131072,"compressed pages read" : 1,"compressed pages written" : 1,"number of blocks with compress ratio greater than 64" : 0,"number of blocks with compress ratio smaller than 16" : 1,"number of blocks with compress ratio smaller than 2" : 0,"number of blocks with compress ratio smaller than 32" : 0,"number of blocks with compress ratio smaller than 4" : 0,"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" : 1},"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" : 2,"close calls that result in cache" : 2,"create calls" : 2,"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" : 0,"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" : 1,"insert key and value bytes" : 2259,"modify" : 0,"modify key and value bytes affected" : 0,"modify value bytes modified" : 0,"next calls" : 0,"open cursor count" : 0,"operation restarted" : 0,"prev calls" : 1,"remove calls" : 0,"remove key bytes removed" : 0,"reserve calls" : 0,"reset calls" : 6,"search calls" : 0,"search history store calls" : 0,"search near calls" : 0,"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" : 0,"dictionary matches" : 0,"fast-path pages deleted" : 0,"internal page key bytes discarded using suffix compression" : 0,"internal page multi-block writes" : 0,"leaf page key bytes discarded using prefix compression" : 0,"leaf page multi-block writes" : 0,"leaf-page overflow keys" : 0,"maximum blocks required for a page" : 1,"overflow values written" : 0,"page checksum matches" : 0,"page reconciliation calls" : 2,"page reconciliation calls for eviction" : 0,"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 " : 0,"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" : 0,"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" : 0,"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" : 1,"indexBuilds" : [ ],"totalIndexSize" : 36864,"totalSize" : 73728,"indexSizes" : {"_id_" : 36864},"scaleFactor" : 1,"ok" : 1}---
No comments:
Post a Comment