explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rRme

Settings
# exclusive inclusive rows x rows loops node
1. 342.654 145,960.837 ↓ 1.0 6,856,609 1

Nested Loop (cost=0.23..98,437,675.23 rows=6,563,962 width=4) (actual time=4.821..145,960.837 rows=6,856,609 loops=1)

  • Planning time: 0.263 ms
  • Execution time: 146258.287 ms
2. 1,319.193 1,319.193 ↓ 1.1 6,559,045 1

Index Only Scan using mws_and_id on payments (cost=0.11..117,489.30 rows=6,174,976 width=4) (actual time=0.062..1,319.193 rows=6,559,045 loops=1)

  • Index Cond: (mws_credential_id = 905)
  • Heap Fetches: 41159
3. 144,298.990 144,298.990 ↑ 15.0 1 6,559,045

Index Only Scan using index_payment_lines_on_payment_id on payment_lines (cost=0.11..15.88 rows=15 width=4) (actual time=0.018..0.022 rows=1 loops=6,559,045)

  • Index Cond: (payment_id = payments.id)
  • Heap Fetches: 6657671