Last active
August 29, 2015 14:11
-
-
Save jefersonmanjos/02cb3972b4f738b42397 to your computer and use it in GitHub Desktop.
Result Profile
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
==> +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | |
==> 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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