ELK Stack for postgresql DB server

Elastic Stack Elasticsearch
1

Hi,

I am evaluating ELK Stack for DB related select queries. Currently i am trying to push postgresql DB analytics data to ELK Stack. Can someone please pitch in for my post about various approach to query sql data from ELK stack in an efficient and elegant manner trying to address read performance issues while reading from the current running Postgresql DB Server.

Any help will be highly appreciable and thanks in Advance.

Best Regards,

Kaushal

2

I shared most of my thoughts there: http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/

Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.