Question : I have a big database (150 GB) that needs a back up and I don’t have space in […]
Tag: kill
Delete statement not responding to Kill session command
Question : Four days ago a user ran the command below on a table with 400,000,000 rows. It’s still running […]
Grant permission to KILL connections (sessions) for certain databases only?
Question : For a SQL Server on a VM/physical box (not Azure SQL database!) Is this possible to grant KILL […]
Grant permission to KILL connections (sessions) for certain databases only?
Question : For a SQL Server on a VM/physical box (not Azure SQL database!) Is this possible to grant KILL […]
Kill infinite loop plperl
Question : How can I kill session with infinite looped plperl function? Both pg_terminate_backend and pg_cancel_backend had no effect. kill […]
Does killed session appears in Query Store?
Question : Is there any option to see killed sessions in Query Store? I am asking, because we have an […]
Using TCP keepalive for terminating orphan postgres queries not working
Question : Problem: A user of some application executes a report which involves a heavy sql query. After some minutes, […]
Kill concurrent materialized view refresh PID
Question : Concurrent refreshes of materialized views don’t have a record in pg_stat_activity, other than the initial (~immediately completing) query […]
after executing a back up cmd (via query) how to kill it
Question : I have a big database (150 GB) that needs a back up and I don’t have space in […]
How to stop the execution of a long running insert query?
Question : I’ve executed an INSERT INTO … SELECT as a job on my MySQL instance and then I realized […]
- 1
- 2