API tools faq
paste
Advertisement
Guest User

Slow query in Slick

a guest
Nov 22nd, 2016
247
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.87 KB | None | 0 0
raw download clone embed print report
  1. 1479833604520
  2. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - Source:
  3. | Filter s2
  4. | from s2: TableExpansion
  5. | table s3: Table Prediction
  6. | columns: TypeMapping
  7. | 0: ProductNode
  8. | 1: Path s3.predictionId : Int'
  9. | 2: Path s3.type : Int'
  10. | 3: Path s3.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  11. | 4: Path s3.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  12. | where: Apply Function =
  13. | 0: Path s2.predictionId : Int'
  14. | 1: LiteralNode 16 (volatileHint=false)
  15.  
  16. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.AssignUniqueSymbols - Detected features: UsedFeatures(false,true,false,false)
  17. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase assignUniqueSymbols:
  18. | Filter s4
  19. | from s4: TableExpansion
  20. | table s5: Table Prediction
  21. | columns: TypeMapping
  22. | 0: ProductNode
  23. | 1: Path s5.predictionId : Int'
  24. | 2: Path s5.type : Int'
  25. | 3: Path s5.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  26. | 4: Path s5.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  27. | where: Apply Function =
  28. | 0: Path s4.predictionId : Int'
  29. | 1: LiteralNode 16 (volatileHint=false)
  30.  
  31. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase inferTypes: (no change)
  32. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.ExpandTables - Found Selects for NominalTypes: @t6
  33. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.ExpandTables - With correct table types:
  34. | Filter s4 : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  35. | from s4: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  36. | where: Apply Function = : Boolean
  37. | 0: Path s4.predictionId : Int'
  38. | 1: LiteralNode 16 (volatileHint=false) : Int'
  39.  
  40. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.ExpandTables - Table expansions: @t6 -> (s5,TypeMapping)
  41. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.ExpandTables - Expanding tables in result type
  42. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase expandTables:
  43. | Bind : Vector[t8<Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]>]
  44. | from s7: Filter s4 : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  45. | from s4: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  46. | where: Apply Function = : Boolean
  47. | 0: Path s4.predictionId : Int'
  48. | 1: LiteralNode 16 (volatileHint=false) : Int'
  49. | select: Pure t8 : Vector[t8<Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]>]
  50. | value: TypeMapping : Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]
  51. | 0: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  52. | 1: Path s7.predictionId : Int'
  53. | 2: Path s7.type : Int'
  54. | 3: Path s7.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  55. | 4: Path s7.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  56.  
  57. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase forceOuterBinds:
  58. | Bind : Vector[t8<Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]>]
  59. | from s7: Filter s4 : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  60. | from s4: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  61. | where: Apply Function = : Boolean
  62. | 0: Path s4.predictionId : Int'
  63. | 1: LiteralNode 16 (volatileHint=false) : Int'
  64. | select: Pure t8 : Vector[t8<Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]>]
  65. | value: TypeMapping : Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]
  66. | 0: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  67. | 1: Path s7.predictionId : Int'
  68. | 2: Path s7.type : Int'
  69. | 3: Path s7.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  70. | 4: Path s7.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  71.  
  72. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase removeMappedTypes:
  73. | Bind : Vector[t8<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  74. | from s7: Filter s4 : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  75. | from s4: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  76. | where: Apply Function = : Boolean
  77. | 0: Path s4.predictionId : Int'
  78. | 1: LiteralNode 16 (volatileHint=false) : Int'
  79. | select: Pure t8 : Vector[t8<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  80. | value: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  81. | 1: Path s7.predictionId : Int'
  82. | 2: Path s7.type : Int'
  83. | 3: Path s7.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  84. | 4: Path s7.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  85.  
  86. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase expandSums: (no change)
  87. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase expandRecords:
  88. | Bind : Vector[t8<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  89. | from s7: Filter s4 : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  90. | from s4: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  91. | where: Apply Function = : Boolean
  92. | 0: Path s4.predictionId : Int'
  93. | 1: LiteralNode 16 (volatileHint=false) : Int'
  94. | select: Pure t8 : Vector[t8<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  95. | value: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  96. | 1: Path s7.predictionId : Int'
  97. | 2: Path s7.type : Int'
  98. | 3: Path s7.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  99. | 4: Path s7.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  100.  
  101. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Analyzing s4.predictionId with symbols
  102. | Path s4.predictionId : Int'
  103.  
  104. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Translated s4.predictionId to:
  105. | Path s4.predictionId
  106.  
  107. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Flattening projection t8
  108. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Analyzing s7.predictionId with symbols
  109. | Path s7.predictionId : Int'
  110.  
  111. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Translated s7.predictionId to:
  112. | Path s7.predictionId
  113.  
  114. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Analyzing s7.type with symbols
  115. | Path s7.type : Int'
  116.  
  117. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Translated s7.type to:
  118. | Path s7.type
  119.  
  120. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Analyzing s7.createdAt with symbols
  121. | Path s7.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  122.  
  123. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Translated s7.createdAt to:
  124. | Path s7.createdAt
  125.  
  126. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Analyzing s7.updatedAt with symbols
  127. | Path s7.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  128.  
  129. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Translated s7.updatedAt to:
  130. | Path s7.updatedAt
  131.  
  132. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Flattening node at Path
  133. | ProductNode
  134. | 1: Path s7.predictionId
  135. | 2: Path s7.type
  136. | 3: Path s7.createdAt
  137. | 4: Path s7.updatedAt
  138.  
  139. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Flattening node at Path _1
  140. | Path s7.predictionId
  141.  
  142. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Adding definition: s9 -> Path s7.predictionId
  143. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Flattening node at Path _2
  144. | Path s7.type
  145.  
  146. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Adding definition: s10 -> Path s7.type
  147. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Flattening node at Path _3
  148. | Path s7.createdAt
  149.  
  150. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Adding definition: s11 -> Path s7.createdAt
  151. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Flattening node at Path _4
  152. | Path s7.updatedAt
  153.  
  154. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Adding definition: s12 -> Path s7.updatedAt
  155. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Adding translation for t8: (Map(List(_2) -> s10, List(_1) -> s9, List(_3) -> s11, List(_4) -> s12), UnassignedType)
  156. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.FlattenProjections - Flattened projection to
  157. | Pure t8
  158. | value: StructNode
  159. | s9: Path s7.predictionId
  160. | s10: Path s7.type
  161. | s11: Path s7.createdAt
  162. | s12: Path s7.updatedAt
  163.  
  164. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase flattenProjections:
  165. | Bind : Vector[t8<{s9: Int', s10: Int', s11: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s12: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  166. | from s7: Filter s4 : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  167. | from s4: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  168. | where: Apply Function = : Boolean
  169. | 0: Path s4.predictionId : Int'
  170. | 1: LiteralNode 16 (volatileHint=false) : Int'
  171. | select: Pure t8 : Vector[t8<{s9: Int', s10: Int', s11: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s12: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  172. | value: StructNode : {s9: Int', s10: Int', s11: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s12: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}
  173. | s9: Path s7.predictionId : Int'
  174. | s10: Path s7.type : Int'
  175. | s11: Path s7.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  176. | s12: Path s7.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  177.  
  178. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase rewriteJoins: (no change)
  179. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase verifySymbols: (no change)
  180. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase relabelUnions: (no change)
  181. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase createAggregates: (no change)
  182. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase resolveZipJoins: (no change)
  183. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.PruneProjections - Unreferenced: t8; Field refs: (@t6,predictionId), (@t6,type), (@t6,updatedAt), (@t6,createdAt)
  184. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase pruneProjections: (no change)
  185. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.RewriteDistinct - No DISTINCT used as determined by assignUniqueSymbols - skipping phase
  186. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase rewriteDistinct: (no change)
  187. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.CreateResultSetMapping - Creating mapping from t8<Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]>
  188. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.CreateResultSetMapping - Creating mapping from (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  189. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.CreateResultSetMapping - Creating mapping from Int'
  190. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.CreateResultSetMapping - Creating mapping from Int'
  191. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.CreateResultSetMapping - Creating mapping from MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  192. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.CreateResultSetMapping - Creating mapping from MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  193. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase createResultSetMapping:
  194. | ResultSetMapping : Vector[Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]]
  195. | from s13: Bind : Vector[t8<{s9: Int', s10: Int', s11: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s12: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  196. | from s7: Filter s4 : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  197. | from s4: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  198. | where: Apply Function = : Boolean
  199. | 0: Path s4.predictionId : Int'
  200. | 1: LiteralNode 16 (volatileHint=false) : Int'
  201. | select: Pure t8 : Vector[t8<{s9: Int', s10: Int', s11: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s12: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  202. | value: StructNode : {s9: Int', s10: Int', s11: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s12: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}
  203. | s9: Path s7.predictionId : Int'
  204. | s10: Path s7.type : Int'
  205. | s11: Path s7.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  206. | s12: Path s7.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  207. | map: TypeMapping : Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]
  208. | 0: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  209. | 1: Path s13.s9 : Int'
  210. | 2: Path s13.s10 : Int'
  211. | 3: Path s13.s11 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  212. | 4: Path s13.s12 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  213.  
  214. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.HoistClientOps - Hoisting operations from defs:
  215. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.HoistClientOps - New defs: Map(Path s7.predictionId -> s14, Path s7.type -> s15, Path s7.createdAt -> s16, Path s7.updatedAt -> s17)
  216. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.HoistClientOps - New ResultSetMapping:
  217. | ResultSetMapping : Vector[Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]]
  218. | from s13: Bind : Vector[t18<{s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  219. | from s7: ...
  220. | select: Pure t18 : Vector[t18<{s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  221. | value: StructNode : {s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}
  222. | s14: Path s7.predictionId : Int'
  223. | s15: Path s7.type : Int'
  224. | s16: Path s7.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  225. | s17: Path s7.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  226. | map: TypeMapping : Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]
  227. | 0: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  228. | 1: Path s13.s14 : Int'
  229. | 2: Path s13.s15 : Int'
  230. | 3: Path s13.s16 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  231. | 4: Path s13.s17 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  232.  
  233. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase hoistClientOps:
  234. | ResultSetMapping : Vector[Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]]
  235. | from s13: Bind : Vector[t18<{s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  236. | from s7: Filter s4 : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  237. | from s4: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  238. | where: Apply Function = : Boolean
  239. | 0: Path s4.predictionId : Int'
  240. | 1: LiteralNode 16 (volatileHint=false) : Int'
  241. | select: Pure t18 : Vector[t18<{s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  242. | value: StructNode : {s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}
  243. | s14: Path s7.predictionId : Int'
  244. | s15: Path s7.type : Int'
  245. | s16: Path s7.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  246. | s17: Path s7.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  247. | map: TypeMapping : Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]
  248. | 0: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  249. | 1: Path s13.s14 : Int'
  250. | 2: Path s13.s15 : Int'
  251. | 3: Path s13.s16 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  252. | 4: Path s13.s17 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  253.  
  254. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase reorderOperations: (no change)
  255. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Table fields: Map(@t6 -> Vector(predictionId, type, createdAt, updatedAt))
  256. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Creating source from TableNode:
  257. | Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  258.  
  259. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Mappings are: ConstArray(((@t6,predictionId),List(predictionId)), ((@t6,type),List(type)), ((@t6,createdAt),List(createdAt)), ((@t6,updatedAt),List(updatedAt)))
  260. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Building new Comprehension from:
  261. | Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  262.  
  263. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Built new Comprehension:
  264. | Comprehension s19, None, None, ConstArray(), None, None, None, None : Vector[t20<{s21: Int', s22: Int', s23: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s24: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  265. | from s19: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  266. | select: Pure t20 : Vector[t20<{s21: Int', s22: Int', s23: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s24: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  267. | value: StructNode : {s21: Int', s22: Int', s23: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s24: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}
  268. | s21: Path s19.predictionId : Int'
  269. | s22: Path s19.type : Int'
  270. | s23: Path s19.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  271. | s24: Path s19.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  272.  
  273. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Replacements are: Map((@t6,predictionId) -> s21, (@t6,type) -> s22, (@t6,createdAt) -> s23, (@t6,updatedAt) -> s24)
  274. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Merging Filter into Comprehension:
  275. | Filter s4 : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  276. | from s4: ...
  277. | where: Apply Function = : Boolean
  278. | 0: Path s4.predictionId : Int'
  279. | 1: LiteralNode 16 (volatileHint=false) : Int'
  280.  
  281. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Merged Filter into Comprehension:
  282. | Comprehension s19, Some(Apply Function =), None, ConstArray(), None, None, None, None : Vector[t20<{s21: Int', s22: Int', s23: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s24: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  283. | from s19: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  284. | select: Pure t20 : Vector[t20<{s21: Int', s22: Int', s23: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s24: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  285. | value: StructNode : {s21: Int', s22: Int', s23: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s24: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}
  286. | s21: Path s19.predictionId : Int'
  287. | s22: Path s19.type : Int'
  288. | s23: Path s19.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  289. | s24: Path s19.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  290. | where: Apply Function = : Boolean
  291. | 0: Path s19.predictionId : Int'
  292. | 1: LiteralNode 16 (volatileHint=false) : Int'
  293.  
  294. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Merging Bind into Comprehension as 'select':
  295. | Bind : Vector[t18<{s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  296. | from s7: ...
  297. | select: Pure t18 : Vector[t18<{s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  298. | value: StructNode : {s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}
  299. | s14: Path s7.predictionId : Int'
  300. | s15: Path s7.type : Int'
  301. | s16: Path s7.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  302. | s17: Path s7.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  303.  
  304. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Merged Bind into Comprehension as 'select':
  305. | Comprehension s19, Some(Apply Function =), None, ConstArray(), None, None, None, None : Vector[t18<{s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  306. | from s19: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  307. | select: Pure t18 : Vector[t18<{s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  308. | value: StructNode : {s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}
  309. | s14: Path s19.predictionId : Int'
  310. | s15: Path s19.type : Int'
  311. | s16: Path s19.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  312. | s17: Path s19.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  313. | where: Apply Function = : Boolean
  314. | 0: Path s19.predictionId : Int'
  315. | 1: LiteralNode 16 (volatileHint=false) : Int'
  316.  
  317. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Replacements are: Map((t18,s14) -> s14, (t18,s15) -> s15, (t18,s16) -> s16, (t18,s17) -> s17)
  318. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.MergeToComprehensions - Mappings are: ConstArray(((t18,s14),List(s14)), ((t18,s15),List(s15)), ((t18,s16),List(s16)), ((t18,s17),List(s17)))
  319. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase mergeToComprehensions:
  320. | ResultSetMapping : Vector[Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]]
  321. | from s13: Comprehension s19, Some(Apply Function =), None, ConstArray(), None, None, None, None : Vector[t18<{s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  322. | from s19: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  323. | select: Pure t18 : Vector[t18<{s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  324. | value: StructNode : {s14: Int', s15: Int', s16: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], s17: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}
  325. | s14: Path s19.predictionId : Int'
  326. | s15: Path s19.type : Int'
  327. | s16: Path s19.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  328. | s17: Path s19.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  329. | where: Apply Function = : Boolean
  330. | 0: Path s19.predictionId : Int'
  331. | 1: LiteralNode 16 (volatileHint=false) : Int'
  332. | map: TypeMapping : Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]
  333. | 0: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  334. | 1: Path s13.s14 : Int'
  335. | 2: Path s13.s15 : Int'
  336. | 3: Path s13.s16 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  337. | 4: Path s13.s17 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  338.  
  339. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase optimizeScalar: (no change)
  340. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase fixRowNumberOrdering: (no change)
  341. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.RemoveFieldNames - Required symbols: s14 -> 0, s15 -> 1, s16 -> 2, s17 -> 3
  342. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.RemoveFieldNames - Transformed RSM:
  343. | ResultSetMapping
  344. | from s13: Comprehension s19, Some(Apply Function =), None, ConstArray(), None, None, None, None : Vector[t18<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  345. | from s19: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  346. | select: Pure t18 : Vector[t18<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  347. | value: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  348. | 1: Path s19.predictionId : Int'
  349. | 2: Path s19.type : Int'
  350. | 3: Path s19.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  351. | 4: Path s19.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  352. | where: Apply Function = : Boolean
  353. | 0: Path s19.predictionId : Int'
  354. | 1: LiteralNode 16 (volatileHint=false) : Int'
  355. | map: TypeMapping : Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]
  356. | 0: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  357. | 1: Path s13.s14 : Int'
  358. | 2: Path s13.s15 : Int'
  359. | 3: Path s13.s16 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  360. | 4: Path s13.s17 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  361.  
  362. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase removeFieldNames:
  363. | ResultSetMapping : Vector[Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]]
  364. | from s13: Comprehension s19, Some(Apply Function =), None, ConstArray(), None, None, None, None : Vector[t18<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  365. | from s19: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  366. | select: Pure t18 : Vector[t18<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  367. | value: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  368. | 1: Path s19.predictionId : Int'
  369. | 2: Path s19.type : Int'
  370. | 3: Path s19.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  371. | 4: Path s19.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  372. | where: Apply Function = : Boolean
  373. | 0: Path s19.predictionId : Int'
  374. | 1: LiteralNode 16 (volatileHint=false) : Int'
  375. | map: TypeMapping : Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]
  376. | 0: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  377. | 1: Path s13._1 : Int'
  378. | 2: Path s13._2 : Int'
  379. | 3: Path s13._3 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  380. | 4: Path s13._4 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  381.  
  382. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase rewriteBooleans:
  383. | ResultSetMapping : Vector[Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]]
  384. | from s13: Comprehension s19, Some(Apply Function =), None, ConstArray(), None, None, None, None : Vector[t18<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  385. | from s19: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  386. | select: Pure t18 : Vector[t18<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  387. | value: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  388. | 1: Path s19.predictionId : Int'
  389. | 2: Path s19.type : Int'
  390. | 3: Path s19.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  391. | 4: Path s19.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  392. | where: Apply Function = : Boolean
  393. | 0: Path s19.predictionId : Int'
  394. | 1: LiteralNode 16 (volatileHint=false) : Int'
  395. | map: TypeMapping : Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]
  396. | 0: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  397. | 1: Path s13._1 : Int'
  398. | 2: Path s13._2 : Int'
  399. | 3: Path s13._3 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  400. | 4: Path s13._4 : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  401.  
  402. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.CodeGen - Compiling server-side and mapping with server-side:
  403. | Comprehension s19, Some(Apply Function =), None, ConstArray(), None, None, None, None : Vector[t18<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  404. | from s19: Table Prediction : Vector[@t6<{predictionId: Int', type: Int', createdAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], updatedAt: MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']}>]
  405. | select: Pure t18 : Vector[t18<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  406. | value: ProductNode : (Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])
  407. | 1: Path s19.predictionId : Int'
  408. | 2: Path s19.type : Int'
  409. | 3: Path s19.createdAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  410. | 4: Path s19.updatedAt : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  411. | where: Apply Function = : Boolean
  412. | 0: Path s19.predictionId : Int'
  413. | 1: LiteralNode 16 (volatileHint=false) : Int'
  414.  
  415. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.relational.ResultConverterCompiler - Compiled ResultConverter
  416. | TypeMappingResultConverter
  417. | child: ProductResultConverter
  418. | 1: BaseResultConverter$mcI$sp idx=1, name=<computed> : Int'
  419. | 2: BaseResultConverter$mcI$sp idx=2, name=<computed> : Int'
  420. | 3: SpecializedJdbcResultConverter$$anon$1 idx=3, name=<computed> : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  421. | 4: SpecializedJdbcResultConverter$$anon$1 idx=4, name=<computed> : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  422.  
  423. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.CodeGen - Compiled server-side to:
  424. | CompiledStatement "select "predictionId", "type", "createdAt", "updatedAt" from "Prediction" where "predictionId" = 16" : Vector[t18<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  425.  
  426. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompiler - After phase codeGen:
  427. | ResultSetMapping : Vector[Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]]
  428. | from s13: CompiledStatement "select "predictionId", "type", "createdAt", "updatedAt" from "Prediction" where "predictionId" = 16" : Vector[t18<(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])>]
  429. | map: CompiledMapping : Mapped[(Int', Int', MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'], MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp'])]
  430. | converter: TypeMappingResultConverter
  431. | child: ProductResultConverter
  432. | 1: BaseResultConverter$mcI$sp idx=1, name=<computed> : Int'
  433. | 2: BaseResultConverter$mcI$sp idx=2, name=<computed> : Int'
  434. | 3: SpecializedJdbcResultConverter$$anon$1 idx=3, name=<computed> : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  435. | 4: SpecializedJdbcResultConverter$$anon$1 idx=4, name=<computed> : MappedJdbcType[java.time.LocalDateTime -> java.sql.Timestamp']
  436.  
  437. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - ------------------- Phase: Time ---------
  438. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - assignUniqueSymbols: 0.813511 ms
  439. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - inferTypes: 0.148154 ms
  440. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - expandTables: 2.056758 ms
  441. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - forceOuterBinds: 1.136595 ms
  442. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - removeMappedTypes: 1.070549 ms
  443. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - expandSums: 0.029452 ms
  444. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - expandRecords: 0.475701 ms
  445. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - flattenProjections: 2.272297 ms
  446. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - rewriteJoins: 0.079878 ms
  447. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - verifySymbols: 0.060690 ms
  448. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - relabelUnions: 0.052658 ms
  449. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - createAggregates: 0.024097 ms
  450. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - resolveZipJoins: 0.042393 ms
  451. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - pruneProjections: 0.209737 ms
  452. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - rewriteDistinct: 0.032576 ms
  453. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - createResultSetMapping: 1.119637 ms
  454. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - hoistClientOps: 1.493146 ms
  455. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - reorderOperations: 0.151278 ms
  456. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - mergeToComprehensions: 4.714613 ms
  457. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - optimizeScalar: 0.434645 ms
  458. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - fixRowNumberOrdering: 0.045071 ms
  459. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - removeFieldNames: 3.875667 ms
  460. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - rewriteBooleans: 1.421747 ms
  461. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - codeGen: 2.289700 ms
  462. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.compiler.QueryCompilerBenchmark - TOTAL: 24.050550 ms
  463. [sangria-server-akka.actor.default-dispatcher-3] DEBUG slick.backend.DatabaseComponent.action - #1: StreamingInvokerAction$HeadAction [select "predictionId", "type", "createdAt", "updatedAt" from "Prediction" where "predictionId" = 16]
  464.  
  465. [test1-1] DEBUG slick.jdbc.JdbcBackend.statement - Preparing statement: select "predictionId", "type", "createdAt", "updatedAt" from "Prediction" where "predictionId" = 16
  466. [test1-1] DEBUG slick.jdbc.JdbcBackend.benchmark - Execution of prepared statement took 502µs
  467. [test1-1] DEBUG slick.jdbc.StatementInvoker.result - /--------------+------+----------------------+----------------------\
  468. [test1-1] DEBUG slick.jdbc.StatementInvoker.result - | 1 | 2 | 3 | 4 |
  469. [test1-1] DEBUG slick.jdbc.StatementInvoker.result - | predictionId | type | createdAt | updatedAt |
  470. [test1-1] DEBUG slick.jdbc.StatementInvoker.result - |--------------+------+----------------------+----------------------|
  471. [test1-1] DEBUG slick.jdbc.StatementInvoker.result - | 16 | 1 | 2016-11-22 16:47:... | 2016-11-22 16:47:... |
  472. [test1-1] DEBUG slick.jdbc.StatementInvoker.result - \--------------+------+----------------------+----------------------/
  473. 1479833604716
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!