explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vuhx

Settings
# exclusive inclusive rows x rows loops node
1. 0.079 40,894.267 ↑ 1.0 25 1

Limit (cost=138,796.86..138,798.93 rows=25 width=557) (actual time=40,894.125..40,894.267 rows=25 loops=1)

2. 0.072 40,894.188 ↑ 4,895.9 25 1

Unique (cost=138,796.86..148,894.62 rows=122,397 width=557) (actual time=40,894.119..40,894.188 rows=25 loops=1)

3. 8,575.272 40,894.116 ↑ 4,895.9 25 1

Sort (cost=138,796.86..139,102.86 rows=122,397 width=557) (actual time=40,894.109..40,894.116 rows=25 loops=1)

  • Sort Key: qc_alltestinstance.id, qc_alltestinstance.origin_id, qc_alltestinstance.qc_id, qc_alltestinstance.test_set_id, qc_alltestinstance.name, qc_alltestinstance.status_id, qc_alltestinstance.fault_report_id, qc_alltesti
  • Sort Method: external merge Disk: 831808kB
4. 1,395.161 32,318.844 ↓ 16.6 2,029,361 1

Hash Join (cost=44,977.34..97,912.58 rows=122,397 width=557) (actual time=1,080.539..32,318.844 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.test_entity_id = qc_testentity.id)
5. 1,312.586 30,923.635 ↓ 16.6 2,029,361 1

Hash Join (cost=44,975.62..97,547.01 rows=122,397 width=489) (actual time=1,080.466..30,923.635 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.test_subarea_id = qc_testsubarea.id)
6. 1,320.109 29,610.995 ↓ 16.6 2,029,361 1

Hash Join (cost=44,972.35..97,208.96 rows=122,397 width=467) (actual time=1,080.389..29,610.995 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.test_lvl_area_id = qc_testlevelandarea.id)
7. 1,246.797 28,290.340 ↓ 16.6 2,029,361 1

Hash Join (cost=44,936.21..96,850.36 rows=122,397 width=435) (actual time=1,079.812..28,290.340 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.det_auto_lvl_id = qc_detailedautomationlevel.id)
8. 1,321.303 27,043.506 ↓ 16.6 2,029,361 1

Hash Join (cost=44,934.19..96,496.79 rows=122,397 width=399) (actual time=1,079.744..27,043.506 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.platform_id = qc_platform.id)
9. 1,196.840 25,721.152 ↓ 16.6 2,029,361 1

Hash Join (cost=44,862.68..96,103.38 rows=122,397 width=357) (actual time=1,078.638..25,721.152 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.phase_id = qc_phase.id)
10. 1,278.960 24,524.139 ↓ 16.6 2,029,361 1

Hash Join (cost=44,849.96..95,766.22 rows=122,397 width=341) (actual time=1,078.437..24,524.139 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.organization_id = qc_organization.id)
11. 1,180.930 23,244.513 ↓ 16.6 2,029,361 1

Hash Join (cost=44,802.13..95,396.26 rows=122,397 width=320) (actual time=1,077.741..23,244.513 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.ca_id = qc_competencearea.id)
12. 1,126.087 22,063.358 ↓ 16.6 2,029,361 1

Hash Join (cost=44,785.69..95,056.06 rows=122,397 width=303) (actual time=1,077.486..22,063.358 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.test_object_id = qc_testobject.id)
13. 1,397.315 20,937.171 ↓ 16.6 2,029,361 1

Hash Join (cost=44,778.31..94,721.70 rows=122,397 width=283) (actual time=1,077.354..20,937.171 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.res_tester_id = qc_person.id)
14. 1,153.629 19,525.265 ↓ 16.6 2,029,361 1

Hash Join (cost=44,009.67..93,631.72 rows=122,397 width=271) (actual time=1,062.519..19,525.265 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.status_id = qc_status.id)
15. 7,373.865 18,371.601 ↓ 16.6 2,029,361 1

Hash Left Join (cost=44,007.95..93,266.15 rows=122,397 width=235) (actual time=1,062.454..18,371.601 rows=2,029,361 loops=1)

  • Hash Cond: (qc_alltestinstance.test_set_id = qc_alltestset.id)
16. 1,846.060 9,943.843 ↓ 16.6 2,029,361 1

Nested Loop (cost=2,907.38..40,087.29 rows=122,397 width=186) (actual time=6.308..9,943.843 rows=2,029,361 loops=1)

17. 0.289 0.423 ↓ 16.0 16 1

Hash Join (cost=1.31..2.59 rows=1 width=8) (actual time=0.059..0.423 rows=16 loops=1)

  • Hash Cond: (qc_domainproject.id = qc_domainproject_feature_set.domainproject_id)
18. 0.105 0.105 ↑ 1.0 21 1

Seq Scan on qc_domainproject (cost=0.00..1.21 rows=21 width=4) (actual time=0.014..0.105 rows=21 loops=1)

19. 0.007 0.029 ↓ 16.0 16 1

