How to collect non postgres database metrics via pgmonitor

[KennyChenFight]

Questions

I can set up postgres-exporter via monitoring -> pgmonitor -> exporter in postgres-operator v5.5
But like ccp_stat_user_tables metrics, only collect metrics from postgres database
Should I set up the another postgres-exporter in sidecar ?

This is the same issue

[dsessler7]

Hello @KennyChenFight,

The global metrics that are collected by the exporter are collected from all databases. However, you are correct that we don't currently have per-db type metrics. That being said, this is a feature that we have in our development backlog.

[KennyChenFight]

Hello @KennyChenFight,

The global metrics that are collected by the exporter are collected from all databases. However, you are correct that we don't currently have per-db type metrics. That being said, this is a feature that we have in our development backlog.

@dsessler7
Thank you for your reply. So the current workaround way is that we set up another postgres-exporter in another deployment or in pgo sidecar and change DATA_SOURCE_URI env to collect another database metrics ?

[dsessler7]

We don't have a documented "workaround" since this is more of a new feature than a bug, but what you've suggested there definitely sounds like you're on the right track. If you give it a try we'd love to hear how it goes/what you find out!

[KennyChenFight]

We don't have a documented "workaround" since this is more of a new feature than a bug, but what you've suggested there definitely sounds like you're on the right track. If you give it a try we'd love to hear how it goes/what you find out!

Got it. And thanks for your reply 😃