explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8NbX : versions for all designs

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

Unique (cost=74.72..79.22 rows=600 width=40) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=74.72..76.22 rows=600 width=40) (actual rows= loops=)

  • Sort Key: design_management_versions.id DESC, design_management_versions.sha
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=18.54..47.04 rows=600 width=40) (actual rows= loops=)

  • Hash Cond: (design_management_versions.id = design_management_designs_versions.version_id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on design_management_versions (cost=0.00..22.00 rows=1,200 width=40) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=16.04..16.04 rows=200 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

HashAggregate (cost=14.04..16.04 rows=200 width=8) (actual rows= loops=)

  • Group Key: design_management_designs_versions.version_id
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.15..9.41 rows=1,850 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on design_management_designs (cost=0.00..1.01 rows=1 width=8) (actual rows= loops=)

  • Filter: (issue_id = 248)
9. 0.000 0.000 ↓ 0.0

Index Only Scan using design_management_designs_versions_uniqueness on design_management_designs_versions (cost=0.15..8.31 rows=9 width=16) (actual rows= loops=)

  • Index Cond: (design_id = design_management_designs.id)