explain.depesz.com

PostgreSQL's explain analyze made readable

Result: osgX

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1,011.626 ↑ 1.0 10 1

Limit (cost=79,904.14..79,904.16 rows=10 width=130) (actual time=1,011.623..1,011.626 rows=10 loops=1)

  • Output: main_unifiedjob.id, main_unifiedjob.polymorphic_ctype_id, main_unifiedjob.created, main_unifiedjob.modified, main_unifiedjob.description, main_unifiedjob.created_by_id, main_unifiedjob.modified_by_id, main_unifiedjob.name, main
2. 232.635 1,011.623 ↑ 60,526.1 10 1

Sort (cost=79,904.14..81,417.29 rows=605,261 width=130) (actual time=1,011.622..1,011.623 rows=10 loops=1)

  • Output: main_unifiedjob.id, main_unifiedjob.polymorphic_ctype_id, main_unifiedjob.created, main_unifiedjob.modified, main_unifiedjob.description, main_unifiedjob.created_by_id, main_unifiedjob.modified_by_id, main_unifiedjob.name
  • Sort Key: main_unifiedjob.created DESC
  • Sort Method: top-N heapsort Memory: 45kB
3. 240.060 778.988 ↑ 1.0 604,550 1

Merge Left Join (cost=0.85..66,824.67 rows=605,261 width=130) (actual time=0.105..778.988 rows=604,550 loops=1)

  • Output: main_unifiedjob.id, main_unifiedjob.polymorphic_ctype_id, main_unifiedjob.created, main_unifiedjob.modified, main_unifiedjob.description, main_unifiedjob.created_by_id, main_unifiedjob.modified_by_id, main_unifiedjo
  • Merge Cond: (main_unifiedjob.id = main_job.unifiedjob_ptr_id)
  • Filter: ((main_job.job_slice_count <= 1) OR (main_job.job_slice_count IS NULL))
4. 316.707 316.707 ↑ 1.0 604,550 1

Index Scan using main_unifiedjob_pkey on public.main_unifiedjob (cost=0.42..32,702.20 rows=605,261 width=130) (actual time=0.085..316.707 rows=604,550 loops=1)

  • Output: main_unifiedjob.id, main_unifiedjob.polymorphic_ctype_id, main_unifiedjob.created, main_unifiedjob.modified, main_unifiedjob.description, main_unifiedjob.created_by_id, main_unifiedjob.modified_by_id, main_uni
  • Filter: (main_unifiedjob.unified_job_template_id = 10)
  • Rows Removed by Filter: 2131
5. 222.221 222.221 ↑ 1.0 604,584 1

Index Scan using main_job_pkey on public.main_job (cost=0.42..23,541.22 rows=606,105 width=8) (actual time=0.009..222.221 rows=604,584 loops=1)

  • Output: main_job.unifiedjob_ptr_id, main_job.job_slice_count