#	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)

QUERY PLAN
Limit  (cost=13.73..13.74 rows=1 width=1767) (actual time=0.070..0.070 rows=1 loops=1)
  ->  Sort  (cost=13.73..13.74 rows=1 width=1767) (actual time=0.070..0.070 rows=1 loops=1)
        Sort Key: main_unifiedjob.created DESC
        Sort Method: quicksort  Memory: 27kB
        ->  Nested Loop  (cost=0.27..13.72 rows=1 width=1767) (actual time=0.037..0.046 rows=1 loops=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
              ->  Index Scan using main_unifiedjob_pkey on main_unifiedjob  (cost=0.27..8.29 rows=1 width=1541) (actual time=0.007..0.007 rows=1 loops=1)
                    Index Cond: (id = main_job.unifiedjob_ptr_id)
Planning time: 0.873 ms
Execution time: 0.151 ms

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	0.007 ms	10.0 %
Limit	1	0.000 ms	0.0 %
Nested Loop	1	0.002 ms	2.9 %
Seq Scan	1	0.037 ms	52.9 %
Sort	1	0.024 ms	34.3 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
main_job	1	0.037 ms	52.9 %
Seq Scan	1	0.037 ms	100.0 %
main_unifiedjob	1	0.007 ms	10.0 %
Index Scan	1	0.007 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kl4G : devel recent_jobs

Color mode:

Visible columns:

Per node type stats

Per table stats