explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qc5r

Settings
# exclusive inclusive rows x rows loops node
1. 25.257 16,848.657 ↑ 12.1 8,588 1

GroupAggregate (cost=1,098,013.29..1,103,730.05 rows=103,941 width=798) (actual time=16,821.293..16,848.657 rows=8,588 loops=1)

  • Group Key: bb.id, bb.status, bb.product_id, bb.date, bb.utm_source, bb.utm_campaign, bb.utm_content, bb.utm_term, bb.kosten, pp.title, pp2.title, pp.locale_code, (concat(pp.locale_code, ' ', CASE WHEN (pv.name IS NULL) THEN 'Geen vertical'::character varying ELSE pv.name END)), ps.parent_source
2. 32.730 16,823.400 ↑ 7.3 14,229 1

Sort (cost=1,098,013.29..1,098,273.15 rows=103,941 width=790) (actual time=16,821.259..16,823.400 rows=14,229 loops=1)

  • Sort Key: bb.id, bb.status, bb.product_id, bb.date, bb.utm_source, bb.utm_campaign, bb.utm_content, bb.utm_term, bb.kosten, pp.title, pp2.title, pp.locale_code, (concat(pp.locale_code, ' ', CASE WHEN (pv.name IS NULL) THEN 'Geen vertical'::character varying ELSE pv.name END)), ps.parent_source
  • Sort Method: quicksort Memory: 4,067kB
3. 7.574 16,790.670 ↑ 7.3 14,229 1

Hash Left Join (cost=1,022,306.25..1,053,113.20 rows=103,941 width=790) (actual time=16,694.003..16,790.670 rows=14,229 loops=1)

  • Hash Cond: (pp.vertical_id = pv.id)
4. 3.848 16,783.080 ↑ 7.3 14,229 1

Hash Left Join (cost=1,022,294.68..1,052,565.76 rows=103,941 width=762) (actual time=16,693.973..16,783.080 rows=14,229 loops=1)

  • Hash Cond: (pp.parent_id = pp2.id)
5. 4.464 16,778.809 ↑ 7.3 14,229 1

Hash Join (cost=1,022,197.37..1,052,194.92 rows=103,941 width=742) (actual time=16,693.545..16,778.809 rows=14,229 loops=1)

  • Hash Cond: (bb.product_id = pp.id)
6. 17.730 16,773.732 ↑ 7.3 14,229 1

Hash Left Join (cost=1,022,100.06..1,051,823.66 rows=103,941 width=704) (actual time=16,692.926..16,773.732 rows=14,229 loops=1)

  • Hash Cond: (lower(bb.utm_source) = lower((psr.utm_source)::text))
7. 58.378 16,755.857 ↑ 7.3 14,229 1

Hash Right Join (cost=1,022,082.58..1,050,470.54 rows=103,941 width=188) (actual time=16,692.768..16,755.857 rows=14,229 loops=1)

  • Hash Cond: (lr.lead_id = cl.id)
8. 76.941 76.941 ↓ 1.0 237,727 1

Seq Scan on lead_reclamation lr (cost=0.00..22,844.98 rows=236,298 width=8) (actual time=0.015..76.941 rows=237,727 loops=1)

9. 4.103 16,620.538 ↑ 7.3 14,229 1

Hash (cost=1,018,143.32..1,018,143.32 rows=103,941 width=184) (actual time=16,620.537..16,620.538 rows=14,229 loops=1)

  • Buckets: 65,536 Batches: 4 Memory Usage: 1,114kB
10. 110.492 16,616.435 ↑ 7.3 14,229 1

Hash Left Join (cost=998,469.85..1,018,143.32 rows=103,941 width=184) (actual time=16,503.200..16,616.435 rows=14,229 loops=1)

  • Hash Cond: ((bb.id = cl.storage_id) AND (bb.product_id = cl.product_id))
11. 1.493 15,807.985 ↑ 12.1 8,588 1

Subquery Scan on bb (cost=861,095.20..866,552.10 rows=103,941 width=180) (actual time=15,803.985..15,807.985 rows=8,588 loops=1)

