explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UQeU

Settings
# exclusive inclusive rows x rows loops node
1. 12.700 303.259 ↓ 7,158.0 7,158 1

Unique (cost=23,178.40..23,178.44 rows=1 width=129) (actual time=289.318..303.259 rows=7,158 loops=1)

2. 71.103 290.559 ↓ 7,158.0 7,158 1

Sort (cost=23,178.40..23,178.40 rows=1 width=129) (actual time=289.305..290.559 rows=7,158 loops=1)

  • Sort Key: tests."order", tests.id, tests.name, tests.description, tests.starting_url, tests.continue_previous, tests.removed, tests.hook, tests.created_at, tests.updated_at, job_sets.id, job_sets.status, tasks.id, tasks.status, tasks.running_time, jobs.ending_time, jobs.id
  • Sort Method: quicksort Memory: 2094kB
3. 5.783 219.456 ↓ 7,158.0 7,158 1

Nested Loop (cost=22,067.58..23,178.39 rows=1 width=129) (actual time=144.338..219.456 rows=7,158 loops=1)

4. 1.667 163.567 ↓ 7,158.0 7,158 1

Hash Join (cost=22,063.72..23,172.78 rows=1 width=125) (actual time=144.292..163.567 rows=7,158 loops=1)

  • Hash Cond: (tests.id = tests_1.id)
5. 9.256 161.817 ↓ 123.4 7,158 1

Hash Right Join (cost=22,047.06..23,155.97 rows=58 width=125) (actual time=144.196..161.817 rows=7,158 loops=1)

  • Hash Cond: (tasks.test_id = tests.id)
6. 50.864 152.546 ↑ 1.0 73,295 1

Sort (cost=22,036.05..22,219.29 rows=73,295 width=46) (actual time=144.154..152.546 rows=73,295 loops=1)

  • Sort Key: job_sets.id DESC
  • Sort Method: external merge Disk: 4464kB
7. 17.357 101.682 ↑ 1.0 73,295 1

Hash Join (cost=2,429.98..13,855.80 rows=73,295 width=46) (actual time=22.525..101.682 rows=73,295 loops=1)

  • Hash Cond: (jobs.job_set_id = job_sets.id)
8. 28.218 77.745 ↑ 1.0 73,295 1

Hash Join (cost=1,590.88..12,824.25 rows=73,295 width=35) (actual time=15.904..77.745 rows=73,295 loops=1)

  • Hash Cond: (tasks.job_id = jobs.id)
9. 33.970 33.970 ↑ 1.0 73,295 1

Seq Scan on tasks (cost=0.00..11,040.95 rows=73,295 width=23) (actual time=0.047..33.970 rows=73,295 loops=1)

10. 8.053 15.557 ↑ 1.0 46,928 1

