explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9IDH

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

Sort (cost=917,763.95..918,279.64 rows=206,275 width=3,496) (actual rows= loops=)

  • Sort Key: db_buildjob.updated_at DESC
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3.97..279,117.84 rows=206,275 width=3,496) (actual rows= loops=)

  • Hash Cond: (db_buildjob.code_reference_id = db_codereference.id)
3. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=0.85..276,278.51 rows=206,275 width=3,329) (actual rows= loops=)

  • Merge Cond: (db_buildjob.status_id = db_buildjobstatus.id)
4. 0.000 0.000 ↓ 0.0

Index Scan using db_buildjob_status_id_key on db_buildjob (cost=0.42..102,219.26 rows=206,275 width=864) (actual rows= loops=)

  • Filter: (NOT deleted)
5. 0.000 0.000 ↓ 0.0

Index Scan using db_buildjobstatus_pkey on db_buildjobstatus (cost=0.43..168,695.13 rows=1,114,273 width=2,465) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=2.50..2.50 rows=50 width=167) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on db_codereference (cost=0.00..2.50 rows=50 width=167) (actual rows= loops=)