FT.PROFILE

Syntax

  1. FT.PROFILE index SEARCH [LIMITED] QUERY query

Time complexity: O(N)

Important: New in Dragonfly v1.13. Currently, Dragonfly Search is in Beta.

Description

Apply the FT.SEARCH command to collect performance details.

Required arguments

index

is index name, created using the FT.CREATE command.

QUERY query

is query string, sent to the FT.SEARCH command to collect performance details.

Return

FT.PROFILE returns an array reply. The first element of the returned array has the following elements:

  • took: time in microseconds (μs) used to execute the query.
  • hits: number of documents returned by the query.
  • serialized: number of documents serialized by the query.

The rest of the array elements represent an execution tree on every Dragonfly shard with timings.

Examples

Collect performance information about an index

  1. dragonfly> HSET blog:post:1 title "blog post 1" published_at 1701210030 category "default" description "this is a blog"
  2. (integer) 4
  4. dragonfly> FT.CREATE idx ON HASH PREFIX 1 blog:post: SCHEMA title TEXT SORTABLE published_at NUMERIC SORTABLE category TAG SORTABLE description TEXT NOINDEX
  5. OK
  7. dragonfly> FT.PROFILE idx SEARCH QUERY "@category:{default}"
  8. 1) 1) "took"
  9.    2) (integer) 488
  10.    3) "hits"
  11.    4) (integer) 1
  12.    5) "serialized"
  13.    6) (integer) 1
  14. 2) 1) "took"
  15.    2) (integer) 13
  16.    3) "tree"
  17.    4) 1) t=9          n=0          Field{category}
  18.       2) 1) t=5          n=0          Tags{default}
  19. 3) 1) "took"
  20.    2) (integer) 35
  21.    3) "tree"
  22.    4) 1) t=30         n=0          Field{category}
  23.       2) 1) t=5          n=0          Tags{default}
  24. 4) 1) "took"
  25.    2) (integer) 24
  26.    3) "tree"
  27.    4) 1) t=19         n=0          Field{category}
  28.       2) 1) t=14         n=0          Tags{default}
  29. 5) 1) "took"
  30.    2) (integer) 54
  31.    3) "tree"
  32.    4) 1) t=11         n=1          Field{category}
  33.       2) 1) t=9          n=1          Tags{default}
  34. 6) 1) "took"
  35.    2) (integer) 9
  36.    3) "tree"
  37.    4) 1) t=6          n=0          Field{category}
  38.       2) 1) t=5          n=0          Tags{default}

See also

FT.SEARCH