FT.EXPLAINCLI
Syntax
FT.EXPLAINCLI index query [DIALECT dialect]
- Available in:
- Redis Stack / Search 1.0.0
- Time complexity:
- O(1)
Return the execution plan for a complex query but formatted for easier reading without using redis-cli --raw
Required arguments
index
is index name. You must first create the index using FT.CREATE.
query
is query string, as if sent to FT.SEARCH`.
Optional arguments
DIALECT {dialect_version}
is dialect version under which to execute the query. If not specified, the query executes under the default dialect version set during module initial loading or via FT.CONFIG SET command.
Note:
In the returned response, a + on a term is an indication of stemming.Return
FT.EXPLAINCLI returns an array reply with a string representing the execution plan.
Examples
Return the execution plan for a complex query
$ redis-cli
127.0.0.1:6379> FT.EXPLAINCLI rd "(foo bar)|(hello world) @date:[100 200]|@date:[500 +inf]"
1) INTERSECT {
2) UNION {
3) INTERSECT {
4) UNION {
5) foo
6) +foo(expanded)
7) }
8) UNION {
9) bar
10) +bar(expanded)
11) }
12) }
13) INTERSECT {
14) UNION {
15) hello
16) +hello(expanded)
17) }
18) UNION {
19) world
20) +world(expanded)
21) }
22) }
23) }
24) UNION {
25) NUMERIC {100.000000 <= @date <= 200.000000}
26) NUMERIC {500.000000 <= @date <= inf}
27) }
28) }
29)See also
FT.CREATE | FT.SEARCH | FT.CONFIG SET