explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dkWJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 32.054 ↓ 0.0 0 1

GroupAggregate (cost=12,122.07..12,122.64 rows=19 width=28) (actual time=32.054..32.054 rows=0 loops=1)

  • Group Key: (date(task.updated_at))
2. 0.000 32.052 ↓ 0.0 0 1

Sort (cost=12,122.07..12,122.12 rows=19 width=15) (actual time=32.052..32.052 rows=0 loops=1)

  • Sort Key: (date(task.updated_at))
  • Sort Method: quicksort Memory: 25kB
3. 24.244 32.890 ↓ 0.0 0 1

Gather (cost=1,004.65..12,121.66 rows=19 width=15) (actual time=32.023..32.890 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.010 8.646 ↓ 0.0 0 3 / 3

Hash Join (cost=4.65..11,119.76 rows=8 width=15) (actual time=8.646..8.646 rows=0 loops=3)

  • Hash Cond: ("job->jobSet".test_suite_id = "job->jobSet->testSuite".id)
5. 0.000 8.624 ↑ 37.0 1 3 / 3

Nested Loop (cost=0.58..11,115.57 rows=37 width=23) (actual time=2.767..8.624 rows=1 loops=3)

6. 0.004 8.617 ↑ 37.0 1 3 / 3

Nested Loop (cost=0.29..11,102.73 rows=37 width=23) (actual time=2.761..8.617 rows=1 loops=3)

7. 8.601 8.601 ↑ 37.0 1 3 / 3

Parallel Seq Scan on tasks task (cost=0.00..10,842.44 rows=37 width=23) (actual time=2.747..8.601 rows=1 loops=3)

  • Filter: ((updated_at >= '2020-03-15 22:00:00+00'::timestamp with time zone) AND (updated_at <= '2020-03-23 22:00:00+00'::timestamp with time zone) AND ((status)::text = ANY ('{passed,failed}'::text[])))
  • Rows Removed by Filter: 24430
8. 0.012 0.012 ↑ 1.0 1 4 / 3

Index Scan using jobs_pkey on jobs job (cost=0.29..7.03 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=4)

  • Index Cond: (id = task.job_id)
9. 0.007 0.007 ↑ 1.0 1 4 / 3

Index Scan using job_sets_pkey on job_sets "job->jobSet" (cost=0.29..0.35 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=4)

  • Index Cond: (id = job.job_set_id)
10. 0.004 0.012 ↑ 1.0 29 1 / 3

Hash (cost=3.71..3.71 rows=29 width=4) (actual time=0.035..0.035 rows=29 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
11. 0.008 0.008 ↑ 1.0 29 1 / 3

Seq Scan on test_suites "job->jobSet->testSuite" (cost=0.00..3.71 rows=29 width=4) (actual time=0.010..0.024 rows=29 loops=1)

  • Filter: (organization_id = 1)
  • Rows Removed by Filter: 108
Planning time : 1.210 ms
Execution time : 33.179 ms