12. 1.987 15,806.492 ↑ 12.1 8,588 1

Unique (cost=861,095.20..865,512.69 rows=103,941 width=252) (actual time=15,803.982..15,806.492 rows=8,588 loops=1)

13. 6.419 15,804.505 ↑ 12.1 8,588 1

Sort (cost=861,095.20..861,355.05 rows=103,941 width=252) (actual time=15,803.981..15,804.505 rows=8,588 loops=1)

  • Sort Key: ls.id, ls.status, a.product_count, llp.product_id, uc.cpl, al.price, b.total_costs, c.incoming, c.accepted_leads, (date(ls.created_at)), (lower((ls.utm_source)::text)), (lower((ls.utm_campaign)::text)), (lower((ls.utm_content)::text)), (lower((ls.utm_term)::text)), al.status_affiliate, (CASE WHEN ((al.price IS NULL) AND (uc.cpl IS NULL) AND (c.accepted_leads > 0) AND ((ls.status)::text = 'ACCEPTED'::text)) THEN ((b.total_costs / c.accepted_leads) / a.product_count) ELSE CASE WHEN ((al.price IS NULL) AND (uc.cpl IS NULL) AND (c.accepted_leads = 0)) THEN ((b.total_costs / c.incoming) / a.product_count) ELSE CASE WHEN ((al.price IS NOT NULL) AND ((al.status_affiliate)::text = ANY ('{ACCEPTED,NEW}'::text[]))) THEN (al.price / a.product_count) ELSE (CASE WHEN (uc.cpl IS NOT NULL) THEN uc.cpl ELSE 0 END)::bigint END END END)
  • Sort Method: quicksort Memory: 1,495kB
14. 0.807 15,798.086 ↑ 12.1 8,588 1

Append (cost=595,908.55..839,998.60 rows=103,941 width=252) (actual time=8,639.907..15,798.086 rows=8,588 loops=1)

15. 5.059 8,645.901 ↑ 14.5 7,185 1

Group (cost=595,908.55..603,704.05 rows=103,940 width=204) (actual time=8,639.906..8,645.901 rows=7,185 loops=1)

  • Group Key: ls.id, a.product_count, llp.product_id, uc.cpl, al.price, b.total_costs, c.incoming, c.accepted_leads, (date(ls.created_at)), (lower((ls.utm_source)::text)), (lower((ls.utm_campaign)::text)), (lower((ls.utm_content)::text)), (lower((ls.utm_term)::text)), al.status_affiliate
16. 4.488 8,640.842 ↑ 14.3 7,267 1

Sort (cost=595,908.55..596,168.40 rows=103,940 width=196) (actual time=8,639.898..8,640.842 rows=7,267 loops=1)

  • Sort Key: ls.id, a.product_count, llp.product_id, uc.cpl, al.price, b.total_costs, c.incoming, c.accepted_leads, (date(ls.created_at)), (lower((ls.utm_source)::text)), (lower((ls.utm_campaign)::text)), (lower((ls.utm_content)::text)), (lower((ls.utm_term)::text)), al.status_affiliate
  • Sort Method: quicksort Memory: 1,193kB
17. 3.505 8,636.354 ↑ 14.3 7,267 1

Hash Left Join (cost=558,069.76..577,297.04 rows=103,940 width=196) (actual time=7,549.685..8,636.354 rows=7,267 loops=1)

  • Hash Cond: ((lower((ls.utm_source)::text) = c.source) AND (lower((ls.utm_campaign)::text) = c.campaign) AND (date(ls.created_at) = c.date))
18. 988.420 4,526.155 ↑ 14.3 7,267 1

