API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 18th, 2019
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 36.93 KB | None | 0 0
raw download clone embed print report
  1. Limit (cost=1270713704901112775049216.00..1270713704901112775049216.00 rows=100 width=304)
  2. -> Sort (cost=1270713704901112775049216.00..1297028717483153898340352.00 rows=10526005032816410661748736 width=304)
  3. Sort Key: t_s_secyear.customer_id, t_s_secyear.customer_first_name, t_s_secyear.customer_last_name, t_s_secyear.customer_email_address
  4. -> Merge Join (cost=40013363189.88..868417361282644477739008.00 rows=10526005032816410661748736 width=304)
  5. Merge Cond: ((t_s_secyear.customer_id)::text = (t_c_secyear.customer_id)::text)
  6. Join Filter: (CASE WHEN (t_c_firstyear.year_total > 0::numeric) THEN (t_c_secyear.year_total / t_c_firstyear.year_total) ELSE NULL::numeric END > CASE WHEN (t_s_firstyear.year_total > 0::numeric) THEN (t_s_secyear.year_total / t_s_firstyear.year_total) ELSE NULL::numeric END)
  7. -> Merge Join (cost=10012203931.76..12172316972.30 rows=144001536005 width=418)
  8. Merge Cond: ((t_s_firstyear.customer_id)::text = (t_s_secyear.customer_id)::text)
  9. -> Sort (cost=3763325.13..3793325.29 rows=375002 width=82)
  10. Sort Key: t_s_firstyear.customer_id
  11. -> Subquery Scan on t_s_firstyear (cost=0.00..240001.28 rows=12000064 width=82)
  12. -> Append (cost=47466749.73..48355947.26 rows=12000064 width=181)
  13. -> Gather Motion 32:1 (slice4; segments: 32) (cost=47466749.73..48355945.74 rows=12000000 width=181)
  14. -> HashAggregate (cost=47466749.73..47995945.74 rows=375000 width=482)
  15. Group Key: customer.c_customer_id, customer.c_first_name, customer.c_last_name, customer.c_preferred_cust_flag, customer.c_birth_country, customer.c_login, customer.c_email_address, date_dim.d_year
  16. Filter: (sum(((((store_sales_1_prt_others.ss_ext_list_price - store_sales_1_prt_others.ss_ext_wholesale_cost) - store_sales_1_prt_others.ss_ext_discount_amt) + store_sales_1_prt_others.ss_ext_sales_price) / 2::numeric)) > 0::numeric)
  17. -> Redistribute Motion 32:32 (slice3; segments: 32) (cost=366017.74..46556569.36 rows=410406 width=139)
  18. Hash Key: customer.c_customer_id, customer.c_first_name, customer.c_last_name, customer.c_preferred_cust_flag, customer.c_birth_country, customer.c_login, customer.c_email_address, date_dim.d_year
  19. -> Hash Join (cost=366017.74..46293909.64 rows=410406 width=139)
  20. Hash Cond: (store_sales_1_prt_others.ss_customer_sk = customer.c_customer_sk)
  21. -> Redistribute Motion 32:32 (slice2; segments: 32) (cost=1440.74..45457604.90 rows=429748 width=30)
  22. Hash Key: store_sales_1_prt_others.ss_customer_sk
  23. -> Hash Join (cost=1440.74..45182566.18 rows=429748 width=30)
  24. Hash Cond: (store_sales_1_prt_others.ss_sold_date_sk = date_dim.d_date_sk)
  25. -> Append (cost=0.00..34243650.96 rows=89999626 width=30)
  26. -> Result (cost=0.00..1444840.40 rows=4050027 width=30)
  27. One-Time Filter: PartSelected
  28. -> Seq Scan on store_sales_1_prt_others (cost=0.00..1444840.40 rows=4050027 width=30)
  29. -> Result (cost=0.00..93694.76 rows=245472 width=30)
  30. One-Time Filter: PartSelected
  31. -> Seq Scan on store_sales_1_prt_2 (cost=0.00..93694.76 rows=245472 width=30)
  32. -> Hash (cost=1294.64..1294.64 rows=366 width=8)
  33. -> Partition Selector for store_sales (dynamic scan id: 1) (cost=0.00..1294.64 rows=366 width=8)
  34. Filter: date_dim.d_date_sk
  35. -> Broadcast Motion 32:32 (slice1; segments: 32) (cost=0.00..1294.64 rows=366 width=8)
  36. -> Seq Scan on date_dim (cost=0.00..1174.11 rows=12 width=8)
  37. Filter: (d_year = 1998)
  38. -> Hash (cost=161842.00..161842.00 rows=375000 width=117)
  39. -> Seq Scan on customer (cost=0.00..161842.00 rows=375000 width=117)
  40. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  41. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  42. -> Result (cost=0.00..0.01 rows=1 width=0)
  43. One-Time Filter: false
  44. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  45. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  46. -> Result (cost=0.00..0.01 rows=1 width=0)
  47. One-Time Filter: false
  48. -> Materialize (cost=8440606.63..8500606.95 rows=375002 width=336)
  49. -> Sort (cost=8440606.63..8470606.79 rows=375002 width=336)
  50. Sort Key: t_s_secyear.customer_id
  51. -> Subquery Scan on t_s_secyear (cost=0.00..240001.28 rows=12000064 width=336)
  52. -> Append (cost=47244799.93..48016209.97 rows=12000064 width=181)
  53. -> Gather Motion 32:1 (slice8; segments: 32) (cost=47244799.93..48016208.45 rows=12000000 width=181)
  54. -> HashAggregate (cost=47244799.93..47656208.45 rows=375000 width=482)
  55. Group Key: customer_1.c_customer_id, customer_1.c_first_name, customer_1.c_last_name, customer_1.c_preferred_cust_flag, customer_1.c_birth_country, customer_1.c_login, customer_1.c_email_address, date_dim_1.d_year
  56. -> Redistribute Motion 32:32 (slice7; segments: 32) (cost=366017.74..46556569.36 rows=410406 width=139)
  57. Hash Key: customer_1.c_customer_id, customer_1.c_first_name, customer_1.c_last_name, customer_1.c_preferred_cust_flag, customer_1.c_birth_country, customer_1.c_login, customer_1.c_email_address, date_dim_1.d_year
  58. -> Hash Join (cost=366017.74..46293909.64 rows=410406 width=139)
  59. Hash Cond: (store_sales_1_prt_others_1.ss_customer_sk = customer_1.c_customer_sk)
  60. -> Redistribute Motion 32:32 (slice6; segments: 32) (cost=1440.74..45457604.90 rows=429748 width=30)
  61. Hash Key: store_sales_1_prt_others_1.ss_customer_sk
  62. -> Hash Join (cost=1440.74..45182566.18 rows=429748 width=30)
  63. Hash Cond: (store_sales_1_prt_others_1.ss_sold_date_sk = date_dim_1.d_date_sk)
  64. -> Append (cost=0.00..34243650.96 rows=89999626 width=30)
  65. -> Result (cost=0.00..1444840.40 rows=4050027 width=30)
  66. One-Time Filter: PartSelected
  67. -> Seq Scan on store_sales_1_prt_others store_sales_1_prt_others_1 (cost=0.00..1444840.40 rows=4050027 width=30)
  68. -> Result (cost=0.00..93694.76 rows=245472 width=30)
  69. One-Time Filter: PartSelected
  70. -> Seq Scan on store_sales_1_prt_2 store_sales_1_prt_2_1 (cost=0.00..93694.76 rows=245472 width=30)
  71. -> Hash (cost=1294.64..1294.64 rows=366 width=8)
  72. -> Partition Selector for store_sales (dynamic scan id: 1) (cost=0.00..1294.64 rows=366 width=8)
  73. Filter: date_dim_1.d_date_sk
  74. -> Broadcast Motion 32:32 (slice5; segments: 32) (cost=0.00..1294.64 rows=366 width=8)
  75. -> Seq Scan on date_dim date_dim_1 (cost=0.00..1174.11 rows=12 width=8)
  76. Filter: (d_year = 1999)
  77. -> Hash (cost=161842.00..161842.00 rows=375000 width=117)
  78. -> Seq Scan on customer customer_1 (cost=0.00..161842.00 rows=375000 width=117)
  79. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  80. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  81. -> Result (cost=0.00..0.01 rows=1 width=0)
  82. One-Time Filter: false
  83. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  84. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  85. -> Result (cost=0.00..0.01 rows=1 width=0)
  86. One-Time Filter: false
  87. -> Materialize (cost=20001159258.12..21946623491724881920.00 rows=6852794763234118 width=264)
  88. -> Nested Loop (cost=20001159258.12..21946075268143824896.00 rows=219289432423491776 width=264)
  89. Join Filter: (((t_c_secyear.customer_id)::text = (t_w_firstyear.customer_id)::text) AND (CASE WHEN (t_c_firstyear.year_total > 0::numeric) THEN (t_c_secyear.year_total / t_c_firstyear.year_total) ELSE NULL::numeric END > CASE WHEN (t_w_firstyear.year_total > 0::numeric) THEN (t_w_secyear.year_total / t_w_firstyear.year_total) ELSE NULL::numeric END))
  90. -> Merge Join (cost=10000927593.96..10195168001.79 rows=12947561386 width=164)
  91. Merge Cond: ((t_w_firstyear.customer_id)::text = (t_w_secyear.customer_id)::text)
  92. -> Sort (cost=463796.98..472792.66 rows=112446 width=82)
  93. Sort Key: t_w_firstyear.customer_id
  94. -> Subquery Scan on t_w_firstyear (cost=0.00..71965.44 rows=3598272 width=82)
  95. -> Append (cost=0.04..13358758.26 rows=3598272 width=482)
  96. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  97. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  98. -> Result (cost=0.00..0.01 rows=1 width=0)
  99. One-Time Filter: false
  100. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  101. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  102. -> Result (cost=0.00..0.01 rows=1 width=0)
  103. One-Time Filter: false
  104. -> Gather Motion 32:1 (slice12; segments: 32) (cost=13127804.39..13358756.74 rows=3598208 width=482)
  105. -> HashAggregate (cost=13127804.39..13250810.50 rows=112444 width=482)
  106. Group Key: customer_2.c_customer_id, customer_2.c_first_name, customer_2.c_last_name, customer_2.c_preferred_cust_flag, customer_2.c_birth_country, customer_2.c_login, customer_2.c_email_address, date_dim_2.d_year
  107. Filter: (pg_catalog.sum((sum(((((web_sales_1_prt_others.ws_ext_list_price - web_sales_1_prt_others.ws_ext_wholesale_cost) - web_sales_1_prt_others.ws_ext_discount_amt) + web_sales_1_prt_others.ws_ext_sales_price) / 2::numeric)))) > 0::numeric)
  108. -> Redistribute Motion 32:32 (slice11; segments: 32) (cost=12808131.70..12909100.95 rows=90152 width=450)
  109. Hash Key: customer_2.c_customer_id, customer_2.c_first_name, customer_2.c_last_name, customer_2.c_preferred_cust_flag, customer_2.c_birth_country, customer_2.c_login, customer_2.c_email_address, date_dim_2.d_year
  110. -> HashAggregate (cost=12808131.70..12851404.24 rows=90152 width=450)
  111. Group Key: customer_2.c_customer_id, customer_2.c_first_name, customer_2.c_last_name, customer_2.c_preferred_cust_flag, customer_2.c_birth_country, customer_2.c_login, customer_2.c_email_address, date_dim_2.d_year
  112. -> Hash Join (cost=366017.74..12646211.51 rows=112445 width=142)
  113. Hash Cond: (web_sales_1_prt_others.ws_bill_customer_sk = customer_2.c_customer_sk)
  114. -> Redistribute Motion 32:32 (slice10; segments: 32) (cost=1440.74..12115872.96 rows=112472 width=33)
  115. Hash Key: web_sales_1_prt_others.ws_bill_customer_sk
  116. -> Hash Join (cost=1440.74..12043890.91 rows=112472 width=33)
  117. Hash Cond: (web_sales_1_prt_others.ws_sold_date_sk = date_dim_2.d_date_sk)
  118. -> Append (cost=0.00..9306457.72 rows=22500012 width=33)
  119. -> Result (cost=0.00..2154.21 rows=5623 width=33)
  120. One-Time Filter: PartSelected
  121. -> Seq Scan on web_sales_1_prt_others (cost=0.00..2154.21 rows=5623 width=33)
  122. -> Result (cost=0.00..114696.50 rows=277233 width=33)
  123. One-Time Filter: PartSelected
  124. -> Seq Scan on web_sales_1_prt_2 (cost=0.00..114696.50 rows=277233 width=33)
  125. -> Hash (cost=1294.64..1294.64 rows=366 width=8)
  126. -> Partition Selector for web_sales (dynamic scan id: 1) (cost=0.00..1294.64 rows=366 width=8)
  127. Filter: date_dim_2.d_date_sk
  128. -> Broadcast Motion 32:32 (slice9; segments: 32) (cost=0.00..1294.64 rows=366 width=8)
  129. -> Seq Scan on date_dim date_dim_2 (cost=0.00..1174.11 rows=12 width=8)
  130. Filter: (d_year = 1998)
  131. -> Hash (cost=161842.00..161842.00 rows=375000 width=117)
  132. -> Seq Scan on customer customer_2 (cost=0.00..161842.00 rows=375000 width=117)
  133. -> Materialize (cost=463796.98..481788.34 rows=112446 width=82)
  134. -> Sort (cost=463796.98..472792.66 rows=112446 width=82)
  135. Sort Key: t_w_secyear.customer_id
  136. -> Subquery Scan on t_w_secyear (cost=0.00..71965.44 rows=3598272 width=82)
  137. -> Append (cost=0.04..13105538.61 rows=3598272 width=181)
  138. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  139. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  140. -> Result (cost=0.00..0.01 rows=1 width=0)
  141. One-Time Filter: false
  142. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  143. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  144. -> Result (cost=0.00..0.01 rows=1 width=0)
  145. One-Time Filter: false
  146. -> Gather Motion 32:1 (slice16; segments: 32) (cost=12893865.82..13105537.08 rows=3598208 width=181)
  147. -> HashAggregate (cost=12893865.82..12997590.84 rows=112444 width=482)
  148. Group Key: customer_3.c_customer_id, customer_3.c_first_name, customer_3.c_last_name, customer_3.c_preferred_cust_flag, customer_3.c_birth_country, customer_3.c_login, customer_3.c_email_address, date_dim_3.d_year
  149. -> Redistribute Motion 32:32 (slice15; segments: 32) (cost=366017.74..12718176.04 rows=112445 width=142)
  150. Hash Key: customer_3.c_customer_id, customer_3.c_first_name, customer_3.c_last_name, customer_3.c_preferred_cust_flag, customer_3.c_birth_country, customer_3.c_login, customer_3.c_email_address, date_dim_3.d_year
  151. -> Hash Join (cost=366017.74..12646211.51 rows=112445 width=142)
  152. Hash Cond: (web_sales_1_prt_others_1.ws_bill_customer_sk = customer_3.c_customer_sk)
  153. -> Redistribute Motion 32:32 (slice14; segments: 32) (cost=1440.74..12115872.96 rows=112472 width=33)
  154. Hash Key: web_sales_1_prt_others_1.ws_bill_customer_sk
  155. -> Hash Join (cost=1440.74..12043890.91 rows=112472 width=33)
  156. Hash Cond: (web_sales_1_prt_others_1.ws_sold_date_sk = date_dim_3.d_date_sk)
  157. -> Append (cost=0.00..9306457.72 rows=22500012 width=33)
  158. -> Result (cost=0.00..2154.21 rows=5623 width=33)
  159. One-Time Filter: PartSelected
  160. -> Seq Scan on web_sales_1_prt_others web_sales_1_prt_others_1 (cost=0.00..2154.21 rows=5623 width=33)
  161. -> Result (cost=0.00..114696.50 rows=277233 width=33)
  162. One-Time Filter: PartSelected
  163. -> Seq Scan on web_sales_1_prt_2 web_sales_1_prt_2_1 (cost=0.00..114696.50 rows=277233 width=33)
  164. -> Hash (cost=1294.64..1294.64 rows=366 width=8)
  165. -> Partition Selector for web_sales (dynamic scan id: 1) (cost=0.00..1294.64 rows=366 width=8)
  166. Filter: date_dim_3.d_date_sk
  167. -> Broadcast Motion 32:32 (slice13; segments: 32) (cost=0.00..1294.64 rows=366 width=8)
  168. -> Seq Scan on date_dim date_dim_3 (cost=0.00..1174.11 rows=12 width=8)
  169. Filter: (d_year = 1999)
  170. -> Hash (cost=161842.00..161842.00 rows=375000 width=117)
  171. -> Seq Scan on customer customer_3 (cost=0.00..161842.00 rows=375000 width=117)
  172. -> Materialize (cost=231664.16..7411537344.85 rows=1587819025 width=164)
  173. -> Hash Join (cost=231664.16..6859770232.93 rows=50810208785 width=164)
  174. Hash Cond: ((t_c_firstyear.customer_id)::text = (t_c_secyear.customer_id)::text)
  175. -> Subquery Scan on t_c_firstyear (cost=0.00..142562.56 rows=7128128 width=82)
  176. -> Append (cost=0.04..25892269.72 rows=7128128 width=181)
  177. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  178. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  179. -> Result (cost=0.00..0.01 rows=1 width=0)
  180. One-Time Filter: false
  181. -> Gather Motion 32:1 (slice20; segments: 32) (cost=25387445.65..25892268.20 rows=7128064 width=181)
  182. -> HashAggregate (cost=25387445.65..25678426.28 rows=222752 width=482)
  183. Group Key: customer_4.c_customer_id, customer_4.c_first_name, customer_4.c_last_name, customer_4.c_preferred_cust_flag, customer_4.c_birth_country, customer_4.c_login, customer_4.c_email_address, date_dim_4.d_year
  184. Filter: (sum(((((catalog_sales_1_prt_others.cs_ext_list_price - catalog_sales_1_prt_others.cs_ext_wholesale_cost) - catalog_sales_1_prt_others.cs_ext_discount_amt) + catalog_sales_1_prt_others.cs_ext_sales_price) / 2::numeric)) > 0::numeric)
  185. -> Redistribute Motion 32:32 (slice19; segments: 32) (cost=366017.74..24900443.07 rows=222753 width=142)
  186. Hash Key: customer_4.c_customer_id, customer_4.c_first_name, customer_4.c_last_name, customer_4.c_preferred_cust_flag, customer_4.c_birth_country, customer_4.c_login, customer_4.c_email_address, date_dim_4.d_year
  187. -> Hash Join (cost=366017.74..24757881.70 rows=222753 width=142)
  188. Hash Cond: (catalog_sales_1_prt_others.cs_bill_customer_sk = customer_4.c_customer_sk)
  189. -> Redistribute Motion 32:32 (slice18; segments: 32) (cost=1440.74..24115937.02 rows=223872 width=33)
  190. Hash Key: catalog_sales_1_prt_others.cs_bill_customer_sk
  191. -> Hash Join (cost=1440.74..23972659.31 rows=223872 width=33)
  192. Hash Cond: (catalog_sales_1_prt_others.cs_sold_date_sk = date_dim_4.d_date_sk)
  193. -> Append (cost=0.00..18499653.12 rows=44999389 width=33)
  194. -> Result (cost=0.00..86106.26 rows=225104 width=33)
  195. One-Time Filter: PartSelected
  196. -> Seq Scan on catalog_sales_1_prt_others (cost=0.00..86106.26 rows=225104 width=33)
  197. -> Result (cost=0.00..163141.83 rows=397006 width=33)
  198. One-Time Filter: PartSelected
  199. -> Seq Scan on catalog_sales_1_prt_2 (cost=0.00..163141.83 rows=397006 width=33)
  200. -> Hash (cost=1294.64..1294.64 rows=366 width=8)
  201. -> Partition Selector for catalog_sales (dynamic scan id: 1) (cost=0.00..1294.64 rows=366 width=8)
  202. Filter: date_dim_4.d_date_sk
  203. -> Broadcast Motion 32:32 (slice17; segments: 32) (cost=0.00..1294.64 rows=366 width=8)
  204. -> Seq Scan on date_dim date_dim_4 (cost=0.00..1174.11 rows=12 width=8)
  205. Filter: (d_year = 1998)
  206. -> Hash (cost=161842.00..161842.00 rows=375000 width=117)
  207. -> Seq Scan on customer customer_4 (cost=0.00..161842.00 rows=375000 width=117)
  208. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  209. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  210. -> Result (cost=0.00..0.01 rows=1 width=0)
  211. One-Time Filter: false
  212. -> Hash (cost=142562.56..142562.56 rows=222754 width=82)
  213. -> Subquery Scan on t_c_secyear (cost=0.00..142562.56 rows=7128128 width=82)
  214. -> Append (cost=0.04..26001845.13 rows=7128128 width=482)
  215. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  216. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  217. -> Result (cost=0.00..0.01 rows=1 width=0)
  218. One-Time Filter: false
  219. -> Gather Motion 32:1 (slice24; segments: 32) (cost=25580005.26..26001843.60 rows=7128064 width=482)
  220. -> HashAggregate (cost=25580005.26..25788001.68 rows=222752 width=482)
  221. Group Key: customer_5.c_customer_id, customer_5.c_first_name, customer_5.c_last_name, customer_5.c_preferred_cust_flag, customer_5.c_birth_country, customer_5.c_login, customer_5.c_email_address, date_dim_5.d_year
  222. -> Redistribute Motion 32:32 (slice23; segments: 32) (cost=24989543.92..25193889.07 rows=196486 width=450)
  223. Hash Key: customer_5.c_customer_id, customer_5.c_first_name, customer_5.c_last_name, customer_5.c_preferred_cust_flag, customer_5.c_birth_country, customer_5.c_login, customer_5.c_email_address, date_dim_5.d_year
  224. -> HashAggregate (cost=24989543.92..25068138.21 rows=196486 width=450)
  225. Group Key: customer_5.c_customer_id, customer_5.c_first_name, customer_5.c_last_name, customer_5.c_preferred_cust_flag, customer_5.c_birth_country, customer_5.c_login, customer_5.c_email_address, date_dim_5.d_year
  226. -> Hash Join (cost=366017.74..24757881.70 rows=222753 width=142)
  227. Hash Cond: (catalog_sales_1_prt_others_1.cs_bill_customer_sk = customer_5.c_customer_sk)
  228. -> Redistribute Motion 32:32 (slice22; segments: 32) (cost=1440.74..24115937.02 rows=223872 width=33)
  229. Hash Key: catalog_sales_1_prt_others_1.cs_bill_customer_sk
  230. -> Hash Join (cost=1440.74..23972659.31 rows=223872 width=33)
  231. Hash Cond: (catalog_sales_1_prt_others_1.cs_sold_date_sk = date_dim_5.d_date_sk)
  232. -> Append (cost=0.00..18499653.12 rows=44999389 width=33)
  233. -> Result (cost=0.00..86106.26 rows=225104 width=33)
  234. One-Time Filter: PartSelected
  235. -> Seq Scan on catalog_sales_1_prt_others catalog_sales_1_prt_others_1 (cost=0.00..86106.26 rows=225104 width=33)
  236. -> Result (cost=0.00..163141.83 rows=397006 width=33)
  237. One-Time Filter: PartSelected
  238. -> Seq Scan on catalog_sales_1_prt_2 catalog_sales_1_prt_2_1 (cost=0.00..163141.83 rows=397006 width=33)
  239. -> Hash (cost=1294.64..1294.64 rows=366 width=8)
  240. -> Partition Selector for catalog_sales (dynamic scan id: 1) (cost=0.00..1294.64 rows=366 width=8)
  241. Filter: date_dim_5.d_date_sk
  242. -> Broadcast Motion 32:32 (slice21; segments: 32) (cost=0.00..1294.64 rows=366 width=8)
  243. -> Seq Scan on date_dim date_dim_5 (cost=0.00..1174.11 rows=12 width=8)
  244. Filter: (d_year = 1999)
  245. -> Hash (cost=161842.00..161842.00 rows=375000 width=117)
  246. -> Seq Scan on customer customer_5 (cost=0.00..161842.00 rows=375000 width=117)
  247. -> HashAggregate (cost=0.04..0.44 rows=32 width=482)
  248. Group Key: c_customer_id, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_country, c_login, c_email_address, d_year
  249. -> Result (cost=0.00..0.01 rows=1 width=0)
  250. One-Time Filter: false
  251. Optimizer: Postgres query optimizer
  252. (2351 rows)
  253.  
  254. Time: 815.293 ms
  255. -- end query 93 in stream 0 using template query4.tpl
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!