How to Stop Navigator Web UI Long-Running Query

Restarting the database will terminate the long-running transaction. However, restarting the database isn't feasible. If you have access to the database to run an SQL query, follow the below query to stop the transaction.

SELECT pid, 
now() - pg_stat_activity.query_start AS duration, query
FROM pg_stat_activity
WHERE state = 'active'
ORDER BY duration DESC;

• pid → backend process ID of the query.

• duration → how long the query has been running.

• query → SQL text.

SELECT pg_terminate_backend(<pid>);