explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N0vv

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.119 ↑ 1.0 1 1

Limit (cost=7.25..7.26 rows=1 width=1,475) (actual time=0.111..0.119 rows=1 loops=1)

2. 0.009 0.110 ↑ 1.0 1 1

Sort (cost=7.25..7.26 rows=1 width=1,475) (actual time=0.109..0.110 rows=1 loops=1)

  • Sort Key: this_.id
  • Sort Method: quicksort Memory: 26kB
3. 0.006 0.101 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.87..7.24 rows=1 width=1,475) (actual time=0.095..0.101 rows=1 loops=1)

  • Join Filter: (this_.type = jpausertyp3_.id)
4. 0.005 0.092 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.87..6.22 rows=1 width=1,462) (actual time=0.087..0.092 rows=1 loops=1)

5. 0.008 0.080 ↑ 1.0 1 1

Nested Loop (cost=2.59..5.92 rows=1 width=1,458) (actual time=0.077..0.080 rows=1 loops=1)

6. 0.024 0.065 ↑ 1.0 1 1

Hash Right Join (cost=2.31..3.62 rows=1 width=682) (actual time=0.063..0.065 rows=1 loops=1)

  • Hash Cond: (userprefer4_.user_id = this_.id)
7. 0.014 0.014 ↑ 1.0 24 1

Seq Scan on user_preferences userprefer4_ (cost=0.00..1.24 rows=24 width=95) (actual time=0.004..0.014 rows=24 loops=1)

8. 0.005 0.027 ↑ 1.0 1 1

Hash (cost=2.30..2.30 rows=1 width=587) (actual time=0.026..0.027 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.022 0.022 ↑ 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.020..0.022 rows=1 loops=1)

  • Index Cond: ((username)::text = 'capture_usr'::text)
10. 0.007 0.007 ↑ 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.007..0.007 rows=1 loops=1)

  • Index Cond: (id = this_.account_id)
11. 0.007 0.007 ↑ 1.0 1 1

Index Scan using account_subscription_account_id_idx on account_subscription jpaaccount2_1_ (cost=0.27..0.29 rows=1 width=12) (actual time=0.005..0.007 rows=1 loops=1)

  • Index Cond: (jpaaccount2_.id = account_id)
12. 0.003 0.003 ↑ 1.0 1 1

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