explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IBRs

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=496.42..15,195.70 rows=1,929 width=217) (actual rows= loops=)

  • Hash Cond: (t1.person_id = t3.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.42..14,653.90 rows=1,929 width=152) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on microcredit_request t1 (cost=0.00..846.67 rows=1,929 width=124) (actual rows= loops=)

  • Filter: is_test
4. 0.000 0.000 ↓ 0.0

Index Scan using microcredit_proposal_proposal_id_idx on microcredit_proposal t2 (cost=0.42..7.15 rows=1 width=57) (actual rows= loops=)

  • Index Cond: ((t1.proposal_id)::text = (proposal_id)::text)
5. 0.000 0.000 ↓ 0.0

Hash (cost=369.89..369.89 rows=10,089 width=87) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on mandarin_fl t3 (cost=0.00..369.89 rows=10,089 width=87) (actual rows= loops=)