explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CwiY

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

Nested Loop Semi Join (cost=35.09..67.00 rows=1 width=976) (actual time=0.018..0.019 rows=0 loops=1)

  • Join Filter: (repayments_repayment.id = repayments_repayment_1.id)
2. 0.003 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.14..25.26 rows=1 width=980) (actual time=0.015..0.017 rows=0 loops=1)

3. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on repayments_repayment (cost=0.00..16.90 rows=1 width=8) (actual time=0.013..0.014 rows=0 loops=1)

  • Filter: ((due_date <= '2019-09-15'::date) AND (status = 4))
  • Rows Removed by Filter: 1
4. 0.000 0.000 ↓ 0.0 0

Index Scan using loans_loan_pkey on loans_loan (cost=0.14..8.16 rows=1 width=976) (never executed)

  • Index Cond: (id = repayments_repayment.loan_id)
5. 0.000 0.000 ↓ 0.0 0

Unique (cost=34.94..37.24 rows=200 width=12) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Sort (cost=34.94..36.09 rows=460 width=12) (never executed)

  • Sort Key: repayments_repayment_1.loan_id, repayments_repayment_1.due_date DESC
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on repayments_repayment repayments_repayment_1 (cost=0.00..14.60 rows=460 width=12) (never executed)

Planning time : 0.300 ms
Execution time : 0.070 ms