explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8tiG

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 37.312 ↑ 1.0 1 1

Nested Loop (cost=8.87..5,047.75 rows=1 width=187) (actual time=25.053..37.312 rows=1 loops=1)

  • Join Filter: ("user".id = user_organisation.user_id)
2. 9.418 37.243 ↑ 1.0 1 1

Hash Join (cost=8.45..5,047.07 rows=1 width=195) (actual time=24.985..37.243 rows=1 loops=1)

  • Hash Cond: (system_user.user_id = "user".id)
3. 27.699 27.699 ↑ 1.0 120,772 1

Seq Scan on system_user (cost=0.00..4,585.72 rows=120,772 width=17) (actual time=0.015..27.699 rows=120,772 loops=1)

4. 0.009 0.126 ↑ 1.0 1 1

Hash (cost=8.44..8.44 rows=1 width=178) (actual time=0.126..0.126 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.117 0.117 ↑ 1.0 1 1

Index Scan using user_lower_idx on "user" (cost=0.42..8.44 rows=1 width=178) (actual time=0.116..0.117 rows=1 loops=1)

  • Index Cond: (lower((username)::text) = 'apikey-10i62tqy4u2y4z3aw3'::text)
6. 0.064 0.064 ↑ 3.0 1 1

Index Scan using user_organisation_user_id_index on user_organisation (cost=0.42..0.64 rows=3 width=8) (actual time=0.063..0.064 rows=1 loops=1)

  • Index Cond: (user_id = system_user.user_id)
  • Filter: is_primary_dealer
Planning time : 2.759 ms
Execution time : 37.473 ms