explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EWRp

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

Hash Join (cost=32.70..84.53 rows=777 width=1,313) (actual rows= loops=)

  • Hash Cond: (loan.customer_id = c.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on t_loan_app loan (cost=0.00..49.77 rows=777 width=624) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=23.98..23.98 rows=698 width=689) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on t_customer c (cost=0.00..23.98 rows=698 width=689) (actual rows= loops=)