janusgraph查询性能分析

profile()

g.V().has(‘BsDoctor’,‘name’,‘test02’).has(‘password’,‘123123’).profile()

未建立索引

gremlin> g.V().has('BsDoctor','name','test02').has('password','123123').profile()
==>Traversal Metrics
Step                                                               Count  Traversers       Time (ms)    % Dur
=============================================================================================================
JanusGraphStep([],[~label.eq(BsDoctor), name.eq...                                           236.579   100.00
    \_condition=(~label = BsDoctor AND name = test02 AND password = 123123)
    \_orders=[]
    \_isFitted=false
    \_isOrdered=true
    \_query=[]
  optimization                                                                                 0.010
  optimization                                                                                 0.048
  scan                                                                                         0.000
    \_query=[]
    \_fullscan=true
    \_condition=VERTEX
                                            >TOTAL                     -           -         236.579        -

从运行结果可以看到 fullscan=true 证明走了全文查找

建立索引

gremlin> g.V().has('BsDoctor','name','test02').has('password','123123').profile()
==>Traversal Metrics
Step                                                               Count  Traversers       Time (ms)    % Dur
=============================================================================================================
JanusGraphStep([],[~label.eq(BsDoctor), name.eq...                     1           1           4.769   100.00
    \_condition=(~label = BsDoctor AND name = test02 AND password = 123123)
    \_orders=[]
    \_isFitted=false
    \_isOrdered=true
    \_query=multiKSQ[1]@2147483647
    \_index=byNameComposite
  optimization                                                                                 0.058
  optimization                                                                                 0.206
  backend-query                                                        1                       2.151
    \_query=byNameComposite:multiKSQ[1]@2147483647
                                            >TOTAL                     -           -           4.769        -

从运行结果可以看到 index=byNameComposite 证明走了索引，性能相差巨大。