Hello everyone!
depesz just released a new useful tool, pg_terminator
I believe it will be useful in Pg DBA's toolbox.
It requires just Ruby, and ruby-pg gem.
You run it like this:
$ pg_terminator etc/pg_terminator/webdb.yaml
and the yaml config looks like this:
log: /tmp/pg_terminator.webdb.log
min_sleep: 1
database:
dbname: webdb
host: webdbsrv1
rules:
- name: long-webapp-txn
action: transaction
threshold: 180
type: transaction
condition: application_name ~ 'webapp' and state <> 'idle'
Here is an example of pg_terminator in action:
2018-09-25 13:01:27 Sleeping for 20 seconds
2018-09-25 13:01:47 Sleeping for 20 seconds
2018-09-25 13:02:07 Sleeping for 15.0 seconds
2018-09-25 13:02:22 Terminated a query (pid: 2242) because of rule #1: long-txn
2018-09-25 13:02:22 Sleeping for 37.987898 seconds
Brak komentarzy:
Prześlij komentarz