{"Entry":{"collection":"metric","key":"pg_stat_ssl-client_serial","name":"pg_stat_ssl.client_serial","aliases":["client_serial","pg_stat_ssl"],"metadata":{"aliases":["client_serial","pg_stat_ssl"],"category":"pg_stat_ssl","content_hash":"7e9fcaab12853afbfcc1c433f74d9506d3bbe69824453ee8651f3a7af92ca7d7","imported_at":"2026-09-30T00:40:46.167249+08:00","name":"pg_stat_ssl.client_serial","name_zh":"","slug":"pg_stat_ssl-client_serial","summary":"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)."}},"Definition":{"Collection":"metric","Key":"pg_stat_ssl-client_serial","SourceDatabase":"center","Version":"18","SourceTable":"statistics_metric","SourceKey":"pg_stat_ssl-client_serial","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"comparison_data":{"field":"client_serial","sql_type":"numeric","units_mentioned":[],"view":"pg_stat_ssl"},"comparison_hash":"0307a121958eb288db008dc654c9f76c11305fa5507a62a449bbabc1bfcaff53","description":["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)."],"documented":true,"facts":[{"label":"View","value":"pg_stat_ssl"},{"label":"Field","value":"client_serial"},{"label":"SQL type","value":"numeric"},{"label":"Units named in the field definition","value":"Not specified"},{"label":"Reset observation","value":"No stats_reset field is documented for this view"}],"field":"client_serial","manual_html":"","manual_path":"/docs/18/monitoring-stats.html","related":[{"label":"pg_stat_ssl columns","url":"/wiki/catalog/pg_stat_ssl/?v=18"},{"label":"Statistics collection and reset functions","url":"/docs/18/monitoring-stats.html"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[{"paragraphs":["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."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT client_serial FROM pg_catalog.pg_stat_ssl;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"signature":"SELECT client_serial FROM pg_catalog.pg_stat_ssl;","source_only":false,"sources":[{"label":"PostgreSQL 18 English manual","path":"monitoring-stats.html","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","url":"/docs/18/monitoring-stats.html#PG-STAT-SSL-VIEW"}],"sql_type":"numeric","tables":[],"units_mentioned":[],"view":"pg_stat_ssl"},"ManualEvidence":{"manual_path":"/docs/18/monitoring-stats.html","release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"label":"PostgreSQL 18 English manual","path":"monitoring-stats.html","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","url":"/docs/18/monitoring-stats.html#PG-STAT-SSL-VIEW"}]},"MeasuredEvidence":{}},"Text":{"Collection":"metric","Key":"pg_stat_ssl-client_serial","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_ssl.client_serial","Summary":"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).","BodyHTML":"\u003cp\u003eSerial 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).\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"0458d2f31f70142cb30dc28b3e387a74efa048c07cf507eec78b862028d869bf","Payload":{"description":["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)."],"manual_html":"","related":[{"label":"pg_stat_ssl columns","url":"/wiki/catalog/pg_stat_ssl/?v=18"},{"label":"Statistics collection and reset functions","url":"/docs/18/monitoring-stats.html"}],"sections":[{"paragraphs":["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."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT client_serial FROM pg_catalog.pg_stat_ssl;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"tables":[]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}