MySQL 8.0: How to display long transactions

Recently, somebody asked me how he can find the long running transactions in MySQL. I already have one MySQL Shell plugin that allows you to find the current transactions sorted by time. The...