explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bzw

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 0.087 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.42..119.47 rows=14 width=1,589) (actual time=0.087..0.087 rows=0 loops=1)

2. 0.014 0.014 ↑ 1.0 14 1

Seq Scan on activation_link activation0_ (cost=0.00..1.14 rows=14 width=1,589) (actual time=0.012..0.014 rows=14 loops=1)

3. 0.056 0.056 ↓ 0.0 0 14

Index Scan using activation_code_pkey on activation_code activation1_ (cost=0.42..8.44 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=14)

  • Index Cond: (id = activation0_.activation_code_id)
  • Filter: (provider_id = 4)
  • Rows Removed by Filter: 1
Planning time : 0.320 ms