What to log

Nikolay and Michael discuss logging in Postgres — mostly what to log, and why changing quite a few settings can pay off big time in the long term.

Here are some links to things they mentioned:
• What to log postgresql.org/docs/current/runtime-config-log…
• Our episode about Auditing postgres.fm/episodes/auditing
• Our episode on auto_explain postgres.fm/episodes/auto_explain

Here are the parameters they mentioned changing:
• log_checkpoints
• log_autovacuum_min_duration
• log_statement
• log_connections and log_disconnections
• log_lock_waits
• log_temp_files
• log_min_duration_statement
• log_min_duration_sample and log_statement_sample_rate

And finally, some very useful tools they meant to mention but forgot to!
• pgpedia.info
• postgresqlco.nf
• why-upgrade.depesz.com/show?from=16.9&to=1…

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With credit to:
• Jessie Draws for the elephant artwork