explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gr9m

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.162 ↓ 0.0 0 1

Sort (cost=64.53..64.53 rows=1 width=546) (actual time=0.162..0.162 rows=0 loops=1)

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

Nested Loop (cost=0.57..64.52 rows=1 width=546) (actual time=0.159..0.159 rows=0 loops=1)

3. 0.000 0.159 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.30..47.90 rows=1 width=546) (actual time=0.159..0.159 rows=0 loops=1)

4. 0.000 0.159 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.15..39.71 rows=1 width=452) (actual time=0.159..0.159 rows=0 loops=1)

  • Join Filter: (job.browser_id = browser.id)
5. 0.000 0.159 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.15..38.37 rows=1 width=227) (actual time=0.159..0.159 rows=0 loops=1)

6. 0.159 0.159 ↓ 0.0 0 1

Seq Scan on jobs job (cost=0.00..30.16 rows=1 width=59) (actual time=0.159..0.159 rows=0 loops=1)

  • Filter: ((status)::text = 'pending'::text)
  • Rows Removed by Filter: 1163
7. 0.000 0.000 ↓ 0.0 0

Index Scan using operating_systems_pkey on operating_systems "operatingSystem" (cost=0.15..8.17 rows=1 width=168) (never executed)

  • Index Cond: (job.operating_system_id = id)
8. 0.000 0.000 ↓ 0.0 0

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

9. 0.000 0.000 ↓ 0.0 0

Index Scan using screen_resolutions_pkey on screen_resolutions "screenResolution" (cost=0.15..8.17 rows=1 width=94) (never executed)

  • Index Cond: (job.screen_resolution_id = id)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using job_sets_pkey on job_sets "jobSet" (cost=0.28..16.60 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.30..8.31 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.28..8.30 rows=1 width=4) (never executed)

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