explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KRBa

Settings
# exclusive inclusive rows x rows loops node
1. 5.617 240.352 ↑ 1.0 10 1

Limit (cost=19,896.99..19,897.01 rows=10 width=77) (actual time=234.725..240.352 rows=10 loops=1)

2. 0.029 234.735 ↑ 202.5 10 1

Sort (cost=19,896.99..19,902.05 rows=2,025 width=77) (actual time=234.724..234.735 rows=10 loops=1)

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

Finalize GroupAggregate (cost=19,319.94..19,853.23 rows=2,025 width=77) (actual time=234.667..234.706 rows=13 loops=1)

  • Group Key: request_logs.name
4. 21.763 240.268 ↑ 103.8 39 1

Gather Merge (cost=19,319.94..19,792.48 rows=4,050 width=93) (actual time=234.648..240.268 rows=39 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.065 218.505 ↑ 155.8 13 3 / 3

Sort (cost=18,319.92..18,324.98 rows=2,025 width=93) (actual time=218.505..218.505 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. 48.195 218.440 ↑ 155.8 13 3 / 3

Partial HashAggregate (cost=18,188.46..18,208.71 rows=2,025 width=93) (actual time=218.415..218.440 rows=13 loops=3)

  • Group Key: request_logs.name
7. 21.744 170.245 ↓ 5.4 93,692 3 / 3

Nested Loop (cost=91.52..18,058.03 rows=17,391 width=61) (actual time=24.749..170.245 rows=93,692 loops=3)

8. 2.894 51.582 ↓ 1.9 3,728 3 / 3

Hash Join (cost=91.09..10,910.88 rows=1,938 width=4) (actual time=24.475..51.582 rows=3,728 loops=3)

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

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

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

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

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

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

12. 0.004 0.093 ↑ 1.0 1 3 / 3

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

13. 0.051 0.051 ↑ 1.0 1 3 / 3

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

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

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

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

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

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

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

17. 0.021 0.343 ↑ 1.0 29 3 / 3

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

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

Seq Scan on test_suites (cost=0.00..3.71 rows=29 width=8) (actual time=0.289..0.322 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.011..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 : 3.350 ms
Execution time : 240.604 ms