some sort of sql process makes my database server to consume 100% of the cpu, Is there any option to kill the particular process automatically if it is consuming a particular value of cpu ?
Postgresql – ny option to kill the particular process automatically if it is consuming a particular value of cpu
postgresql
Related Question
- PostgreSQL Index Fillfactor – Should Primary Key Indexes Be Set to 100% Fillfactor?
- Postgresql – How to profile Postgresql instance
- PostgreSQL Docker – How to Reduce Excessive CPU Consumption
- PostgreSQL String Compaction – Is There Any String Compaction Option for PostgreSQL?
- PostgreSQL – Prevent Heavy Queries from Affecting Performance of Other Databases
- Postgres EXPLAIN ANALYZE Performance Issues
- Postgresql – Prevent execution of heavy-loading and / or runaway queries in postgres
- Postgresql – Best way to solve a lot of queries stuck because of no index
Best Answer
No, there isn't. But you could consider setting
statement_timeout, which will kill any query running longer than a certain time.