xdmp.queryMeters

xdmp.queryMeters() as Object

Summary

Returns the current value of the resource meters for this query sequence as a JSON node.

Usage Notes

The resource meters returned include:

elapsedTime
The time elapsed since the start of the processing of this query, in the form of a duration.
requests
The number of requests.
listCacheHits
The number of successful list cache lookups. The list cache holds search termlists used to accelerate path expressions and text searches.
listCacheMisses
The number of unsuccessful list cache lookups. Each unsuccessful list cache lookup was followed by a disk access to load the search termlist into the cache.
inMemoryListHits
The number of successful list lookups in in-memory stands.
listSize
The aggregate size in bytes read from disk by unsuccessful list cache lookups. Each unsuccessful list cache lookup is followed by a disk access to load the search term list into the cache.
expandedTreeCacheHits
The number of successful expanded tree cache lookups. The expanded tree cache cache holds XML document data in the expanded representation used by the XQuery evaluator.
expandedTreeCacheMisses
The number of unsuccessful expanded tree cache lookups. Each unsuccessful expanded tree lookup was followed by a compressed tree cache lookup to load the expanded tree into the cache.
compressedTreeCacheHits
The number of successful compressed tree cache lookups. The compressed tree cache holds XML document data in the compressed representation stored on disk.
compressedTreeCacheMisses
The number of unsuccessful compressed tree cache lookups. Each unsuccessful compressed tree cache lookup was followed by a disk access to load the compressed tree into the cache.
inMemoryCompressedTreeHits
The number of successful compressed tree lookups in in-memory stands.
compressedTreeSize
The aggregate size in bytes read from disk by unsuccessful compressed tree cache lookups. Each unsuccessful compressed tree cache lookup is followed by a disk access to load the compressed tree into the cache.
valueCacheHits
The number of successful value cache lookups. The value cache is a transient cache that exists only for the duration of one query. It holds typed values, and is used to accelerate the frequent conversion of nodes to typed values.
valueCacheMisses
The number of unsuccessful value cache lookups. Each unsuccessful value cache lookup was followed by a conversion of an XML node to a typed value.
regexpCacheHits
The number of successful regular expression cache lookups. The regular expression cache is a transient cache that exists only for the duration of one query. It holds compiled regular expressions, and is used to accelerate the frequent use of regular expressions during the evaluation of a query.
regexpCacheMisses
The number of unsuccessful regular expression cache lookups. Each unsuccessful regular expression cache lookup was followed by a compilation of a regular expression from source text.
linkCacheHits
The number of successful link cache lookups. The link cache is a transient cache that exists only for the duration of one query. It holds pointers to expanded trees, and is used to accelerate the frequent dereferencing of link nodes.
linkCacheMisses
The number of unsuccessful link cache lookups. Each unsuccessful link cache lookup was followed by a search for the link target tree.
filterHits
The number of successful search filter matches.
filterMisses
The number of unsuccessful search filter matches.
fragmentsAdded
The number of XML fragments added to the database by an update.
fragmentsDeleted
The number of XML fragments deleted from the database by an update.
fsProgramCacheHits
The number of module cache hits from the entire program made from modules on the file system.
fsProgramCacheMisses
The number of module cache misses from the entire program made from modules on the file system.
dbProgramCacheHits
The number of module cache hits from the entire program made from modules in a database (may contain library modules from the special Modules directory).
dbProgramCacheMisses
The number of module cache misses from the entire program made from modules in a database (may contain library modules from the special Modules directory).
envProgramCacheHits
The number of module cache hits from the entire program made from ad hoc XSLT stylesheet nodes.
envProgramCacheMisses
The number of module cache misses from the entire program made from ad hoc XSLT stylesheet nodes.
fsMainModuleSequenceCacheHits
The number of main module cache hits from main modules on the file system.
fsMainModuleSequenceCacheMisses
The number of main module cache misses from main modules on the file system.
dbMainModuleSequenceCacheHits
The number of main module cache hits from main modules in a database.
dbMainModuleSequenceCacheMisses
The number of main module cache misses from main modules in a database.
fsLibraryModuleCacheHits
The number of library module cache hits from library modules on the file system.
fsLibraryModuleCacheMisses
The number of library module cache misses from library modules on the file system.
dbLibraryModuleCacheHits
The number of library module cache hits from library modules from the modules database.
dbLibraryModuleCacheMisses
The number of library module cache misses from library modules from the modules database.
readLocks
The number of read locks.
writeLocks
The number of write locks.
compileTime
The aggregate time in seconds spent compiling a module or a program.
runTime
The aggregate time in seconds spent evaluating/running a module or a program.
lockTime
The aggregate time in seconds forests spend waiting for transactional read and write locks. This time can exceed the run-time.
contemporaneousTimestampTime
The time in seconds spent by queries waiting for the contemporaneous timestamp for which any transaction is known to have committed. When the multi-version concurrency control is set contemporaneous, queries can block waiting for the contemporaneous transactions to fully commit.
indexingTime
The indexing time of documents in seconds before they are inserted into the database.
commitTime
The aggregate commit phase time in seconds.
temporaryFileReadBytes
The total number of bytes read from temporary files for example for external sort and join.
temporaryFileWriteBytes
The total number of bytes written to temporary files for example for external sort and join.

