monitoring database performance in distributed systems, you really have to watch a lot of moving parts.

We're setting up a new distributed system, and it's got a bunch of microservices all talking to the same PostgreSQL database. I'm trying to nail down the best way to keep an eye on how our queries are performing, how connection pooling is working, and just generally make sure the database is healthy across everything. Have you found any tools or approaches that are really good for spotting slowdowns or problems when you've got a distributed database setup like this? Any tips would be awesome!