explain.depesz.com

PostgreSQL's explain analyze made readable

Result: djXg : Optimization for: Optimization for: plan #DbVo; plan #Pt1E

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 27.299 1,275.152 ↓ 1.1 52,994 1

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

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

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

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

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

  • Buckets: 16384 Batches: 1 Memory Usage: 2575kB
4. 12.967 14.459 ↑ 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.772..14.459 rows=14,444 loops=1)

  • Recheck Cond: (provider_id = 45)
  • Heap Blocks: exact=10059
5. 1.492 1.492 ↑ 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.492..1.492 rows=14,444 loops=1)

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