Some meters are broken down by fragment root and document URI:

fragments
A sequence of fragment elements, each containing:
root
The fragment root name.
expandedTreeCacheHits
A count of successful expanded tree cache lookups for this fragment root.
expandedTreeCacheMisses
A count of unsuccessful expanded tree cache lookups for this fragment root.
documents
A sequence of document elements, each containing:
uri
The document URI.
expandedTreeCacheHits
A count of successful expanded tree cache lookups for this document URI.
expandedTreeCacheMisses
A count of unsuccessful expanded tree cache lookups for this document URI.

There are also meters that measure the query activity per host. There is a qm.hosts member with one qm.host child per host that participates in the query. Each qm.host member contains meters showing the roundTripTime and roundTripCount for communications between the evaluator host and the host referenced in the xdmp.queryMeters output. The qm.hosts member is empty for a single-node cluster.

Certain operations are run concurrently with the timing operations, and if those operations are not actually used in the query, they might not be included in the timings. This occurs for operations like cts.estimate, xdmp.exists, and lexicon calls (for example, cts.elementValues). If you want to see the total timings that include calls that are not used, you can form some other expression with the results of the calls. For example, if you have an expression that calls cts.estimate , you can add 0 to the output, which causes it to be included in the timings (something like cts.estimate(query) + 0).

Example

xdmp.queryMeters()

// Returns results similar to the following:
// {
//   "elapsedTime": "PT0.007101S",
//   "requests": 0,
//   "listCacheHits": 0,
//   "listCacheMisses": 0,
//   "listSize": 0,
//   "inMemoryListHits": 0,
//   "tripleCacheHits": 0,
//   "tripleCacheMisses": 0,
//   "tripleValueCacheHits": 0,
//   "tripleValueCacheMisses": 0,
//   "expandedTreeCacheHits": 0,
//   "expandedTreeCacheMisses": 0,
//   "compressedTreeCacheHits": 0,
//   "compressedTreeCacheMisses": 0,
//   "compressedTreeSize": 0,
//   "inMemoryCompressedTreeHits": 0,
//   "valueCacheHits": 0,
//   "valueCacheMisses": 0,
//   "regexpCacheHits": 0,
//   "regexpCacheMisses": 0,
//   "linkCacheHits": 0,
//   "linkCacheMisses": 0,
//   "filterHits": 0,
//   "filterMisses": 0,
//   "fragmentsAdded": 0,
//   "fragmentsDeleted": 0,
//   "fsProgramCacheHits": 0,
//   "fsProgramCacheMisses": 1,
//   "dbProgramCacheHits": 0,
//   "dbProgramCacheMisses": 0,
//   "envProgramCacheHits": 0,
//   "envProgramCacheMisses": 0,
//   "fsMainModuleSequenceCacheHits": 0,
//   "fsMainModuleSequenceCacheMisses": 0,
//   "dbMainModuleSequenceCacheHits": 0,
//   "dbMainModuleSequenceCacheMisses": 0,
//   "fsLibraryModuleCacheHits": 0,
//   "fsLibraryModuleCacheMisses": 0,
//   "dbLibraryModuleCacheHits": 0,
//   "dbLibraryModuleCacheMisses": 0,
//   "readLocks": 0,
//   "writeLocks": 0,
//   "lockTime": 0,
//   "contemporaneousTimestampTime": 0,
//   "compileTime": 0,
//   "commitTime": 0,
//   "runTime": 0,
//   "indexingTime": 0,
//   "fragments": [ ],
//   "documents": [ ],
//   "hosts": [ ]
// }

Example

fn.count(fn.collection());
xdmp.queryMeters().elapsedTime;

=> PT0.003416S
Powered by MarkLogic Server | Terms of Use | Privacy Policy