explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kl4G : devel recent_jobs

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.070 ↑ 1.0 1 1

Limit (cost=13.73..13.74 rows=1 width=1,767) (actual time=0.070..0.070 rows=1 loops=1)

2. 0.024 0.070 ↑ 1.0 1 1

Sort (cost=13.73..13.74 rows=1 width=1,767) (actual time=0.070..0.070 rows=1 loops=1)

  • Sort Key: main_unifiedjob.created DESC
  • Sort Method: quicksort Memory: 27kB
3. 0.002 0.046 ↑ 1.0 1 1

Nested Loop (cost=0.27..13.72 rows=1 width=1,767) (actual time=0.037..0.046 rows=1 loops=1)

4. 0.037 0.037 ↑ 1.0 1 1

Seq Scan on main_job (cost=0.00..5.42 rows=1 width=226) (actual time=0.028..0.037 rows=1 loops=1)

  • Filter: (job_template_id = 665)
  • Rows Removed by Filter: 113
5. 0.007 0.007 ↑ 1.0 1 1

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

  • Index Cond: (id = main_job.unifiedjob_ptr_id)