V
V
Vladimir2020-01-21 15:22:16
PostgreSQL
Vladimir, 2020-01-21 15:22:16

What postgresql log entries do you need to monitor?

I collect logs from postgresql through the elk stack.
Now it is possible to set up an alert for the presence of certain entries in the log.
Since I did not find any best practices or articles on similar topics, I would like to know which log entries you monitor or which entries are better to set alerts on.
Refused to write long queries, because I think it's better to do it through pg_stat_statments.
shutdown or recovery record is already being monitored.
We also monitor failed autovacuum tasks.
Also checkpoint frequency.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question