explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Npv

Settings
# exclusive inclusive rows x rows loops node
1. 18.085 14,024.525 ↓ 0.0 0 1

Hash Semi Join (cost=256,417.83..1,905,965.29 rows=33 width=9,032) (actual time=14,024.525..14,024.525 rows=0 loops=1)

  • Hash Cond: (commentari0_.related_version_attachment_id = attachment1_.attachment_id)
2. 212.056 14,006.341 ↑ 1.0 253,649 1

Nested Loop Left Join (cost=256,395.07..1,905,276.33 rows=253,649 width=9,016) (actual time=1,748.341..14,006.341 rows=253,649 loops=1)

3. 218.644 13,540.636 ↑ 1.0 253,649 1

Nested Loop Left Join (cost=256,394.65..1,780,632.41 rows=253,649 width=8,972) (actual time=1,748.337..13,540.636 rows=253,649 loops=1)

4. 196.345 12,307.396 ↑ 1.0 253,649 1

Hash Left Join (cost=256,394.22..1,255,571.99 rows=253,649 width=8,661) (actual time=1,748.325..12,307.396 rows=253,649 loops=1)

  • Hash Cond: (commentari0_.created_by_id = user27_.id)
5. 50.924 12,110.043 ↑ 1.0 253,649 1

Nested Loop Left Join (cost=256,242.33..1,251,932.42 rows=253,649 width=8,352) (actual time=1,747.312..12,110.043 rows=253,649 loops=1)

6. 70.664 11,551.821 ↑ 1.0 253,649 1

Nested Loop Left Join (cost=256,241.91..1,126,544.30 rows=253,649 width=8,308) (actual time=1,747.296..11,551.821 rows=253,649 loops=1)

7. 150.289 10,720.210 ↑ 1.0 253,649 1

Hash Left Join (cost=256,241.49..976,634.81 rows=253,649 width=8,089) (actual time=1,747.276..10,720.210 rows=253,649 loops=1)

  • Hash Cond: (documentqu21_.qualification_id = qualificat23_.id)
8. 145.950 10,569.721 ↑ 1.0 253,649 1

Hash Left Join (cost=256,200.52..973,109.04 rows=253,649 width=8,038) (actual time=1,747.073..10,569.721 rows=253,649 loops=1)

  • Hash Cond: (workflow19_.current_step_id = workflowst20_.id)
9. 162.734 10,423.580 ↑ 1.0 253,649 1

Hash Left Join (cost=256,160.18..969,581.03 rows=253,649 width=8,002) (actual time=1,746.878..10,423.580 rows=253,649 loops=1)

  • Hash Cond: (workflow19_.project_id = project24_.id)
10. 5,562.595 10,260.669 ↑ 1.0 253,649 1

Hash Left Join (cost=256,138.66..966,071.84 rows=253,649 width=7,304) (actual time=1,746.691..10,260.669 rows=253,649 loops=1)

  • Hash Cond: (actionhist1_.workflow_id = workflow19_.id)
11. 139.682 2,975.658 ↑ 1.0 253,649 1

Hash Left Join (cost=2,155.88..266,312.05 rows=253,649 width=6,925) (actual time=23.856..2,975.658 rows=253,649 loops=1)

  • Hash Cond: (actionhist1_.step_before_id = workflowst18_.id)
12. 129.865 2,835.714 ↑ 1.0 253,649 1

Hash Left Join (cost=2,115.55..262,812.70 rows=253,649 width=6,889) (actual time=23.580..2,835.714 rows=253,649 loops=1)

  • Hash Cond: (actionhist1_.step_after_id = workflowst17_.id)
13. 151.744 2,705.568 ↑ 1.0 253,649 1

Hash Left Join (cost=2,075.21..259,313.35 rows=253,649 width=6,853) (actual time=23.280..2,705.568 rows=253,649 loops=1)

  • Hash Cond: (project12_.id = project12_1_.id)
14. 145.328 2,552.416 ↑ 1.0 253,649 1

Hash Left Join (cost=1,914.06..255,664.52 rows=253,649 width=6,364) (actual time=21.858..2,552.416 rows=253,649 loops=1)

  • Hash Cond: (project12_.contract_id = contract14_.id)
15. 113.745 2,406.988 ↑ 1.0 253,649 1

