Re: SSL information view

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Bernd Helmle <mailings(at)oopsware(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SSL information view
Date: 2015-04-09 13:56:00
Message-ID: CABUevExEy4Z5Hcd1mEbymoKTJmTshko2W0fnCNG+D5pTPhB-pg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Apr 9, 2015 at 3:20 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:

> Hi,
>
> On 2015-04-09 13:31:55 +0200, Magnus Hagander wrote:
> > + <row>
> > +
> <entry><structname>pg_stat_ssl</><indexterm><primary>pg_stat_ssl</primary></indexterm></entry>
> > + <entry>One row per connection (regular and replication), showing
> information about
> > + SSL used on this connection.
> > + See <xref linkend="pg-stat-ssl-view"> for details.
> > + </entry>
> > + </row>
> > +
>
> I kinda wonder why this even separate from pg_stat_activity, at least
> from the POV of the function gathering the result. This way you have to
> join between pg_stat_activity and pg_stat_ssl which will mean that the
> two don't necessarily correspond to each other.
>

To keep from "cluttering" pg_stat_activity for the majority of users who
are the ones not actually using SSL.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2015-04-09 14:53:38 Re: "rejected" vs "returned with feedback" in new CF app
Previous Message Andrew Dunstan 2015-04-09 13:52:48 Re: "rejected" vs "returned with feedback" in new CF app