Usually databases(focusing postgres) offer multiple simultaneous connection that enable us to perform CRUD operations on them. I wonder if each connection is resource heavy, and would like to know if there is a measure as to how much resource (cpu/ram etc) each connection keeps consumed/allocated while the connection is active?
Any tool or methodology to help monitor this would be great