explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ufJH

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

Nested Loop (cost=659.00..1,342.51 rows=16,094 width=1,244) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=658.71..1,301.85 rows=1 width=720) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=658.42..1,172.63 rows=1 width=625) (actual rows= loops=)

  • Hash Cond: ((endorsement_carrier.endorsement_id = endorsement_agency.endorsement_id) AND (endorsement_carrier.due_to_endorsement_id = endorsement_agency.due_to_endorsement_id))
4. 0.000 0.000 ↓ 0.0

Seq Scan on endorsement_carrier (cost=0.00..385.54 rows=17,154 width=567) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=400.77..400.77 rows=17,177 width=58) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on endorsement_agency (cost=0.00..400.77 rows=17,177 width=58) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using endorsement_insured_pkey on endorsement_insured (cost=0.29..129.21 rows=1 width=95) (actual rows= loops=)

  • Index Cond: (endorsement_id = endorsement_carrier.endorsement_id)
  • Filter: (endorsement_carrier.due_to_endorsement_id = due_to_endorsement_id)
8. 0.000 0.000 ↓ 0.0

Index Scan using endorsement_pkey on endorsement (cost=0.29..0.43 rows=1 width=616) (actual rows= loops=)

  • Index Cond: ((id = endorsement_insured.endorsement_id) AND (due_to_endorsement_id = endorsement_insured.due_to_endorsement_id))
  • Filter: (NOT admitted)