explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dstU

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

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

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

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

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

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

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

Index Scan using db_buildjobstatus_pkey on db_buildjobstatus (cost=0.43..168,473.86 rows=1,112,811 width=2,465) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

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

6. 0.000 0.000 ↓ 0.0

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