API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 11th, 2014
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.91 KB | None | 0 0
raw download clone embed print report
  1. PROFILE
  2. MATCH (user:User {origin_id:138})
  3. WITH user
  4.  
  5. MATCH user-[userLivesIn:LIVES_IN]->(userLoc:Location)
  6. WITH user, userLoc
  7.  
  8. MATCH user-[:FRIENDS_WITH]->(friend:User)
  9. WITH user, friend, userLoc
  10.  
  11. MATCH friend-[:FRIENDS_WITH]->(fof:User)
  12. WHERE
  13. user <> fof
  14. AND NOT user-[:FRIENDS_WITH]->fof
  15.  
  16. AND (fof.dob_age <= 35 AND fof.dob_age >= 20)
  17.  
  18. WITH user, friend, fof, userLoc
  19.  
  20. MATCH (fof)-[r:LIVES_IN]->(fofLoc:Location)
  21. WHERE (fofLoc.country = userLoc.country OR (fofLoc.country_code <> "" AND fofLoc.country_code = userLoc.country_code))
  22.  
  23. WITH user, friend, fof, userLoc, fofLoc
  24.  
  25. OPTIONAL MATCH user-[:LIKES]->(like:Like)
  26. WHERE fof-[:LIKES]->like
  27. WITH user, friend, like, fof, userLoc, fofLoc
  28.  
  29. RETURN
  30. fof.origin_id as fof_origin_id,
  31. fof.first_name as fof_first_name,
  32. fof.last_name as fof_last_name,
  33. fof.dob_age as fof_age,
  34. user.dob_age as user_age,
  35. userLoc.latitude as user_loc_latitude,
  36. userLoc.longitude as user_loc_longitude,
  37. fofLoc.name as fof_loc_name,
  38. fofLoc.latitude as fof_loc_latitude,
  39. fofLoc.longitude as fof_loc_longitude,
  40. COUNT(distinct(friend)) as mutual_friend_count,
  41. collect(distinct(friend)) as mutual_friends,
  42. collect(distinct(like)) as mutual_likes;
  43.  
  44.  
  45.  
  46.  
  47.  
  48. ColumnFilter(0)
  49. |
  50. +EagerAggregation
  51. |
  52. +Extract
  53. |
  54. +ColumnFilter(1)
  55. |
  56. +Eager(0)
  57. |
  58. +OptionalMatch
  59. |
  60. +Eager(1)
  61. | |
  62. | +ColumnFilter(6)
  63. | |
  64. | +Filter(5)
  65. | |
  66. | +SimplePatternMatcher(5)
  67. | |
  68. | +ColumnFilter(7)
  69. | |
  70. | +Filter(6)
  71. | |
  72. | +SimplePatternMatcher(6)
  73. | |
  74. | +ColumnFilter(8)
  75. | |
  76. | +Filter(7)
  77. | |
  78. | +SimplePatternMatcher(7)
  79. | |
  80. | +ColumnFilter(9)
  81. | |
  82. | +Filter(8)
  83. | |
  84. | +SimplePatternMatcher(8)
  85. | |
  86. | +SchemaIndex(1)
  87. |
  88. +Eager(2)
  89. |
  90. +Filter(4)
  91. |
  92. +SimplePatternMatcher(4)
  93. |
  94. +ColumnFilter(6)
  95. |
  96. +Filter(5)
  97. |
  98. +SimplePatternMatcher(5)
  99. |
  100. +ColumnFilter(7)
  101. |
  102. +Filter(6)
  103. |
  104. +SimplePatternMatcher(6)
  105. |
  106. +ColumnFilter(8)
  107. |
  108. +Filter(7)
  109. |
  110. +SimplePatternMatcher(7)
  111. |
  112. +ColumnFilter(9)
  113. |
  114. +Filter(8)
  115. |
  116. +SimplePatternMatcher(8)
  117. |
  118. +SchemaIndex(1)
  119.  
  120. +-------------------------+------+--------+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  121. | Operator | Rows | DbHits | Identifiers | Other |
  122. +-------------------------+------+--------+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  123. | ColumnFilter(0) | 909 | 0 | | keep columns fof_origin_id, fof_first_name, fof_last_name, fof_age, user_age, user_loc_latitude, user_loc_longitude, fof_loc_name, fof_loc_latitude, fof_loc_longitude, mutual_friend_count, mutual_friends, mutual_likes |
  124. | EagerAggregation | 909 | 0 | | user_loc_longitude, fof_loc_latitude, fof_first_name, fof_last_name, fof_loc_longitude, fof_loc_name, fof_origin_id, user_loc_latitude, fof_age, user_age |
  125. | Extract | 1452 | 29040 | | user_loc_longitude, fof_loc_latitude, fof_first_name, fof_last_name, fof_loc_longitude, fof_loc_name, fof_origin_id, user_loc_latitude, fof_age, user_age |
  126. | ColumnFilter(1) | 1452 | 0 | | keep columns user, friend, like, fof, userLoc, fofLoc |
  127. | Eager(0) | 1452 | 0 | | |
  128. | OptionalMatch | 1452 | 0 | | |
  129. | Eager(1) | 1007 | 0 | | |
  130. | ColumnFilter(6) | 1007 | 0 | | keep columns user, friend, fof, userLoc, fofLoc |
  131. | Filter(5) | 1007 | 11077 | | (hasLabel(fofLoc:Location(4)) AND (Property(fofLoc,country(18)) == Property(userLoc,country(18)) OR (NOT(Property(fofLoc,country_code(23)) == { AUTOSTRING3}) AND Property(fofLoc,country_code(23)) == Property(userLoc,country_code(23))))) |
  132. | SimplePatternMatcher(5) | 1007 | 54483 | fof, fofLoc, r | |
  133. | ColumnFilter(7) | 5785 | 0 | | keep columns user, friend, fof, userLoc |
  134. | Filter(6) | 5785 | 28925 | | ((((hasLabel(fof:User(0)) AND NOT(user == fof)) AND NOT(nonEmpty(PathExpression((user)-[ UNNAMED260:FRIENDS_WITH]->(fof), true)))) AND Property(fof,dob_age(7)) <= { AUTOINT1}) AND Property(fof,dob_age(7)) >= { AUTOINT2}) |
  135. | SimplePatternMatcher(6) | 5785 | 108592 | friend, fof, UNNAMED201 | |
  136. | ColumnFilter(8) | 901 | 0 | | keep columns user, friend, userLoc |
  137. | Filter(7) | 901 | 901 | | hasLabel(friend:User(0)) |
  138. | SimplePatternMatcher(7) | 901 | 901 | user, friend, UNNAMED129 | |
  139. | ColumnFilter(9) | 1 | 0 | | keep columns user, userLoc |
  140. | Filter(8) | 1 | 1 | | hasLabel(userLoc:Location(4)) |
  141. | SimplePatternMatcher(8) | 1 | 1 | user, userLoc, userLivesIn | |
  142. | SchemaIndex(1) | 1 | 2 | user, user | { AUTOINT0}; :User(origin_id) |
  143. | Eager(2) | 2 | 0 | | |
  144. | Filter(4) | 2 | 2 | | (hasLabel(like:Like(3)) AND nonEmpty(PathExpression((fof)-[ UNNAMED627:LIKES]->(like), true))) |
  145. | SimplePatternMatcher(4) | 2 | 224 | user, like, UNNAMED595 | |
  146. | ColumnFilter(6) | 1007 | 0 | | keep columns user, friend, fof, userLoc, fofLoc |
  147. | Filter(5) | 1007 | 11077 | | (hasLabel(fofLoc:Location(4)) AND (Property(fofLoc,country(18)) == Property(userLoc,country(18)) OR (NOT(Property(fofLoc,country_code(23)) == { AUTOSTRING3}) AND Property(fofLoc,country_code(23)) == Property(userLoc,country_code(23))))) |
  148. | SimplePatternMatcher(5) | 1007 | 54483 | fof, fofLoc, r | |
  149. | ColumnFilter(7) | 5785 | 0 | | keep columns user, friend, fof, userLoc |
  150. | Filter(6) | 5785 | 28925 | | ((((hasLabel(fof:User(0)) AND NOT(user == fof)) AND NOT(nonEmpty(PathExpression((user)-[ UNNAMED260:FRIENDS_WITH]->(fof), true)))) AND Property(fof,dob_age(7)) <= { AUTOINT1}) AND Property(fof,dob_age(7)) >= { AUTOINT2}) |
  151. | SimplePatternMatcher(6) | 5785 | 108592 | friend, fof, UNNAMED201 | |
  152. | ColumnFilter(8) | 901 | 0 | | keep columns user, friend, userLoc |
  153. | Filter(7) | 901 | 901 | | hasLabel(friend:User(0)) |
  154. | SimplePatternMatcher(7) | 901 | 901 | user, friend, UNNAMED129 | |
  155. | ColumnFilter(9) | 1 | 0 | | keep columns user, userLoc |
  156. | Filter(8) | 1 | 1 | | hasLabel(userLoc:Location(4)) |
  157. | SimplePatternMatcher(8) | 1 | 1 | user, userLoc, userLivesIn | |
  158. | SchemaIndex(1) | 1 | 2 | user, user | { AUTOINT0}; :User(origin_id) |
  159. +-------------------------+------+--------+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  160.  
  161. Total database accesses: 439032
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!