Add metricset for replication to Metricbeat Postgresql module

[noahbailey]

Describe the enhancement:

Add a metricset for monitoring Postgresql replication information from the pg_stat_replication table. There are already modules that use similar tables to extract similar data.

https://www.postgresql.org/docs/9.5/monitoring-stats.html#PG-STAT-REPLICATION-VIEW

Describe a specific use case for the enhancement or feature:

This would be great for displaying and tracking the replication time between servers, time taken in each state, and the overall status of the replica set.

Thanks guys!
-Noah

[mmelyp]

+2

[BuffaloWill]

+1

This feature would help us understand if we have replication lag and, if so, should be alerted.

I would be interested in workarounds to get this information if anyone has them.

[slithernix]

me too

[chandransajith]

+1

[botelastic]

Hi!
We just realized that we haven't looked into this issue in a while. We're sorry!

We're labeling this issue as Stale to make it hit our filters and make sure we get back to it as soon as possible. In the meantime, it'd be extremely helpful if you could take a look at it as well and confirm its relevance. A simple comment with a nice emoji will be enough :+1.
Thank you for your contribution!

[mchirilab]

+1

[Vladislavgen]

+1

[lalit-satapathy]

@ishleenk17,

Since we have a beats PR on this in advanced stage, there are couple of questions for next steps:

• What's the overall plan to have this new data stream enabled on beats?
• Is this new data stream also needed in integration?
• Should we instead explore generic SQL to provide this new data stream in the integration(when we plan to do so.)