explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C0ic

Settings
# exclusive inclusive rows x rows loops node
1. 6.505 242.390 ↑ 1.0 10 1

Limit (cost=19,901.54..19,901.56 rows=10 width=77) (actual time=235.886..242.390 rows=10 loops=1)

2. 0.031 235.885 ↑ 202.5 10 1

Sort (cost=19,901.54..19,906.60 rows=2,025 width=77) (actual time=235.885..235.885 rows=10 loops=1)

  • Sort Key: (max(request_logs.duration)) DESC
  • Sort Method: quicksort Memory: 26kB
3. 0.000 235.854 ↑ 155.8 13 1

Finalize GroupAggregate (cost=19,324.50..19,857.78 rows=2,025 width=77) (actual time=235.813..235.854 rows=13 loops=1)

  • Group Key: request_logs.name
4. 18.572 242.295 ↑ 103.8 39 1

Gather Merge (cost=19,324.50..19,797.03 rows=4,050 width=93) (actual time=235.782..242.295 rows=39 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.206 223.723 ↑ 155.8 13 3 / 3

Sort (cost=18,324.47..18,329.53 rows=2,025 width=93) (actual time=223.722..223.723 rows=13 loops=3)

  • Sort Key: request_logs.name
  • Sort Method: quicksort Memory: 26kB
  • Worker 0: Sort Method: quicksort Memory: 26kB
  • Worker 1: Sort Method: quicksort Memory: 26kB
6. 50.939 223.517 ↑ 155.8 13 3 / 3

Partial HashAggregate (cost=18,193.01..18,213.26 rows=2,025 width=93) (actual time=223.483..223.517 rows=13 loops=3)

  • Group Key: request_logs.name
7. 24.289 172.578 ↓ 5.4 93,692 3 / 3

Nested Loop (cost=91.52..18,062.44 rows=17,410 width=61) (actual time=22.249..172.578 rows=93,692 loops=3)

8. 3.663 51.370 ↓ 1.9 3,728 3 / 3

Hash Join (cost=91.09..10,910.94 rows=1,940 width=4) (actual time=21.993..51.370 rows=3,728 loops=3)

  • Hash Cond: (tasks.test_id = tests.id)
9. 45.036 45.036 ↑ 1.2 7,355 3 / 3

Parallel Seq Scan on tasks (cost=0.00..10,766.09 rows=9,162 width=8) (actual time=17.928..45.036 rows=7,355 loops=3)

  • Filter: ((updated_at >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (updated_at <= '2020-01-31 22:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 17076
10. 0.050 2.671 ↑ 3.6 147 3 / 3

Hash (cost=84.42..84.42 rows=534 width=4) (actual time=2.671..2.671 rows=147 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
11. 0.055 2.621 ↑ 3.6 147 3 / 3

Nested Loop (cost=4.08..84.42 rows=534 width=4) (actual time=0.928..2.621 rows=147 loops=3)

12. 0.003 0.133 ↑ 1.0 1 3 / 3

Nested Loop (cost=0.00..2.96 rows=1 width=4) (actual time=0.119..0.133 rows=1 loops=3)

13. 0.079 0.079 ↑ 1.0 1 3 / 3

Seq Scan on organizations (cost=0.00..1.48 rows=1 width=4) (actual time=0.073..0.079 rows=1 loops=3)

  • Filter: (id = 1)
  • Rows Removed by Filter: 37
14. 0.051 0.051 ↑ 1.0 1 3 / 3

Seq Scan on organization_members (cost=0.00..1.48 rows=1 width=4) (actual time=0.043..0.051 rows=1 loops=3)

  • Filter: (organization_id = 1)
  • Rows Removed by Filter: 37
15. 1.574 2.433 ↑ 3.6 147 3 / 3

Hash Join (cost=4.08..76.12 rows=534 width=8) (actual time=0.806..2.433 rows=147 loops=3)

  • Hash Cond: (tests.test_suite_id = test_suites.id)
16. 0.482 0.482 ↑ 1.0 2,522 3 / 3

Seq Scan on tests (cost=0.00..65.22 rows=2,522 width=8) (actual time=0.055..0.482 rows=2,522 loops=3)

17. 0.017 0.377 ↑ 1.0 29 3 / 3

Hash (cost=3.71..3.71 rows=29 width=8) (actual time=0.376..0.377 rows=29 loops=3)

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

Seq Scan on test_suites (cost=0.00..3.71 rows=29 width=8) (actual time=0.168..0.360 rows=29 loops=3)

  • Filter: (organization_id = 1)
  • Rows Removed by Filter: 108
19. 96.919 96.919 ↓ 1.3 25 11,183 / 3

Index Scan using request_logs_task_id on request_logs (cost=0.42..3.50 rows=19 width=65) (actual time=0.010..0.026 rows=25 loops=11,183)

  • Index Cond: (task_id = tasks.id)
  • Filter: ((entry_type)::text <> 'navigation'::text)
  • Rows Removed by Filter: 2
Planning time : 4.252 ms
Execution time : 242.630 ms