# • 查询分析 ## 查询的解释方式 查询的解释方式 ```sql "hello world" @title "example program"~5 @body python -(php|perl) @* code ``` 此搜索的完整含义是： * 在文档的任何字段中相邻地查找单词 'hello' 和 'world'； * 此外，文档还必须包含在 title 字段中的单词 'example' 和 'program'，二者之间最多有 4 个单词；（例如，"example PHP program" 会匹配，而 "example script to introduce outside data into the correct context for your program" 不会匹配，因为这两个词之间有 5 个或更多单词） * 同时，文档的 body 字段中必须包含单词 'python'，并排除 'php' 或 'perl'； * 最后，文档的任何字段中都必须包含单词 'code'。 OR 操作符的优先级高于 AND，所以 "looking for cat | dog | mouse" 的意思是 "looking for (cat | dog | mouse)"，而不是 "(looking for cat) | dog | mouse"。 为了理解查询的执行方式，Manticore Search 提供了查询性能分析工具，以查看由查询表达式生成的查询树。 ## 在 SQL 中分析查询树 要启用 SQL 语句的全文查询性能分析，必须在执行所需查询之前激活它： ```sql SET profiling =1; SELECT * FROM test WHERE MATCH('@title abc* @body hey'); ``` 执行查询后，可以使用 `SHOW PLAN` 命令查看查询树： ```sql SHOW PLAN; ``` 此命令将返回执行的查询结构。请记住，SET profiling、查询和 SHOW 必须在同一会话中执行。 ## 在 HTTP JSON 中分析查询 使用 HTTP JSON 协议时，只需启用 `"profile":true` 即可在响应中获取全文查询树结构。 ```json { "index":"test", "profile":true, "query": { "match_phrase": { "_all" : "had grown quite" } } } ``` 响应将包含一个 `profile` 对象，其中包含一个 `query` 成员。 `query` 属性持有转换后的全文查询树。每个节点由以下部分组成： * `type`: 节点类型，可以是 AND、OR、PHRASE、KEYWORD 等。 * `description`: 表示此节点的查询子树的字符串（以 `SHOW PLAN` 格式显示）。 * `children`: 子节点（如果有的话）。 * `max_field_pos`: 字段内的最大位置。 关键词节点将额外包含以下内容： * `word`: 转换后的关键词。 * `querypos`: 此关键词在查询中的位置。 * `excluded`: 被查询排除的关键词。 * `expanded`: 由前缀扩展添加的关键词。 * `field_start`: 关键词必须出现在字段的开头。 * `field_end`: 关键词必须出现在字段的末尾。 * `boost`: 关键词的 IDF 将乘以此值以影响包含 IDF 的排名计算。 **SQL:** ```sql SET profiling=1; SELECT * FROM test WHERE MATCH('@title abc* @body hey'); SHOW PLAN \G ``` ```sql *************************** 1\. row *************************** Variable: transformed_tree Value: AND( OR(fields=(title), KEYWORD(abcx, querypos=1, expanded), KEYWORD(abcm, querypos=1, expanded)), AND(fields=(body), KEYWORD(hey, querypos=2))) 1 row in set (0.00 sec) ``` ```JSON POST /search { "index": "forum", "query": {"query_string": "i me"}, "_source": { "excludes":["*"] }, "limit": 1, "profile":true } ``` ```JSON { "took":1503, "timed_out":false, "hits": { "total":406301, "hits": [ { "_id": 406443, "_score":3493, "_source":{} } ] }, "profile": { "query": { "type":"AND", "description":"AND( AND(KEYWORD(i, querypos=1)), AND(KEYWORD(me, querypos=2)))", "children": [ { "type":"AND", "description":"AND(KEYWORD(i, querypos=1))", "children": [ { "type":"KEYWORD", "word":"i", "querypos":1 } ] }, { "type":"AND", "description":"AND(KEYWORD(me, querypos=2))", "children": [ { "type":"KEYWORD", "word":"me", "querypos":2 } ] } ] } } } ``` ```php $result = $index->search('i me')->setSource(['excludes'=>['*']])->setLimit(1)->profile()->get(); print_r($result->getProfile()); ``` ```php Array ( [query] => Array ( [type] => AND [description] => AND( AND(KEYWORD(i, querypos=1)), AND(KEYWORD(me, querypos=2))) [children] => Array ( [0] => Array ( [type] => AND [description] => AND(KEYWORD(i, querypos=1)) [children] => Array ( [0] => Array ( [type] => KEYWORD [word] => i [querypos] => 1 ) ) ) [1] => Array ( [type] => AND [description] => AND(KEYWORD(me, querypos=2)) [children] => Array ( [0] => Array ( [type] => KEYWORD [word] => me [querypos] => 2 ) ) ) ) ) ) ``` Python ```python searchApi.search({"index":"forum","query":{"query_string":"i me"},"_source":{"excludes":["*"]},"limit":1,"profile":True}) ``` ```python {'hits': {'hits': [{u'_id': u'100', u'_score': 2500, u'_source': {}}], 'total': 1}, 'profile': {u'query': {u'children': [{u'children': [{u'querypos': 1, u'type': u'KEYWORD', u'word': u'i'}], u'description': u'AND(KEYWORD(i, querypos=1))', u'type': u'AND'}, {u'children': [{u'querypos': 2, u'type': u'KEYWORD', u'word': u'me'}], u'description': u'AND(KEYWORD(me, querypos=2))', u'type': u'AND'}], u'description': u'AND( AND(KEYWORD(i, querypos=1)), AND(KEYWORD(me, querypos=2)))', u'type': u'AND'}}, 'timed_out': False, 'took': 0} ``` javascript ```javascript res = await searchApi.search({"index":"forum","query":{"query_string":"i me"},"_source":{"excludes":["*"]},"limit":1,"profile":true}); ``` ```javascript {"hits": {"hits": [{"_id": 100, "_score": 2500, "_source": {}}], "total": 1}, "profile": {"query": {"children": [{"children": [{"querypos": 1, "type": "KEYWORD", "word": "i"}], "description": "AND(KEYWORD(i, querypos=1))", "type": "AND"}, {"children": [{"querypos": 2, "type": "KEYWORD", "word": "me"}], "description": "AND(KEYWORD(me, querypos=2))", "type": "AND"}], "description": "AND( AND(KEYWORD(i, querypos=1)), AND(KEYWORD(me, querypos=2)))", "type": "AND"}}, "timed_out": False, "took": 0} ``` java ```java query = new HashMap(); query.put("query_string","i me"); searchRequest = new SearchRequest(); searchRequest.setIndex("forum"); searchRequest.setQuery(query); searchRequest.setProfile(true); searchRequest.setLimit(1); searchRequest.setSort(new ArrayList(){{ add("*"); }}); searchResponse = searchApi.search(searchRequest); ``` ```java class SearchResponse { took: 18 timedOut: false hits: class SearchResponseHits { total: 1 hits: [{_id=100, _score=2500, _source={}}] aggregations: null } profile: {query={type=AND, description=AND( AND(KEYWORD(i, querypos=1)), AND(KEYWORD(me, querypos=2))), children=[{type=AND, description=AND(KEYWORD(i, querypos=1)), children=[{type=KEYWORD, word=i, querypos=1}]}, {type=AND, description=AND(KEYWORD(me, querypos=2)), children=[{type=KEYWORD, word=me, querypos=2}]}]}} } ``` C# ```clike object query = new { query_string="i me" }; var searchRequest = new SearchRequest("forum", query); searchRequest.Profile = true; searchRequest.Limit = 1; searchRequest.Sort = new List { "*" }; var searchResponse = searchApi.Search(searchRequest); ``` ```clike class SearchResponse { took: 18 timedOut: false hits: class SearchResponseHits { total: 1 hits: [{_id=100, _score=2500, _source={}}] aggregations: null } profile: {query={type=AND, description=AND( AND(KEYWORD(i, querypos=1)), AND(KEYWORD(me, querypos=2))), children=[{type=AND, description=AND(KEYWORD(i, querypos=1)), children=[{type=KEYWORD, word=i, querypos=1}]}, {type=AND, description=AND(KEYWORD(me, querypos=2)), children=[{type=KEYWORD, word=me, querypos=2}]}]}} } ``` TypeScript ```typescript res = await searchApi.search({ index: 'test', query: { query_string: 'Text' }, _source: { excludes: ['*'] }, limit: 1, profile: true }); ``` ```typescript { "hits": { "hits": [{ "_id": 1, "_score": 1480, "_source": {} }], "total": 1 }, "profile": { "query": { "children": [{ "children": [{ "querypos": 1, "type": "KEYWORD", "word": "i" }], "description": "AND(KEYWORD(i, querypos=1))", "type": "AND" }, { "children": [{ "querypos": 2, "type": "KEYWORD", "word": "me" }], "description": "AND(KEYWORD(me, querypos=2))", "type": "AND" }], "description": "AND( AND(KEYWORD(i, querypos=1)), AND(KEYWORD(me, querypos=2)))", "type": "AND" } }, "timed_out": False, "took": 0 } ``` Go ```go searchRequest := manticoresearch.NewSearchRequest("test") query := map[string]interface{} {"query_string": "Text"} source := map[string]interface{} { "excludes": []string {"*"} } searchRequest.SetQuery(query) searchRequest.SetSource(source) searchReq.SetLimit(1) searchReq.SetProfile(true) res, _, _ := apiClient.SearchAPI.Search(context.Background()).SearchRequest(*searchRequest).Execute() ``` ```Go { "hits": { "hits": [{ "_id": 1, "_score": 1480, "_source": {} }], "total": 1 }, "profile": { "query": { "children": [{ "children": [{ "querypos": 1, "type": "KEYWORD", "word": "i" }], "description": "AND(KEYWORD(i, querypos=1))", "type": "AND" }, { "children": [{ "querypos": 2, "type": "KEYWORD", "word": "me" }], "description": "AND(KEYWORD(me, querypos=2))", "type": "AND" }], "description": "AND( AND(KEYWORD(i, querypos=1)), AND(KEYWORD(me, querypos=2)))", "type": "AND" } }, "timed_out": False, "took": 0 } ``` 在某些情况下，由于扩展和其他转换，评估后的查询树可能与原始查询有显著差异。 **SQL:** ```sql SET profiling=1; SELECT id FROM forum WHERE MATCH('@title way* @content hey') LIMIT 1; SHOW PLAN; ``` ```sql Query OK, 0 rows affected (0.00 sec) +--------+ | id | +--------+ | 711651 | +--------+ 1 row in set (0.04 sec) +------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Variable | Value | +------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | transformed_tree | AND( OR( OR( AND(fields=(title), KEYWORD(wayne, querypos=1, expanded)), OR( AND(fields=(title), KEYWORD(ways, querypos=1, expanded)), AND(fields=(title), KEYWORD(wayyy, querypos=1, expanded)))), AND(fields=(title), KEYWORD(way, querypos=1, expanded)), OR(fields=(title), KEYWORD(way*, querypos=1, expanded))), AND(fields=(content), KEYWORD(hey, querypos=2))) | +------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) ``` **JSON:** ```JSON POST /search { "index": "forum", "query": {"query_string": "@title way* @content hey"}, "_source": { "excludes":["*"] }, "limit": 1, "profile":true } ``` ```JSON { "took":33, "timed_out":false, "hits": { "total":105, "hits": [ { "_id": 711651, "_score":2539, "_source":{} } ] }, "profile": { "query": { "type":"AND", "description":"AND( OR( OR( AND(fields=(title), KEYWORD(wayne, querypos=1, expanded)), OR( AND(fields=(title), KEYWORD(ways, querypos=1, expanded)), AND(fields=(title), KEYWORD(wayyy, querypos=1, expanded)))), AND(fields=(title), KEYWORD(way, querypos=1, expanded)), OR(fields=(title), KEYWORD(way*, querypos=1, expanded))), AND(fields=(content), KEYWORD(hey, querypos=2)))", "children": [ { "type":"OR", "description":"OR( OR( AND(fields=(title), KEYWORD(wayne, querypos=1, expanded)), OR( AND(fields=(title), KEYWORD(ways, querypos=1, expanded)), AND(fields=(title), KEYWORD(wayyy, querypos=1, expanded)))), AND(fields=(title), KEYWORD(way, querypos=1, expanded)), OR(fields=(title), KEYWORD(way*, querypos=1, expanded)))", "children": [ { "type":"OR", "description":"OR( AND(fields=(title), KEYWORD(wayne, querypos=1, expanded)), OR( AND(fields=(title), KEYWORD(ways, querypos=1, expanded)), AND(fields=(title), KEYWORD(wayyy, querypos=1, expanded))))", "children": [ { "type":"AND", "description":"AND(fields=(title), KEYWORD(wayne, querypos=1, expanded))", "fields":["title"], "max_field_pos":0, "children": [ { "type":"KEYWORD", "word":"wayne", "querypos":1, "expanded":true } ] }, { "type":"OR", "description":"OR( AND(fields=(title), KEYWORD(ways, querypos=1, expanded)), AND(fields=(title), KEYWORD(wayyy, querypos=1, expanded)))", "children": [ { "type":"AND", "description":"AND(fields=(title), KEYWORD(ways, querypos=1, expanded))", "fields":["title"], "max_field_pos":0, "children": [ { "type":"KEYWORD", "word":"ways", "querypos":1, "expanded":true } ] }, { "type":"AND", "description":"AND(fields=(title), KEYWORD(wayyy, querypos=1, expanded))", "fields":["title"], "max_field_pos":0, "children": [ { "type":"KEYWORD", "word":"wayyy", "querypos":1, "expanded":true } ] } ] } ] }, { "type":"AND", "description":"AND(fields=(title), KEYWORD(way, querypos=1, expanded))", "fields":["title"], "max_field_pos":0, "children": [ { "type":"KEYWORD", "word":"way", "querypos":1, "expanded":true } ] }, { "type":"OR", "description":"OR(fields=(title), KEYWORD(way*, querypos=1, expanded))", "fields":["title"], "max_field_pos":0, "children": [ { "type":"KEYWORD", "word":"way*", "querypos":1, "expanded":true } ] } ] }, { "type":"AND", "description":"AND(fields=(content), KEYWORD(hey, querypos=2))", "fields":["content"], "max_field_pos":0, "children": [ { "type":"KEYWORD", "word":"hey", "querypos":2 } ] } ] } } } ``` **PHP:** ```php $result = $index->search('@title way* @content hey')->setSource(['excludes'=>['*']])->setLimit(1)->profile()->get(); print_r($result->getProfile()); ``` ```php Array ( [query] => Array ( [type] => AND [description] => AND( OR( OR( AND(fields=(title), KEYWORD(wayne, querypos=1, expanded)), OR( AND(fields=(title), KEYWORD(ways, querypos=1, expanded)), AND(fields=(title), KEYWORD(wayyy, querypos=1, expanded)))), AND(fields=(title), KEYWORD(way, querypos=1, expanded)), OR(fields=(title), KEYWORD(way*, querypos=1, expanded))), AND(fields=(content), KEYWORD(hey, querypos=2))) [children] => Array ( [0] => Array ( [type] => OR [description] => OR( OR( AND(fields=(title), KEYWORD(wayne, querypos=1, expanded)), OR( AND(fields=(title), KEYWORD(ways, querypos=1, expanded)), AND(fields=(title), KEYWORD(wayyy, querypos=1, expanded)))), AND(fields=(title), KEYWORD(way, querypos=1, expanded)), OR(fields=(title), KEYWORD(way*, querypos=1, expanded))) [children] => Array ( [0] => Array ( [type] => OR [description] => OR( AND(fields=(title), KEYWORD(wayne, querypos=1, expanded)), OR( AND(fields=(title), KEYWORD(ways, querypos=1, expanded)), AND(fields=(title), KEYWORD(wayyy, querypos=1, expanded)))) [children] => Array ( [0] => Array ( [type] => AND [description] => AND(fields=(title), KEYWORD(wayne, querypos=1, expanded)) [fields] => Array ( [0] => title ) [max_field_pos] => 0 [children] => Array ( [0] => Array ( [type] => KEYWORD [word] => wayne [querypos] => 1 [expanded] => 1 ) ) ) [1] => Array ( [type] => OR [description] => OR( AND(fields=(title), KEYWORD(ways, querypos=1, expanded)), AND(fields=(title), KEYWORD(wayyy, querypos=1, expanded))) [children] => Array ( [0] => Array ( [type] => AND [description] => AND(fields=(title), KEYWORD(ways, querypos=1, expanded)) [fields] => Array ( [0] => title ) [max_field_pos] => 0 [children] => Array ( [0] => Array ( [type] => KEYWORD [word] => ways [querypos] => 1 [expanded] => 1 ) ) ) [1] => Array ( [type] => AND [description] => AND(fields=(title), KEYWORD(wayyy, querypos=1, expanded)) [fields] => Array ( [0] => title ) [max_field_pos] => 0 [children] => Array ( [0] => Array ( [type] => KEYWORD [word] => wayyy [querypos] => 1 [expanded] => 1 ) ) ) ) ) ) ) [1] => Array ( [type] => AND [description] => AND(fields=(title), KEYWORD(way, querypos=1, expanded)) [fields] => Array ( [0] => title ) [max_field_pos] => 0 [children] => Array ( [0] => Array ( [type] => KEYWORD [word] => way [querypos] => 1 [expanded] => 1 ) ) ) [2] => Array ( [type] => OR [description] => OR(fields=(title), KEYWORD(way*, querypos=1, expanded)) [fields] => Array ( [0] => title ) [max_field_pos] => 0 [children] => Array ( [0] => Array ( [type] => KEYWORD [word] => way* [querypos] => 1 [expanded] => 1 ) ) ) ) ) [1] => Array ( [type] => AND [description] => AND(fields=(content), KEYWORD(hey, querypos=2)) [fields] => Array ( [0] => content ) [max_field_pos] => 0 [children] => Array ( [0] => Array ( [type] => KEYWORD [word] => hey [querypos] => 2 ) ) ) ) ) ) ``` Python ```python searchApi.search({"index":"forum","query":{"query_string":"@title way* @content hey"},"_source":{"excludes":["*"]},"limit":1,"profile":true}) ``` ```python {'hits': {'hits': [{u'_id': u'2811025403043381551', u'_score': 2643, u'_source': {}}], 'total': 1}, 'profile': {u'query': {u'children': [{u'children': [{u'expanded': True, u'querypos': 1, u'type': u'KEYWORD', u'word': u'way*'}], u'description': u'AND(fields=(title), KEYWORD(way*, querypos=1, expanded))', u'fields': [u'title'], u'type': u'AND'}, {u'children': [{u'querypos': 2, u'type': u'KEYWORD', u'word': u'hey'}], u'description': u'AND(fields=(content), KEYWORD(hey, querypos=2))', u'fields': [u'content'], u'type': u'AND'}], u'description': u'AND( AND(fields=(title), KEYWORD(way*, querypos=1, expanded)), AND(fields=(content), KEYWORD(hey, querypos=2)))', u'type': u'AND'}}, 'timed_out': False, 'took': 0} ``` javascript ```javascript res = await searchApi.search({"index":"forum","query":{"query_string":"@title way* @content hey"},"_source":{"excludes":["*"]},"limit":1,"profile":true}); ``` ```javascript {"hits": {"hits": [{"_id": 2811025403043381551, "_score": 2643, "_source": {}}], "total": 1}, "profile": {"query": {"children": [{"children": [{"expanded": True, "querypos": 1, "type": "KEYWORD", "word": "way*"}], "description": "AND(fields=(title), KEYWORD(way*, querypos=1, expanded))", "fields": ["title"], "type": "AND"}, {"children": [{"querypos": 2, "type": "KEYWORD", "word": "hey"}], "description": "AND(fields=(content), KEYWORD(hey, querypos=2))", "fields": ["content"], "type": "AND"}], "description": "AND( AND(fields=(title), KEYWORD(way*, querypos=1, expanded)), AND(fields=(content), KEYWORD(hey, querypos=2)))", "type": "AND"}}, "timed_out": False, "took": 0} ``` java ```java query = new HashMap(); query.put("query_string","@title way* @content hey"); searchRequest = new SearchRequest(); searchRequest.setIndex("forum"); searchRequest.setQuery(query); searchRequest.setProfile(true); searchRequest.setLimit(1); searchRequest.setSort(new ArrayList(){{ add("*"); }}); searchResponse = searchApi.search(searchRequest); ``` ```java class SearchResponse { took: 18 timedOut: false hits: class SearchResponseHits { total: 1 hits: [{_id=2811025403043381551, _score=2643, _source={}}] aggregations: null } profile: {query={type=AND, description=AND( AND(fields=(title), KEYWORD(way*, querypos=1, expanded)), AND(fields=(content), KEYWORD(hey, querypos=2))), children=[{type=AND, description=AND(fields=(title), KEYWORD(way*, querypos=1, expanded)), fields=[title], children=[{type=KEYWORD, word=way*, querypos=1, expanded=true}]}, {type=AND, description=AND(fields=(content), KEYWORD(hey, querypos=2)), fields=[content], children=[{type=KEYWORD, word=hey, querypos=2}]}]}} } ``` C# ```clike object query = new { query_string="@title way* @content hey" }; var searchRequest = new SearchRequest("forum", query); searchRequest.Profile = true; searchRequest.Limit = 1; searchRequest.Sort = new List { "*" }; var searchResponse = searchApi.Search(searchRequest); ``` ```clike class SearchResponse { took: 18 timedOut: false hits: class SearchResponseHits { total: 1 hits: [{_id=2811025403043381551, _score=2643, _source={}}] aggregations: null } profile: {query={type=AND, description=AND( AND(fields=(title), KEYWORD(way*, querypos=1, expanded)), AND(fields=(content), KEYWORD(hey, querypos=2))), children=[{type=AND, description=AND(fields=(title), KEYWORD(way*, querypos=1, expanded)), fields=[title], children=[{type=KEYWORD, word=way*, querypos=1, expanded=true}]}, {type=AND, description=AND(fields=(content), KEYWORD(hey, querypos=2)), fields=[content], children=[{type=KEYWORD, word=hey, querypos=2}]}]}} } ``` TypeScript ```typescript res = await searchApi.search({ index: 'test', query: { query_string: '@content 1'}, _source: { excludes: ["*"] }, limit:1, profile":true }); ``` ```typescript { "hits": { "hits": [{ "_id": 1, "_score": 1480, "_source": {} }], "total": 1 }, "profile": { "query": { "children": [{ "children": [{ "expanded": True, "querypos": 1, "type": "KEYWORD", "word": "1*" }], "description": "AND(fields=(content), KEYWORD(1*, querypos=1, expanded))", "fields": ["content"], "type": "AND" }], "description": "AND(fields=(content), KEYWORD(1*, querypos=1))", "type": "AND" }}, "timed_out": False, "took": 0 } ``` Go ```go searchRequest := manticoresearch.NewSearchRequest("test") query := map[string]interface{} {"query_string": "1*"} source := map[string]interface{} { "excludes": []string {"*"} } searchRequest.SetQuery(query) searchRequest.SetSource(source) searchReq.SetLimit(1) searchReq.SetProfile(true) res, _, _ := apiClient.SearchAPI.Search(context.Background()).SearchRequest(*searchRequest).Execute() ``` ```go { "hits": { "hits": [{ "_id": 1, "_score": 1480, "_source": {} }], "total": 1 }, "profile": { "query": { "children": [{ "children": [{ "expanded": True, "querypos": 1, "type": "KEYWORD", "word": "1*" }], "description": "AND(fields=(content), KEYWORD(1*, querypos=1, expanded))", "fields": ["content"], "type": "AND" }], "description": "AND(fields=(content), KEYWORD(1*, querypos=1))", "type": "AND" }}, "timed_out": False, "took": 0 } ``` ## 不执行查询的情况下进行分析 SQL 语句 `EXPLAIN QUERY` 允许显示给定全文查询的执行树，而无需在表上实际执行搜索查询。 **SQL:** ```sql EXPLAIN QUERY index_base '@title running @body dog'\G ``` ```sql EXPLAIN QUERY index_base '@title running @body dog'\G *************************** 1\. row *************************** Variable: transformed_tree Value: AND( OR( AND(fields=(title), KEYWORD(run, querypos=1, morphed)), AND(fields=(title), KEYWORD(running, querypos=1, morphed)))) AND(fields=(body), KEYWORD(dog, querypos=2, morphed))) ``` `EXPLAIN QUERY ... option format=dot` 允许以层次结构的格式显示所提供的全文查询的执行树，适用于由现有工具（例如 ![EXPLAIN QUERY graphviz example](/files/fjAZUkUyP4TKtNG55eju) **SQL:** ```sql EXPLAIN QUERY tbl 'i me' option format=dot\G ``` ```sql EXPLAIN QUERY tbl 'i me' option format=dot\G *************************** 1. row *************************** Variable: transformed_tree Value: digraph "transformed_tree" { 0 [shape=record,style=filled,bgcolor="lightgrey" label="AND"] 0 -> 1 1 [shape=record,style=filled,bgcolor="lightgrey" label="AND"] 1 -> 2 2 [shape=record label="i | { querypos=1 }"] 0 -> 3 3 [shape=record,style=filled,bgcolor="lightgrey" label="AND"] 3 -> 4 4 [shape=record label="me | { querypos=2 }"] } ``` ## 查看匹配因子的值 在使用表达式排序器时，可以使用 [PACKEDFACTORS()](https://vergil-lai.gitbook.io/manticoresearch-manual-zh/5-sou-suo/quan-wen-pi-pei/pages/9ncsQnEnz7C5Xrn0NlPl#PACKEDFACTORS\(\)) 函数显示计算出的因子值。 该函数返回： * 文档级因子的值（例如 bm25、field\_mask、doc\_word\_count） * 生成命中的每个字段的列表（包括 lcs、hit\_count、word\_count、sum\_idf、min\_hit\_pos 等） * 查询中每个关键词的 tf 和 idf 值列表 这些值可以用来理解为什么某些文档在搜索中得分较高或较低，或者用来优化现有的排名表达式。 示例： ```sql SELECT id, PACKEDFACTORS() FROM test1 WHERE MATCH('test one') OPTION ranker=expr('1')\G ``` ```sql id: 1 packedfactors(): bm25=569, bm25a=0.617197, field_mask=2, doc_word_count=2, field1=(lcs=1, hit_count=2, word_count=2, tf_idf=0.152356, min_idf=-0.062982, max_idf=0.215338, sum_idf=0.152356, min_hit_pos=4, min_best_span_pos=4, exact_hit=0, max_window_hits=1, min_gaps=2, exact_order=1, lccs=1, wlccs=0.215338, atc=-0.003974), word0=(tf=1, idf=-0.062982), word1=(tf=1, idf=0.215338) 1 row in set (0.00 sec) ``` --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://vergil-lai.gitbook.io/manticoresearch-manual-zh/5-sou-suo/quan-wen-pi-pei/profiling.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.