Hash Left Join (cost=1,907.73..252,170.51 rows=253,649 width=5,881) (actual time=21.747..2,406.988 rows=253,649 loops=1)

  • Hash Cond: (actionhist1_.project_id = project12_.id)
16. 83.725 2,293.105 ↑ 1.0 253,649 1

Hash Left Join (cost=1,895.46..248,670.58 rows=253,649 width=5,363) (actual time=21.597..2,293.105 rows=253,649 loops=1)

  • Hash Cond: (actionhist1_.personified_by_id = user11_.id)
17. 73.494 2,207.975 ↑ 1.0 253,649 1

Hash Left Join (cost=1,743.57..247,505.02 rows=253,649 width=5,054) (actual time=20.180..2,207.975 rows=253,649 loops=1)

  • Hash Cond: (actionexec3_2_.next_step_id = workflowst8_.id)
18. 71.093 2,134.236 ↑ 1.0 253,649 1

Hash Left Join (cost=1,703.23..243,977.01 rows=253,649 width=5,018) (actual time=19.925..2,134.236 rows=253,649 loops=1)

  • Hash Cond: (actionexec3_.workflow_step_id = workflowst7_.id)
19. 69.934 2,062.847 ↑ 1.0 253,649 1

Hash Left Join (cost=1,662.89..241,852.21 rows=253,649 width=4,982) (actual time=19.611..2,062.847 rows=253,649 loops=1)

  • Hash Cond: (documentpr5_.parent_id = documentpr6_.id)
20. 122.093 1,990.959 ↑ 1.0 253,649 1

Hash Left Join (cost=1,490.02..238,478.28 rows=253,649 width=4,735) (actual time=17.640..1,990.959 rows=253,649 loops=1)

  • Hash Cond: (actionhist1_.logged_user_id = user9_.id)
21. 85.213 1,863.922 ↑ 1.0 253,649 1

Hash Left Join (cost=1,027.12..234,527.71 rows=253,649 width=3,078) (actual time=12.679..1,863.922 rows=253,649 loops=1)

  • Hash Cond: (actionhist1_.action_id = action2_.id)
22. 84.960 1,777.342 ↑ 1.0 253,649 1

Hash Left Join (cost=900.31..230,913.22 rows=253,649 width=3,003) (actual time=11.285..1,777.342 rows=253,649 loops=1)

  • Hash Cond: (actionhist1_.action_execution_id = actionexec3_.id)
23. 287.117 1,681.387 ↑ 1.0 253,649 1

Merge Left Join (cost=31.02..228,329.86 rows=253,649 width=1,792) (actual time=0.279..1,681.387 rows=253,649 loops=1)

  • Merge Cond: (commentari0_.action_history_id = actionhist1_.id)
24. 138.577 138.577 ↑ 1.0 253,649 1

Index Scan using commentary_action_history_id_idx on commentary commentari0_ (cost=0.42..41,070.14 rows=253,649 width=1,481) (actual time=0.010..138.577 rows=253,649 loops=1)

25. 1,255.693 1,255.693 ↓ 1.0 2,979,614 1

Index Scan using ""action_historyPK"" on action_history actionhist1_ (cost=0.43..176,649.95 rows=2,977,344 width=311) (actual time=0.005..1,255.693 rows=2,979,614 loops=1)

26. 1.965 10.995 ↑ 1.0 2,415 1

