Skip to content

Instantly share code, notes, and snippets.

@jefersonmanjos
Last active August 29, 2015 14:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jefersonmanjos/02cb3972b4f738b42397 to your computer and use it in GitHub Desktop.
Save jefersonmanjos/02cb3972b4f738b42397 to your computer and use it in GitHub Desktop.
Result Profile
==> +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
==> 6 rows
==>
==> ColumnFilter(0)
==> |
==> +SchemaIndex
==> |
==> +PatternMatcher(0)
==> |
==> +Filter
==> |
==> +ColumnFilter(1)
==> |
==> +Extract(0)
==> |
==> +ColumnFilter(2)
==> |
==> +EagerAggregation(0)
==> |
==> +Extract(1)
==> |
==> +OptionalMatch(0)
==> |
==> +ColumnFilter(4)
==> | |
==> | +Slice(1)
==> | |
==> | +Top(1)
==> | |
==> | +Extract(5)
==> | |
==> | +EagerAggregation(2)
==> | |
==> | +OptionalMatch(2)
==> | |
==> | +Distinct(3)
==> | | |
==> | | +Extract(7)
==> | | |
==> | | +PatternMatcher(10)
==> | | |
==> | | +PatternMatcher(11)
==> | | |
==> | | +PatternMatcher(12)
==> | | |
==> | | +TraversalMatcher(3)
==> | |
==> | +ShortestPath(1)
==> | |
==> | +Distinct(3)
==> | |
==> | +Extract(7)
==> | |
==> | +PatternMatcher(10)
==> | |
==> | +PatternMatcher(11)
==> | |
==> | +PatternMatcher(12)
==> | |
==> | +TraversalMatcher(3)
==> |
==> +SimplePatternMatcher
==> |
==> +ColumnFilter(4)
==> |
==> +Slice(1)
==> |
==> +Top(1)
==> |
==> +Extract(5)
==> |
==> +EagerAggregation(2)
==> |
==> +OptionalMatch(2)
==> |
==> +Distinct(3)
==> | |
==> | +Extract(7)
==> | |
==> | +PatternMatcher(10)
==> | |
==> | +PatternMatcher(11)
==> | |
==> | +PatternMatcher(12)
==> | |
==> | +TraversalMatcher(3)
==> |
==> +ShortestPath(1)
==> |
==> +Distinct(3)
==> |
==> +Extract(7)
==> |
==> +PatternMatcher(10)
==> |
==> +PatternMatcher(11)
==> |
==> +PatternMatcher(12)
==> |
==> +TraversalMatcher(3)
==>
==> +----------------------+------+--------+-----------------------------------------------------+-----------------------------------------------------------------------------------------------------------+
==> | Operator | Rows | DbHits | Identifiers | Other |
==> +----------------------+------+--------+-----------------------------------------------------+-----------------------------------------------------------------------------------------------------------+
==> | ColumnFilter(0) | 6 | 0 | | keep columns followers, a, parent, l, coll, totalComments, owner |
==> | SchemaIndex | 6 | 24 | owner, owner | Property(a,Createdby(13)); :Packer(Username) |
==> | PatternMatcher(0) | 6 | 12 | parent, a, l | |
==> | Filter | 10 | 20 | | (num > { AUTOINT5} OR Property(a,Datecreated(17)) > { AUTOINT6}) |
==> | ColumnFilter(1) | 10 | 0 | | keep columns followers, a, l, coll, totalComments, num |
==> | Extract(0) | 10 | 0 | | coll, totalComments |
==> | ColumnFilter(2) | 10 | 0 | | keep columns followers, a, l, AGGREGATION613, AGGREGATION631, AGGREGATION634, AGGREGATION645, num |
==> | EagerAggregation(0) | 10 | 0 | | followers, a, num, l, AGGREGATION634, AGGREGATION631 |
==> | Extract(1) | 10 | 0 | | AGGREGATION634, AGGREGATION631 |
==> | OptionalMatch(0) | 10 | 0 | | |
==> | ColumnFilter(4) | 10 | 0 | | keep columns followers, a, num, l |
==> | Slice(1) | 10 | 0 | | { AUTOINT1} |
==> | Top(1) | 10 | 0 | | Add({ AUTOINT1},{ AUTOINT2}); Cached( UNNAMEDS-1398249603 of type Any) |
==> | Extract(5) | 3775 | 7542 | | UNNAMEDS-1398249603 |
==> | EagerAggregation(2) | 3775 | 0 | | followers, a, l |
==> | OptionalMatch(2) | 3775 | 0 | | |
==> | Distinct(3) | 3775 | 0 | | |
==> | Extract(7) | 3775 | 0 | | l |
==> | PatternMatcher(10) | 3775 | 0 | d, a, UNNAMED168 | |
==> | PatternMatcher(11) | 3645 | 0 | e, d, UNNAMED124 | |
==> | PatternMatcher(12) | 114 | 0 | e, UNNAMED41, followers, currentUser, UNNAMED69 | |
==> | TraversalMatcher(3) | 4 | 7 | | followers, UNNAMED41, followers |
==> | ShortestPath(1) | 0 | 0 | UNNAMED313 | |
==> | Distinct(3) | 3775 | 0 | | |
==> | Extract(7) | 3775 | 0 | | l |
==> | PatternMatcher(10) | 3775 | 0 | d, a, UNNAMED168 | |
==> | PatternMatcher(11) | 3645 | 0 | e, d, UNNAMED124 | |
==> | PatternMatcher(12) | 114 | 0 | e, UNNAMED41, followers, currentUser, UNNAMED69 | |
==> | TraversalMatcher(3) | 4 | 7 | | followers, UNNAMED41, followers |
==> | SimplePatternMatcher | 0 | 0 | a, rf, UNNAMED539, UNNAMED558, comments | |
==> | ColumnFilter(4) | 10 | 0 | | keep columns followers, a, num, l |
==> | Slice(1) | 10 | 0 | | { AUTOINT1} |
==> | Top(1) | 10 | 0 | | Add({ AUTOINT1},{ AUTOINT2}); Cached( UNNAMEDS-1398249603 of type Any) |
==> | Extract(5) | 3775 | 7542 | | UNNAMEDS-1398249603 |
==> | EagerAggregation(2) | 3775 | 0 | | followers, a, l |
==> | OptionalMatch(2) | 3775 | 0 | | |
==> | Distinct(3) | 3775 | 0 | | |
==> | Extract(7) | 3775 | 0 | | l |
==> | PatternMatcher(10) | 3775 | 0 | d, a, UNNAMED168 | |
==> | PatternMatcher(11) | 3645 | 0 | e, d, UNNAMED124 | |
==> | PatternMatcher(12) | 114 | 0 | e, UNNAMED41, followers, currentUser, UNNAMED69 | |
==> | TraversalMatcher(3) | 4 | 7 | | followers, UNNAMED41, followers |
==> | ShortestPath(1) | 0 | 0 | UNNAMED313 | |
==> | Distinct(3) | 3775 | 0 | | |
==> | Extract(7) | 3775 | 0 | | l |
==> | PatternMatcher(10) | 3775 | 0 | d, a, UNNAMED168 | |
==> | PatternMatcher(11) | 3645 | 0 | e, d, UNNAMED124 | |
==> | PatternMatcher(12) | 114 | 0 | e, UNNAMED41, followers, currentUser, UNNAMED69 | |
==> | TraversalMatcher(3) | 4 | 7 | | followers, UNNAMED41, followers |
==> +----------------------+------+--------+-----------------------------------------------------+-----------------------------------------------------------------------------------------------------------+
==>
==> Total database accesses: 15168
count(*),count(distinct a),count(distinct followers),totalComments,num
34,17,2,1,1
4,2,1,4,1
3,2,1,9,1
2,1,1,6,1
5,3,1,3,1
3,1,1,41,1
4,2,1,8,1
3706,3618,4,0,1
3,2,1,5,1
9,7,2,2,1
2,1,1,21,1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment