[SERVER-16245] Expose index statistics for WiredTiger Created: 19/Nov/14  Updated: 27/Oct/15  Resolved: 23/Dec/14

Status: Closed
Project: Core Server
Component/s: Diagnostics
Affects Version/s: None
Fix Version/s: 2.8.0-rc4

Type: Improvement Priority: Major - P3
Reporter: Daniel Pasette (Inactive) Assignee: Eric Milkie
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-16782 Modify collection stats helper to opt... Closed
Documented
is documented by DOCS-4608 Update collStats documentation to ref... Closed
Related
is related to SERVER-44432 Per index access stats Closed
Tested
Backwards Compatibility: Minor Change
Participants:

 Description   

Currently, the only way to expose WT index statistics is by calling db.col.validate({full:true}), which is an expensive way to get a cheap set of stats.

Plan: extend collStats to produce index stats for each index. These will be added to the custom section of collStats output, so this output will only be valid for WiredTiger collections.
As part of this extension, we will need to remove collStats privilege from read role.



 Comments   
Comment by Githook User [ 23/Dec/14 ]

Author:

{u'username': u'milkie', u'name': u'Eric Milkie', u'email': u'milkie@10gen.com'}

Message: SERVER-16245 fix multiversion tests
Branch: master
https://github.com/mongodb/mongo/commit/784c8b1efa30da2cb1b445a153c0b6fd58703d7a

Comment by Githook User [ 23/Dec/14 ]

Author:

{u'username': u'milkie', u'name': u'Eric Milkie', u'email': u'milkie@10gen.com'}

Message: SERVER-16245 fix multiversion tests
Branch: master
https://github.com/mongodb/mongo/commit/fcd9920dc5f501bb2b9439b8d60722d5d3793307

Comment by Githook User [ 23/Dec/14 ]

Author:

{u'username': u'milkie', u'name': u'Eric Milkie', u'email': u'milkie@10gen.com'}

Message: SERVER-16245 clean up index stat display
Branch: master
https://github.com/mongodb/mongo/commit/0e9f78133f2bbff5b215a106eba64ec98cfecf98

Comment by Eric Milkie [ 23/Dec/14 ]

WiredTiger index statistics are now available as part of collection stats. The validate command will continue to produce index statistics as well.

Comment by Githook User [ 23/Dec/14 ]

Author:

{u'username': u'milkie', u'name': u'Eric Milkie', u'email': u'milkie@10gen.com'}

Message: SERVER-16245 expose index statistics on WiredTiger
Branch: master
https://github.com/mongodb/mongo/commit/8a0987a81b10c9b5559170bfc00a6292eefe3866

Comment by Eric Milkie [ 22/Dec/14 ]

Note that the new mmapv1 output will change to look like this:

> db.foo.stats()
{
	"ns" : "test.foo",
	"count" : 1,
	"size" : 48,
	"avgObjSize" : 48,
	"numExtents" : 1,
	"storageSize" : 8192,
	"lastExtentSize" : 8192,
	"paddingFactor" : 1,
	"paddingFactorNote" : "paddingFactor is unused and unmaintained in 2.8. It remains hard coded to 1.0 for compatibility only.",
	"userFlags" : 1,
	"nindexes" : 2,
	"indexDetails" : {
		"test.foo.$_id_" : {
			
		},
		"test.foo.$a_1" : {
			
		}
	},
	"totalIndexSize" : 16352,
	"indexSizes" : {
		"_id_" : 8176,
		"a_1" : 8176
	},
	"ok" : 1
}

Comment by Eric Milkie [ 22/Dec/14 ]

New output example:

