1. 6

    We have several “services” (not the micro-variety) that use a shared database. Each service has its own user with limited access to the tables it needs, but more importantly it lets us use a tool like PgHero or PgAnalyze to look at database usage patterns on a per-service basis. This has helped a lot with identifying bad queries, application bugs, etc.