How to deal with long-running transactions (OLTP)
Identify and handle long-running transactions that can impact OLTP system performance
Identify and handle long-running transactions that can impact OLTP system performance
Some very popular reasons affecting the duration of the shutdown attempt:
Understand subtransactions, savepoints, and their impact on database performance