explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4BB1

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

Delete on pesagem pe (cost=0.00..2,377,065,069,154.00 rows=640,000 width=6) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on pesagem pe (cost=0.00..2,377,065,069,154.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

Materialize (cost=0.00..87,916.87 rows=2,559,791 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

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

6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1,634,761.02 rows=51,201,868 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

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