pg_stat_ssl.client_serial
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).
Reading PG 18·Select a recorded version
- View
- pg_stat_ssl
- Field
- client_serial
- SQL type
- numeric
- Units named in the field definition
- Not specified
- Reset observation
- No stats_reset field is documented for this view
- documented
- true
- field
- client_serial
- manual path
- /docs/18/monitoring-stats.html
- signature
- SELECT client_serial FROM pg_catalog.pg_stat_ssl;
- source only
- false
- sql type
- numeric
- units mentioned
- Unknown
- view
- pg_stat_ssl
Definition PG 18
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).
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f