explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yofd : Optimization for: plan #DbVo

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 316.253 624.263 ↓ 1.1 52,994 1

Hash Right Join (cost=117,603.72..187,968.66 rows=49,426 width=523) (actual time=79.520..624.263 rows=52,994 loops=1)

  • Hash Cond: (providerli1_.activation_code_id = activation0_.id)
2. 229.413 229.413 ↑ 1.0 821,737 1

Seq Scan on provider_link providerli1_ (cost=0.00..26,492.37 rows=821,737 width=167) (actual time=0.013..229.413 rows=821,737 loops=1)

3. 26.666 78.597 ↓ 1.1 52,974 1

Hash (cost=114,812.90..114,812.90 rows=49,426 width=332) (actual time=78.597..78.597 rows=52,974 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 6219kB
4. 45.717 51.931 ↓ 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.255..51.931 rows=52,974 loops=1)

  • Recheck Cond: (provider_id = 45)
  • Heap Blocks: exact=34978
5. 6.214 6.214 ↓ 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.214..6.214 rows=52,974 loops=1)

  • Index Cond: (provider_id = 45)