explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MCdT

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 0.074 ↑ 1.0 1 1

Limit (cost=0.97..7.09 rows=1 width=1,475) (actual time=0.052..0.074 rows=1 loops=1)

2. 0.002 0.051 ↑ 1.0 1 1

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

3. 0.003 0.044 ↑ 1.0 1 1

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

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

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

5. 0.005 0.027 ↑ 1.0 1 1

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

6. 0.015 0.015 ↑ 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.015 rows=1 loops=1)

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

  • Index Cond: (id = this_.account_id)
8. 0.007 0.007 ↑ 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.007..0.007 rows=1 loops=1)

  • Index Cond: (account_id = jpaaccount2_.id)
  • Heap Fetches: 1
9. 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.003..0.003 rows=1 loops=1)

10. 0.005 0.005 ↓ 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.004..0.005 rows=0 loops=1)

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