explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gv7E

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1.259 ↑ 1.0 1 1
→

Limit (cost=2,393.42..2,393.42 rows=1 width=1,563) (actual time=1.257..1.259 rows=1 loops=1)

2. 0.023 1.256 ↑ 8.0 1 1
→

Sort (cost=2,393.42..2,393.44 rows=8 width=1,563) (actual time=1.256..1.256 rows=1 loops=1)

  • Sort Key: report.id DESC
  • Sort Method: top-N heapsort Memory: 26kB
3. 0.049 1.233 ↓ 2.5 20 1
→

Nested Loop (cost=0.86..2,393.38 rows=8 width=1,563) (actual time=0.031..1.233 rows=20 loops=1)

4. 0.228 0.228 ↑ 1.0 239 1
→

Index Scan using service_bki_upload_billing_loan_billing_loan_id on service_bki_upload_billing_loan ""uploadedLoan"" (cost=0.43..317.45 rows=246 width=4) (actual time=0.013..0.228 rows=239 loops=1)

  • Index Cond: (billing_loan_id = 3492086)
5. 0.956 0.956 ↓ 0.0 0 239
→

Index Scan using service_bki_upload_pkey on service_bki_upload report (cost=0.43..8.44 rows=1 width=1,563) (actual time=0.004..0.004 rows=0 loops=239)

  • Index Cond: (id = ""uploadedLoan"".service_bki_upload_id)
  • Filter: ((service_bki_upload_state_id = ANY ('{3,4}'::integer[])) AND (service_id = 3427))
  • Rows Removed by Filter: 1