Domino statistics for query analysis
If DQL is deployed on a Domino server, the show stat query command can be used to report statistics about DQL.
This feature is introduced in Domino 11.0.1. Example show stat query
output:
QUERY.AllQueries.Count = 265
QUERY.AllQueries.MAX.Msecs = 1889
QUERY.AllQueries.Msecs = 81889
QUERY.AllQueries.Terms = 586
QUERY.FT.AVG.DocsFound = 927
QUERY.FT.AVG.Msecs = 8
QUERY.FT.DocsFound = 204036
QUERY.FT.MAX.DocsFound = 14371
QUERY.FT.MAX.Msecs = 181
QUERY.FT.Msecs = 1861
QUERY.FT.TermCount = 220
QUERY.INVIEW.AVG.DocsFound = 1976
QUERY.INVIEW.AVG.Msecs = 48
QUERY.INVIEW.DocsFound = 100800
QUERY.INVIEW.MAX.DocsFound = 14700
QUERY.INVIEW.MAX.Msecs = 424
QUERY.INVIEW.Msecs = 2462
QUERY.INVIEW.TermCount = 51
QUERY.NSF.AVG.DocsFound = 558
QUERY.NSF.AVG.Msecs = 135
QUERY.NSF.AVG.ScannedDocs|Entries = 7576
QUERY.NSF.DocsFound = 139660
QUERY.NSF.MAX.DocsFound = 20741
QUERY.NSF.MAX.Msecs = 986
QUERY.NSF.MAX.ScannedDocs|Entries = 83479
QUERY.NSF.Msecs = 33687
QUERY.NSF.ScannedDocs|Entries = 1891238
QUERY.NSF.TermCount = 251
QUERY.VIEW.AVG.DocsFound = 1014
QUERY.VIEW.AVG.Msecs = 33
QUERY.VIEW.AVG.ScannedDocs|Entries = 143
QUERY.VIEW.DocsFound = 116663
QUERY.VIEW.MAX.DocsFound = 15740
QUERY.VIEW.MAX.Msecs = 1099
QUERY.VIEW.MAX.ScannedDocs|Entries = 5228
QUERY.VIEW.Msecs = 3799
QUERY.VIEW.ScannedDocs|Entries = 16551
QUERY.VIEW.TermCount = 115
38 statistics found