explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AEYM

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.239 ↑ 1.0 1 1

Nested Loop (cost=0..83.14 rows=1 width=145) (actual time=0.238..0.239 rows=1 loops=1)

  • Buffers: shared hit=62
2. 0.219 0.219 ↑ 1.0 1 1

Seq Scan on account account (cost=0..80.86 rows=1 width=129) (actual time=0.219..0.219 rows=1 loops=1)

  • Filter: (account.email = 'adam@gosimple.me'::text)
  • Buffers: shared hit=61
3. 0.012 0.012 ↑ 1.0 56 1

Seq Scan on account_client account_client (cost=0..1.57 rows=57 width=16) (actual time=0.005..0.012 rows=56 loops=1)

  • Buffers: shared hit=1
Planning time : 0.249 ms
Execution time : 0.264 ms