explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pt1E : Optimization for: plan #DbVo

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 27.256 1,281.975 ↓ 1.1 52,994 1

Hash Left Join (cost=18,971.21..273,870.07 rows=49,453 width=523) (actual time=87.012..1,281.975 rows=52,994 loops=1)

  • Hash Cond: ((activation0_.provider_id = providerli1_.provider_id) AND (activation0_.id = providerli1_.activation_code_id))
2. 1,231.424 1,231.424 ↓ 1.1 52,974 1

Seq Scan on activation_code activation0_ (cost=0.00..247,849.99 rows=49,453 width=332) (actual time=63.651..1,231.424 rows=52,974 loops=1)

  • Filter: (provider_id = 45)
  • Rows Removed by Filter: 4088903
3. 5.014 23.295 ↑ 1.1 14,444 1

Hash (cost=18,742.76..18,742.76 rows=15,230 width=167) (actual time=23.295..23.295 rows=14,444 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 2575kB
4. 16.835 18.281 ↑ 1.1 14,444 1

Bitmap Heap Scan on provider_link providerli1_ (cost=286.46..18,742.76 rows=15,230 width=167) (actual time=2.590..18.281 rows=14,444 loops=1)

  • Recheck Cond: (provider_id = 45)
  • Heap Blocks: exact=10059
5. 1.446 1.446 ↑ 1.1 14,444 1

Bitmap Index Scan on idx_provider_link_provider_id (cost=0.00..282.65 rows=15,230 width=0) (actual time=1.446..1.446 rows=14,444 loops=1)

  • Index Cond: (provider_id = 45)
Planning time : 9.958 ms