Monitoring postgresql

When running a database as part of your application it’s important that you proactively monitor, perform maintenance and tune your queries on a regular basis.

Especially in cloud based installations, at the outset, you need to consider what services and subsciption levels or features you might receive that can give you fault tollerent infrastructure with load balanced or higher performance at scale out.

For example: There’s little point running your Live database on the Azure platform in ‘Basic’ mode when you want to use geo location recovery or need high guaranteed IOPS.

Monitoring the correct method will give you the correct insight into why your database sometimes is a bottleneck or you want you know when to build an addition instance for scalability.

Read more detail