Hash (cost=1,004.28..1,004.28 rows=46,928 width=16) (actual time=15.557..15.557 rows=46,928 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2712kB
11. 7.504 7.504 ↑ 1.0 46,928 1

Seq Scan on jobs (cost=0.00..1,004.28 rows=46,928 width=16) (actual time=0.006..7.504 rows=46,928 loops=1)

12. 3.428 6.580 ↑ 1.0 17,560 1

Hash (cost=619.60..619.60 rows=17,560 width=11) (actual time=6.579..6.580 rows=17,560 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 994kB
13. 3.152 3.152 ↑ 1.0 17,560 1

Seq Scan on job_sets (cost=0.00..619.60 rows=17,560 width=11) (actual time=0.003..3.152 rows=17,560 loops=1)

14. 0.002 0.015 ↑ 1.0 2 1

Hash (cost=10.98..10.98 rows=2 width=87) (actual time=0.015..0.015 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.004 0.013 ↑ 1.0 2 1

Bitmap Heap Scan on tests (cost=4.30..10.98 rows=2 width=87) (actual time=0.012..0.013 rows=2 loops=1)

  • Recheck Cond: (test_suite_id = 137)
  • Filter: ((hook IS NULL) AND (NOT removed))
  • Heap Blocks: exact=2
16. 0.009 0.009 ↑ 1.0 2 1

Bitmap Index Scan on tests_test_suite_id (cost=0.00..4.29 rows=2 width=0) (actual time=0.008..0.009 rows=2 loops=1)

  • Index Cond: (test_suite_id = 137)
17. 0.002 0.083 ↑ 1.0 2 1

Hash (cost=16.64..16.64 rows=2 width=4) (actual time=0.083..0.083 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
18. 0.001 0.081 ↑ 1.0 2 1

Limit (cost=16.61..16.62 rows=2 width=4) (actual time=0.080..0.081 rows=2 loops=1)

19. 0.001 0.080 ↑ 1.0 2 1

Unique (cost=16.61..16.62 rows=2 width=4) (actual time=0.079..0.080 rows=2 loops=1)

20. 0.005 0.079 ↑ 1.0 2 1

Sort (cost=16.61..16.61 rows=2 width=4) (actual time=0.079..0.079 rows=2 loops=1)

  • Sort Key: tests_1.id
  • Sort Method: quicksort Memory: 25kB
21. 0.001 0.074 ↑ 1.0 2 1

Nested Loop (cost=8.16..16.60 rows=2 width=4) (actual time=0.064..0.074 rows=2 loops=1)

22. 0.002 0.053 ↑ 1.0 1 1

Nested Loop (cost=3.87..5.60 rows=1 width=4) (actual time=0.045..0.053 rows=1 loops=1)

  • Join Filter: (test_suites_1.organization_id = organization_members_1.organization_id)
23. 0.015 0.041 ↑ 1.0 1 1

Hash Join (cost=3.73..5.22 rows=1 width=12) (actual time=0.033..0.041 rows=1 loops=1)

  • Hash Cond: (organizations_1.id = test_suites_1.organization_id)
24. 0.008 0.008 ↑ 1.0 38 1

Seq Scan on organizations organizations_1 (cost=0.00..1.38 rows=38 width=4) (actual time=0.004..0.008 rows=38 loops=1)

25. 0.002 0.018 ↑ 1.0 1 1

Hash (cost=3.71..3.71 rows=1 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
26. 0.016 0.016 ↑ 1.0 1 1

Seq Scan on test_suites test_suites_1 (cost=0.00..3.71 rows=1 width=8) (actual time=0.006..0.016 rows=1 loops=1)

  • Filter: (id = 137)
  • Rows Removed by Filter: 136
27. 0.010 0.010 ↑ 1.0 1 1

Index Only Scan using organization_members_organization_id on organization_members organization_members_1 (cost=0.14..0.37 rows=1 width=4) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (organization_id = organizations_1.id)
  • Heap Fetches: 0
28. 0.007 0.020 ↑ 1.0 2 1

Bitmap Heap Scan on tests tests_1 (cost=4.30..10.98 rows=2 width=8) (actual time=0.018..0.020 rows=2 loops=1)

  • Recheck Cond: (test_suite_id = 137)
  • Filter: ((hook IS NULL) AND (NOT removed))
  • Heap Blocks: exact=2
29. 0.013 0.013 ↑ 1.0 2 1

Bitmap Index Scan on tests_test_suite_id (cost=0.00..4.29 rows=2 width=0) (actual time=0.013..0.013 rows=2 loops=1)

  • Index Cond: (test_suite_id = 137)
30. 0.000 50.106 ↑ 1.0 1 7,158

Nested Loop (cost=3.87..5.60 rows=1 width=4) (actual time=0.001..0.007 rows=1 loops=7,158)

  • Join Filter: (test_suites.organization_id = organization_members.organization_id)
31. 21.456 42.948 ↑ 1.0 1 7,158

Hash Join (cost=3.73..5.22 rows=1 width=12) (actual time=0.001..0.006 rows=1 loops=7,158)

  • Hash Cond: (organizations.id = test_suites.organization_id)
32. 21.474 21.474 ↑ 1.0 38 7,158

Seq Scan on organizations (cost=0.00..1.38 rows=38 width=4) (actual time=0.001..0.003 rows=38 loops=7,158)

33. 0.001 0.018 ↑ 1.0 1 1

Hash (cost=3.71..3.71 rows=1 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on test_suites (cost=0.00..3.71 rows=1 width=8) (actual time=0.007..0.017 rows=1 loops=1)

  • Filter: (id = 137)
  • Rows Removed by Filter: 136
35. 7.158 7.158 ↑ 1.0 1 7,158

Index Only Scan using organization_members_organization_id on organization_members (cost=0.14..0.37 rows=1 width=4) (actual time=0.000..0.001 rows=1 loops=7,158)

  • Index Cond: (organization_id = organizations.id)
  • Heap Fetches: 0
Planning time : 1.996 ms
Execution time : 309.468 ms