Re: How to improve traversal query performance

Home Messages Hashtags Subgroups Calendar

#5342

Re: How to improve traversal query performance

Manabu Kotani <smallcany...@...>

#5342

Hi Marc,

Sorry, I forgot an attachment (Image of tree structure).

Relationships between vertices and edges are like below.

(Label:item, serial:A)<--[Label:assembled, work_date:2020-11-24]--(Label:item, serial:B)

(Label:item, serial:A)<--[Label:assembled, work_date:2020-11-25]--(Label:item, serial:C)

(Label:item, serial:B)<--[Label:assembled, work_date:2020-11-23]--(Label:item, serial:D)

(Label:item, serial:B)<--[Label:assembled, work_date:2020-11-22]--(Label:item, serial:E)

(Label:item, serial:C)<--[Label:assembled, work_date:2020-11-21]--(Label:item, serial:E)

(Label:item, serial:C)<--[Label:assembled, work_date:2020-11-20]--(Label:item, serial:F)

Best regards,

Manabu

2020年11月25日水曜日 19:55:54 UTC+9 HadoopMarc:

Show quoted text

Hi Manabu,

What edge are present between vertices A,B,C,D,E,F?

If there are only edges A-B, A-C, A-D, A-E, A-F, you do not need repeat().

Best wishes,    Marc

Op woensdag 25 november 2020 om 09:22:34 UTC+1 schreef Manabu Kotani:
Hi Marc,

Thank you for your quick reply.

Sorry for the lack of my explanation.
I have a graph like below. (There are 3 levels in this figure, but not necessarily 3 levels.)

When query by "A" for property "serial", then I would like to get results like these.
1. A, B, 2020-11-24
2. A, C, 2020-11-25
3. A, D, 2020-11-23
4. A, E, 2020-11-21
5. A, E, 2020-11-22
6. A, F, 2020-11-20

In this situation, how shoud I use until() step?

Sorry for my low comprehension, I've just started to learn Gremlin.

Best regards,
Manabu

2020年11月25日水曜日 15:46:35 UTC+9 HadoopMarc:
Hi Manabu,

repeat()/simplePath()/emit() can have valid uses, although normally you combine it with the times() or until() step to limit the number of repeats. The profile from your query suggests that the repeat step never takes effect, that is, each traversal takes only a single step from parent to child. The repeat step is not wrong in itself, but if it is not necessary you do not want it to be there if you do not know its impact on performance.

Best wishes,    Marc

Op dinsdag 24 november 2020 om 08:43:36 UTC+1 schreef Manabu Kotani:
Hi Marc,

Thank you for your reply.

I'm reading ref docs that you referred about sack()/barrier(). But, I've not able to understand yet.

One question.
What means this you advised? repeat()/simplePath()/emit() steps should not be used?

in the current traversal the repeat(), simplePath() and emit() steps have no effect if the children do not assemble children themselves. So you can leave these steps out for clarity and to be sure that they do not influence the janusgraph execution plan
Best regards,
Manabu

2020年11月21日土曜日 20:13:28 UTC+9 HadoopMarc:
Hi Manabu,

