I am trying to create a query that will be able to isolate transactions that have been in the mempool for an abnormal amount of time. How can I go about doing that?
There’s no query to calc duration present in mempool, you can get mempool tx data and try to check if confirmed after a set duration ( just my 2 cents).
Some sample queries