explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QYBJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.052 14.156 ↓ 0.0 0 1

Sort (cost=1,141.86..1,141.86 rows=1 width=110) (actual time=14.156..14.156 rows=0 loops=1)

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

Nested Loop (cost=0.29..1,141.85 rows=1 width=110) (actual time=14.104..14.104 rows=0 loops=1)

3. 0.000 14.104 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..1,125.16 rows=1 width=110) (actual time=14.104..14.104 rows=0 loops=1)

  • Join Filter: (job.screen_resolution_id = "screenResolution".id)
4. 0.000 14.104 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..1,124.00 rows=1 width=91) (actual time=14.104..14.104 rows=0 loops=1)

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

Nested Loop Left Join (cost=0.00..1,122.67 rows=1 width=74) (actual time=14.104..14.104 rows=0 loops=1)

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

Seq Scan on jobs job (cost=0.00..1,121.60 rows=1 width=60) (actual time=14.102..14.102 rows=0 loops=1)

  • Filter: ((status)::text = 'pending'::text)
  • Rows Removed by Filter: 46928
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 browsers browser (cost=0.00..1.15 rows=15 width=17) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Seq Scan on screen_resolutions "screenResolution" (cost=0.00..1.07 rows=7 width=19) (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 : 18.550 ms
Execution time : 14.382 ms