Ad-hoc monitoring
In some cases, we need to observe some values in Postgres or the environment it's running on (OS, FS, etc.), and:
9 docs tagged with "troubleshooting"
View all tagsHow to analyze heavyweight locks, part 1
How to get into trouble using some Postgres features
How to make "" work in psql on a new machine ("editor/nano/vi not found")
How to troubleshoot a growing pg_wal directory
How to troubleshoot and speed up Postgres stop and restart attempts
#PostgresMarathon day 2. Let's discuss PostgreSQL shutdown and restarts. It's not uncommon to see quite long and even failed shutdown/restart attempts.
How to troubleshoot long Postgres startup
#PostgresMarathon day 3. In the previous how-to, we discussed how to quickly stop or restart PostgreSQL.
How to troubleshoot streaming replication lag
Learn how to troubleshoot streaming replication lag