Without knowing if the considerations below will really help, you may try the following:
in the current traversal the repeat(), simplePath() and emit() steps have no effect if the children do not assemble children themselves. So you can leave these steps out for clarity and to be sure that they do not influence the janusgraph execution plan
you may want to study the profile(), sack() and barrier() steps in the TinkerPop ref docs:
https://tinkerpop.apache.org/docs/3.4.8/reference/#profile-step
https://tinkerpop.apache.org/docs/3.4.8/reference/#sack-step
https://tinkerpop.apache.org/docs/3.4.8/reference/#barrier-step
https://kelvinlawrence.net/book/Gremlin-Graph-Guide.html#lambdasack
https://groups.google.com/g/gremlin-users/c/yGs1rv8YXRw/m/Y_iKg15KAwAJ
https://groups.google.com/g/gremlin-users/c/Z7WqhtHvhRc/m/SAbRRMvNBQAJ
Because of your use of the as()/select() mechanism the traversers cannot be bulked and the number of traversers (20669) equals the path count (20669). I am not sure how bulking would affect the JanusGraph execution plan, but with some luck the number of backend calls decreases from 20669 to 1392 (the number of child vertices).
You can influence the bulking by using the sack() step instead of the as()/select() mechanism. You presently get 20669 (a,b,c) items out of your query. You have to rewrite that to get 1392 child vertices out of your query that each have a sack with (a, b) items. Not well covered in the TinkerPop docs is that the sack can be initialized with a Collection object and that the split and merge operators can take closures to act on such a Collection. E.g. you could structure the Sack as an ArrayList that gets (b, a) tuples or "b|a" strings appended during the traversal of a path.
Finally, note that the barrier() step and LazyBarrierStrategy also influence the bulking process.
Best wishes,    Marc

Op donderdag 19 november 2020 om 02:37:48 UTC+1 schreef Manabu Kotani:
Hi All,

I'm testing traversal query performance.
My query (please see below) takes about 1.8sec.

Is there solution for improve performance (faster than 1.8sec)?
I hope that takes less than 500ms.

1.Environment:
JanusGraph (0.5.2) + Cassandra (3.11.0) on Docker Desktop (Windows)

2.Schema:
------------------------------------------------------------------------------------------------
Vertex Label Name | Partitioned | Static |
---------------------------------------------------------------------------------------------------
item | false | false |
---------------------------------------------------------------------------------------------------
Edge Label Name | Directed | Unidirected | Multiplicity |
---------------------------------------------------------------------------------------------------
assembled | true | false | MULTI |
---------------------------------------------------------------------------------------------------
Property Key Name | Cardinality | Data Type |
---------------------------------------------------------------------------------------------------
serial | SINGLE | class java.lang.String |
work_date | SINGLE | class java.util.Date |
---------------------------------------------------------------------------------------------------
Vertex Index Name | Type | Unique | Backing | Key: Status |
---------------------------------------------------------------------------------------------------
bySerial | Composite | false | internalindex | serial: ENABLED |
---------------------------------------------------------------------------------------------------
Edge Index (VCI) Name | Type | Unique | Backing | Key: Status |
---------------------------------------------------------------------------------------------------
byWorkDate | Composite | false | internalindex | work_date: ENABLED |
---------------------------------------------------------------------------------------------------
Relation Index | Type | Direction | Sort Key | Order | Status |
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------

