API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 24th, 2019
5,502
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.36 KB | None | 0 0
raw download clone embed print report
  1. Nested Loop (cost=1113.46..1115.51 rows=1 width=320) (actual time=5423.648..5637.029 rows=1 loops=1)
  2. CTE item
  3. -> Hash Full Join (cost=1.92..9.96 rows=1 width=2331) (actual time=0.095..0.100 rows=1 loops=1)
  4. Hash Cond: (enwiktionary.title = lower(w.title))
  5. -> Limit (cost=0.43..8.45 rows=1 width=56) (actual time=0.010..0.010 rows=0 loops=1)
  6. -> Index Scan using enwiktionary_title on enwiktionary (cost=0.43..8.45 rows=1 width=56) (actual time=0.010..0.010 rows=0 loops=1)
  7. Index Cond: (title = 'shaquille o''neal'::text)
  8. -> Hash (cost=1.47..1.47 rows=1 width=2275) (actual time=0.066..0.067 rows=1 loops=1)
  9. Buckets: 1024 Batches: 1 Memory Usage: 10kB
  10. -> Limit (cost=1.41..1.46 rows=1 width=2275) (actual time=0.051..0.053 rows=1 loops=1)
  11. -> Nested Loop Left Join (cost=1.41..25.48 rows=429 width=2275) (actual time=0.050..0.051 rows=1 loops=1)
  12. -> Nested Loop Left Join (cost=1.12..17.17 rows=1 width=1629) (actual time=0.040..0.040 rows=1 loops=1)
  13. -> Index Scan using enwikipedia_title on enwikipedia w (cost=0.56..8.57 rows=1 width=968) (actual time=0.020..0.020 rows=1 loops=1)
  14. Index Cond: (lower(title) = 'shaquille o''neal'::text)
  15. -> Index Scan using wikidata_id on wikidata wd (cost=0.56..8.58 rows=1 width=670) (actual time=0.012..0.012 rows=1 loops=1)
  16. Index Cond: (w.id = id)
  17. -> Index Scan using enwikiquote_id on enwikiquote wq (cost=0.29..8.30 rows=1 width=652) (actual time=0.007..0.007 rows=0 loops=1)
  18. Index Cond: (w.id = id)
  19. CTE country
  20. -> Aggregate (cost=78.28..78.29 rows=1 width=32) (actual time=0.035..0.035 rows=1 loops=1)
  21. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.033..0.033 rows=0 loops=1)
  22. -> CTE Scan on item item_1 (cost=0.00..0.02 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=1)
  23. -> Function Scan on jsonb_array_elements (cost=0.01..1.00 rows=100 width=32) (actual time=0.027..0.027 rows=0 loops=1)
  24. CTE image
  25. -> CTE Scan on item item_2 (cost=0.00..0.27 rows=1 width=32) (actual time=0.350..0.351 rows=1 loops=1)
  26. CTE birthplace
  27. -> CTE Scan on item item_3 (cost=0.00..0.27 rows=1 width=32) (actual time=1.987..1.988 rows=1 loops=1)
  28. CTE sex
  29. -> CTE Scan on item item_4 (cost=0.00..0.27 rows=1 width=32) (actual time=0.937..0.938 rows=1 loops=1)
  30. CTE father
  31. -> CTE Scan on item item_5 (cost=0.00..0.27 rows=1 width=32) (actual time=52.199..52.200 rows=1 loops=1)
  32. CTE mother
  33. -> CTE Scan on item item_6 (cost=0.00..0.27 rows=1 width=32) (actual time=0.031..0.033 rows=1 loops=1)
  34. CTE spouse
  35. -> Aggregate (cost=103.53..103.54 rows=1 width=32) (actual time=49.974..49.974 rows=1 loops=1)
  36. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.045..0.048 rows=1 loops=1)
  37. -> CTE Scan on item item_7 (cost=0.00..0.02 rows=1 width=32) (actual time=0.005..0.006 rows=1 loops=1)
  38. -> Function Scan on jsonb_array_elements jsonb_array_elements_1 (cost=0.01..1.00 rows=100 width=32) (actual time=0.037..0.038 rows=1 loops=1)
  39. CTE country_of_citizenship
  40. -> CTE Scan on item item_8 (cost=0.00..0.27 rows=1 width=32) (actual time=47.805..47.807 rows=1 loops=1)
  41. CTE instance
  42. -> CTE Scan on item item_9 (cost=0.00..0.27 rows=1 width=32) (actual time=1.436..1.437 rows=1 loops=1)
  43. CTE capital
  44. -> Aggregate (cost=78.28..78.29 rows=1 width=32) (actual time=0.049..0.049 rows=1 loops=1)
  45. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.035..0.035 rows=0 loops=1)
  46. -> CTE Scan on item item_10 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)
  47. -> Function Scan on jsonb_array_elements jsonb_array_elements_2 (cost=0.01..1.00 rows=100 width=32) (actual time=0.033..0.033 rows=0 loops=1)
  48. CTE currency
  49. -> CTE Scan on item item_11 (cost=0.00..0.27 rows=1 width=32) (actual time=0.042..0.042 rows=1 loops=1)
  50. CTE flag
  51. -> CTE Scan on item item_12 (cost=0.00..0.27 rows=1 width=32) (actual time=0.033..0.034 rows=1 loops=1)
  52. CTE teams
  53. -> Aggregate (cost=103.78..103.79 rows=1 width=32) (actual time=161.800..161.800 rows=1 loops=1)
  54. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.049..0.065 rows=7 loops=1)
  55. -> CTE Scan on item item_13 (cost=0.00..0.02 rows=1 width=32) (actual time=0.002..0.003 rows=1 loops=1)
  56. -> Function Scan on jsonb_array_elements jsonb_array_elements_3 (cost=0.01..1.00 rows=100 width=32) (actual time=0.045..0.051 rows=7 loops=1)
  57. CTE education
  58. -> Aggregate (cost=128.78..128.79 rows=1 width=32) (actual time=64.021..64.021 rows=1 loops=1)
  59. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.038..0.047 rows=6 loops=1)
  60. -> CTE Scan on item item_14 (cost=0.00..0.02 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=1)
  61. -> Function Scan on jsonb_array_elements jsonb_array_elements_4 (cost=0.01..1.00 rows=100 width=32) (actual time=0.033..0.036 rows=6 loops=1)
  62. CTE occupation
  63. -> CTE Scan on item item_15 (cost=0.00..0.27 rows=1 width=32) (actual time=52.270..52.271 rows=1 loops=1)
  64. CTE signature
  65. -> CTE Scan on item item_16 (cost=0.00..0.02 rows=1 width=32) (actual time=0.034..0.035 rows=1 loops=1)
  66. CTE interment
  67. -> Aggregate (cost=78.28..78.29 rows=1 width=32) (actual time=0.041..0.042 rows=1 loops=1)
  68. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.038..0.038 rows=0 loops=1)
  69. -> CTE Scan on item item_17 (cost=0.00..0.02 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=1)
  70. -> Function Scan on jsonb_array_elements jsonb_array_elements_5 (cost=0.01..1.00 rows=100 width=32) (actual time=0.033..0.033 rows=0 loops=1)
  71. CTE genre
  72. -> CTE Scan on item item_18 (cost=0.00..0.27 rows=1 width=32) (actual time=0.997..0.998 rows=1 loops=1)
  73. CTE religion
  74. -> CTE Scan on item item_19 (cost=0.00..0.27 rows=1 width=32) (actual time=2.211..2.213 rows=1 loops=1)
  75. CTE awards
  76. -> Aggregate (cost=53.03..53.04 rows=1 width=32) (actual time=135.975..135.976 rows=1 loops=1)
  77. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.040..0.071 rows=21 loops=1)
  78. -> CTE Scan on item item_20 (cost=0.00..0.02 rows=1 width=32) (actual time=0.000..0.005 rows=1 loops=1)
  79. -> Function Scan on jsonb_array_elements jsonb_array_elements_6 (cost=0.01..1.00 rows=100 width=32) (actual time=0.036..0.044 rows=21 loops=1)
  80. CTE ethnicity
  81. -> CTE Scan on item item_21 (cost=0.00..0.27 rows=1 width=32) (actual time=0.899..0.901 rows=1 loops=1)
  82. CTE military
  83. -> Aggregate (cost=78.28..78.29 rows=1 width=32) (actual time=0.034..0.034 rows=1 loops=1)
  84. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.032..0.033 rows=0 loops=1)
  85. -> CTE Scan on item item_22 (cost=0.00..0.02 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=1)
  86. -> Function Scan on jsonb_array_elements jsonb_array_elements_7 (cost=0.01..1.00 rows=100 width=32) (actual time=0.029..0.029 rows=0 loops=1)
  87. CTE record_label
  88. -> CTE Scan on item item_23 (cost=0.00..0.27 rows=1 width=32) (actual time=1.572..1.573 rows=1 loops=1)
  89. CTE position
  90. -> CTE Scan on item item_24 (cost=0.00..0.27 rows=1 width=32) (actual time=0.646..0.647 rows=1 loops=1)
  91. CTE musicbrainz
  92. -> CTE Scan on item item_25 (cost=0.00..0.02 rows=1 width=32) (actual time=0.059..0.061 rows=1 loops=1)
  93. CTE partner
  94. -> Aggregate (cost=103.53..103.54 rows=1 width=32) (actual time=0.027..0.028 rows=1 loops=1)
  95. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.024..0.024 rows=0 loops=1)
  96. -> CTE Scan on item item_26 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)
  97. -> Function Scan on jsonb_array_elements jsonb_array_elements_8 (cost=0.01..1.00 rows=100 width=32) (actual time=0.022..0.022 rows=0 loops=1)
  98. CTE origin
  99. -> CTE Scan on item item_27 (cost=0.00..0.27 rows=1 width=32) (actual time=0.032..0.033 rows=1 loops=1)
  100. CTE cause_of_death
  101. -> CTE Scan on item item_28 (cost=0.00..0.27 rows=1 width=32) (actual time=0.020..0.021 rows=1 loops=1)
  102. CTE members
  103. -> Aggregate (cost=103.53..103.54 rows=1 width=32) (actual time=0.032..0.032 rows=1 loops=1)
  104. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.029..0.029 rows=0 loops=1)
  105. -> CTE Scan on item item_29 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)
  106. -> Function Scan on jsonb_array_elements jsonb_array_elements_9 (cost=0.01..1.00 rows=100 width=32) (actual time=0.025..0.025 rows=0 loops=1)
  107. CTE residence
  108. -> CTE Scan on item item_30 (cost=0.00..0.27 rows=1 width=32) (actual time=2.917..2.918 rows=1 loops=1)
  109. CTE hand
  110. -> CTE Scan on item item_31 (cost=0.00..0.27 rows=1 width=32) (actual time=0.074..0.075 rows=1 loops=1)
  111. CTE coordinate
  112. -> CTE Scan on item item_32 (cost=0.00..0.27 rows=1 width=32) (actual time=0.029..0.030 rows=1 loops=1)
  113. CTE birthday
  114. -> CTE Scan on item item_33 (cost=0.00..0.27 rows=1 width=32) (actual time=0.385..0.386 rows=1 loops=1)
  115. CTE death
  116. -> CTE Scan on item item_34 (cost=0.00..0.27 rows=1 width=32) (actual time=0.026..0.026 rows=1 loops=1)
  117. CTE start
  118. -> CTE Scan on item item_35 (cost=0.00..0.27 rows=1 width=32) (actual time=0.040..0.040 rows=1 loops=1)
  119. CTE publication
  120. -> CTE Scan on item item_36 (cost=0.00..0.27 rows=1 width=32) (actual time=0.037..0.038 rows=1 loops=1)
  121. CTE sport
  122. -> CTE Scan on item item_37 (cost=0.00..0.27 rows=1 width=32) (actual time=0.988..0.989 rows=1 loops=1)
  123. CTE drafted
  124. -> CTE Scan on item item_38 (cost=0.00..0.27 rows=1 width=32) (actual time=0.477..0.479 rows=1 loops=1)
  125. CTE given_name
  126. -> CTE Scan on item item_39 (cost=0.00..0.27 rows=1 width=32) (actual time=0.483..0.485 rows=1 loops=1)
  127. CTE influences
  128. -> CTE Scan on item item_40 (cost=0.00..0.27 rows=1 width=32) (actual time=0.050..0.051 rows=1 loops=1)
  129. CTE location
  130. -> CTE Scan on item item_41 (cost=0.00..0.27 rows=1 width=32) (actual time=0.024..0.025 rows=1 loops=1)
  131. CTE website
  132. -> CTE Scan on item item_42 (cost=0.00..0.02 rows=1 width=32) (actual time=0.139..0.140 rows=1 loops=1)
  133. CTE population
  134. -> Aggregate (cost=53.03..53.04 rows=1 width=32) (actual time=0.038..0.038 rows=1 loops=1)
  135. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.036..0.036 rows=0 loops=1)
  136. -> CTE Scan on item item_43 (cost=0.00..0.02 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=1)
  137. -> Function Scan on jsonb_array_elements jsonb_array_elements_10 (cost=0.01..1.00 rows=100 width=32) (actual time=0.031..0.031 rows=0 loops=1)
  138. CTE instrument
  139. -> Aggregate (cost=53.03..53.04 rows=1 width=32) (actual time=48.731..48.731 rows=1 loops=1)
  140. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.039..0.044 rows=1 loops=1)
  141. -> CTE Scan on item item_44 (cost=0.00..0.02 rows=1 width=32) (actual time=0.000..0.002 rows=1 loops=1)
  142. -> Function Scan on jsonb_array_elements jsonb_array_elements_11 (cost=0.01..1.00 rows=100 width=32) (actual time=0.033..0.034 rows=1 loops=1)
  143. CTE participant
  144. -> CTE Scan on item item_45 (cost=0.00..0.27 rows=1 width=32) (actual time=49.190..49.191 rows=1 loops=1)
  145. CTE nominations
  146. -> Aggregate (cost=78.28..78.29 rows=1 width=32) (actual time=103.895..103.895 rows=1 loops=1)
  147. -> Nested Loop (cost=0.01..2.02 rows=100 width=32) (actual time=0.046..0.063 rows=16 loops=1)
  148. -> CTE Scan on item item_46 (cost=0.00..0.02 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=1)
  149. -> Function Scan on jsonb_array_elements jsonb_array_elements_12 (cost=0.01..1.00 rows=100 width=32) (actual time=0.041..0.046 rows=16 loops=1)
  150. CTE languages
  151. -> CTE Scan on item item_47 (cost=0.00..0.27 rows=1 width=32) (actual time=0.030..0.031 rows=1 loops=1)
  152. CTE birth_name
  153. -> CTE Scan on item item_48 (cost=0.00..0.02 rows=1 width=32) (actual time=0.051..0.052 rows=1 loops=1)
  154. CTE spotify
  155. -> CTE Scan on item item_49 (cost=0.00..0.02 rows=1 width=32) (actual time=0.034..0.035 rows=1 loops=1)
  156. CTE usda
  157. -> CTE Scan on item item_50 (cost=0.00..0.02 rows=1 width=32) (actual time=0.036..0.037 rows=1 loops=1)
  158. CTE twitter
  159. -> CTE Scan on item item_51 (cost=0.00..0.02 rows=1 width=32) (actual time=0.030..0.031 rows=1 loops=1)
  160. CTE instagram
  161. -> CTE Scan on item item_52 (cost=0.00..0.02 rows=1 width=32) (actual time=0.056..0.057 rows=1 loops=1)
  162. CTE facebook
  163. -> CTE Scan on item item_53 (cost=0.00..0.02 rows=1 width=32) (actual time=0.054..0.056 rows=1 loops=1)
  164. CTE youtube
  165. -> CTE Scan on item item_54 (cost=0.00..0.02 rows=1 width=32) (actual time=0.025..0.027 rows=1 loops=1)
  166. CTE work_start
  167. -> CTE Scan on item item_55 (cost=0.00..0.27 rows=1 width=32) (actual time=0.038..0.039 rows=1 loops=1)
  168. CTE height
  169. -> CTE Scan on item item_56 (cost=0.00..0.27 rows=1 width=32) (actual time=1.196..1.197 rows=1 loops=1)
  170. CTE weight
  171. -> CTE Scan on item item_57 (cost=0.00..0.27 rows=1 width=32) (actual time=1.025..1.027 rows=1 loops=1)
  172. CTE siblings
  173. -> CTE Scan on item item_58 (cost=0.00..0.27 rows=1 width=32) (actual time=0.025..0.026 rows=1 loops=1)
  174. -> Nested Loop (cost=0.00..1.73 rows=1 width=2112) (actual time=885.273..885.394 rows=1 loops=1)
  175. -> Nested Loop (cost=0.00..1.70 rows=1 width=2080) (actual time=885.245..885.362 rows=1 loops=1)
  176. -> Nested Loop (cost=0.00..1.67 rows=1 width=2048) (actual time=885.212..885.328 rows=1 loops=1)
  177. -> Nested Loop (cost=0.00..1.64 rows=1 width=2016) (actual time=884.262..884.374 rows=1 loops=1)
  178. -> Nested Loop (cost=0.00..1.61 rows=1 width=1984) (actual time=834.274..834.384 rows=1 loops=1)
  179. -> Nested Loop (cost=0.00..1.58 rows=1 width=1952) (actual time=834.211..834.319 rows=1 loops=1)
  180. -> Nested Loop (cost=0.00..1.55 rows=1 width=1920) (actual time=831.994..832.099 rows=1 loops=1)
  181. -> Nested Loop (cost=0.00..1.52 rows=1 width=1888) (actual time=831.639..831.742 rows=1 loops=1)
  182. -> Nested Loop (cost=0.00..1.49 rows=1 width=1856) (actual time=829.641..829.742 rows=1 loops=1)
  183. -> Nested Loop (cost=0.00..1.46 rows=1 width=1568) (actual time=829.639..829.740 rows=1 loops=1)
  184. -> Nested Loop (cost=0.00..1.43 rows=1 width=1536) (actual time=829.603..829.701 rows=1 loops=1)
  185. -> Nested Loop (cost=0.00..1.40 rows=1 width=1504) (actual time=829.546..829.642 rows=1 loops=1)
  186. -> Nested Loop (cost=0.00..1.37 rows=1 width=1472) (actual time=730.151..730.245 rows=1 loops=1)
  187. -> Nested Loop (cost=0.00..1.34 rows=1 width=1440) (actual time=730.115..730.207 rows=1 loops=1)
  188. -> Nested Loop (cost=0.00..1.31 rows=1 width=1408) (actual time=730.074..730.164 rows=1 loops=1)
  189. -> Nested Loop (cost=0.00..1.28 rows=1 width=1376) (actual time=730.039..730.126 rows=1 loops=1)
  190. -> Nested Loop (cost=0.00..1.25 rows=1 width=1344) (actual time=729.384..729.468 rows=1 loops=1)
  191. -> Nested Loop (cost=0.00..1.22 rows=1 width=1312) (actual time=567.528..567.611 rows=1 loops=1)
  192. -> Nested Loop (cost=0.00..1.19 rows=1 width=1280) (actual time=503.494..503.576 rows=1 loops=1)
  193. -> Nested Loop (cost=0.00..1.16 rows=1 width=1248) (actual time=502.583..502.663 rows=1 loops=1)
  194. -> Nested Loop (cost=0.00..1.13 rows=1 width=1216) (actual time=502.529..502.606 rows=1 loops=1)
  195. -> Nested Loop (cost=0.00..1.10 rows=1 width=1184) (actual time=453.774..453.850 rows=1 loops=1)
  196. -> Nested Loop (cost=0.00..1.07 rows=1 width=1152) (actual time=453.737..453.811 rows=1 loops=1)
  197. -> Nested Loop (cost=0.00..1.04 rows=1 width=1120) (actual time=453.704..453.776 rows=1 loops=1)
  198. -> Nested Loop (cost=0.00..1.01 rows=1 width=1088) (actual time=453.217..453.286 rows=1 loops=1)
  199. -> Nested Loop (cost=0.00..0.98 rows=1 width=1056) (actual time=453.176..453.243 rows=1 loops=1)
  200. -> Nested Loop (cost=0.00..0.95 rows=1 width=1024) (actual time=452.146..452.211 rows=1 loops=1)
  201. -> Nested Loop (cost=0.00..0.92 rows=1 width=992) (actual time=452.109..452.171 rows=1 loops=1)
  202. -> Nested Loop (cost=0.00..0.89 rows=1 width=960) (actual time=450.531..450.590 rows=1 loops=1)
  203. -> Nested Loop (cost=0.00..0.86 rows=1 width=928) (actual time=398.431..398.489 rows=1 loops=1)
  204. -> Nested Loop (cost=0.00..0.83 rows=1 width=896) (actual time=395.479..395.534 rows=1 loops=1)
  205. -> Nested Loop (cost=0.00..0.80 rows=1 width=864) (actual time=395.433..395.486 rows=1 loops=1)
  206. -> Nested Loop (cost=0.00..0.77 rows=1 width=832) (actual time=346.236..346.287 rows=1 loops=1)
  207. -> Nested Loop (cost=0.00..0.74 rows=1 width=800) (actual time=242.313..242.363 rows=1 loops=1)
  208. -> Nested Loop (cost=0.00..0.71 rows=1 width=768) (actual time=241.921..241.969 rows=1 loops=1)
  209. -> Nested Loop (cost=0.00..0.68 rows=1 width=736) (actual time=241.424..241.468 rows=1 loops=1)
  210. -> Nested Loop (cost=0.00..0.65 rows=1 width=704) (actual time=241.392..241.435 rows=1 loops=1)
  211. -> Nested Loop (cost=0.00..0.62 rows=1 width=672) (actual time=240.190..240.231 rows=1 loops=1)
  212. -> Nested Loop (cost=0.00..0.59 rows=1 width=640) (actual time=240.152..240.192 rows=1 loops=1)
  213. -> Nested Loop (cost=0.00..0.56 rows=1 width=608) (actual time=240.099..240.136 rows=1 loops=1)
  214. -> Nested Loop (cost=0.00..0.53 rows=1 width=576) (actual time=192.272..192.307 rows=1 loops=1)
  215. -> Nested Loop (cost=0.00..0.50 rows=1 width=544) (actual time=192.231..192.263 rows=1 loops=1)
  216. -> Nested Loop (cost=0.00..0.47 rows=1 width=512) (actual time=192.191..192.220 rows=1 loops=1)
  217. -> Nested Loop (cost=0.00..0.44 rows=1 width=480) (actual time=192.148..192.175 rows=1 loops=1)
  218. -> Nested Loop (cost=0.00..0.41 rows=1 width=448) (actual time=190.705..190.730 rows=1 loops=1)
  219. -> Nested Loop (cost=0.00..0.38 rows=1 width=416) (actual time=190.652..190.676 rows=1 loops=1)
  220. -> Nested Loop (cost=0.00..0.35 rows=1 width=384) (actual time=190.593..190.616 rows=1 loops=1)
  221. -> Nested Loop (cost=0.00..0.32 rows=1 width=352) (actual time=138.390..138.410 rows=1 loops=1)
  222. -> Nested Loop (cost=0.00..0.29 rows=1 width=320) (actual time=138.361..138.380 rows=1 loops=1)
  223. -> Nested Loop (cost=0.00..0.26 rows=1 width=288) (actual time=138.333..138.350 rows=1 loops=1)
  224. -> Nested Loop (cost=0.00..0.23 rows=1 width=256) (actual time=138.299..138.314 rows=1 loops=1)
  225. -> Nested Loop (cost=0.00..0.20 rows=1 width=224) (actual time=137.306..137.318 rows=1 loops=1)
  226. -> Nested Loop (cost=0.00..0.17 rows=1 width=192) (actual time=136.295..136.306 rows=1 loops=1)
  227. -> Nested Loop (cost=0.00..0.14 rows=1 width=160) (actual time=136.258..136.267 rows=1 loops=1)
  228. -> Nested Loop (cost=0.00..0.11 rows=1 width=128) (actual time=0.215..0.222 rows=1 loops=1)
  229. -> Nested Loop (cost=0.00..0.08 rows=1 width=96) (actual time=0.192..0.196 rows=1 loops=1)
  230. -> Nested Loop (cost=0.00..0.05 rows=1 width=64) (actual time=0.166..0.169 rows=1 loops=1)
  231. -> CTE Scan on website (cost=0.00..0.02 rows=1 width=32) (actual time=0.140..0.141 rows=1 loops=1)
  232. -> CTE Scan on location (cost=0.00..0.02 rows=1 width=32) (actual time=0.025..0.026 rows=1 loops=1)
  233. -> CTE Scan on siblings (cost=0.00..0.02 rows=1 width=32) (actual time=0.025..0.026 rows=1 loops=1)
  234. -> CTE Scan on cause_of_death (cost=0.00..0.02 rows=1 width=32) (actual time=0.023..0.024 rows=1 loops=1)
  235. -> CTE Scan on awards (cost=0.00..0.02 rows=1 width=32) (actual time=136.042..136.043 rows=1 loops=1)
  236. -> CTE Scan on signature (cost=0.00..0.02 rows=1 width=32) (actual time=0.035..0.037 rows=1 loops=1)
  237. -> CTE Scan on genre (cost=0.00..0.02 rows=1 width=32) (actual time=1.009..1.010 rows=1 loops=1)
  238. -> CTE Scan on sport (cost=0.00..0.02 rows=1 width=32) (actual time=0.991..0.993 rows=1 loops=1)
  239. -> CTE Scan on mother (cost=0.00..0.02 rows=1 width=32) (actual time=0.032..0.034 rows=1 loops=1)
  240. -> CTE Scan on death (cost=0.00..0.02 rows=1 width=32) (actual time=0.027..0.029 rows=1 loops=1)
  241. -> CTE Scan on partner (cost=0.00..0.02 rows=1 width=32) (actual time=0.027..0.028 rows=1 loops=1)
  242. -> CTE Scan on father (cost=0.00..0.02 rows=1 width=32) (actual time=52.202..52.203 rows=1 loops=1)
  243. -> CTE Scan on instagram (cost=0.00..0.02 rows=1 width=32) (actual time=0.058..0.059 rows=1 loops=1)
  244. -> CTE Scan on capital (cost=0.00..0.02 rows=1 width=32) (actual time=0.051..0.051 rows=1 loops=1)
  245. -> CTE Scan on instance (cost=0.00..0.02 rows=1 width=32) (actual time=1.441..1.442 rows=1 loops=1)
  246. -> CTE Scan on start (cost=0.00..0.02 rows=1 width=32) (actual time=0.042..0.044 rows=1 loops=1)
  247. -> CTE Scan on work_start (cost=0.00..0.02 rows=1 width=32) (actual time=0.039..0.040 rows=1 loops=1)
  248. -> CTE Scan on usda (cost=0.00..0.02 rows=1 width=32) (actual time=0.038..0.039 rows=1 loops=1)
  249. -> CTE Scan on country_of_citizenship (cost=0.00..0.02 rows=1 width=32) (actual time=47.825..47.827 rows=1 loops=1)
  250. -> CTE Scan on influences (cost=0.00..0.02 rows=1 width=32) (actual time=0.051..0.052 rows=1 loops=1)
  251. -> CTE Scan on country (cost=0.00..0.02 rows=1 width=32) (actual time=0.036..0.037 rows=1 loops=1)
  252. -> CTE Scan on height (cost=0.00..0.02 rows=1 width=32) (actual time=1.199..1.201 rows=1 loops=1)
  253. -> CTE Scan on languages (cost=0.00..0.02 rows=1 width=32) (actual time=0.032..0.033 rows=1 loops=1)
  254. -> CTE Scan on given_name (cost=0.00..0.02 rows=1 width=32) (actual time=0.494..0.496 rows=1 loops=1)
  255. -> CTE Scan on birthday (cost=0.00..0.02 rows=1 width=32) (actual time=0.391..0.392 rows=1 loops=1)
  256. -> CTE Scan on nominations (cost=0.00..0.02 rows=1 width=32) (actual time=103.921..103.921 rows=1 loops=1)
  257. -> CTE Scan on participant (cost=0.00..0.02 rows=1 width=32) (actual time=49.194..49.196 rows=1 loops=1)
  258. -> CTE Scan on currency (cost=0.00..0.02 rows=1 width=32) (actual time=0.044..0.046 rows=1 loops=1)
  259. -> CTE Scan on residence (cost=0.00..0.02 rows=1 width=32) (actual time=2.950..2.951 rows=1 loops=1)
  260. -> CTE Scan on hand (cost=0.00..0.02 rows=1 width=32) (actual time=52.099..52.100 rows=1 loops=1)
  261. -> CTE Scan on record_label (cost=0.00..0.02 rows=1 width=32) (actual time=1.576..1.578 rows=1 loops=1)
  262. -> CTE Scan on flag (cost=0.00..0.02 rows=1 width=32) (actual time=0.035..0.036 rows=1 loops=1)
  263. -> CTE Scan on weight (cost=0.00..0.02 rows=1 width=32) (actual time=1.027..1.029 rows=1 loops=1)
  264. -> CTE Scan on population (cost=0.00..0.02 rows=1 width=32) (actual time=0.039..0.040 rows=1 loops=1)
  265. -> CTE Scan on drafted (cost=0.00..0.02 rows=1 width=32) (actual time=0.485..0.487 rows=1 loops=1)
  266. -> CTE Scan on coordinate (cost=0.00..0.02 rows=1 width=32) (actual time=0.030..0.031 rows=1 loops=1)
  267. -> CTE Scan on spotify (cost=0.00..0.02 rows=1 width=32) (actual time=0.036..0.038 rows=1 loops=1)
  268. -> CTE Scan on instrument (cost=0.00..0.02 rows=1 width=32) (actual time=48.752..48.753 rows=1 loops=1)
  269. -> CTE Scan on birth_name (cost=0.00..0.02 rows=1 width=32) (actual time=0.053..0.055 rows=1 loops=1)
  270. -> CTE Scan on ethnicity (cost=0.00..0.02 rows=1 width=32) (actual time=0.910..0.913 rows=1 loops=1)
  271. -> CTE Scan on education (cost=0.00..0.02 rows=1 width=32) (actual time=64.033..64.033 rows=1 loops=1)
  272. -> CTE Scan on teams (cost=0.00..0.02 rows=1 width=32) (actual time=161.854..161.854 rows=1 loops=1)
  273. -> CTE Scan on "position" (cost=0.00..0.02 rows=1 width=32) (actual time=0.652..0.653 rows=1 loops=1)
  274. -> CTE Scan on origin (cost=0.00..0.02 rows=1 width=32) (actual time=0.032..0.034 rows=1 loops=1)
  275. -> CTE Scan on publication (cost=0.00..0.02 rows=1 width=32) (actual time=0.039..0.040 rows=1 loops=1)
  276. -> CTE Scan on military (cost=0.00..0.02 rows=1 width=32) (actual time=0.035..0.035 rows=1 loops=1)
  277. -> CTE Scan on occupation (cost=0.00..0.02 rows=1 width=32) (actual time=99.392..99.394 rows=1 loops=1)
  278. -> CTE Scan on facebook (cost=0.00..0.02 rows=1 width=32) (actual time=0.055..0.057 rows=1 loops=1)
  279. -> CTE Scan on members (cost=0.00..0.02 rows=1 width=32) (actual time=0.034..0.034 rows=1 loops=1)
  280. -> CTE Scan on item (cost=0.00..0.02 rows=1 width=288) (actual time=0.000..0.000 rows=1 loops=1)
  281. -> CTE Scan on birthplace (cost=0.00..0.02 rows=1 width=32) (actual time=1.996..1.997 rows=1 loops=1)
  282. -> CTE Scan on image (cost=0.00..0.02 rows=1 width=32) (actual time=0.351..0.353 rows=1 loops=1)
  283. -> CTE Scan on religion (cost=0.00..0.02 rows=1 width=32) (actual time=2.215..2.217 rows=1 loops=1)
  284. -> CTE Scan on musicbrainz (cost=0.00..0.02 rows=1 width=32) (actual time=0.061..0.063 rows=1 loops=1)
  285. -> CTE Scan on spouse (cost=0.00..0.02 rows=1 width=32) (actual time=49.985..49.985 rows=1 loops=1)
  286. -> CTE Scan on sex (cost=0.00..0.02 rows=1 width=32) (actual time=0.947..0.949 rows=1 loops=1)
  287. -> CTE Scan on twitter (cost=0.00..0.02 rows=1 width=32) (actual time=0.032..0.033 rows=1 loops=1)
  288. -> CTE Scan on youtube (cost=0.00..0.02 rows=1 width=32) (actual time=0.026..0.028 rows=1 loops=1)
  289. -> CTE Scan on interment (cost=0.00..0.02 rows=1 width=32) (actual time=0.042..0.044 rows=1 loops=1)
  290. Planning time: 1010.487 ms
  291. Execution time: 5692.599 ms
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!