> db.foo.stats()
{
	"ns" : "test.foo",
	"count" : 1,
	"size" : 33,
	"avgObjSize" : 33,
	"storageSize" : 16384,
	"capped" : false,
	"wiredTiger" : {
		"uri" : "statistics:table:collection-0--1706195830996214790",
		"LSM" : {
			"bloom filters in the LSM tree" : 0,
			"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,
			"total size of bloom filters" : 0,
			"sleep for LSM checkpoint throttle" : 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 merge throttle" : 0
		},
		"block-manager" : {
			"file allocation unit size" : 4096,
			"blocks allocated" : 0,
			"checkpoint size" : 8192,
			"allocations requiring file extension" : 0,
			"blocks freed" : 0,
			"file magic number" : 120897,
			"file major version number" : 1,
			"minor version number" : 0,
			"file bytes available for reuse" : 0,
			"file size in bytes" : 16384
		},
		"btree" : {
			"column-store variable-size deleted values" : 0,
			"column-store fixed-size leaf pages" : 0,
			"column-store internal pages" : 0,
			"column-store variable-size leaf pages" : 0,
			"pages rewritten by compaction" : 0,
			"number of key/value pairs" : 0,
			"fixed-record size" : 0,
			"maximum tree depth" : 3,
			"maximum internal page key size" : 307,
			"maximum internal page size" : 4096,
			"maximum leaf page key size" : 2457,
			"maximum leaf page size" : 32768,
			"maximum leaf page value size" : 1048576,
			"overflow pages" : 0,
			"row-store internal pages" : 0,
			"row-store leaf pages" : 0
		},
		"cache" : {
			"bytes read into cache" : 127,
			"bytes written from cache" : 0,
			"checkpoint blocked page eviction" : 0,
			"unmodified pages evicted" : 0,
			"modified pages evicted" : 0,
			"data source pages selected for eviction unable to be evicted" : 0,
			"hazard pointer blocked page eviction" : 0,
			"internal pages evicted" : 0,
			"in-memory page splits" : 0,
			"overflow values cached in memory" : 0,
			"pages read into cache" : 2,
			"overflow pages read into cache" : 0,
			"pages written from cache" : 0
		},
		"compression" : {
			"raw compression call failed, no additional data available" : 0,
			"raw compression call failed, additional data available" : 0,
			"raw compression call succeeded" : 0,
			"compressed pages read" : 0,
			"compressed pages written" : 0,
			"page written failed to compress" : 0,
			"page written was too small to compress" : 0
		},
		"cursor" : {
			"create calls" : 2,
			"insert calls" : 0,
			"bulk-loaded cursor-insert calls" : 0,
			"cursor-insert key and value bytes inserted" : 0,
			"next calls" : 0,
			"prev calls" : 2,
			"remove calls" : 0,
			"cursor-remove key bytes removed" : 0,
			"reset calls" : 2,
			"search calls" : 1,
			"search near calls" : 0,
			"update calls" : 0,
			"cursor-update value bytes updated" : 0
		},
		"reconciliation" : {
			"dictionary matches" : 0,
			"internal page multi-block writes" : 0,
			"leaf page multi-block writes" : 0,
			"maximum blocks required for a page" : 0,
			"internal-page overflow keys" : 0,
			"leaf-page overflow keys" : 0,
			"overflow values written" : 0,
			"pages deleted" : 0,
			"page checksum matches" : 0,
			"page reconciliation calls" : 0,
			"page reconciliation calls for eviction" : 0,
			"leaf page key bytes discarded using prefix compression" : 0,
			"internal page key bytes discarded using suffix compression" : 0
		},
		"session" : {
			"object compaction" : 0,
			"open cursor count" : 4
		},
		"transaction" : {
			"update conflicts" : 0
		}
	},
	"nindexes" : 2,
	"indexDetails" : {
		"test.foo.$_id_" : {
			"wiredTiger" : {
				"uri" : "statistics:table:index-1--1706195830996214790",
				"LSM" : {
					"bloom filters in the LSM tree" : 0,
					"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,
					"total size of bloom filters" : 0,
					"sleep for LSM checkpoint throttle" : 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 merge throttle" : 0
				},
				"block-manager" : {
					"file allocation unit size" : 4096,
					"blocks allocated" : 0,
					"checkpoint size" : 8192,
					"allocations requiring file extension" : 0,
					"blocks freed" : 0,
					"file magic number" : 120897,
					"file major version number" : 1,
					"minor version number" : 0,
					"file bytes available for reuse" : 0,
					"file size in bytes" : 16384
				},
				"btree" : {
					"column-store variable-size deleted values" : 0,
					"column-store fixed-size leaf pages" : 0,
					"column-store internal pages" : 0,
					"column-store variable-size leaf pages" : 0,
					"pages rewritten by compaction" : 0,
					"number of key/value pairs" : 0,
					"fixed-record size" : 0,
					"maximum tree depth" : 0,
					"maximum internal page key size" : 307,
					"maximum internal page size" : 4096,
					"maximum leaf page key size" : 1228,
					"maximum leaf page size" : 16384,
					"maximum leaf page value size" : 6144,
					"overflow pages" : 0,
					"row-store internal pages" : 0,
					"row-store leaf pages" : 0
				},
				"cache" : {
					"bytes read into cache" : 51,
					"bytes written from cache" : 0,
					"checkpoint blocked page eviction" : 0,
					"unmodified pages evicted" : 0,
					"modified pages evicted" : 0,
					"data source pages selected for eviction unable to be evicted" : 0,
					"hazard pointer blocked page eviction" : 0,
					"internal pages evicted" : 0,
					"in-memory page splits" : 0,
					"overflow values cached in memory" : 0,
					"pages read into cache" : 1,
					"overflow pages read into cache" : 0,
					"pages written from cache" : 0
				},
				"compression" : {
					"raw compression call failed, no additional data available" : 0,
					"raw compression call failed, additional data available" : 0,
					"raw compression call succeeded" : 0,
					"compressed pages read" : 0,
					"compressed pages written" : 0,
					"page written failed to compress" : 0,
					"page written was too small to compress" : 0
				},
				"cursor" : {
					"create calls" : 0,
					"insert calls" : 0,
					"bulk-loaded cursor-insert calls" : 0,
					"cursor-insert key and value bytes inserted" : 0,
					"next calls" : 0,
					"prev calls" : 0,
					"remove calls" : 0,
					"cursor-remove key bytes removed" : 0,
					"reset calls" : 0,
					"search calls" : 0,
					"search near calls" : 0,
					"update calls" : 0,
					"cursor-update value bytes updated" : 0
				},
				"reconciliation" : {
					"dictionary matches" : 0,
					"internal page multi-block writes" : 0,
					"leaf page multi-block writes" : 0,
					"maximum blocks required for a page" : 0,
					"internal-page overflow keys" : 0,
					"leaf-page overflow keys" : 0,
					"overflow values written" : 0,
					"pages deleted" : 0,
					"page checksum matches" : 0,
					"page reconciliation calls" : 0,
					"page reconciliation calls for eviction" : 0,
					"leaf page key bytes discarded using prefix compression" : 0,
					"internal page key bytes discarded using suffix compression" : 0
				},
				"session" : {
					"object compaction" : 0,
					"open cursor count" : 0
				},
				"transaction" : {
					"update conflicts" : 0
				}
			}
		},
		"test.foo.$a_1" : {
			"wiredTiger" : {
				"uri" : "statistics:table:index-2--1706195830996214790",
				"LSM" : {
					"bloom filters in the LSM tree" : 0,
					"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,
					"total size of bloom filters" : 0,
					"sleep for LSM checkpoint throttle" : 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 merge throttle" : 0
				},
				"block-manager" : {
					"file allocation unit size" : 4096,
					"blocks allocated" : 0,
					"checkpoint size" : 8192,
					"allocations requiring file extension" : 0,
					"blocks freed" : 0,
					"file magic number" : 120897,
					"file major version number" : 1,
					"minor version number" : 0,
					"file bytes available for reuse" : 0,
					"file size in bytes" : 16384
				},
				"btree" : {
					"column-store variable-size deleted values" : 0,
					"column-store fixed-size leaf pages" : 0,
					"column-store internal pages" : 0,
					"column-store variable-size leaf pages" : 0,
					"pages rewritten by compaction" : 0,
					"number of key/value pairs" : 0,
					"fixed-record size" : 0,
					"maximum tree depth" : 0,
					"maximum internal page key size" : 307,
					"maximum internal page size" : 4096,
					"maximum leaf page key size" : 1228,
					"maximum leaf page size" : 16384,
					"maximum leaf page value size" : 6144,
					"overflow pages" : 0,
					"row-store internal pages" : 0,
					"row-store leaf pages" : 0
				},
				"cache" : {
					"bytes read into cache" : 51,
					"bytes written from cache" : 0,
					"checkpoint blocked page eviction" : 0,
					"unmodified pages evicted" : 0,
					"modified pages evicted" : 0,
					"data source pages selected for eviction unable to be evicted" : 0,
					"hazard pointer blocked page eviction" : 0,
					"internal pages evicted" : 0,
					"in-memory page splits" : 0,
					"overflow values cached in memory" : 0,
					"pages read into cache" : 1,
					"overflow pages read into cache" : 0,
					"pages written from cache" : 0
				},
				"compression" : {
					"raw compression call failed, no additional data available" : 0,
					"raw compression call failed, additional data available" : 0,
					"raw compression call succeeded" : 0,
					"compressed pages read" : 0,
					"compressed pages written" : 0,
					"page written failed to compress" : 0,
					"page written was too small to compress" : 0
				},
				"cursor" : {
					"create calls" : 0,
					"insert calls" : 0,
					"bulk-loaded cursor-insert calls" : 0,
					"cursor-insert key and value bytes inserted" : 0,
					"next calls" : 0,
					"prev calls" : 0,
					"remove calls" : 0,
					"cursor-remove key bytes removed" : 0,
					"reset calls" : 0,
					"search calls" : 0,
					"search near calls" : 0,
					"update calls" : 0,
					"cursor-update value bytes updated" : 0
				},
				"reconciliation" : {
					"dictionary matches" : 0,
					"internal page multi-block writes" : 0,
					"leaf page multi-block writes" : 0,
					"maximum blocks required for a page" : 0,
					"internal-page overflow keys" : 0,
					"leaf-page overflow keys" : 0,
					"overflow values written" : 0,
					"pages deleted" : 0,
					"page checksum matches" : 0,
					"page reconciliation calls" : 0,
					"page reconciliation calls for eviction" : 0,
					"leaf page key bytes discarded using prefix compression" : 0,
					"internal page key bytes discarded using suffix compression" : 0
				},
				"session" : {
					"object compaction" : 0,
					"open cursor count" : 0
				},
				"transaction" : {
					"update conflicts" : 0
				}
			}
		}
	},
	"totalIndexSize" : 32768,
	"indexSizes" : {
		"_id_" : 16384,
		"a_1" : 16384
	},
	"ok" : 1
}

