explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VXaS

Settings
# exclusive inclusive rows x rows loops node
1. 138.661 91,270.650 ↓ 2.8 247,549 1

Nested Loop (cost=0.23..291,969.20 rows=89,177 width=4) (actual time=17.483..91,270.650 rows=247,549 loops=1)

  • Output: payment_lines.payment_id
  • Buffers: shared hit=1120646 read=44150 dirtied=87
  • I/O Timings: read=89964.163
2. 81.725 81.725 ↓ 2.8 235,272 1

Index Only Scan using index_payments_on_mws_credential_id_and_id on public.payments (cost=0.11..932.76 rows=84,193 width=4) (actual time=12.259..81.725 rows=235,272 loops=1)

  • Output: payments.mws_credential_id, payments.id
  • Index Cond: (payments.mws_credential_id = 1)
  • Heap Fetches: 82
  • Buffers: shared hit=25 read=784
  • I/O Timings: read=25.426
3. 91,050.264 91,050.264 ↑ 12.0 1 235,272

Index Only Scan using index_payment_lines_on_payment_id on public.payment_lines (cost=0.11..3.42 rows=12 width=4) (actual time=0.364..0.387 rows=1 loops=235,272)

  • Output: payment_lines.payment_id
  • Index Cond: (payment_lines.payment_id = payments.id)
  • Heap Fetches: 85327
  • Buffers: shared hit=1120621 read=43366 dirtied=87
  • I/O Timings: read=89938.737