explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IH09

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Delete on pesagem pe (cost=2,178,391.33..2,543,062.50 rows=198 width=18) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=2,178,391.33..2,543,062.50 rows=198 width=18) (actual rows= loops=)

  • Hash Cond: (pe.id = pei.pesagem)
3. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=109,614.30..224,268.21 rows=209 width=20) (actual rows= loops=)

  • Hash Cond: (pe.id = pa.pesagem)
4. 0.000 0.000 ↓ 0.0

Seq Scan on pesagem pe (cost=0.00..54,754.00 rows=2,560,000 width=14) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=65,117.91..65,117.91 rows=2,559,791 width=14) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on passagem pa (cost=0.00..65,117.91 rows=2,559,791 width=14) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1,178,743.68..1,178,743.68 rows=51,201,868 width=14) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on pesagem_eixo pei (cost=0.00..1,178,743.68 rows=51,201,868 width=14) (actual rows= loops=)