explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mDl6x

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

Hash Join (cost=761.33..1,487.26 rows=16,219 width=672) (actual rows= loops=)

  • Hash Cond: ((endorsement.id = endorsement_insured.endorsement_id) AND (endorsement.due_to_endorsement_id = endorsement_insured.due_to_endorsement_id))
2. 0.000 0.000 ↓ 0.0

Seq Scan on endorsement (cost=0.00..563.32 rows=16,275 width=605) (actual rows= loops=)

  • Filter: (NOT admitted)
3. 0.000 0.000 ↓ 0.0

Hash (cost=503.73..503.73 rows=17,173 width=95) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on endorsement_insured (cost=0.00..503.73 rows=17,173 width=95) (actual rows= loops=)