Rootconf 2015

DevOps and scaling infrastructure


Logstash, statsd and graphite combo for PostgreSQL log monitoring

Submitted by Himanchali (@himanchali) on Tuesday, 31 March 2015

Section: Full talk Technical level: Beginner Status: Rejected


The session (full length talk of 40 mins) will aim to explain the use case of log monitoring done for Postgres DB server with the help of logstash, statsd and graphite. The same combination can be used for other logs as well.


Mindmap Link for the session:

When you have a system where the DB server is generating 1GB log per 10 minutes, monitoring those logs for different kind of performance and security analysis is a big challenge.
The session will cover the monitoring setup for db server logs using the 3 opensource tools and how these graphs can help in analysis improvement.
The key points covered:

  • Introduction of the used tools

  • The basic setup of these tools

  • The basic conf setup

  • Proper aggregation of metrics

  • Issues faced during setup and their solution

  • Final performance

  • Kind of metrics generated and their usage

Speaker bio

I am currently working as Tech lead Production & Infra Engg @ Inmobi. Other than being part of DBE team, has been involved in evaluating and implementing open source tools for production environment.


Preview video


  •   Gay Prince (@jusanuco) 6 months ago

    Videos that were availableat this forum has some brief introduction on it that was good to have among these parts. I used to be present some data that was at this was able to have some fiction on this that has some knowledge on it.

Login with Twitter or Google to leave a comment