explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ItCF : Optimization for: plan #J3sG

Settings

Optimization path:

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

Limit (cost=11,219.46..11,219.71 rows=100 width=89) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=11,219.46..11,222.80 rows=1,336 width=89) (actual rows= loops=)

  • Sort Key: c.cwid
3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=11,108.28..11,155.04 rows=1,336 width=89) (actual rows= loops=)

  • Group Key: m.name, c.cwid
4. 0.000 0.000 ↓ 0.0

Sort (cost=11,108.28..11,111.62 rows=1,336 width=120) (actual rows= loops=)

  • Sort Key: m.name, c.cwid
5. 0.000 0.000 ↓ 0.0

Gather (cost=1,001.53..11,038.91 rows=1,336 width=120) (actual rows= loops=)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.53..9,905.31 rows=557 width=120) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.11..9,593.10 rows=557 width=54) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.68..5,250.39 rows=557 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.54..5,018.69 rows=668 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Parallel Index Only Scan using matches_pkey on matches (cost=0.40..4,907.11 rows=668 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using names_pkey on names n (cost=0.14..0.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (nameid = matches.nameid)
12. 0.000 0.000 ↓ 0.0

Index Scan using models_pkey on models m (cost=0.14..0.35 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (modelid = n.modelid)
  • Filter: good
13. 0.000 0.000 ↓ 0.0

Index Scan using cw_pkey on cw c (cost=0.42..7.80 rows=1 width=42) (actual rows= loops=)

  • Index Cond: (cwid = matches.cwid)
  • Filter: (NOT done)
14. 0.000 0.000 ↓ 0.0

Index Scan using cwb_id on cwbypass b (cost=0.42..0.54 rows=2 width=74) (actual rows= loops=)

  • Index Cond: (c.cwid = cwid)