explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gEJl

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.080 ↓ 0.0 0 1

Sort (cost=28.56..28.57 rows=1 width=110) (actual time=0.080..0.080 rows=0 loops=1)

  • Sort Key: job.created_at
  • Sort Method: quicksort Memory: 25kB
2. 0.000 0.074 ↓ 0.0 0 1

Nested Loop (cost=0.58..28.55 rows=1 width=110) (actual time=0.074..0.074 rows=0 loops=1)

3. 0.000 0.074 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..11.87 rows=1 width=110) (actual time=0.074..0.074 rows=0 loops=1)

  • Join Filter: (job.browser_id = browser.id)
4. 0.001 0.074 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..10.53 rows=1 width=93) (actual time=0.074..0.074 rows=0 loops=1)

  • Join Filter: (job.screen_resolution_id = "screenResolution".id)
5. 0.001 0.073 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..9.37 rows=1 width=74) (actual time=0.073..0.073 rows=0 loops=1)

  • Join Filter: (job.operating_system_id = "operatingSystem".id)
6. 0.072 0.072 ↓ 0.0 0 1

Index Scan using idx_jobs_status on jobs job (cost=0.29..8.31 rows=1 width=60) (actual time=0.072..0.072 rows=0 loops=1)

  • Index Cond: ((status)::text = 'pending'::text)
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on operating_systems "operatingSystem" (cost=0.00..1.03 rows=3 width=14) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Seq Scan on screen_resolutions "screenResolution" (cost=0.00..1.07 rows=7 width=19) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Seq Scan on browsers browser (cost=0.00..1.15 rows=15 width=17) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Index Scan using job_sets_pkey on job_sets "jobSet" (cost=0.29..16.67 rows=1 width=5) (never executed)

  • Index Cond: (id = job.job_set_id)
  • Filter: (run_in_parallel OR ((NOT run_in_parallel) AND ((SubPlan 1) = 0)))
11.          

SubPlan (for Index Scan)

12. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.36..8.37 rows=1 width=8) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using jobs_job_set_id on jobs jobs2 (cost=0.29..8.35 rows=1 width=4) (never executed)

  • Index Cond: (job_set_id = job.job_set_id)
  • Filter: ((status)::text = 'running'::text)
Planning time : 1.036 ms
Execution time : 0.172 ms