Gather Merge (cost=365,594.00..382,664.54 rows=103,940 width=79) (actual time=3,442.803..4,526.155 rows=7,267 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
19. 198.006 3,537.735 ↑ 17.9 2,422 3 / 3

Merge Left Join (cost=364,593.98..369,667.26 rows=43,308 width=79) (actual time=2,879.428..3,537.735 rows=2,422 loops=3)

  • Merge Cond: (((lower((ls.utm_campaign)::text)) = (lower((uc.campaign)::text))) AND (llp.product_id = uc.product_id) AND ((lower((ls.utm_source)::text)) = (lower((uc.source)::text))))
  • Join Filter: ((ls.created_at >= uc.from_date) AND (ls.created_at <= CASE WHEN (uc.to_date IS NULL) THEN (('now'::cstring)::date + '23:59:59'::time without time zone) ELSE uc.to_date END))
  • Rows Removed by Join Filter: 761,945
20. 15.960 2,321.733 ↑ 17.9 2,422 3 / 3

Sort (cost=338,511.01..338,619.28 rows=43,308 width=75) (actual time=2,321.375..2,321.733 rows=2,422 loops=3)

  • Sort Key: (lower((ls.utm_campaign)::text)), llp.product_id, (lower((ls.utm_source)::text))
  • Sort Method: quicksort Memory: 1,237kB
  • Worker 0: Sort Method: quicksort Memory: 29kB
  • Worker 1: Sort Method: quicksort Memory: 34kB
21. 10.422 2,305.773 ↑ 17.9 2,422 3 / 3

Hash Left Join (cost=319,138.35..335,175.79 rows=43,308 width=75) (actual time=2,280.846..2,305.773 rows=2,422 loops=3)

  • Hash Cond: ((date(ls.created_at) = b.date) AND (lower((ls.utm_source)::text) = b.source) AND (lower((ls.utm_campaign)::text) = b.campaign))
22. 6.437 2,210.197 ↑ 17.9 2,422 3 / 3

Parallel Hash Left Join (cost=311,401.95..327,082.09 rows=43,308 width=67) (actual time=2,195.514..2,210.197 rows=2,422 loops=3)

  • Hash Cond: (pld.lead_id = al.id)
23. 5.322 2,091.980 ↑ 17.9 2,422 3 / 3

Parallel Hash Left Join (cost=304,079.22..319,645.67 rows=43,308 width=59) (actual time=2,082.061..2,091.980 rows=2,422 loops=3)

  • Hash Cond: (ls.id = pld.storage_id)
24. 7.163 1,997.990 ↑ 18.1 2,395 3 / 3

Hash Join (cost=295,652.58..310,904.89 rows=43,308 width=55) (actual time=1,989.995..1,997.990 rows=2,395 loops=3)

  • Hash Cond: (llp.lead_id = a.id)
25. 78.243 516.837 ↑ 57.5 2,395 3 / 3

Parallel Hash Join (cost=108,483.61..119,448.62 rows=137,637 width=51) (actual time=514.898..516.837 rows=2,395 loops=3)

  • Hash Cond: (llp.lead_id = ls.id)
26. 65.619 65.619 ↑ 1.5 279,705 3 / 3

Parallel Seq Scan on lead_product llp (cost=0.00..9,881.11 rows=412,911 width=8) (actual time=0.013..65.619 rows=279,705 loops=3)

27. 3.083 372.975 ↑ 48.6 2,167 3 / 3

Parallel Hash (cost=107,166.08..107,166.08 rows=105,402 width=43) (actual time=372.975..372.975 rows=2,167 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 2,624kB
28. 369.892 369.892 ↑ 48.6 2,167 3 / 3

Parallel Seq Scan on storage ls (cost=0.00..107,166.08 rows=105,402 width=43) (actual time=0.025..369.892 rows=2,167 loops=3)

  • Filter: (date(created_at) >= '2020-06-17'::date)
  • Rows Removed by Filter: 250,682
29. 1.900 1,473.990 ↑ 38.9 6,502 3 / 3

Hash (cost=182,770.92..182,770.92 rows=252,964 width=12) (actual time=1,473.990..1,473.990 rows=6,502 loops=3)

  • Buckets: 262,144 Batches: 2 Memory Usage: 2,188kB
30. 0.900 1,472.090 ↑ 38.9 6,502 3 / 3

Subquery Scan on a (cost=175,234.17..182,770.92 rows=252,964 width=12) (actual time=1,467.713..1,472.090 rows=6,502 loops=3)

31. 2.696 1,471.190 ↑ 38.9 6,502 3 / 3

GroupAggregate (cost=175,234.17..180,241.28 rows=252,964 width=12) (actual time=1,467.712..1,471.190 rows=6,502 loops=3)

  • Group Key: ls_1.id
32. 4.797 1,468.494 ↑ 46.0 7,185 3 / 3

Sort (cost=175,234.17..176,060.00 rows=330,329 width=8) (actual time=1,467.699..1,468.494 rows=7,185 loops=3)

  • Sort Key: ls_1.id
  • Sort Method: quicksort Memory: 529kB
  • Worker 0: Sort Method: quicksort Memory: 529kB
  • Worker 1: Sort Method: quicksort Memory: 529kB
33. 293.739 1,463.697 ↑ 46.0 7,185 3 / 3

Hash Join (cost=117,957.45..144,953.67 rows=330,329 width=8) (actual time=1,384.986..1,463.697 rows=7,185 loops=3)

  • Hash Cond: (lp.lead_id = ls_1.id)
34. 216.707 216.707 ↑ 1.2 839,115 3 / 3

Seq Scan on lead_product lp (cost=0.00..15,661.87 rows=990,987 width=8) (actual time=0.021..216.707 rows=839,115 loops=3)

35. 6.209 953.251 ↑ 38.9 6,502 3 / 3

Hash (cost=113,806.40..113,806.40 rows=252,964 width=4) (actual time=953.251..953.251 rows=6,502 loops=3)

  • Buckets: 262,144 Batches: 2 Memory Usage: 2,163kB
36. 947.042 947.042 ↑ 38.9 6,502 3 / 3

Seq Scan on storage ls_1 (cost=0.00..113,806.40 rows=252,964 width=4) (actual time=0.017..947.042 rows=6,502 loops=3)

  • Filter: (date(created_at) >= '2020-06-17'::date)
  • Rows Removed by Filter: 752,045
37. 61.789 88.668 ↑ 2.6 103,552 3 / 3

Parallel Hash (cost=5,102.95..5,102.95 rows=265,895 width=8) (actual time=88.668..88.668 rows=103,552 loops=3)

  • Buckets: 524,288 Batches: 1 Memory Usage: 16,288kB
38. 26.879 26.879 ↑ 2.6 103,552 3 / 3

Parallel Seq Scan on product_lead_details pld (cost=0.00..5,102.95 rows=265,895 width=8) (actual time=0.018..26.879 rows=103,552 loops=3)

39. 62.775 111.780 ↑ 1.2 103,862 3 / 3

Parallel Hash (cost=5,771.77..5,771.77 rows=124,077 width=16) (actual time=111.780..111.780 rows=103,862 loops=3)

  • Buckets: 524,288 Batches: 1 Memory Usage: 21,184kB
40. 49.005 49.005 ↑ 1.2 103,862 3 / 3

Parallel Seq Scan on affiliate_lead al (cost=0.00..5,771.77 rows=124,077 width=16) (actual time=0.015..49.005 rows=103,862 loops=3)

41. 0.384 85.154 ↑ 21.2 855 3 / 3

Hash (cost=7,419.48..7,419.48 rows=18,110 width=76) (actual time=85.154..85.154 rows=855 loops=3)

  • Buckets: 32,768 Batches: 1 Memory Usage: 306kB
42. 0.125 84.770 ↑ 21.2 855 3 / 3

Subquery Scan on b (cost=6,921.45..7,419.48 rows=18,110 width=76) (actual time=84.253..84.770 rows=855 loops=3)

43. 2.214 84.645 ↑ 21.2 855 3 / 3

HashAggregate (cost=6,921.45..7,238.38 rows=18,110 width=76) (actual time=84.252..84.645 rows=855 loops=3)

  • Group Key: date(uc_1.from_date), lower((uc_1.source)::text), lower((uc_1.campaign)::text)
44. 82.431 82.431 ↑ 16.0 3,840 3 / 3

Seq Scan on utm_costs uc_1 (cost=0.00..6,307.14 rows=61,431 width=72) (actual time=54.468..82.431 rows=3,840 loops=3)

  • Filter: (date(from_date) >= '2020-06-17'::date)
  • Rows Removed by Filter: 203,952
45. 64.839 1,017.996 ↓ 5.1 936,000 3 / 3

Materialize (cost=26,082.97..27,004.44 rows=184,294 width=37) (actual time=677.360..1,017.996 rows=936,000 loops=3)

46. 758.013 953.157 ↓ 1.1 206,644 3 / 3

Sort (cost=26,082.97..26,543.71 rows=184,294 width=37) (actual time=677.355..953.157 rows=206,644 loops=3)

  • Sort Key: (lower((uc.campaign)::text)), uc.product_id, (lower((uc.source)::text))
  • Sort Method: external merge Disk: 12,432kB
  • Worker 0: Sort Method: external merge Disk: 12,432kB
  • Worker 1: Sort Method: external merge Disk: 12,432kB
47. 195.144 195.144 ↓ 1.1 207,792 3 / 3

Seq Scan on utm_costs uc (cost=0.00..4,924.94 rows=184,294 width=37) (actual time=0.013..195.144 rows=207,792 loops=3)

48. 0.155 4,106.694 ↑ 36.1 510 1

Hash (cost=192,153.25..192,153.25 rows=18,429 width=84) (actual time=4,106.693..4,106.694 rows=510 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 291kB
49. 0.053 4,106.539 ↑ 36.1 510 1

Subquery Scan on c (cost=189,380.22..192,153.25 rows=18,429 width=84) (actual time=4,101.079..4,106.539 rows=510 loops=1)

50. 4.654 4,106.486 ↑ 36.1 510 1

GroupAggregate (cost=189,380.22..191,968.96 rows=18,429 width=84) (actual time=4,101.077..4,106.486 rows=510 loops=1)

  • Group Key: (date(uc_2.from_date)), (lower((uc_2.source)::text)), (lower((uc_2.campaign)::text))
51. 11.583 4,101.832 ↑ 8.7 14,958 1

Sort (cost=189,380.22..189,703.96 rows=129,499 width=80) (actual time=4,101.050..4,101.832 rows=14,958 loops=1)

  • Sort Key: (date(uc_2.from_date)), (lower((uc_2.source)::text)), (lower((uc_2.campaign)::text))
  • Sort Method: quicksort Memory: 1,553kB
52. 782.490 4,090.249 ↑ 8.7 14,958 1

Gather (cost=138,002.50..172,626.58 rows=129,499 width=80) (actual time=1,861.788..4,090.249 rows=14,958 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
53. 964.468 3,307.759 ↑ 10.8 4,986 3 / 3

Merge Join (cost=137,002.50..158,676.68 rows=53,958 width=80) (actual time=1,731.658..3,307.759 rows=4,986 loops=3)

  • Merge Cond: (((lower((ls_2.utm_campaign)::text)) = (lower((uc_2.campaign)::text))) AND ((lower((ls_2.utm_source)::text)) = (lower((uc_2.source)::text))))
  • Join Filter: ((ls_2.created_at >= uc_2.from_date) AND (ls_2.created_at <= CASE WHEN (uc_2.to_date IS NULL) THEN (('now'::cstring)::date + '23:59:59'::time without time zone) ELSE uc_2.to_date END))
  • Rows Removed by Join Filter: 2,615,362
54. 4.116 528.564 ↑ 51.5 2,045 3 / 3

Sort (cost=115,959.53..116,223.03 rows=105,402 width=38) (actual time=528.184..528.564 rows=2,045 loops=3)

  • Sort Key: (lower((ls_2.utm_campaign)::text)), (lower((ls_2.utm_source)::text))
  • Sort Method: quicksort Memory: 775kB
  • Worker 0: Sort Method: quicksort Memory: 265kB
  • Worker 1: Sort Method: quicksort Memory: 134kB
55. 524.448 524.448 ↑ 48.6 2,167 3 / 3

Parallel Seq Scan on storage ls_2 (cost=0.00..107,166.08 rows=105,402 width=38) (actual time=0.110..524.448 rows=2,167 loops=3)

  • Filter: (date(created_at) >= '2020-06-17'::date)
  • Rows Removed by Filter: 250,682
56. 1,409.908 1,814.727 ↓ 14.6 2,688,250 3 / 3

Sort (cost=21,042.97..21,503.71 rows=184,294 width=29) (actual time=1,199.251..1,814.727 rows=2,688,250 loops=3)

  • Sort Key: (lower((uc_2.campaign)::text)), (lower((uc_2.source)::text))
  • Sort Method: external sort Disk: 12,408kB
  • Worker 0: Sort Method: external sort Disk: 12,408kB
  • Worker 1: Sort Method: external sort Disk: 12,408kB
57. 404.819 404.819 ↓ 1.1 207,792 3 / 3

Seq Scan on utm_costs uc_2 (cost=0.00..4,924.94 rows=184,294 width=29) (actual time=0.027..404.819 rows=207,792 loops=3)

58. 0.232 7,151.378 ↓ 1,403.0 1,403 1

Subquery Scan on "*SELECT* 2" (cost=234,735.40..234,735.45 rows=1 width=252) (actual time=7,149.597..7,151.378 rows=1,403 loops=1)

59. 1.445 7,151.146 ↓ 1,403.0 1,403 1

GroupAggregate (cost=234,735.40..234,735.44 rows=1 width=265) (actual time=7,149.594..7,151.146 rows=1,403 loops=1)

  • Group Key: (date(uc_3.from_date)), uc_3.source, uc_3.campaign, uc_3.product_id
60. 2.816 7,149.701 ↓ 1,403.0 1,403 1

Sort (cost=234,735.40..234,735.41 rows=1 width=25) (actual time=7,149.574..7,149.701 rows=1,403 loops=1)

  • Sort Key: (date(uc_3.from_date)), uc_3.source, uc_3.campaign, uc_3.product_id
  • Sort Method: quicksort Memory: 158kB
61. 215.496 7,146.885 ↓ 1,403.0 1,403 1

Gather (cost=209,397.18..234,735.39 rows=1 width=25) (actual time=4,153.876..7,146.885 rows=1,403 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
62. 1,267.691 6,931.389 ↓ 468.0 468 3 / 3

Merge Left Join (cost=208,397.18..233,735.29 rows=1 width=25) (actual time=4,736.769..6,931.389 rows=468 loops=3)

  • Merge Cond: (((lower((uc_3.campaign)::text)) = (lower((ls_3.utm_campaign)::text))) AND ((lower((uc_3.source)::text)) = (lower((ls_3.utm_source)::text))))
  • Join Filter: ((ls_3.created_at >= uc_3.from_date) AND (ls_3.created_at <= CASE WHEN (uc_3.to_date IS NULL) THEN (CURRENT_DATE + '23:59:59'::time without time zone) ELSE uc_3.to_date END))
  • Rows Removed by Join Filter: 2,584,069
  • Filter: (ls_3.id IS NULL)
  • Rows Removed by Filter: 4,927
63. 2.323 38.182 ↑ 20.0 1,280 3 / 3

Sort (cost=6,107.93..6,171.92 rows=25,596 width=37) (actual time=37.923..38.182 rows=1,280 loops=3)

  • Sort Key: (lower((uc_3.campaign)::text)), (lower((uc_3.source)::text))
  • Sort Method: quicksort Memory: 251kB
  • Worker 0: Sort Method: quicksort Memory: 289kB
  • Worker 1: Sort Method: quicksort Memory: 122kB
64. 35.859 35.859 ↑ 20.0 1,280 3 / 3

Parallel Seq Scan on utm_costs uc_3 (cost=0.00..4,233.84 rows=25,596 width=37) (actual time=22.689..35.859 rows=1,280 loops=3)

  • Filter: (date(from_date) >= '2020-06-17'::date)
  • Rows Removed by Filter: 67,984
65. 358.931 5,625.516 ↓ 4.0 3,042,179 3 / 3

Materialize (cost=202,289.25..206,083.72 rows=758,893 width=30) (actual time=4,681.097..5,625.516 rows=3,042,179 loops=3)

66. 3,061.544 5,266.585 ↑ 1.2 641,010 3 / 3

Sort (cost=202,289.25..204,186.48 rows=758,893 width=30) (actual time=4,681.091..5,266.585 rows=641,010 loops=3)

  • Sort Key: (lower((ls_3.utm_campaign)::text)), (lower((ls_3.utm_source)::text))
  • Sort Method: external merge Disk: 43,472kB
  • Worker 0: Sort Method: external merge Disk: 43,472kB
  • Worker 1: Sort Method: external merge Disk: 43,472kB
67. 2,205.041 2,205.041 ↑ 1.0 758,547 3 / 3

Seq Scan on storage ls_3 (cost=0.00..110,011.93 rows=758,893 width=30) (actual time=0.023..2,205.041 rows=758,547 loops=3)

68. 236.003 697.958 ↓ 1.0 1,477,236 1

Hash (cost=108,454.06..108,454.06 rows=1,454,506 width=12) (actual time=697.958..697.958 rows=1,477,236 loops=1)

  • Buckets: 262,144 Batches: 16 Memory Usage: 6,032kB
69. 461.955 461.955 ↓ 1.0 1,477,236 1

Seq Scan on lead cl (cost=0.00..108,454.06 rows=1,454,506 width=12) (actual time=0.016..461.955 rows=1,477,236 loops=1)

70. 0.077 0.145 ↑ 1.1 121 1

Hash (cost=15.83..15.83 rows=132 width=526) (actual time=0.145..0.145 rows=121 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
71. 0.030 0.068 ↑ 1.1 123 1

Hash Left Join (cost=13.15..15.83 rows=132 width=526) (actual time=0.038..0.068 rows=123 loops=1)

  • Hash Cond: (psr.parent_source_id = ps.id)
72. 0.015 0.015 ↑ 1.1 123 1

Seq Scan on parent_source_rel psr (cost=0.00..2.32 rows=132 width=14) (actual time=0.008..0.015 rows=123 loops=1)

73. 0.014 0.023 ↑ 15.6 9 1

Hash (cost=11.40..11.40 rows=140 width=520) (actual time=0.023..0.023 rows=9 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
74. 0.009 0.009 ↑ 15.6 9 1

Seq Scan on parent_source ps (cost=0.00..11.40 rows=140 width=520) (actual time=0.008..0.009 rows=9 loops=1)

75. 0.172 0.613 ↑ 1.1 980 1

Hash (cost=84.36..84.36 rows=1,036 width=42) (actual time=0.612..0.613 rows=980 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 84kB
76. 0.441 0.441 ↑ 1.1 980 1

Seq Scan on product pp (cost=0.00..84.36 rows=1,036 width=42) (actual time=0.009..0.441 rows=980 loops=1)

77. 0.179 0.423 ↑ 1.1 980 1

Hash (cost=84.36..84.36 rows=1,036 width=28) (actual time=0.423..0.423 rows=980 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 76kB
78. 0.244 0.244 ↑ 1.1 980 1

Seq Scan on product pp2 (cost=0.00..84.36 rows=1,036 width=28) (actual time=0.005..0.244 rows=980 loops=1)

79. 0.010 0.016 ↑ 4.7 15 1

Hash (cost=10.70..10.70 rows=70 width=520) (actual time=0.016..0.016 rows=15 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
80. 0.006 0.006 ↑ 4.7 15 1

Seq Scan on verticals pv (cost=0.00..10.70 rows=70 width=520) (actual time=0.005..0.006 rows=15 loops=1)

Planning time : 6.499 ms
Execution time : 16,876.120 ms