explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nBx1

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.067 ↓ 0.0 0 1

Nested Loop (cost=0.42..119.47 rows=1 width=1,918) (actual time=0.067..0.067 rows=0 loops=1)

2. 0.010 0.010 ↑ 1.0 14 1

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

3. 0.042 0.042 ↓ 0.0 0 14

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

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