Describe the bug
Prometheus alert for a long running transaction.

I think the transaction is

SELECT pg_advisory_unlock($1)

To Reproduce
No activity, sitting idle

Expected behavior
Shouldn't have the alert

Screenshots

Logs

Version and Deployment (please complete the following information):
2024.4.0 kubernetes

Additional context
Add any other context about the problem here.