Feature Request: pg_stat_activity.client_hostname and Unix sockets

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Feature Request: pg_stat_activity.client_hostname and Unix sockets
Date: 2026-09-01 16:14:19
Message-ID: CANzqJaB8m5j2jUHL-90LdDj-Ti8b3id=1fzdqodXXCAJi6MA8Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

This predicate is, I think, comprehensive, but it seems fragile, since new
state and backend_type values could be added.

( client_hostname IS NULL
AND state IS NOT NULL
AND backend_type IN ( 'client backend'
, 'parallel worker'
, 'autovacuum launcher'
, 'autovacuum worker')
)

Thus, client_hostname set to "unix" or "socket" on such local connections
would be handy.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

Browse pgsql-admin by date

  From Date Subject
Next Message Pierre Forstmann 2026-09-02 05:15:49 what is the difference between ROLE clause and IN ROLE clause for CREATE USER statement ?
Previous Message bertrand HARTWIG 2026-09-01 05:07:17 Re: How to definitively determine whether a statement is a SELECT statement?