explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LLP1

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

Delete on pesagem pe (cost=2,185,394.50..2,529,779.86 rows=149,271 width=18) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=2,185,394.50..2,529,779.86 rows=149,271 width=18) (actual rows= loops=)

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

Hash Anti Join (cost=106,030.54..212,100.56 rows=156,066 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..55,340.01 rows=2,560,001 width=14) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=64,243.35..64,243.35 rows=2,403,935 width=14) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on passagem pa (cost=0.00..64,243.35 rows=2,403,935 width=14) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1,245,152.76..1,245,152.76 rows=47,990,576 width=14) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on pesagem_eixo pei (cost=0.00..1,245,152.76 rows=47,990,576 width=14) (actual rows= loops=)