System view for open sessions

[hlcianfagna]

Problem Statement

When debugging issues with connection pooling, connections in sys.nodes allows to see the number of open connections, but there are no further details.

Possible Solutions

It would be nice to have a system view for open sessions which could maybe show handling node, client IP address, user name, time opened, last command sent, session settings, and SSL status.

• pg_stat_activity
• sys.sessions?
• ?

Considered Alternatives

No response

[amotl]

Hi Hernan,

I like the idea. Is there any blueprint for that, for example how PostgreSQL does it?

With kind regards, Andreas.

[hlcianfagna]

Is there any blueprint for that, for example how PostgreSQL does it?

Hi, yes, maybe this could be based on pg_stat_activity