As a sysop I can run

to display all database connections, including idle connections.

The application_name column shows the value set by the module. By default the module libraries set it to PostgreSQL JDBC Driver or vertx-pg-client.

Task:

Configure all modules to show the module name, not the SQL client library name.

RMB does this automatically for all RMB based modules for the Ramsons and all following releases:

folio-vertx-lib enforces this for all folio-vertx-lib modules: https://github.com/folio-org/folio-vertx-lib/blob/v1.0.0/core/src/main/java/org/folio/tlib/postgres/impl/TenantPgPoolImpl.java#L104-L110

Spring Boot based modules may use this in the application.yml:

If using hikari also add