explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gQuQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.053 ↑ 1.1 7 1

Nested Loop (cost=0.84..122.06 rows=8 width=109) (actual time=0.015..0.053 rows=7 loops=1)

2. 0.011 0.011 ↑ 1.1 7 1

Index Scan using idx_account_id on sessions s (cost=0.42..54.56 rows=8 width=8) (actual time=0.008..0.011 rows=7 loops=1)

  • Index Cond: (account_id = '640469'::bigint)
  • Filter: (NOT revoked)
3. 0.035 0.035 ↑ 1.0 1 7

Index Scan using devices_pkey on devices d (cost=0.42..8.44 rows=1 width=109) (actual time=0.005..0.005 rows=1 loops=7)

  • Index Cond: (id = s.device_id)
Planning time : 0.193 ms
Execution time : 0.074 ms