explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 22.462 80.140 ↓ 1.1 52,994 1

Hash Left Join (cost=19,898.69..140,829.13 rows=49,426 width=523) (actual time=31.105..80.140 rows=52,994 loops=1)

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

Bitmap Heap Scan on activation_code activation0_ (cost=927.48..114,812.90 rows=49,426 width=332) (actual time=12.309..38.930 rows=52,974 loops=1)

  • Recheck Cond: (provider_id = 45)
  • Heap Blocks: exact=34978
3. 6.247 6.247 ↓ 1.1 52,974 1

Bitmap Index Scan on idx_activation_code_provider_id (cost=0.00..915.12 rows=49,426 width=0) (actual time=6.247..6.247 rows=52,974 loops=1)

  • Index Cond: (provider_id = 45)
4. 5.215 18.748 ↑ 1.1 14,444 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 2575kB
5. 12.076 13.533 ↑ 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.663..13.533 rows=14,444 loops=1)

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

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