explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q5OK

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 225.760 ↑ 1.0 2 1

Nested Loop (cost=0.97..176,095.80 rows=2 width=1,943) (actual time=70.858..225.760 rows=2 loops=1)

  • Buffers: shared hit=43,234 read=1
  • I/O Timings: read=0.023
2. 225.503 225.503 ↑ 1.0 2 1

Index Scan using message_key on ebox_message mess (cost=0.55..176,080.91 rows=2 width=1,412) (actual time=70.811..225.503 rows=2 loops=1)

  • Index Cond: (id = '3000000121896'::bigint)
  • Buffers: shared hit=43,201 read=1
  • I/O Timings: read=0.023
3. 0.218 0.218 ↑ 1.0 1 2

Index Scan using mailbox_pk on ebox_mailbox box (cost=0.42..7.44 rows=1 width=564) (actual time=0.033..0.109 rows=1 loops=2)

  • Index Cond: ((id)::text = (mess.access_key)::text)
  • Buffers: shared hit=33
Planning time : 0.687 ms
Execution time : 225.837 ms