explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NnsT

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.432 ↓ 0.0 0 1

Nested Loop (cost=6.87..12.85 rows=1 width=31) (actual time=1.431..1.432 rows=0 loops=1)

  • Join Filter: (ap.id = ah.ap_payment_id)
2. 0.001 1.430 ↓ 0.0 0 1

Nested Loop (cost=0.42..6.29 rows=1 width=9) (actual time=1.430..1.430 rows=0 loops=1)

  • Join Filter: (ap.bank_account_id = ba.id)
3. 1.429 1.429 ↓ 0.0 0 1

Index Scan using pk_ap_payments on ap_payments ap (cost=0.29..3.21 rows=1 width=17) (actual time=1.429..1.429 rows=0 loops=1)

  • Index Cond: (cid = 13916)
  • Filter: (id = ANY ('{1000181,1000182,1000183,1000184,1000185,1000186,1000187,1000188,1000189,1000190}'::integer[]))
4. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_bank_accounts on bank_accounts ba (cost=0.14..3.05 rows=1 width=8) (never executed)

  • Index Cond: (cid = 13916)
  • Heap Fetches: 0
5. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=6.45..6.50 rows=1 width=30) (never executed)

  • Group Key: ah.cid, ah.header_number, ah.ap_payee_id, ah.ap_payment_id
6. 0.000 0.000 ↓ 0.0 0

Sort (cost=6.45..6.45 rows=1 width=26) (never executed)

  • Sort Key: ah.header_number, ah.ap_payee_id, ah.ap_payment_id
7. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..6.44 rows=1 width=26) (never executed)

  • Join Filter: (ah.id = ad.ap_header_id)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ap_headers on ap_headers ah (cost=0.29..3.20 rows=1 width=26) (never executed)

  • Index Cond: (cid = 13916)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_ap_details_cid_apheaderid on ap_details ad (cost=0.29..3.20 rows=1 width=12) (never executed)

  • Index Cond: (cid = 13916)
  • Filter: (deleted_on IS NULL)
Planning time : 133.503 ms