explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AQS : recent_jobs

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.076 ↓ 0.0 0 1

Limit (cost=13.89..13.90 rows=1 width=1,541) (actual time=0.076..0.076 rows=0 loops=1)

2. 0.031 0.068 ↓ 0.0 0 1

Sort (cost=13.89..13.90 rows=1 width=1,541) (actual time=0.068..0.068 rows=0 loops=1)

  • Sort Key: main_unifiedjob.created DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.011 0.037 ↓ 0.0 0 1

Hash Right Join (cost=8.30..13.88 rows=1 width=1,541) (actual time=0.037..0.037 rows=0 loops=1)

  • Hash Cond: (main_job.unifiedjob_ptr_id = main_unifiedjob.id)
  • Filter: ((main_job.job_slice_count <= 1) OR (main_job.job_slice_count IS NULL))
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on main_job (cost=0.00..5.14 rows=114 width=8) (never executed)

5. 0.008 0.026 ↓ 0.0 0 1

Hash (cost=8.29..8.29 rows=1 width=1,541) (actual time=0.026..0.026 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.018 0.018 ↓ 0.0 0 1

Index Scan using main_unifiedjob_unified_job_template_id_a398b197 on main_unifiedjob (cost=0.27..8.29 rows=1 width=1,541) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (unified_job_template_id = 350)