Currently for a managed Postgres db (and perhaps for other types as well) there is a "Logs & queries" tab which at the top has a section "Currently running queries".
As I understand, this doesn't actually show running
queries
, it shows connections currently opened to the database. A connection can be open and idle for a long time without any performance impact on the application that opened it.
Current naming leads you to believe that you are looking at stats of individual queries, so when the "Duration" column says "500000ms" alarm bells start ringing in your head. Perhaps "Currently open connections" would be a more appropriate title?