Hash (cost=839.10..839.10 rows=2,415 width=1,211) (actual time=10.995..10.995 rows=2,415 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 2,529kB
27. 1.080 9.030 ↑ 1.0 2,415 1

Hash Left Join (cost=430.66..839.10 rows=2,415 width=1,211) (actual time=4.176..9.030 rows=2,415 loops=1)

  • Hash Cond: (actionexec3_.document_profile_id = documentpr5_.id)
28. 1.037 6.112 ↑ 1.0 2,415 1

Hash Left Join (cost=257.78..636.47 rows=2,415 width=964) (actual time=2.330..6.112 rows=2,415 loops=1)

  • Hash Cond: (actionexec3_.action_id = action4_.id)
29. 0.527 3.678 ↑ 1.0 2,415 1

Hash Left Join (cost=130.96..476.45 rows=2,415 width=889) (actual time=0.927..3.678 rows=2,415 loops=1)

  • Hash Cond: (actionexec3_.id = actionexec3_2_.id)
30. 1.100 3.149 ↑ 1.0 2,415 1

Hash Right Join (cost=79.34..397.27 rows=2,415 width=881) (actual time=0.921..3.149 rows=2,415 loops=1)

  • Hash Cond: (actionexec3_1_.id = actionexec3_.id)
31. 1.147 1.147 ↑ 1.0 2,397 1

Seq Scan on action_script actionexec3_1_ (cost=0.00..284.97 rows=2,397 width=835) (actual time=0.007..1.147 rows=2,397 loops=1)

32. 0.420 0.902 ↑ 1.0 2,415 1

Hash (cost=49.15..49.15 rows=2,415 width=54) (actual time=0.902..0.902 rows=2,415 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 225kB
33. 0.482 0.482 ↑ 1.0 2,415 1

Seq Scan on action_execution actionexec3_ (cost=0.00..49.15 rows=2,415 width=54) (actual time=0.012..0.482 rows=2,415 loops=1)

34. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=28.50..28.50 rows=1,850 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
35. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on action_step_transition actionexec3_2_ (cost=0.00..28.50 rows=1,850 width=16) (actual time=0.001..0.001 rows=0 loops=1)

36. 0.719 1.397 ↑ 1.0 3,503 1

Hash (cost=83.03..83.03 rows=3,503 width=75) (actual time=1.397..1.397 rows=3,503 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 402kB
37. 0.678 0.678 ↑ 1.0 3,503 1

Seq Scan on action action4_ (cost=0.00..83.03 rows=3,503 width=75) (actual time=0.003..0.678 rows=3,503 loops=1)

38. 0.856 1.838 ↑ 1.0 3,239 1

Hash (cost=132.39..132.39 rows=3,239 width=247) (actual time=1.838..1.838 rows=3,239 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 758kB
39. 0.982 0.982 ↑ 1.0 3,239 1

Seq Scan on document_profile documentpr5_ (cost=0.00..132.39 rows=3,239 width=247) (actual time=0.003..0.982 rows=3,239 loops=1)

40. 0.807 1.367 ↑ 1.0 3,503 1

Hash (cost=83.03..83.03 rows=3,503 width=75) (actual time=1.367..1.367 rows=3,503 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 402kB
41. 0.560 0.560 ↑ 1.0 3,503 1

Seq Scan on action action2_ (cost=0.00..83.03 rows=3,503 width=75) (actual time=0.005..0.560 rows=3,503 loops=1)

42. 1.820 4.944 ↑ 1.0 1,462 1

Hash (cost=444.62..444.62 rows=1,462 width=1,657) (actual time=4.944..4.944 rows=1,462 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 2,423kB
43. 0.787 3.124 ↑ 1.0 1,462 1

Hash Right Join (cost=151.90..444.62 rows=1,462 width=1,657) (actual time=1.475..3.124 rows=1,462 loops=1)

  • Hash Cond: (avatar10_.user_id = user9_.id)
44. 0.881 0.881 ↑ 1.0 1,462 1

Seq Scan on avatar avatar10_ (cost=0.00..272.62 rows=1,462 width=1,348) (actual time=0.007..0.881 rows=1,462 loops=1)

45. 0.723 1.456 ↑ 1.0 1,462 1

Hash (cost=133.62..133.62 rows=1,462 width=309) (actual time=1.456..1.456 rows=1,462 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 482kB
46. 0.733 0.733 ↑ 1.0 1,462 1

Seq Scan on keep_user user9_ (cost=0.00..133.62 rows=1,462 width=309) (actual time=0.010..0.733 rows=1,462 loops=1)

47. 1.009 1.954 ↑ 1.0 3,239 1

Hash (cost=132.39..132.39 rows=3,239 width=247) (actual time=1.954..1.954 rows=3,239 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 758kB
48. 0.945 0.945 ↑ 1.0 3,239 1

Seq Scan on document_profile documentpr6_ (cost=0.00..132.39 rows=3,239 width=247) (actual time=0.004..0.945 rows=3,239 loops=1)

49. 0.166 0.296 ↑ 1.0 1,215 1

Hash (cost=25.15..25.15 rows=1,215 width=36) (actual time=0.296..0.296 rows=1,215 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 98kB
50. 0.130 0.130 ↑ 1.0 1,215 1

Seq Scan on workflow_step workflowst7_ (cost=0.00..25.15 rows=1,215 width=36) (actual time=0.005..0.130 rows=1,215 loops=1)

51. 0.159 0.245 ↑ 1.0 1,215 1

Hash (cost=25.15..25.15 rows=1,215 width=36) (actual time=0.245..0.245 rows=1,215 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 98kB
52. 0.086 0.086 ↑ 1.0 1,215 1

Seq Scan on workflow_step workflowst8_ (cost=0.00..25.15 rows=1,215 width=36) (actual time=0.002..0.086 rows=1,215 loops=1)

53. 0.783 1.405 ↑ 1.0 1,462 1

Hash (cost=133.62..133.62 rows=1,462 width=309) (actual time=1.405..1.405 rows=1,462 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 482kB
54. 0.622 0.622 ↑ 1.0 1,462 1

Seq Scan on keep_user user11_ (cost=0.00..133.62 rows=1,462 width=309) (actual time=0.003..0.622 rows=1,462 loops=1)

55. 0.087 0.138 ↑ 1.0 145 1

Hash (cost=10.45..10.45 rows=145 width=518) (actual time=0.138..0.138 rows=145 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 75kB
56. 0.051 0.051 ↑ 1.0 145 1

Seq Scan on project project12_ (cost=0.00..10.45 rows=145 width=518) (actual time=0.007..0.051 rows=145 loops=1)

57. 0.031 0.100 ↑ 1.0 34 1

Hash (cost=5.91..5.91 rows=34 width=483) (actual time=0.100..0.100 rows=34 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
58. 0.020 0.069 ↑ 1.0 34 1

Hash Left Join (cost=3.10..5.91 rows=34 width=483) (actual time=0.050..0.069 rows=34 loops=1)

  • Hash Cond: (contract14_.customer_id = customer15_.id)
59. 0.009 0.009 ↑ 1.0 34 1

Seq Scan on contract contract14_ (cost=0.00..2.34 rows=34 width=396) (actual time=0.003..0.009 rows=34 loops=1)

60. 0.011 0.040 ↑ 1.0 29 1

Hash (cost=2.74..2.74 rows=29 width=87) (actual time=0.040..0.040 rows=29 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
61. 0.023 0.029 ↑ 1.0 29 1

Nested Loop Left Join (cost=0.00..2.74 rows=29 width=87) (actual time=0.014..0.029 rows=29 loops=1)

  • Join Filter: (customer15_.workspace_id = workspace16_.id)
62. 0.006 0.006 ↑ 1.0 29 1

Seq Scan on customer customer15_ (cost=0.00..1.29 rows=29 width=74) (actual time=0.004..0.006 rows=29 loops=1)

63. 0.000 0.000 ↑ 1.0 1 29

Materialize (cost=0.00..1.01 rows=1 width=13) (actual time=0.000..0.000 rows=1 loops=29)

64. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on workspace workspace16_ (cost=0.00..1.01 rows=1 width=13) (actual time=0.005..0.005 rows=1 loops=1)

65. 0.095 1.408 ↑ 1.0 145 1

Hash (cost=159.34..159.34 rows=145 width=497) (actual time=1.408..1.408 rows=145 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 75kB
66. 0.100 1.313 ↑ 1.0 145 1

Hash Left Join (cost=151.90..159.34 rows=145 width=497) (actual time=1.210..1.313 rows=145 loops=1)

  • Hash Cond: (project12_1_.created_by_id = user13_.id)
67. 0.020 0.020 ↑ 1.0 145 1

Seq Scan on config_item_group project12_1_ (cost=0.00..5.45 rows=145 width=188) (actual time=0.005..0.020 rows=145 loops=1)

68. 0.683 1.193 ↑ 1.0 1,462 1

Hash (cost=133.62..133.62 rows=1,462 width=309) (actual time=1.193..1.193 rows=1,462 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 482kB
69. 0.510 0.510 ↑ 1.0 1,462 1

Seq Scan on keep_user user13_ (cost=0.00..133.62 rows=1,462 width=309) (actual time=0.002..0.510 rows=1,462 loops=1)

70. 0.174 0.281 ↑ 1.0 1,215 1

Hash (cost=25.15..25.15 rows=1,215 width=36) (actual time=0.281..0.281 rows=1,215 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 98kB
71. 0.107 0.107 ↑ 1.0 1,215 1

Seq Scan on workflow_step workflowst17_ (cost=0.00..25.15 rows=1,215 width=36) (actual time=0.007..0.107 rows=1,215 loops=1)

72. 0.160 0.262 ↑ 1.0 1,215 1

Hash (cost=25.15..25.15 rows=1,215 width=36) (actual time=0.262..0.262 rows=1,215 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 98kB
73. 0.102 0.102 ↑ 1.0 1,215 1

Seq Scan on workflow_step workflowst18_ (cost=0.00..25.15 rows=1,215 width=36) (actual time=0.003..0.102 rows=1,215 loops=1)

74. 143.578 1,722.416 ↑ 1.0 237,082 1

Hash (cost=239,211.25..239,211.25 rows=237,082 width=379) (actual time=1,722.416..1,722.416 rows=237,082 loops=1)

  • Buckets: 16,384 Batches: 32 Memory Usage: 3,298kB
75. 216.913 1,578.838 ↑ 1.0 237,082 1

Merge Right Join (cost=51,041.63..239,211.25 rows=237,082 width=379) (actual time=240.745..1,578.838 rows=237,082 loops=1)

  • Merge Cond: (actionhist22_.id = documentqu21_.action_history_id)
76. 1,051.738 1,051.738 ↓ 1.0 2,979,614 1

Index Scan using ""action_historyPK"" on action_history actionhist22_ (cost=0.43..176,649.95 rows=2,977,344 width=311) (actual time=0.012..1,051.738 rows=2,979,614 loops=1)

77. 16.646 310.187 ↑ 1.0 237,082 1

Materialize (cost=51,007.01..52,192.42 rows=237,082 width=68) (actual time=240.628..310.187 rows=237,082 loops=1)

78. 129.270 293.541 ↑ 1.0 237,082 1

Sort (cost=51,007.01..51,599.72 rows=237,082 width=68) (actual time=240.624..293.541 rows=237,082 loops=1)

  • Sort Key: documentqu21_.action_history_id
  • Sort Method: external merge Disk: 16,976kB
79. 84.729 164.271 ↑ 1.0 237,082 1

Hash Left Join (cost=7,726.41..20,114.99 rows=237,082 width=68) (actual time=52.438..164.271 rows=237,082 loops=1)

  • Hash Cond: (workflow19_.document_qualification_id = documentqu21_.id)
80. 27.315 27.315 ↑ 1.0 237,082 1

Seq Scan on workflow workflow19_ (cost=0.00..4,501.82 rows=237,082 width=44) (actual time=0.004..27.315 rows=237,082 loops=1)

81. 28.930 52.227 ↑ 1.0 222,507 1

Hash (cost=3,641.07..3,641.07 rows=222,507 width=24) (actual time=52.227..52.227 rows=222,507 loops=1)

  • Buckets: 65,536 Batches: 4 Memory Usage: 3,546kB
82. 23.297 23.297 ↑ 1.0 222,507 1

Seq Scan on document_qualification documentqu21_ (cost=0.00..3,641.07 rows=222,507 width=24) (actual time=0.009..23.297 rows=222,507 loops=1)

83. 0.043 0.177 ↑ 1.0 145 1

Hash (cost=19.71..19.71 rows=145 width=698) (actual time=0.177..0.177 rows=145 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 95kB
84. 0.040 0.134 ↑ 1.0 145 1

Hash Left Join (cost=7.26..19.71 rows=145 width=698) (actual time=0.065..0.134 rows=145 loops=1)

  • Hash Cond: (project24_.id = project24_1_.id)
85. 0.039 0.039 ↑ 1.0 145 1

Seq Scan on project project24_ (cost=0.00..10.45 rows=145 width=518) (actual time=0.007..0.039 rows=145 loops=1)

86. 0.031 0.055 ↑ 1.0 145 1

Hash (cost=5.45..5.45 rows=145 width=188) (actual time=0.055..0.055 rows=145 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 33kB
87. 0.024 0.024 ↑ 1.0 145 1

Seq Scan on config_item_group project24_1_ (cost=0.00..5.45 rows=145 width=188) (actual time=0.005..0.024 rows=145 loops=1)

88. 0.105 0.191 ↑ 1.0 1,215 1

Hash (cost=25.15..25.15 rows=1,215 width=36) (actual time=0.191..0.191 rows=1,215 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 98kB
89. 0.086 0.086 ↑ 1.0 1,215 1

Seq Scan on workflow_step workflowst20_ (cost=0.00..25.15 rows=1,215 width=36) (actual time=0.005..0.086 rows=1,215 loops=1)

90. 0.112 0.200 ↑ 1.0 1,243 1

Hash (cost=25.43..25.43 rows=1,243 width=51) (actual time=0.200..0.200 rows=1,243 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 118kB
91. 0.088 0.088 ↑ 1.0 1,243 1

Seq Scan on qualification qualificat23_ (cost=0.00..25.43 rows=1,243 width=51) (actual time=0.005..0.088 rows=1,243 loops=1)

92. 760.947 760.947 ↑ 1.0 1 253,649

Index Scan using version_workflow_idx on version version25_ (cost=0.42..0.58 rows=1 width=219) (actual time=0.002..0.003 rows=1 loops=253,649)

  • Index Cond: (workflow19_.id = workflow_id)
93. 507.298 507.298 ↑ 1.0 1 253,649

Index Scan using ""workflowPK"" on workflow workflow26_ (cost=0.42..0.48 rows=1 width=44) (actual time=0.001..0.002 rows=1 loops=253,649)

  • Index Cond: (version25_.workflow_id = id)
94. 0.410 1.008 ↑ 1.0 1,462 1

Hash (cost=133.62..133.62 rows=1,462 width=309) (actual time=1.008..1.008 rows=1,462 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 482kB
95. 0.598 0.598 ↑ 1.0 1,462 1

Seq Scan on keep_user user27_ (cost=0.00..133.62 rows=1,462 width=309) (actual time=0.004..0.598 rows=1,462 loops=1)

96. 1,014.596 1,014.596 ↑ 1.0 1 253,649

Index Scan using ""action_historyPK"" on action_history actionhist28_ (cost=0.43..2.06 rows=1 width=311) (actual time=0.004..0.004 rows=1 loops=253,649)

  • Index Cond: (commentari0_.vcl_action_history_id = id)
97. 253.649 253.649 ↑ 1.0 1 253,649

Index Scan using ""workflowPK"" on workflow workflow29_ (cost=0.42..0.48 rows=1 width=44) (actual time=0.001..0.001 rows=1 loops=253,649)

  • Index Cond: (commentari0_.workflow_id = id)
98. 0.003 0.099 ↑ 1.0 2 1

Hash (cost=22.73..22.73 rows=2 width=16) (actual time=0.099..0.099 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
99. 0.003 0.096 ↑ 1.0 2 1

Nested Loop (cost=1.26..22.73 rows=2 width=16) (actual time=0.092..0.096 rows=2 loops=1)

100. 0.005 0.077 ↑ 1.0 2 1

Nested Loop (cost=0.84..13.83 rows=2 width=8) (actual time=0.076..0.077 rows=2 loops=1)

101. 0.036 0.036 ↑ 1.0 1 1

Index Only Scan using ""versionPK"" on version version0_ (cost=0.42..4.44 rows=1 width=8) (actual time=0.035..0.036 rows=1 loops=1)

  • Index Cond: (id = 275,377)
  • Heap Fetches: 0
102. 0.036 0.036 ↑ 1.0 2 1

Index Scan using version_attachment_version_id_idx on version_attachment attachment1_ (cost=0.42..9.38 rows=2 width=16) (actual time=0.036..0.036 rows=2 loops=1)

  • Index Cond: (version_id = 275,377)
103. 0.016 0.016 ↑ 1.0 1 2

Index Only Scan using ""attachmentPK"" on attachment attachment2_ (cost=0.42..4.44 rows=1 width=8) (actual time=0.007..0.008 rows=1 loops=2)

  • Index Cond: (id = attachment1_.attachment_id)
  • Heap Fetches: 0
Planning time : 13.355 ms
Execution time : 14,027.922 ms