explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 46Z

Settings
# exclusive inclusive rows x rows loops node
1. 131.880 29,555.907 ↑ 1.0 1 1

Aggregate (cost=450,379.99..450,380.00 rows=1 width=0) (actual time=29,555.907..29,555.907 rows=1 loops=1)

  • Output: count(*)
2. 4,621.570 29,424.027 ↓ 1,762,209.0 1,762,209 1

Merge Join (cost=427,843.99..450,379.99 rows=1 width=0) (actual time=23,496.490..29,424.027 rows=1,762,209 loops=1)

  • Merge Cond: (((t.ref)::text = (s.l2_ref)::text) AND ((t.ean13)::text = (s.l1_ean13)::text))
  • Join Filter: (((t.label)::text = (s.l3_label)::text) OR ((t.label IS NULL) AND (s.l3_label IS NULL)))
  • Rows Removed by Join Filter: 660388
3. 13,531.814 13,891.078 ↑ 1.0 1,711,769 1

Sort (cost=272,588.43..276,867.85 rows=1,711,769 width=55) (actual time=12,982.903..13,891.078 rows=1,711,769 loops=1)

  • Output: t.ref, t.ean13, t.label
  • Sort Key: t.ref, t.ean13
  • Sort Method: external merge Disk: 112216kB
4. 359.264 359.264 ↑ 1.0 1,711,769 1

Seq Scan on public.product t (cost=0.00..41,029.69 rows=1,711,769 width=55) (actual time=0.015..359.264 rows=1,711,769 loops=1)

  • Output: t.ref, t.ean13, t.label
5. 10,698.545 10,911.379 ↓ 1.9 2,422,597 1

Sort (cost=154,908.49..158,075.41 rows=1,266,765 width=56) (actual time=10,508.812..10,911.379 rows=2,422,597 loops=1)

  • Output: s.l2_ref, s.l1_ean13, s.l3_label
  • Sort Key: s.l2_ref, s.l1_ean13
  • Sort Method: external sort Disk: 89048kB
6. 212.834 212.834 ↑ 1.0 1,266,765 1

Seq Scan on public.l1_product s (cost=0.00..26,504.65 rows=1,266,765 width=56) (actual time=0.012..212.834 rows=1,266,765 loops=1)

  • Output: s.l2_ref, s.l1_ean13, s.l3_label
Planning time : 1.223 ms
Execution time : 29,607.401 ms