explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rSjr

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

Limit (cost=21,103.79..21,103.80 rows=1 width=24) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=21,103.79..21,103.80 rows=1 width=24) (actual rows= loops=)

  • Sort Key: claim.created_ts DESC
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.41..21,103.78 rows=1 width=24) (actual rows= loops=)

  • Join Filter: (linepolicy.id = claim.line_policy_id)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.41..19,169.16 rows=3 width=16) (actual rows= loops=)

  • Join Filter: (cc.id = linepolicy.coverage_contract_id)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.41..11,651.43 rows=1 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on sale (cost=0.00..11,643.00 rows=1 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Only Scan using coverage_contract_pk on coverage_contract cc (cost=0.41..8.43 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = sale.coverage_contract_id)
8. 0.000 0.000 ↓ 0.0

Seq Scan on line_policy linepolicy (cost=0.00..7,172.88 rows=27,588 width=32) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1,724.25 rows=4,950 width=40) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on claim (cost=0.00..1,699.50 rows=4,950 width=40) (actual rows= loops=)