STATISTICS VIEW · Statistics view

pg_stat_ssl

PostgreSQL documentation ↗Source definition ↗

The pg_stat_ssl view will contain one row per backend or WAL sender process, showing statistics about SSL usage on this connection. It can be joined to pg_stat_activity or pg_stat_replication on the pid column to get more details about the connection.

First seen PG 9.5Last seen PG 19Columns 8

9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19^β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns PostgreSQL 18

pg_stat_ssl

COLUMN	TYPE	DESCRIPTION
`pid`	`integer`	Process ID of a backend or WAL sender process
`ssl`	`boolean`	True if SSL is used on this connection
`version`	`text`	Version of SSL in use, or NULL if SSL is not in use on this connection
`cipher`	`text`	Name of SSL cipher in use, or NULL if SSL is not in use on this connection
`bits`	`integer`	Number of bits in the encryption algorithm used, or NULL if SSL is not used on this connection
`client_dn`	`text`	Distinguished Name (DN) field from the client certificate used, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated if the DN field is longer than NAMEDATALEN (64 characters in a standard build).
`client_serial`	`numeric`	Serial number of the client certificate, or NULL if no client certificate was supplied or if SSL is not in use on this connection. The combination of certificate serial number and certificate issuer uniquely identifies a certificate (unless the issuer erroneously reuses serial numbers).
`issuer_dn`	`text`	DN of the issuer of the client certificate, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated like client_dn.

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Column evolution matrix

Hover a cell for the column type

PresentAdded / type or attribute changeRemoved

COLUMN	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19
`pid`	–	–	–	–	–
`ssl`	–	–	–	–	–
`version`	–	–	–	–	–
`cipher`	–	–	–	–	–
`bits`	–	–	–	–	–
`compression`	–	–	–	–	–							−	–	–	–	–	–
`clientdn`	–	–	–	–	–					−	–	–	–	–	–	–	–
`client_dn`	–	–	–	–	–	–	–	–	–
`client_serial`	–	–	–	–	–	–	–	–	–
`issuer_dn`	–	–	–	–	–	–	–	–	–

9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 14 ← 13

− compression

PostgreSQL 13 ← 12

Catalog description updated

PostgreSQL 12 ← 11

+ client_dn+ client_serial+ issuer_dn− clientdnCatalog description updated

PostgreSQL 10 ← 9.6

Catalog description updated

PostgreSQL 9.6 ← 9.5

Catalog description updated

PostgreSQL 9.5 ← 9.4Catalog added

+ pid+ ssl+ version+ cipher+ bits+ compression+ clientdn

Compare any two versions

FROMTOInclude description updates

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.