Comment by Eric Milkie [ 19/Dec/14 ]

Example output from collection stats, on a collection with two indexes:

> db.foo.stats()
{
	"ns" : "test.foo",
	"count" : 1,
	"size" : 33,
	"avgObjSize" : 33,
	"storageSize" : 16384,
	"nindexes" : 2,
	"indexDetails" : {
		"test.foo.$_id_" : {
			"uri" : "statistics:table:index-1--1706195830996214790",
			"LSM" : {
				"bloom filters in the LSM tree" : 0,
				"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,
				"total size of bloom filters" : 0,
				"sleep for LSM checkpoint throttle" : 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 merge throttle" : 0
			},
			"block-manager" : {
				"file allocation unit size" : 4096,
				"blocks allocated" : 0,
				"checkpoint size" : 8192,
				"allocations requiring file extension" : 0,
				"blocks freed" : 0,
				"file magic number" : 120897,
				"file major version number" : 1,
				"minor version number" : 0,
				"file bytes available for reuse" : 0,
				"file size in bytes" : 16384
			},
			"btree" : {
				"column-store variable-size deleted values" : 0,
				"column-store fixed-size leaf pages" : 0,
				"column-store internal pages" : 0,
				"column-store variable-size leaf pages" : 0,
				"pages rewritten by compaction" : 0,
				"number of key/value pairs" : 0,
				"fixed-record size" : 0,
				"maximum tree depth" : 0,
				"maximum internal page key size" : 307,
				"maximum internal page size" : 4096,
				"maximum leaf page key size" : 1228,
				"maximum leaf page size" : 16384,
				"maximum leaf page value size" : 6144,
				"overflow pages" : 0,
				"row-store internal pages" : 0,
				"row-store leaf pages" : 0
			},
			"cache" : {
				"bytes read into cache" : 51,
				"bytes written from cache" : 0,
				"checkpoint blocked page eviction" : 0,
				"unmodified pages evicted" : 0,
				"modified pages evicted" : 0,
				"data source pages selected for eviction unable to be evicted" : 0,
				"hazard pointer blocked page eviction" : 0,
				"internal pages evicted" : 0,
				"in-memory page splits" : 0,
				"overflow values cached in memory" : 0,
				"pages read into cache" : 1,
				"overflow pages read into cache" : 0,
				"pages written from cache" : 0
			},
			"compression" : {
				"raw compression call failed, no additional data available" : 0,
				"raw compression call failed, additional data available" : 0,
				"raw compression call succeeded" : 0,
				"compressed pages read" : 0,
				"compressed pages written" : 0,
				"page written failed to compress" : 0,
				"page written was too small to compress" : 0
			},
			"cursor" : {
				"create calls" : 0,
				"insert calls" : 0,
				"bulk-loaded cursor-insert calls" : 0,
				"cursor-insert key and value bytes inserted" : 0,
				"next calls" : 0,
				"prev calls" : 0,
				"remove calls" : 0,
				"cursor-remove key bytes removed" : 0,
				"reset calls" : 0,
				"search calls" : 0,
				"search near calls" : 0,
				"update calls" : 0,
				"cursor-update value bytes updated" : 0
			},
			"reconciliation" : {
				"dictionary matches" : 0,
				"internal page multi-block writes" : 0,
				"leaf page multi-block writes" : 0,
				"maximum blocks required for a page" : 0,
				"internal-page overflow keys" : 0,
				"leaf-page overflow keys" : 0,
				"overflow values written" : 0,
				"pages deleted" : 0,
				"page checksum matches" : 0,
				"page reconciliation calls" : 0,
				"page reconciliation calls for eviction" : 0,
				"leaf page key bytes discarded using prefix compression" : 0,
				"internal page key bytes discarded using suffix compression" : 0
			},
			"session" : {
				"object compaction" : 0,
				"open cursor count" : 0
			},
			"transaction" : {
				"update conflicts" : 0
			}
		},
		"test.foo.$a_1" : {
			"uri" : "statistics:table:index-2--1706195830996214790",
			"LSM" : {
				"bloom filters in the LSM tree" : 0,
				"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,
				"total size of bloom filters" : 0,
				"sleep for LSM checkpoint throttle" : 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 merge throttle" : 0
			},
			"block-manager" : {
				"file allocation unit size" : 4096,
				"blocks allocated" : 0,
				"checkpoint size" : 8192,
				"allocations requiring file extension" : 0,
				"blocks freed" : 0,
				"file magic number" : 120897,
				"file major version number" : 1,
				"minor version number" : 0,
				"file bytes available for reuse" : 0,
				"file size in bytes" : 16384
			},
			"btree" : {
				"column-store variable-size deleted values" : 0,
				"column-store fixed-size leaf pages" : 0,
				"column-store internal pages" : 0,
				"column-store variable-size leaf pages" : 0,
				"pages rewritten by compaction" : 0,
				"number of key/value pairs" : 0,
				"fixed-record size" : 0,
				"maximum tree depth" : 0,
				"maximum internal page key size" : 307,
				"maximum internal page size" : 4096,
				"maximum leaf page key size" : 1228,
				"maximum leaf page size" : 16384,
				"maximum leaf page value size" : 6144,
				"overflow pages" : 0,
				"row-store internal pages" : 0,
				"row-store leaf pages" : 0
			},
			"cache" : {
				"bytes read into cache" : 51,
				"bytes written from cache" : 0,
				"checkpoint blocked page eviction" : 0,
				"unmodified pages evicted" : 0,
				"modified pages evicted" : 0,
				"data source pages selected for eviction unable to be evicted" : 0,
				"hazard pointer blocked page eviction" : 0,
				"internal pages evicted" : 0,
				"in-memory page splits" : 0,
				"overflow values cached in memory" : 0,
				"pages read into cache" : 1,
				"overflow pages read into cache" : 0,
				"pages written from cache" : 0
			},
			"compression" : {
				"raw compression call failed, no additional data available" : 0,
				"raw compression call failed, additional data available" : 0,
				"raw compression call succeeded" : 0,
				"compressed pages read" : 0,
				"compressed pages written" : 0,
				"page written failed to compress" : 0,
				"page written was too small to compress" : 0
			},
			"cursor" : {
				"create calls" : 0,
				"insert calls" : 0,
				"bulk-loaded cursor-insert calls" : 0,
				"cursor-insert key and value bytes inserted" : 0,
				"next calls" : 0,
				"prev calls" : 0,
				"remove calls" : 0,
				"cursor-remove key bytes removed" : 0,
				"reset calls" : 0,
				"search calls" : 0,
				"search near calls" : 0,
				"update calls" : 0,
				"cursor-update value bytes updated" : 0
			},
			"reconciliation" : {
				"dictionary matches" : 0,
				"internal page multi-block writes" : 0,
				"leaf page multi-block writes" : 0,
				"maximum blocks required for a page" : 0,
				"internal-page overflow keys" : 0,
				"leaf-page overflow keys" : 0,
				"overflow values written" : 0,
				"pages deleted" : 0,
				"page checksum matches" : 0,
				"page reconciliation calls" : 0,
				"page reconciliation calls for eviction" : 0,
				"leaf page key bytes discarded using prefix compression" : 0,
				"internal page key bytes discarded using suffix compression" : 0
			},
			"session" : {
				"object compaction" : 0,
				"open cursor count" : 0
			},
			"transaction" : {
				"update conflicts" : 0
			}
		}
	},
	"totalIndexSize" : 32768,
	"indexSizes" : {
		"_id_" : 16384,
		"a_1" : 16384
	},
	"capped" : false,
	"collectionDetails" : {
		"uri" : "statistics:table:collection-0--1706195830996214790",
		"LSM" : {
			"bloom filters in the LSM tree" : 0,
			"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,
			"total size of bloom filters" : 0,
			"sleep for LSM checkpoint throttle" : 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 merge throttle" : 0
		},
		"block-manager" : {
			"file allocation unit size" : 4096,
			"blocks allocated" : 0,
			"checkpoint size" : 8192,
			"allocations requiring file extension" : 0,
			"blocks freed" : 0,
			"file magic number" : 120897,
			"file major version number" : 1,
			"minor version number" : 0,
			"file bytes available for reuse" : 0,
			"file size in bytes" : 16384
		},
		"btree" : {
			"column-store variable-size deleted values" : 0,
			"column-store fixed-size leaf pages" : 0,
			"column-store internal pages" : 0,
			"column-store variable-size leaf pages" : 0,
			"pages rewritten by compaction" : 0,
			"number of key/value pairs" : 0,
			"fixed-record size" : 0,
			"maximum tree depth" : 3,
			"maximum internal page key size" : 307,
			"maximum internal page size" : 4096,
			"maximum leaf page key size" : 2457,
			"maximum leaf page size" : 32768,
			"maximum leaf page value size" : 1048576,
			"overflow pages" : 0,
			"row-store internal pages" : 0,
			"row-store leaf pages" : 0
		},
		"cache" : {
			"bytes read into cache" : 127,
			"bytes written from cache" : 0,
			"checkpoint blocked page eviction" : 0,
			"unmodified pages evicted" : 0,
			"modified pages evicted" : 0,
			"data source pages selected for eviction unable to be evicted" : 0,
			"hazard pointer blocked page eviction" : 0,
			"internal pages evicted" : 0,
			"in-memory page splits" : 0,
			"overflow values cached in memory" : 0,
			"pages read into cache" : 2,
			"overflow pages read into cache" : 0,
			"pages written from cache" : 0
		},
		"compression" : {
			"raw compression call failed, no additional data available" : 0,
			"raw compression call failed, additional data available" : 0,
			"raw compression call succeeded" : 0,
			"compressed pages read" : 0,
			"compressed pages written" : 0,
			"page written failed to compress" : 0,
			"page written was too small to compress" : 0
		},
		"cursor" : {
			"create calls" : 2,
			"insert calls" : 0,
			"bulk-loaded cursor-insert calls" : 0,
			"cursor-insert key and value bytes inserted" : 0,
			"next calls" : 0,
			"prev calls" : 2,
			"remove calls" : 0,
			"cursor-remove key bytes removed" : 0,
			"reset calls" : 2,
			"search calls" : 1,
			"search near calls" : 0,
			"update calls" : 0,
			"cursor-update value bytes updated" : 0
		},
		"reconciliation" : {
			"dictionary matches" : 0,
			"internal page multi-block writes" : 0,
			"leaf page multi-block writes" : 0,
			"maximum blocks required for a page" : 0,
			"internal-page overflow keys" : 0,
			"leaf-page overflow keys" : 0,
			"overflow values written" : 0,
			"pages deleted" : 0,
			"page checksum matches" : 0,
			"page reconciliation calls" : 0,
			"page reconciliation calls for eviction" : 0,
			"leaf page key bytes discarded using prefix compression" : 0,
			"internal page key bytes discarded using suffix compression" : 0
		},
		"session" : {
			"object compaction" : 0,
			"open cursor count" : 4
		},
		"transaction" : {
			"update conflicts" : 0
		}
	},
	"ok" : 1
}

Generated at Thu Feb 08 03:40:26 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.