How to export schema level metrics

“I’m currently using postgres_exporter to collect database metrics and have successfully created a Grafana dashboard to visualize these metrics. However, my new requirement is to add a new panel to gather schema-level metrics for a specific database. I’m currently unsure about the configuration steps for achieving this. While I came across some documentation on configuring custom metrics, it appears that this method has been deprecated.”

The exporter is poorly documented rendering it useless, I am in the same situation.