explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4dbm

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

GroupAggregate (cost=894.36..894.96 rows=20 width=28) (actual time=0.232..0.232 rows=0 loops=1)

  • Group Key: (date(task.updated_at))
2. 0.002 0.231 ↓ 0.0 0 1

Sort (cost=894.36..894.41 rows=20 width=15) (actual time=0.231..0.231 rows=0 loops=1)

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

Hash Join (cost=5.07..893.93 rows=20 width=15) (actual time=0.228..0.229 rows=0 loops=1)

  • Hash Cond: ("job->jobSet".test_suite_id = "job->jobSet->testSuite".id)
4. 0.005 0.125 ↑ 23.8 4 1

Nested Loop (cost=0.99..889.54 rows=95 width=23) (actual time=0.103..0.125 rows=4 loops=1)

5. 0.005 0.088 ↑ 23.8 4 1

Nested Loop (cost=0.71..856.57 rows=95 width=23) (actual time=0.075..0.088 rows=4 loops=1)

6. 0.055 0.055 ↑ 23.8 4 1

Index Scan using idx_tasks_status on tasks task (cost=0.42..195.35 rows=95 width=23) (actual time=0.048..0.055 rows=4 loops=1)

  • Index Cond: ((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))
  • Filter: ((status)::text = ANY ('{passed,failed}'::text[]))
  • Rows Removed by Filter: 3
7. 0.028 0.028 ↑ 1.0 1 4

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

  • Index Cond: (id = task.job_id)
8. 0.032 0.032 ↑ 1.0 1 4

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)
9. 0.011 0.031 ↑ 1.0 29 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.020 0.020 ↑ 1.0 29 1

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

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