explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bvK1

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

Delete on pesagem pe (cost=0.00..1,764,181,440,354.00 rows=640,000 width=6) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on pesagem pe (cost=0.00..1,764,181,440,354.00 rows=640,000 width=6) (actual rows= loops=)

  • Filter: ((NOT (SubPlan 1)) AND (NOT (SubPlan 2)))
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0

Seq Scan on passagem pa (cost=0.00..71,517.39 rows=1 width=8) (actual rows= loops=)

  • Filter: (pesagem = pe.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on pesagem_eixo pei (cost=0.00..1,306,748.35 rows=383 width=8) (actual rows= loops=)

  • Filter: (pe.id = pesagem)