Log Files and System Statistics
In Chapter 4, Handling Advanced SQL, you learned about advanced SQL and ways of viewing SQL in a different light. However, database work doesn’t only consist of hacking up fancy SQL. Sometimes, it’s about keeping things running professionally. To do that, it’s highly important to keep an eye on system statistics, log files, and so on.
Monitoring is the key to running databases professionally. Fortunately, PostgreSQL has many features that can help you monitor your databases, and you’ll learn how to use them in this chapter.
In this chapter, you’ll learn about the following topics:
- Gathering runtime statistics
- Creating log files
By the end of this chapter, you’ll be able to configure PostgreSQL’s logging infrastructure properly and take care of log files in the most professional way possible.
