explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uhf

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 0.562 ↑ 1.0 14 1

Nested Loop Semi Join (cost=0.42..119.44 rows=14 width=1,589) (actual time=0.505..0.562 rows=14 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.013..0.014 rows=14 loops=1)

3. 0.518 0.518 ↑ 1.0 1 14

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

  • Index Cond: (id = activation0_.activation_code_id)
  • Heap Fetches: 14
Planning time : 0.396 ms