{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_ssl-client_serial", "name": "pg_stat_ssl.client_serial", "name_zh": "", "category": "pg_stat_ssl", "summary": "\u5ba2\u6237\u7aef\u8bc1\u4e66\u7684\u5e8f\u5217\u53f7\uff0c\u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u5ba2\u6237\u7aef\u8bc1\u4e66\u6216\u5728\u6b64\u8fde\u63a5\u4e0a\u6ca1\u6709\u4f7f\u7528SSL\uff0c\u5219\u4e3a\u7a7a\u503c\u3002\u8bc1\u4e66\u5e8f\u5217\u53f7\u548c\u8bc1\u4e66\u9881\u53d1\u8005\u7684\u7ec4\u5408\u552f\u4e00\u6807\u8bc6\u4e00\u4e2a\u8bc1\u4e66\uff08\u9664\u975e\u9881\u53d1\u8005\u9519\u8bef\u5730\u91cd\u7528\u5e8f\u5217\u53f7\uff09\u3002", "aliases": ["client_serial", "pg_stat_ssl"], "content_hash": "4edb056fe9a467fe550f8ada0c00819e1478523178a52e0d9dce7a7c369241fe", "versions": {"12": {"view": "pg_stat_ssl", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_ssl"}, {"label": "\u5b57\u6bb5", "value": "client_serial"}, {"label": "SQL \u7c7b\u578b", "value": "numeric"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "client_serial", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_ssl/?v=12", "label": "pg_stat_ssl \u5b57\u6bb5"}, {"url": "/docs/12/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "12.22", "major": "12", "channel": "stable", "revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "sources": [{"url": "https://pg.center/docs/12/monitoring-stats.html#PG-STAT-SSL-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 12 English manual", "sha256": "3a764eaa784efc0eed1081cdfc2bf313c91bd17122d66dd16055d8b640320699", "language": "en", "original_url": "/docs/12/monitoring-stats.html#PG-STAT-SSL-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u4e2a\u8fde\u63a5\uff08\u666e\u901a\u8fde\u63a5\u548c\u590d\u5236\u8fde\u63a5\uff09\u4e00\u884c\uff0c\u663e\u793a\u6b64\u8fde\u63a5\u6240\u4f7f\u7528 SSL \u7684\u4fe1\u606f\u3002\u8be6\u89c1 pg_stat_ssl \u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "numeric", "signature": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "documented": true, "description": ["\u5ba2\u6237\u7aef\u8bc1\u4e66\u7684\u5e8f\u5217\u53f7\uff0c\u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u5ba2\u6237\u7aef\u8bc1\u4e66\u6216\u5728\u6b64\u8fde\u63a5\u4e0a\u6ca1\u6709\u4f7f\u7528SSL\uff0c\u5219\u4e3a\u7a7a\u503c\u3002\u8bc1\u4e66\u5e8f\u5217\u53f7\u548c\u8bc1\u4e66\u9881\u53d1\u8005\u7684\u7ec4\u5408\u552f\u4e00\u6807\u8bc6\u4e00\u4e2a\u8bc1\u4e66\uff08\u9664\u975e\u9881\u53d1\u8005\u9519\u8bef\u5730\u91cd\u7528\u5e8f\u5217\u53f7\uff09\u3002"], "manual_html": "", "manual_path": "/docs/12/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/12/monitoring-stats.html", "method": "same-major semantic node", "sha256": "d9fccd3a149dcb1b042346f59f216885cbd5a1cef552dae403a74da45af66cd0", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[6]/div[33]/div[1]/table[0]/tbody[2]/tr[7]/td[2]", "#MONITORING-STATS/div[6]/div[6]/div[1]/table[0]/tbody[2]/tr[4]/td[1]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "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).", "/versions/12/facts/0/label": "View", "/versions/12/facts/1/label": "Field", "/versions/12/facts/2/label": "SQL type", "/versions/12/facts/3/label": "Units named in the field definition", "/versions/12/facts/3/value": "Not specified", "/versions/12/facts/4/label": "Reset observation", "/versions/12/facts/4/value": "No stats_reset field is documented for this view", "/versions/12/related/0/label": "pg_stat_ssl columns", "/versions/12/related/1/label": "Statistics collection and reset functions", "/versions/12/sections/0/title": "View semantics", "/versions/12/sections/1/title": "Collection and reset context", "/versions/12/sections/2/title": "Inspect this field", "/versions/12/sections/0/paragraphs/0": "One row per connection (regular and replication), showing information about SSL used on this connection. See pg_stat_ssl for details.", "/versions/12/sections/1/paragraphs/0": "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.", "/versions/12/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "b467c89e9d92d37d3f1f449ff25dba94ec1d0ef3cc9f3cfba393dca841ff0d52"}, "comparison_data": {"view": "pg_stat_ssl", "field": "client_serial", "sql_type": "numeric", "units_mentioned": []}, "comparison_hash": "0307a121958eb288db008dc654c9f76c11305fa5507a62a449bbabc1bfcaff53", "units_mentioned": []}, "13": {"view": "pg_stat_ssl", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_ssl"}, {"label": "\u5b57\u6bb5", "value": "client_serial"}, {"label": "SQL \u7c7b\u578b", "value": "numeric"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "client_serial", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_ssl/?v=13", "label": "pg_stat_ssl \u5b57\u6bb5"}, {"url": "/docs/13/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "13.23", "major": "13", "channel": "stable", "revision": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "sources": [{"url": "https://pg.center/docs/13/monitoring-stats.html#PG-STAT-SSL-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 13 English manual", "sha256": "a8ec0d199d592259f260a41ccb2821e582cd6dae1014a784e1e86203740afcb0", "language": "en", "original_url": "/docs/13/monitoring-stats.html#PG-STAT-SSL-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_ssl \u89c6\u56fe\u5c06\u4e3a\u6bcf\u4e00\u4e2a\u540e\u7aef\u6216\u8005 WAL \u53d1\u9001\u8fdb\u7a0b\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u8fd9\u4e2a\u8fde\u63a5\u4e0a\u7684 SSL \u4f7f\u7528\u60c5\u51b5\u3002\u53ef\u4ee5\u628a\u5b83\u4e0e pg_stat_activity \u6216\u8005 pg_stat_replication \u901a\u8fc7 pid \u5217\u8fde\u63a5\u6765\u5f97\u5230\u66f4\u591a\u6709\u5173\u8be5\u8fde\u63a5\u7684\u7ec6\u8282\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "numeric", "signature": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "documented": true, "description": ["\u5ba2\u6237\u7aef\u8bc1\u4e66\u7684\u5e8f\u5217\u53f7\uff0c\u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u5ba2\u6237\u7aef\u8bc1\u4e66\u6216\u5728\u6b64\u8fde\u63a5\u4e0a\u6ca1\u6709\u4f7f\u7528SSL\uff0c\u5219\u4e3a\u7a7a\u503c\u3002\u8bc1\u4e66\u5e8f\u5217\u53f7\u548c\u8bc1\u4e66\u9881\u53d1\u8005\u7684\u7ec4\u5408\u552f\u4e00\u6807\u8bc6\u4e00\u4e2a\u8bc1\u4e66\uff08\u9664\u975e\u9881\u53d1\u8005\u9519\u8bef\u5730\u91cd\u7528\u5e8f\u5217\u53f7\uff09\u3002"], "manual_html": "", "manual_path": "/docs/13/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/13/monitoring-stats.html", "method": "same-major semantic node", "sha256": "1afff4ad1a4bc0c7e04a62d13adebcc1d39c30aca969618fab0cca8d0a115a96", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[11]/div[3]/div[1]/table[0]/tbody[2]/tr[7]/td[0]/p[1]", "#MONITORING-STATS/div[11]/p[2]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "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).", "/versions/13/facts/0/label": "View", "/versions/13/facts/1/label": "Field", "/versions/13/facts/2/label": "SQL type", "/versions/13/facts/3/label": "Units named in the field definition", "/versions/13/facts/3/value": "Not specified", "/versions/13/facts/4/label": "Reset observation", "/versions/13/facts/4/value": "No stats_reset field is documented for this view", "/versions/13/related/0/label": "pg_stat_ssl columns", "/versions/13/related/1/label": "Statistics collection and reset functions", "/versions/13/sections/0/title": "View semantics", "/versions/13/sections/1/title": "Collection and reset context", "/versions/13/sections/2/title": "Inspect this field", "/versions/13/sections/0/paragraphs/0": "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.", "/versions/13/sections/1/paragraphs/0": "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.", "/versions/13/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "561d34399a99833b0d3ed6f55d922ce05d8d32852f2b24c4a7a8b5ed16847fbd"}, "comparison_data": {"view": "pg_stat_ssl", "field": "client_serial", "sql_type": "numeric", "units_mentioned": []}, "comparison_hash": "0307a121958eb288db008dc654c9f76c11305fa5507a62a449bbabc1bfcaff53", "units_mentioned": []}, "14": {"view": "pg_stat_ssl", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_ssl"}, {"label": "\u5b57\u6bb5", "value": "client_serial"}, {"label": "SQL \u7c7b\u578b", "value": "numeric"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "client_serial", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_ssl/?v=14", "label": "pg_stat_ssl \u5b57\u6bb5"}, {"url": "/docs/14/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "14.24", "major": "14", "channel": "stable", "revision": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "sources": [{"url": "https://pg.center/docs/14/monitoring-stats.html#PG-STAT-SSL-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 14 English manual", "sha256": "1852c6205d68e465d08dd8f75e3b6bfdd4a475ee8d79886e2dcff6bff8e2d243", "language": "en", "original_url": "/docs/14/monitoring-stats.html#PG-STAT-SSL-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_ssl \u89c6\u56fe\u5c06\u4e3a\u6bcf\u4e00\u4e2a\u540e\u7aef\u6216\u8005 WAL \u53d1\u9001\u8fdb\u7a0b\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u8fd9\u4e2a\u8fde\u63a5\u4e0a\u7684 SSL \u4f7f\u7528\u60c5\u51b5\u3002\u53ef\u4ee5\u628a\u5b83\u4e0e pg_stat_activity \u6216\u8005 pg_stat_replication \u901a\u8fc7 pid \u5217\u8fde\u63a5\u6765\u5f97\u5230\u66f4\u591a\u6709\u5173\u8be5\u8fde\u63a5\u7684\u7ec6\u8282\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "numeric", "signature": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "documented": true, "description": ["\u5ba2\u6237\u7aef\u8bc1\u4e66\u7684\u5e8f\u5217\u53f7\uff0c\u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u5ba2\u6237\u7aef\u8bc1\u4e66\u6216\u5728\u6b64\u8fde\u63a5\u4e0a\u6ca1\u6709\u4f7f\u7528SSL\uff0c\u5219\u4e3a\u7a7a\u503c\u3002\u8bc1\u4e66\u5e8f\u5217\u53f7\u548c\u8bc1\u4e66\u9881\u53d1\u8005\u7684\u7ec4\u5408\u552f\u4e00\u6807\u8bc6\u4e00\u4e2a\u8bc1\u4e66\uff08\u9664\u975e\u9881\u53d1\u8005\u9519\u8bef\u5730\u91cd\u7528\u5e8f\u5217\u53f7\uff09\u3002"], "manual_html": "", "manual_path": "/docs/14/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/14/monitoring-stats.html", "method": "same-major semantic node", "sha256": "a622383556aa74bc5f0e402d9cb6c1e6ce1d111286c0f4e45f55b81e34d57922", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[12]/div[3]/div[1]/table[0]/tbody[2]/tr[6]/td[0]/p[1]", "#MONITORING-STATS/div[12]/p[2]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "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).", "/versions/14/facts/0/label": "View", "/versions/14/facts/1/label": "Field", "/versions/14/facts/2/label": "SQL type", "/versions/14/facts/3/label": "Units named in the field definition", "/versions/14/facts/3/value": "Not specified", "/versions/14/facts/4/label": "Reset observation", "/versions/14/facts/4/value": "No stats_reset field is documented for this view", "/versions/14/related/0/label": "pg_stat_ssl columns", "/versions/14/related/1/label": "Statistics collection and reset functions", "/versions/14/sections/0/title": "View semantics", "/versions/14/sections/1/title": "Collection and reset context", "/versions/14/sections/2/title": "Inspect this field", "/versions/14/sections/0/paragraphs/0": "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.", "/versions/14/sections/1/paragraphs/0": "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.", "/versions/14/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "e682ad5f37c4e17a6475a0bcfd7307a2732a8ed132896c18a6dfd085d75d9ce3"}, "comparison_data": {"view": "pg_stat_ssl", "field": "client_serial", "sql_type": "numeric", "units_mentioned": []}, "comparison_hash": "0307a121958eb288db008dc654c9f76c11305fa5507a62a449bbabc1bfcaff53", "units_mentioned": []}, "15": {"view": "pg_stat_ssl", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_ssl"}, {"label": "\u5b57\u6bb5", "value": "client_serial"}, {"label": "SQL \u7c7b\u578b", "value": "numeric"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "client_serial", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_ssl/?v=15", "label": "pg_stat_ssl \u5b57\u6bb5"}, {"url": "/docs/15/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "15.19", "major": "15", "channel": "stable", "revision": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "sources": [{"url": "https://pg.center/docs/15/monitoring-stats.html#PG-STAT-SSL-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 15 English manual", "sha256": "034c0a2e99e6707e637bf4d6cfd819d39eddc1b4b7c1ec2a00f0b4f0fdb0a078", "language": "en", "original_url": "/docs/15/monitoring-stats.html#PG-STAT-SSL-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_ssl \u89c6\u56fe\u5c06\u4e3a\u6bcf\u4e00\u4e2a\u540e\u7aef\u6216\u8005 WAL \u53d1\u9001\u8fdb\u7a0b\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u8fd9\u4e2a\u8fde\u63a5\u4e0a\u7684 SSL \u4f7f\u7528\u60c5\u51b5\u3002\u53ef\u4ee5\u628a\u5b83\u4e0e pg_stat_activity \u6216\u8005 pg_stat_replication \u901a\u8fc7 pid \u5217\u8fde\u63a5\u6765\u5f97\u5230\u66f4\u591a\u6709\u5173\u8be5\u8fde\u63a5\u7684\u7ec6\u8282\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "numeric", "signature": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "documented": true, "description": ["\u5ba2\u6237\u7aef\u8bc1\u4e66\u7684\u5e8f\u5217\u53f7\uff0c\u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u5ba2\u6237\u7aef\u8bc1\u4e66\u6216\u5728\u6b64\u8fde\u63a5\u4e0a\u6ca1\u6709\u4f7f\u7528SSL\uff0c\u5219\u4e3a\u7a7a\u503c\u3002\u8bc1\u4e66\u5e8f\u5217\u53f7\u548c\u8bc1\u4e66\u9881\u53d1\u8005\u7684\u7ec4\u5408\u552f\u4e00\u6807\u8bc6\u4e00\u4e2a\u8bc1\u4e66\uff08\u9664\u975e\u9881\u53d1\u8005\u9519\u8bef\u5730\u91cd\u7528\u5e8f\u5217\u53f7\uff09\u3002"], "manual_html": "", "manual_path": "/docs/15/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/15/monitoring-stats.html", "method": "same-major semantic node", "sha256": "373028581d43d13a3f098f997d5912fca6c8c1bf42a129d9336834c119bcaf6b", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[14]/div[3]/div[1]/table[0]/tbody[2]/tr[6]/td[0]/p[1]", "#MONITORING-STATS/div[14]/p[2]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "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).", "/versions/15/facts/0/label": "View", "/versions/15/facts/1/label": "Field", "/versions/15/facts/2/label": "SQL type", "/versions/15/facts/3/label": "Units named in the field definition", "/versions/15/facts/3/value": "Not specified", "/versions/15/facts/4/label": "Reset observation", "/versions/15/facts/4/value": "No stats_reset field is documented for this view", "/versions/15/related/0/label": "pg_stat_ssl columns", "/versions/15/related/1/label": "Statistics collection and reset functions", "/versions/15/sections/0/title": "View semantics", "/versions/15/sections/1/title": "Collection and reset context", "/versions/15/sections/2/title": "Inspect this field", "/versions/15/sections/0/paragraphs/0": "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.", "/versions/15/sections/1/paragraphs/0": "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.", "/versions/15/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "4141878d84624ea08ae698b54718f92d978a2abf0b4974b8d888742bcaa9bd80"}, "comparison_data": {"view": "pg_stat_ssl", "field": "client_serial", "sql_type": "numeric", "units_mentioned": []}, "comparison_hash": "0307a121958eb288db008dc654c9f76c11305fa5507a62a449bbabc1bfcaff53", "units_mentioned": []}, "16": {"view": "pg_stat_ssl", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_ssl"}, {"label": "\u5b57\u6bb5", "value": "client_serial"}, {"label": "SQL \u7c7b\u578b", "value": "numeric"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "client_serial", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_ssl/?v=16", "label": "pg_stat_ssl \u5b57\u6bb5"}, {"url": "/docs/16/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "sources": [{"url": "https://pg.center/docs/16/monitoring-stats.html#PG-STAT-SSL-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 16 English manual", "sha256": "a4c274defe8a41ff2895040cd542b5499063b844669ff3336de1a1317c3fe086", "language": "en", "original_url": "/docs/16/monitoring-stats.html#PG-STAT-SSL-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_ssl \u89c6\u56fe\u5c06\u4e3a\u6bcf\u4e00\u4e2a\u540e\u7aef\u6216\u8005 WAL \u53d1\u9001\u8fdb\u7a0b\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u8fd9\u4e2a\u8fde\u63a5\u4e0a\u7684 SSL \u4f7f\u7528\u60c5\u51b5\u3002\u53ef\u4ee5\u628a\u5b83\u4e0e pg_stat_activity \u6216\u8005 pg_stat_replication \u901a\u8fc7 pid \u5217\u8fde\u63a5\u6765\u5f97\u5230\u66f4\u591a\u6709\u5173\u8be5\u8fde\u63a5\u7684\u7ec6\u8282\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "numeric", "signature": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "documented": true, "description": ["\u5ba2\u6237\u7aef\u8bc1\u4e66\u7684\u5e8f\u5217\u53f7\uff0c\u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u5ba2\u6237\u7aef\u8bc1\u4e66\u6216\u5728\u6b64\u8fde\u63a5\u4e0a\u6ca1\u6709\u4f7f\u7528SSL\uff0c\u5219\u4e3a\u7a7a\u503c\u3002\u8bc1\u4e66\u5e8f\u5217\u53f7\u548c\u8bc1\u4e66\u9881\u53d1\u8005\u7684\u7ec4\u5408\u552f\u4e00\u6807\u8bc6\u4e00\u4e2a\u8bc1\u4e66\uff08\u9664\u975e\u9881\u53d1\u8005\u9519\u8bef\u5730\u91cd\u7528\u5e8f\u5217\u53f7\uff09\u3002"], "manual_html": "", "manual_path": "/docs/16/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/16/monitoring-stats.html", "method": "same-major semantic node", "sha256": "602e708943074767e7aad252e93938422e388dae22bd99fc583e93f7689395ba", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[14]/div[3]/div[1]/table[0]/tbody[2]/tr[6]/td[0]/p[1]", "#MONITORING-STATS/div[14]/p[2]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "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).", "/versions/16/facts/0/label": "View", "/versions/16/facts/1/label": "Field", "/versions/16/facts/2/label": "SQL type", "/versions/16/facts/3/label": "Units named in the field definition", "/versions/16/facts/3/value": "Not specified", "/versions/16/facts/4/label": "Reset observation", "/versions/16/facts/4/value": "No stats_reset field is documented for this view", "/versions/16/related/0/label": "pg_stat_ssl columns", "/versions/16/related/1/label": "Statistics collection and reset functions", "/versions/16/sections/0/title": "View semantics", "/versions/16/sections/1/title": "Collection and reset context", "/versions/16/sections/2/title": "Inspect this field", "/versions/16/sections/0/paragraphs/0": "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.", "/versions/16/sections/1/paragraphs/0": "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.", "/versions/16/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "3999bed18376309f4bc43c6e0b138b143416b0b5d0d70724077b6a75aea5d3e2"}, "comparison_data": {"view": "pg_stat_ssl", "field": "client_serial", "sql_type": "numeric", "units_mentioned": []}, "comparison_hash": "0307a121958eb288db008dc654c9f76c11305fa5507a62a449bbabc1bfcaff53", "units_mentioned": []}, "17": {"view": "pg_stat_ssl", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_ssl"}, {"label": "\u5b57\u6bb5", "value": "client_serial"}, {"label": "SQL \u7c7b\u578b", "value": "numeric"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "client_serial", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_ssl/?v=17", "label": "pg_stat_ssl \u5b57\u6bb5"}, {"url": "/docs/17/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sources": [{"url": "https://pg.center/docs/17/monitoring-stats.html#PG-STAT-SSL-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 17 English manual", "sha256": "007af6e8ab39b925963273ec3ba7f06f8ee6fbfaad821f07a1dc78383dbb9b99", "language": "en", "original_url": "/docs/17/monitoring-stats.html#PG-STAT-SSL-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_ssl \u89c6\u56fe\u5c06\u4e3a\u6bcf\u4e00\u4e2a\u540e\u7aef\u6216\u8005 WAL \u53d1\u9001\u8fdb\u7a0b\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u8fd9\u4e2a\u8fde\u63a5\u4e0a\u7684 SSL \u4f7f\u7528\u60c5\u51b5\u3002\u53ef\u4ee5\u628a\u5b83\u4e0e pg_stat_activity \u6216\u8005 pg_stat_replication \u901a\u8fc7 pid \u5217\u8fde\u63a5\u6765\u5f97\u5230\u66f4\u591a\u6709\u5173\u8be5\u8fde\u63a5\u7684\u7ec6\u8282\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "numeric", "signature": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "documented": true, "description": ["\u5ba2\u6237\u7aef\u8bc1\u4e66\u7684\u5e8f\u5217\u53f7\uff0c\u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u5ba2\u6237\u7aef\u8bc1\u4e66\u6216\u5728\u6b64\u8fde\u63a5\u4e0a\u6ca1\u6709\u4f7f\u7528SSL\uff0c\u5219\u4e3a\u7a7a\u503c\u3002\u8bc1\u4e66\u5e8f\u5217\u53f7\u548c\u8bc1\u4e66\u9881\u53d1\u8005\u7684\u7ec4\u5408\u552f\u4e00\u6807\u8bc6\u4e00\u4e2a\u8bc1\u4e66\uff08\u9664\u975e\u9881\u53d1\u8005\u9519\u8bef\u5730\u91cd\u7528\u5e8f\u5217\u53f7\uff09\u3002"], "manual_html": "", "manual_path": "/docs/17/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/17/monitoring-stats.html", "method": "same-major semantic node", "sha256": "5cd346cc373a5a006b07664d9969d4c630c8ea55dea33b8f3211f061ce43e54f", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[14]/div[3]/div[1]/table[0]/tbody[2]/tr[6]/td[0]/p[1]", "#MONITORING-STATS/div[14]/p[2]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "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).", "/versions/17/facts/0/label": "View", "/versions/17/facts/1/label": "Field", "/versions/17/facts/2/label": "SQL type", "/versions/17/facts/3/label": "Units named in the field definition", "/versions/17/facts/3/value": "Not specified", "/versions/17/facts/4/label": "Reset observation", "/versions/17/facts/4/value": "No stats_reset field is documented for this view", "/versions/17/related/0/label": "pg_stat_ssl columns", "/versions/17/related/1/label": "Statistics collection and reset functions", "/versions/17/sections/0/title": "View semantics", "/versions/17/sections/1/title": "Collection and reset context", "/versions/17/sections/2/title": "Inspect this field", "/versions/17/sections/0/paragraphs/0": "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.", "/versions/17/sections/1/paragraphs/0": "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.", "/versions/17/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "344bf529854bbad21f4eee69587e7f6f72b5551fbdfd59717e295f92b7e3e0c9"}, "comparison_data": {"view": "pg_stat_ssl", "field": "client_serial", "sql_type": "numeric", "units_mentioned": []}, "comparison_hash": "0307a121958eb288db008dc654c9f76c11305fa5507a62a449bbabc1bfcaff53", "units_mentioned": []}, "18": {"view": "pg_stat_ssl", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_ssl"}, {"label": "\u5b57\u6bb5", "value": "client_serial"}, {"label": "SQL \u7c7b\u578b", "value": "numeric"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "client_serial", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_ssl/?v=18", "label": "pg_stat_ssl \u5b57\u6bb5"}, {"url": "/docs/18/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/monitoring-stats.html#PG-STAT-SSL-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 18 English manual", "sha256": "aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722", "language": "en", "original_url": "/docs/18/monitoring-stats.html#PG-STAT-SSL-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_ssl \u89c6\u56fe\u5c06\u4e3a\u6bcf\u4e00\u4e2a\u540e\u7aef\u6216\u8005 WAL \u53d1\u9001\u8fdb\u7a0b\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u8fd9\u4e2a\u8fde\u63a5\u4e0a\u7684 SSL \u4f7f\u7528\u60c5\u51b5\u3002\u53ef\u4ee5\u628a\u5b83\u4e0e pg_stat_activity \u6216\u8005 pg_stat_replication \u901a\u8fc7 pid \u5217\u8fde\u63a5\u6765\u5f97\u5230\u66f4\u591a\u6709\u5173\u8be5\u8fde\u63a5\u7684\u7ec6\u8282\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "numeric", "signature": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "documented": true, "description": ["\u5ba2\u6237\u7aef\u8bc1\u4e66\u7684\u5e8f\u5217\u53f7\uff0c\u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u5ba2\u6237\u7aef\u8bc1\u4e66\u6216\u5728\u6b64\u8fde\u63a5\u4e0a\u6ca1\u6709\u4f7f\u7528SSL\uff0c\u5219\u4e3a\u7a7a\u503c\u3002\u8bc1\u4e66\u5e8f\u5217\u53f7\u548c\u8bc1\u4e66\u9881\u53d1\u8005\u7684\u7ec4\u5408\u552f\u4e00\u6807\u8bc6\u4e00\u4e2a\u8bc1\u4e66\uff08\u9664\u975e\u9881\u53d1\u8005\u9519\u8bef\u5730\u91cd\u7528\u5e8f\u5217\u53f7\uff09\u3002"], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/18/monitoring-stats.html", "method": "same-major semantic node", "sha256": "ff0b10c5fb4b75c247e38b7ad0e8a50fa0b6ebaa25e68c8c67a1ca972bda40b1", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[14]/div[3]/div[1]/table[0]/tbody[2]/tr[6]/td[0]/p[1]", "#MONITORING-STATS/div[14]/p[2]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "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).", "/versions/18/facts/0/label": "View", "/versions/18/facts/1/label": "Field", "/versions/18/facts/2/label": "SQL type", "/versions/18/facts/3/label": "Units named in the field definition", "/versions/18/facts/3/value": "Not specified", "/versions/18/facts/4/label": "Reset observation", "/versions/18/facts/4/value": "No stats_reset field is documented for this view", "/versions/18/related/0/label": "pg_stat_ssl columns", "/versions/18/related/1/label": "Statistics collection and reset functions", "/versions/18/sections/0/title": "View semantics", "/versions/18/sections/1/title": "Collection and reset context", "/versions/18/sections/2/title": "Inspect this field", "/versions/18/sections/0/paragraphs/0": "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.", "/versions/18/sections/1/paragraphs/0": "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.", "/versions/18/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "ed1b319cd68607095a1c9c0f99b38808207ce12b4d3b2837c03a7320a61b07ae"}, "comparison_data": {"view": "pg_stat_ssl", "field": "client_serial", "sql_type": "numeric", "units_mentioned": []}, "comparison_hash": "0307a121958eb288db008dc654c9f76c11305fa5507a62a449bbabc1bfcaff53", "units_mentioned": []}, "19": {"view": "pg_stat_ssl", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_ssl"}, {"label": "\u5b57\u6bb5", "value": "client_serial"}, {"label": "SQL \u7c7b\u578b", "value": "numeric"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "client_serial", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_ssl/?v=19", "label": "pg_stat_ssl \u5b57\u6bb5"}, {"url": "/docs/19/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "https://pg.center/docs/19/monitoring-stats.html#PG-STAT-SSL-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 19 English manual", "sha256": "26e1b6632bdf05ebe081987cb60ab4ded526eec7db73e41316fbd69466c494fe", "language": "en", "original_url": "/docs/19/monitoring-stats.html#PG-STAT-SSL-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_ssl \u89c6\u56fe\u5c06\u4e3a\u6bcf\u4e00\u4e2a\u540e\u7aef\u6216\u8005 WAL \u53d1\u9001\u8fdb\u7a0b\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u8fd9\u4e2a\u8fde\u63a5\u4e0a\u7684 SSL \u4f7f\u7528\u60c5\u51b5\u3002\u53ef\u4ee5\u628a\u5b83\u4e0e pg_stat_activity \u6216\u8005 pg_stat_replication \u901a\u8fc7 pid \u5217\u8fde\u63a5\u6765\u5f97\u5230\u66f4\u591a\u6709\u5173\u8be5\u8fde\u63a5\u7684\u7ec6\u8282\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "numeric", "signature": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "documented": true, "description": ["\u5ba2\u6237\u7aef\u8bc1\u4e66\u7684\u5e8f\u5217\u53f7\uff0c\u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u5ba2\u6237\u7aef\u8bc1\u4e66\u6216\u5728\u6b64\u8fde\u63a5\u4e0a\u6ca1\u6709\u4f7f\u7528SSL\uff0c\u5219\u4e3a\u7a7a\u503c\u3002\u8bc1\u4e66\u5e8f\u5217\u53f7\u548c\u8bc1\u4e66\u9881\u53d1\u8005\u7684\u7ec4\u5408\u552f\u4e00\u6807\u8bc6\u4e00\u4e2a\u8bc1\u4e66\uff08\u9664\u975e\u9881\u53d1\u8005\u9519\u8bef\u5730\u91cd\u7528\u5e8f\u5217\u53f7\uff09\u3002"], "manual_html": "", "manual_path": "/docs/19/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/19/monitoring-stats.html", "method": "same-major semantic node", "sha256": "024434288428f15560d48c78af2e836ca669a4217589cfaeb2f16b72123b501a", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[15]/div[3]/div[1]/table[0]/tbody[2]/tr[6]/td[0]/p[1]", "#MONITORING-STATS/div[15]/p[2]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "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).", "/versions/19/facts/0/label": "View", "/versions/19/facts/1/label": "Field", "/versions/19/facts/2/label": "SQL type", "/versions/19/facts/3/label": "Units named in the field definition", "/versions/19/facts/3/value": "Not specified", "/versions/19/facts/4/label": "Reset observation", "/versions/19/facts/4/value": "No stats_reset field is documented for this view", "/versions/19/related/0/label": "pg_stat_ssl columns", "/versions/19/related/1/label": "Statistics collection and reset functions", "/versions/19/sections/0/title": "View semantics", "/versions/19/sections/1/title": "Collection and reset context", "/versions/19/sections/2/title": "Inspect this field", "/versions/19/sections/0/paragraphs/0": "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.", "/versions/19/sections/1/paragraphs/0": "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.", "/versions/19/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "9e66e44b6d90817603986de1982956b117b97e80fb13893fd7c81d198455c21c"}, "comparison_data": {"view": "pg_stat_ssl", "field": "client_serial", "sql_type": "numeric", "units_mentioned": []}, "comparison_hash": "0307a121958eb288db008dc654c9f76c11305fa5507a62a449bbabc1bfcaff53", "units_mentioned": []}, "20": {"view": "pg_stat_ssl", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_ssl"}, {"label": "\u5b57\u6bb5", "value": "client_serial"}, {"label": "SQL \u7c7b\u578b", "value": "numeric"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "client_serial", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_ssl/?v=20", "label": "pg_stat_ssl \u5b57\u6bb5"}, {"url": "/docs/devel/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "https://pg.center/docs/devel/monitoring-stats.html#PG-STAT-SSL-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 20 English manual", "sha256": "dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251", "language": "en", "original_url": "/docs/devel/monitoring-stats.html#PG-STAT-SSL-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_ssl \u89c6\u56fe\u5c06\u4e3a\u6bcf\u4e00\u4e2a\u540e\u7aef\u6216\u8005 WAL \u53d1\u9001\u8fdb\u7a0b\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u8fd9\u4e2a\u8fde\u63a5\u4e0a\u7684 SSL \u4f7f\u7528\u60c5\u51b5\u3002\u53ef\u4ee5\u628a\u5b83\u4e0e pg_stat_activity \u6216\u8005 pg_stat_replication \u901a\u8fc7 pid \u5217\u8fde\u63a5\u6765\u5f97\u5230\u66f4\u591a\u6709\u5173\u8be5\u8fde\u63a5\u7684\u7ec6\u8282\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "numeric", "signature": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "documented": true, "description": ["\u5ba2\u6237\u7aef\u8bc1\u4e66\u7684\u5e8f\u5217\u53f7\uff0c\u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u5ba2\u6237\u7aef\u8bc1\u4e66\u6216\u5728\u6b64\u8fde\u63a5\u4e0a\u6ca1\u6709\u4f7f\u7528SSL\uff0c\u5219\u4e3a\u7a7a\u503c\u3002\u8bc1\u4e66\u5e8f\u5217\u53f7\u548c\u8bc1\u4e66\u9881\u53d1\u8005\u7684\u7ec4\u5408\u552f\u4e00\u6807\u8bc6\u4e00\u4e2a\u8bc1\u4e66\uff08\u9664\u975e\u9881\u53d1\u8005\u9519\u8bef\u5730\u91cd\u7528\u5e8f\u5217\u53f7\uff09\u3002"], "manual_html": "", "manual_path": "/docs/devel/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/devel/monitoring-stats.html", "method": "same-major semantic node", "sha256": "1d9a086fb4c6fdd9a56d3a7a28e8c164354ef0bf50c402f06ebe174538f96a4f", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[15]/div[3]/div[1]/table[0]/tbody[2]/tr[6]/td[0]/p[1]", "#MONITORING-STATS/div[15]/p[2]"]}], "language": "zh", "original_text": {"/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).", "/versions/20/description/0": "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).", "/versions/20/facts/0/label": "View", "/versions/20/facts/1/label": "Field", "/versions/20/facts/2/label": "SQL type", "/versions/20/facts/3/label": "Units named in the field definition", "/versions/20/facts/3/value": "Not specified", "/versions/20/facts/4/label": "Reset observation", "/versions/20/facts/4/value": "No stats_reset field is documented for this view", "/versions/20/related/0/label": "pg_stat_ssl columns", "/versions/20/related/1/label": "Statistics collection and reset functions", "/versions/20/sections/0/title": "View semantics", "/versions/20/sections/1/title": "Collection and reset context", "/versions/20/sections/2/title": "Inspect this field", "/versions/20/sections/0/paragraphs/0": "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.", "/versions/20/sections/1/paragraphs/0": "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.", "/versions/20/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "212938a6190e26dea80db0fd9f937acb9a986ff907ecd81db1c2d1225f0e3d7f"}, "comparison_data": {"view": "pg_stat_ssl", "field": "client_serial", "sql_type": "numeric", "units_mentioned": []}, "comparison_hash": "0307a121958eb288db008dc654c9f76c11305fa5507a62a449bbabc1bfcaff53", "units_mentioned": []}}}, "snapshot": {"view": "pg_stat_ssl", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_ssl"}, {"label": "\u5b57\u6bb5", "value": "client_serial"}, {"label": "SQL \u7c7b\u578b", "value": "numeric"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "client_serial", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_ssl/?v=18", "label": "pg_stat_ssl \u5b57\u6bb5"}, {"url": "/docs/18/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/monitoring-stats.html#PG-STAT-SSL-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 18 English manual", "sha256": "aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722", "language": "en", "original_url": "/docs/18/monitoring-stats.html#PG-STAT-SSL-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_ssl \u89c6\u56fe\u5c06\u4e3a\u6bcf\u4e00\u4e2a\u540e\u7aef\u6216\u8005 WAL \u53d1\u9001\u8fdb\u7a0b\u5305\u542b\u4e00\u884c\uff0c\u7528\u6765\u663e\u793a\u8fd9\u4e2a\u8fde\u63a5\u4e0a\u7684 SSL \u4f7f\u7528\u60c5\u51b5\u3002\u53ef\u4ee5\u628a\u5b83\u4e0e pg_stat_activity \u6216\u8005 pg_stat_replication \u901a\u8fc7 pid \u5217\u8fde\u63a5\u6765\u5f97\u5230\u66f4\u591a\u6709\u5173\u8be5\u8fde\u63a5\u7684\u7ec6\u8282\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "numeric", "signature": "SELECT client_serial FROM pg_catalog.pg_stat_ssl;", "documented": true, "description": ["\u5ba2\u6237\u7aef\u8bc1\u4e66\u7684\u5e8f\u5217\u53f7\uff0c\u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u5ba2\u6237\u7aef\u8bc1\u4e66\u6216\u5728\u6b64\u8fde\u63a5\u4e0a\u6ca1\u6709\u4f7f\u7528SSL\uff0c\u5219\u4e3a\u7a7a\u503c\u3002\u8bc1\u4e66\u5e8f\u5217\u53f7\u548c\u8bc1\u4e66\u9881\u53d1\u8005\u7684\u7ec4\u5408\u552f\u4e00\u6807\u8bc6\u4e00\u4e2a\u8bc1\u4e66\uff08\u9664\u975e\u9881\u53d1\u8005\u9519\u8bef\u5730\u91cd\u7528\u5e8f\u5217\u53f7\uff09\u3002"], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/18/monitoring-stats.html", "method": "same-major semantic node", "sha256": "ff0b10c5fb4b75c247e38b7ad0e8a50fa0b6ebaa25e68c8c67a1ca972bda40b1", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[14]/div[3]/div[1]/table[0]/tbody[2]/tr[6]/td[0]/p[1]", "#MONITORING-STATS/div[14]/p[2]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "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).", "/versions/18/facts/0/label": "View", "/versions/18/facts/1/label": "Field", "/versions/18/facts/2/label": "SQL type", "/versions/18/facts/3/label": "Units named in the field definition", "/versions/18/facts/3/value": "Not specified", "/versions/18/facts/4/label": "Reset observation", "/versions/18/facts/4/value": "No stats_reset field is documented for this view", "/versions/18/related/0/label": "pg_stat_ssl columns", "/versions/18/related/1/label": "Statistics collection and reset functions", "/versions/18/sections/0/title": "View semantics", "/versions/18/sections/1/title": "Collection and reset context", "/versions/18/sections/2/title": "Inspect this field", "/versions/18/sections/0/paragraphs/0": "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.", "/versions/18/sections/1/paragraphs/0": "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.", "/versions/18/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "ed1b319cd68607095a1c9c0f99b38808207ce12b4d3b2837c03a7320a61b07ae"}, "comparison_data": {"view": "pg_stat_ssl", "field": "client_serial", "sql_type": "numeric", "units_mentioned": []}, "comparison_hash": "0307a121958eb288db008dc654c9f76c11305fa5507a62a449bbabc1bfcaff53", "units_mentioned": []}, "comparison": {"left": "11", "right": "12", "status": "added", "diff": "--- PostgreSQL 11\n+++ PostgreSQL 12\n@@ -1 +1,6 @@\n-\u8be5\u7248\u672a\u6536\u5f55\n+{\n+  \"field\": \"client_serial\",\n+  \"sql_type\": \"numeric\",\n+  \"units_mentioned\": [],\n+  \"view\": \"pg_stat_ssl\"\n+}"}}