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 😃

[xiaobu2954]

@KennyChenFight
I have the same requirement as yours. Would you mind share your solution with me?

[aeroyorch]

Hi!

Any update on this?

We would also find it very useful if the exporter could collect per-database metrics (e.g. ccp_table_size_bytes) from databases other than the default "postgres", for example by allowing additional values in the DATA_SOURCE_URI environment variable. Or unless having a specific section explaining how to do it in https://access.crunchydata.com/documentation/postgres-operator/latest/guides/exporter-configuration.

Thank you in advance!