explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EddT : teste pos index

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

Limit (cost=1,000.00..209,811,645.03 rows=105,000 width=274) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..4,200,344,172.97 rows=2,102,067 width=274) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on home_importacao_temp (cost=0.00..4,200,132,966.27 rows=875,861 width=274) (actual rows= loops=)

  • Filter: (NOT (SubPlan 1))
4.          

SubPlan (for Parallel Seq Scan)

5. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..4,532.78 rows=105,000 width=14) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..3494.78 rows=105000 width=14)" -> Seq Scan on home_crm_importacao_unificado (cost=0.00..54,653.54 rows=1,642,054 width=14) (actual rows= loops=)