explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DbVo

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 27.109 1,266.661 ↓ 1.1 52,994 1

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

  • Hash Cond: ((activation0_.provider_id = providerli1_.provider_id) AND (activation0_.id = providerli1_.activation_code_id))
2. 1,221.447 1,221.447 ↓ 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.944..1,221.447 rows=52,974 loops=1)

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

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

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

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

  • Index Cond: (provider_id = 45)