What are the entries in the postgresql logs you want to monitor?
Collect the logs with the elk stack using postgresql.
It is now possible to configure alerting by the presence of certain journal entries.
Since it is not found best practices or articles on these topics, would like to know what log entries you monitor or what records it is better to tie alerts.
Have refused to write the long queries because I think it is better to do via pg_stat_statments.
shutdown or writing about recovery already monitoring.
Also monitor the rubble tasks autovacuum
As the frequency of checkpoints