Dont mind waiting but I had significant money in that transaction and made a dumb mistake. That's why I am willing to pay extra to get it confirmed. The receiving wallet is also mine.
How did it take for your transaction to be forgotten from the pool ?
since you are sending from yourself to yourself there are a lot of options you can choose as long as you own the private keys!
the first thing is to double spend the transaction this time with higher fee. it may be hard because double spent transactions are mostly rejected and also you need to go through console usually to make these.
the other thing is CPFP (which i recommend).
assume you sent bitcoin from first address to second address and that is pending.
use a third address from your wallet and send the funds from your second address to your third (new address) and pay extra fee as much as it covers 2 transactions (the one that is unconfirmed + the new one) and broadcast it.
read more here:
https://bitcointalk.org/index.php?topic=1802212.0