3.Query:
g.V().has('serial',within('XXXXXX','YYYYYY',....<- 100 search keys).as('a')
.repeat(inE('assembled').as('b').outV().as('c').simplePath())
.emit()
.select('a').values('serial').as('parent')
.select('b').values('work_date').as('work_date')
.select('c').values('serial').as('child')
.select('parent','child','work_date')
.order().by('parent').by('child').by('work_date')
-----------------------------------------------------------------------------------------------------------

4.Query Profile:
==>Traversal Metrics
Step Count Traversers Time (ms) % Dur
=============================================================================================================
JanusGraphStep([],[serial.within([XXXXXX... 100 100 159.582 8.89
\_condition=((serial = XXXXXX OR serial = YYYYYY OR .... <- 100 search keys))
\_orders=[]
\_isFitted=true
\_isOrdered=true
\_query=multiKSQ[100]@2000
\_index=bySerial
optimization 0.018
optimization 6.744
backend-query 100 1074.225
\_query=bySerial:multiKSQ[100]@2000
\_limit=2000
RepeatStep([JanusGraphVertexStep(IN,[assembled]... 20669 20669 857.001 47.74
JanusGraphVertexStep(IN,[assembled],edge)@[b] 20669 20669 633.529
\_condition=type[assembled]
\_orders=[]
\_isFitted=true
\_isOrdered=true
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
\_multi=true
\_vertices=204
optimization 0.477
backend-query 228 2.076
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.150
backend-query 0 43.366
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.093
backend-query 229 1.978
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.107
backend-query 0 32.738
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.111
backend-query 229 1.577
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.107
backend-query 0 17.827
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.085
backend-query 229 1.517
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.108
backend-query 0 5.729
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.071
backend-query 228 1.993
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.083
backend-query 0 3.335
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.150
backend-query 229 1.890
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.137
backend-query 0 32.593
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.110
backend-query 229 2.253
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.069
backend-query 230 1.624
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.070
backend-query 0 12.797
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.116
backend-query 229 1.579
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.090
backend-query 0 5.764
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.107
backend-query 229 1.651
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.134
backend-query 0 22.327
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.074
backend-query 229 1.756
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.075
backend-query 0 11.145
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.069
backend-query 229 1.947
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.086
backend-query 0 3.727
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.100
backend-query 116 1.492
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.085
backend-query 0 27.159
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.132
backend-query 229 1.524
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.100
backend-query 0 7.173
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.075
backend-query 230 1.880
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.114
backend-query 0 3.696
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.085
backend-query 228 1.645
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.143
backend-query 0 2.924
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.105
backend-query 229 2.010
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.316
backend-query 0 3.806
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.095
backend-query 230 1.854
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.185
backend-query 229 1.936
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.099
backend-query 0 2.135
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.070
backend-query 231 1.479
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.067
backend-query 0 5.907
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.069
backend-query 1 1.129
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.109
backend-query 0 1.069
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.082
backend-query 231 1.245
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.072
backend-query 0 1.175
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.064
backend-query 229 1.308
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.078
backend-query 0 7.058
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.145
backend-query 231 1.655
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.115
backend-query 0 3.946
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.067
backend-query 117 1.231
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.063
backend-query 0 11.856
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.065
backend-query 230 1.606
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.072
backend-query 0 6.973
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.070
backend-query 229 1.445
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.088
backend-query 230 1.836
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.098
backend-query 0 2.552
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.088
backend-query 116 1.450
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.060
backend-query 0 4.072
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.062
backend-query 229 1.421
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.058
backend-query 0 2.342
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.058
backend-query 229 0.999
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.070
backend-query 0 1.847
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.063
backend-query 229 1.171
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.064
backend-query 0 0.999
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.051
backend-query 228 0.991
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.070
backend-query 0 2.107
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.215
backend-query 116 1.678
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.069
backend-query 229 1.578
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.081
backend-query 0 3.649
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.096
backend-query 229 1.619
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.066
backend-query 228 1.549
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.070
backend-query 116 1.610
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.154
backend-query 228 1.746
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.092
backend-query 0 2.958
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.093
backend-query 232 1.698
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.143
backend-query 229 1.719
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.081
backend-query 0 2.809
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.065
backend-query 229 1.410
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.082
backend-query 229 1.458
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.109
backend-query 228 1.651
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.066
backend-query 228 1.417
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.111
backend-query 117 1.536
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.188
backend-query 0 1.660
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.132
backend-query 229 2.361
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.110
backend-query 0 2.384
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.140
backend-query 229 1.680
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.067
backend-query 230 1.342
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.070
backend-query 0 3.129
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.118
backend-query 231 1.397
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.169
backend-query 0 5.665
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.114
backend-query 116 1.780
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.128
backend-query 0 2.316
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.108
backend-query 229 1.521
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.083
backend-query 231 1.508
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.074
backend-query 0 2.327
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.092
backend-query 116 1.509
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.285
backend-query 0 2.007
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.079
backend-query 116 1.245
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.134
backend-query 230 1.521
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.092
backend-query 1 1.278
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.064
backend-query 0 1.104
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.076
backend-query 231 1.287
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.079
backend-query 229 1.768
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.098
backend-query 0 2.570
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.110
backend-query 116 1.489
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.061
backend-query 0 1.756
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.055
backend-query 229 1.133
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.060
backend-query 116 1.241
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.056
backend-query 0 2.435
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.056
backend-query 228 1.099
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.061
backend-query 0 1.017
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.080
backend-query 229 1.217
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.065
backend-query 230 1.448
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.065
backend-query 229 1.546
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.079
backend-query 230 1.955
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.165
backend-query 0 3.284
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.102
backend-query 229 1.936
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.081
backend-query 0 4.640
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.072
backend-query 229 1.384
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.062
backend-query 0 2.224
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.088
backend-query 116 1.419
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.069
backend-query 0 2.289
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.070
backend-query 231 1.474
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.071
backend-query 229 1.646
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.072
backend-query 0 1.408
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.068
backend-query 230 1.974
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.090
backend-query 229 1.923
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.151
backend-query 230 2.211
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.074
backend-query 230 1.234
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.059
backend-query 0 1.695
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.125
backend-query 230 1.199
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.064
backend-query 0 1.089
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.057
backend-query 116 1.807
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.085
backend-query 0 1.299
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.074
backend-query 228 1.397
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.081
backend-query 228 1.776
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.079
backend-query 0 1.980
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.101
backend-query 229 1.571
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.070
backend-query 231 1.483
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.064
backend-query 0 2.260
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.060
backend-query 230 1.471
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.070
backend-query 232 1.305
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.060
backend-query 229 1.246
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.063
backend-query 229 1.093
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.053
backend-query 229 1.420
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.062
backend-query 226 1.596
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.145
backend-query 0 2.730
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.059
backend-query 229 1.550
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.076
backend-query 231 1.622
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.058
backend-query 117 1.224
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.108
backend-query 0 2.025
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.062
backend-query 230 1.251
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.058
backend-query 230 1.223
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.068
backend-query 116 1.224
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.051
backend-query 0 0.937
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.045
backend-query 116 1.597
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.058
backend-query 228 1.595
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.063
backend-query 0 3.238
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.058
backend-query 229 1.573
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.078
backend-query 231 1.894
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.092
backend-query 230 1.717
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
optimization 0.061
backend-query 231 1.302
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@812bd43d
EdgeVertexStep(OUT)@[c] 20669 20669 39.223
PathFilterStep(simple) 20669 20669 44.905
JanusGraphMultiQueryStep(RepeatEndStep) 20669 20669 65.528
RepeatEndStep 20669 20669 39.443
SelectOneStep(last,a) 20669 20669 44.574 2.48
JanusGraphPropertiesStep([serial],value)@[parent] 20669 20669 92.515 5.15
\_condition=type[serial]
\_orders=[]
\_isFitted=true
\_isOrdered=true
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@811c505d
\_multi=true
\_vertices=100
optimization 0.090
backend-query 100 12.807
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@811c505d
SelectOneStep(last,b) 20669 20669 41.753 2.33
JanusGraphPropertiesStep([work_date],value)@[wo... 20669 20669 98.648 5.50
SelectOneStep(last,c) 20669 20669 41.674 2.32
JanusGraphPropertiesStep([serial],value)@[child] 20669 20669 246.094 13.71
\_condition=type[serial]
\_orders=[]
\_isFitted=true
\_isOrdered=true
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@811c505d
\_multi=true
\_vertices=1392
optimization 0.060
backend-query 1392 136.281
\_query=org.janusgraph.diskstorage.keycolumnvalue.SliceQuery@811c505d
SelectStep(last,[parent, child, work_date]) 20669 20669 49.139 2.74
OrderGlobalStep([[value(parent), asc], [value(c... 20669 20669 164.034 9.14
>TOTAL - - 1795.018 -
-----------------------------------------------------------------------------------------------------------

Sorry for my poor English.
Thanks,
Manabu

View All 12 Messages In Topic

#5342

Join {janusgraph-users@lists.lfaidata.foundation to automatically receive all group messages.

Home Hashtags Subgroups Calendar Terms