Re: SSL information view - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: SSL information view
Date
Msg-id CABUevExEy4Z5Hcd1mEbymoKTJmTshko2W0fnCNG+D5pTPhB-pg@mail.gmail.com
Whole thread Raw
In response to Re: SSL information view  (Andres Freund <andres@anarazel.de>)
Responses Re: SSL information view
List pgsql-hackers

On Thu, Apr 9, 2015 at 3:20 PM, Andres Freund <andres@anarazel.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.

--

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: "rejected" vs "returned with feedback" in new CF app
Next
From: "David G. Johnston"
Date:
Subject: Re: "rejected" vs "returned with feedback" in new CF app