explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h8bx

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.177 ↑ 1.0 1 1

Limit (cost=7.10..7.10 rows=1 width=1,475) (actual time=0.168..0.177 rows=1 loops=1)

2. 0.009 0.167 ↑ 1.0 1 1

Sort (cost=7.10..7.10 rows=1 width=1,475) (actual time=0.167..0.167 rows=1 loops=1)

  • Sort Key: this_.id
  • Sort Method: quicksort Memory: 25kB
3. 0.090 0.158 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.97..7.09 rows=1 width=1,475) (actual time=0.151..0.158 rows=1 loops=1)

4. 0.006 0.060 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.84..5.92 rows=1 width=1,380) (actual time=0.054..0.060 rows=1 loops=1)

  • Join Filter: (this_.type = jpausertyp3_.id)
5. 0.007 0.050 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.84..4.90 rows=1 width=1,367) (actual time=0.044..0.050 rows=1 loops=1)

6. 0.008 0.030 ↑ 1.0 1 1

Nested Loop (cost=0.56..4.60 rows=1 width=1,363) (actual time=0.028..0.030 rows=1 loops=1)

7. 0.017 0.017 ↑ 1.0 1 1

Index Scan using users_username_status_idx on users this_ (cost=0.28..2.30 rows=1 width=587) (actual time=0.015..0.017 rows=1 loops=1)

  • Index Cond: ((username)::text = 'capture_usr'::text)
8. 0.005 0.005 ↑ 1.0 1 1

Index Scan using account_id_idx on account jpaaccount2_ (cost=0.28..2.30 rows=1 width=776) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = this_.account_id)
9. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using account_subscription_pkey on account_subscription jpaaccount2_1_ (cost=0.27..0.29 rows=1 width=12) (actual time=0.011..0.013 rows=1 loops=1)

  • Index Cond: (account_id = jpaaccount2_.id)
  • Heap Fetches: 1
10. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on user_type jpausertyp3_ (cost=0.00..1.01 rows=1 width=13) (actual time=0.003..0.004 rows=1 loops=1)

11. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using user_preference_user_id_idx on user_preferences userprefer4_ (cost=0.14..1.16 rows=1 width=95) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (user_id = this_.id)
  • Heap Fetches: 0