explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t8rc

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.052 ↑ 1.0 1 1

Nested Loop (cost=0.42..5 rows=1 width=145) (actual time=0.051..0.052 rows=1 loops=1)

  • Buffers: shared hit=6
2. 0.021 0.021 ↑ 1.0 1 1

Index Scan using account_email_unique on account account (cost=0.28..3.29 rows=1 width=129) (actual time=0.02..0.021 rows=1 loops=1)

  • Index Cond: (lower(account.email) = 'adam@gosimple.me'::text)
  • Buffers: shared hit=3
3. 0.027 0.027 ↑ 1.0 1 1

Index Only Scan using account_client_unique on account_client account_client (cost=0.14..1.66 rows=1 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: (account_client.account_id_foreign = account.account_id)
  • Heap Fetches: 1
  • Buffers: shared hit=3
Planning time : 0.486 ms
Execution time : 0.098 ms