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