explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YnqI

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 15.369 ↓ 0.0 0 1

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

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

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.055 10.679 ↓ 0.0 0 3 / 3

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

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

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

6. 0.006 10.579 ↑ 37.0 1 3 / 3

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

7. 10.560 10.560 ↑ 37.0 1 3 / 3

Parallel Seq Scan on tasks task (cost=0.00..10,842.44 rows=37 width=23) (actual time=4.931..10.560 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.013 0.013 ↑ 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.010..0.010 rows=1 loops=4)

  • Index Cond: (id = task.job_id)
9. 0.011 0.011 ↑ 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.008..0.008 rows=1 loops=4)

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

Hash (cost=3.71..3.71 rows=29 width=4) (actual time=0.050..0.050 rows=29 loops=2)

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

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

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