explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y1ohn

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.056 ↑ 1.0 14 1

Nested Loop Left Join (cost=0.42..119.44 rows=14 width=1,918) (actual time=0.020..0.056 rows=14 loops=1)

2. 0.009 0.009 ↑ 1.0 14 1

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

3. 0.028 0.028 ↑ 1.0 1 14

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

  • Index Cond: (activation0_.activation_code_id = id)
Planning time : 0.186 ms