Hash (cost=1.30..1.30 rows=1 width=4) (actual time=0.029..0.029 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
20. 0.022 0.022 ↓ 16.0 16 1

Seq Scan on qc_domainproject_feature_set (cost=0.00..1.30 rows=1 width=4) (actual time=0.018..0.022 rows=16 loops=1)

  • Filter: (featureset_id = '4g'::text)
  • Rows Removed by Filter: 8
21. 7,321.472 8,097.360 ↑ 1.2 126,835 16

Bitmap Heap Scan on qc_alltestinstance (cost=2,906.07..38,538.64 rows=154,606 width=186) (actual time=66.512..506.085 rows=126,835 loops=16)

  • Recheck Cond: (origin_id = qc_domainproject.id)
  • Filter: (deleted = '3000-01-01'::date)
  • Rows Removed by Filter: 44259
  • Heap Blocks: exact=871311
22. 775.888 775.888 ↑ 1.2 171,094 16

Bitmap Index Scan on qc_alltestinstance_origin_id_55a8c926_uniq (cost=0.00..2,867.42 rows=196,792 width=0) (actual time=48.493..48.493 rows=171,094 loops=16)

  • Index Cond: (origin_id = qc_domainproject.id)
23. 530.956 1,053.893 ↑ 1.0 542,781 1

Hash (cost=29,014.81..29,014.81 rows=542,781 width=49) (actual time=1,053.893..1,053.893 rows=542,781 loops=1)

  • Buckets: 262144 Batches: 4 Memory Usage: 12813kB
24. 522.937 522.937 ↑ 1.0 542,781 1

Seq Scan on qc_alltestset (cost=0.00..29,014.81 rows=542,781 width=49) (actual time=0.030..522.937 rows=542,781 loops=1)

25. 0.011 0.035 ↑ 1.0 32 1

Hash (cost=1.32..1.32 rows=32 width=36) (actual time=0.035..0.035 rows=32 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
26. 0.024 0.024 ↑ 1.0 32 1

Seq Scan on qc_status (cost=0.00..1.32 rows=32 width=36) (actual time=0.020..0.024 rows=32 loops=1)

27. 6.992 14.591 ↑ 1.0 25,406 1

Hash (cost=451.06..451.06 rows=25,406 width=12) (actual time=14.591..14.591 rows=25,406 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1367kB
28. 7.599 7.599 ↑ 1.0 25,406 1

Seq Scan on qc_person (cost=0.00..451.06 rows=25,406 width=12) (actual time=0.025..7.599 rows=25,406 loops=1)

29. 0.061 0.100 ↑ 1.0 239 1

Hash (cost=4.39..4.39 rows=239 width=20) (actual time=0.100..0.100 rows=239 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
30. 0.039 0.039 ↑ 1.0 239 1

Seq Scan on qc_testobject (cost=0.00..4.39 rows=239 width=20) (actual time=0.014..0.039 rows=239 loops=1)

31. 0.130 0.225 ↑ 1.0 553 1

Hash (cost=9.53..9.53 rows=553 width=17) (actual time=0.225..0.225 rows=553 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
32. 0.095 0.095 ↑ 1.0 553 1

Seq Scan on qc_competencearea (cost=0.00..9.53 rows=553 width=17) (actual time=0.012..0.095 rows=553 loops=1)

33. 0.341 0.666 ↑ 1.0 1,637 1

Hash (cost=27.37..27.37 rows=1,637 width=21) (actual time=0.665..0.666 rows=1,637 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 102kB
34. 0.325 0.325 ↑ 1.0 1,637 1

Seq Scan on qc_organization (cost=0.00..27.37 rows=1,637 width=21) (actual time=0.015..0.325 rows=1,637 loops=1)

35. 0.100 0.173 ↑ 1.0 432 1

Hash (cost=7.32..7.32 rows=432 width=16) (actual time=0.173..0.173 rows=432 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
36. 0.073 0.073 ↑ 1.0 432 1

Seq Scan on qc_phase (cost=0.00..7.32 rows=432 width=16) (actual time=0.012..0.073 rows=432 loops=1)

37. 0.551 1.051 ↑ 1.0 2,245 1

Hash (cost=43.45..43.45 rows=2,245 width=42) (actual time=1.051..1.051 rows=2,245 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 197kB
38. 0.500 0.500 ↑ 1.0 2,245 1

Seq Scan on qc_platform (cost=0.00..43.45 rows=2,245 width=42) (actual time=0.012..0.500 rows=2,245 loops=1)

39. 0.015 0.037 ↑ 1.0 45 1

Hash (cost=1.45..1.45 rows=45 width=36) (actual time=0.037..0.037 rows=45 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
40. 0.022 0.022 ↑ 1.0 45 1

Seq Scan on qc_detailedautomationlevel (cost=0.00..1.45 rows=45 width=36) (actual time=0.018..0.022 rows=45 loops=1)

41. 0.282 0.546 ↑ 1.0 1,162 1

Hash (cost=21.62..21.62 rows=1,162 width=32) (actual time=0.546..0.546 rows=1,162 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 90kB
42. 0.264 0.264 ↑ 1.0 1,162 1

Seq Scan on qc_testlevelandarea (cost=0.00..21.62 rows=1,162 width=32) (actual time=0.014..0.264 rows=1,162 loops=1)

43. 0.034 0.054 ↑ 1.0 101 1

Hash (cost=2.01..2.01 rows=101 width=22) (actual time=0.054..0.054 rows=101 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
44. 0.020 0.020 ↑ 1.0 101 1

Seq Scan on qc_testsubarea (cost=0.00..2.01 rows=101 width=22) (actual time=0.010..0.020 rows=101 loops=1)

45. 0.020 0.048 ↑ 1.0 32 1

Hash (cost=1.32..1.32 rows=32 width=36) (actual time=0.047..0.048 rows=32 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
46. 0.028 0.028 ↑ 1.0 32 1

Seq Scan on qc_testentity (cost=0.00..1.32 rows=32 width=36) (actual time=0.025..0.028 rows=32 loops=1)