You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
One feature that feels missing though is information on xid. I struggle to keep my long-running queries at bay (running a datawarehouse type db) but sometimes they happen and cause issues. Knowing what transactions are blocking vacuum based on xmin horizon stuff would be really helpful. Its not always as simple as "the oldest transaction" because that could be vacuums or replication slots OR (in my case) procedures that have transaction control built in internally.
The text was updated successfully, but these errors were encountered:
I use pg_activity all day every day, thanks!
One feature that feels missing though is information on xid. I struggle to keep my long-running queries at bay (running a datawarehouse type db) but sometimes they happen and cause issues. Knowing what transactions are blocking vacuum based on xmin horizon stuff would be really helpful. Its not always as simple as "the oldest transaction" because that could be vacuums or replication slots OR (in my case) procedures that have transaction control built in internally.
The text was updated successfully, but these errors were encountered: