explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bsNK

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.038 ↑ 138.0 2 1

Nested Loop (cost=27.31..7,430.14 rows=276 width=188) (actual time=0.029..0.038 rows=2 loops=1)

2. 0.001 0.024 ↑ 395.0 2 1

Nested Loop (cost=26.89..7,012.71 rows=790 width=196) (actual time=0.022..0.024 rows=2 loops=1)

3. 0.002 0.014 ↑ 781.0 1 1

Bitmap Heap Scan on "user" (cost=26.47..2,259.21 rows=781 width=179) (actual time=0.014..0.014 rows=1 loops=1)

  • Recheck Cond: (lower((username)::text) = 'apikey-ys1663xc73lglwd13r'::text)
  • Heap Blocks: exact=1
4. 0.012 0.012 ↑ 781.0 1 1

Bitmap Index Scan on user_lower_idx (cost=0.00..26.28 rows=781 width=0) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (lower((username)::text) = 'apikey-ys1663xc73lglwd13r'::text)
5. 0.009 0.009 ↓ 2.0 2 1

Index Scan using system_user_user_id_idx on system_user (cost=0.42..6.08 rows=1 width=17) (actual time=0.007..0.009 rows=2 loops=1)

  • Index Cond: (user_id = "user".id)
6. 0.014 0.014 ↑ 1.0 1 2

Index Scan using user_organisation_system_id_user_id_idx1 on user_organisation (cost=0.42..0.52 rows=1 width=12) (actual time=0.006..0.007 rows=1 loops=2)

  • Index Cond: ((system_id = system_user.system_id) AND (user_id = system_user.user_id))
Planning time : 0.677 ms
Execution time : 0.072 ms