{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_gssapi-principal", "name": "pg_stat_gssapi.principal", "name_zh": "", "category": "pg_stat_gssapi", "summary": "\u7528\u4e8e\u8ba4\u8bc1\u6b64\u8fde\u63a5\u7684\u4e3b\u4f53\uff1b\u672a\u4f7f\u7528 GSSAPI \u8ba4\u8bc1\u65f6\u4e3a NULL\u3002\u5982\u679c\u4e3b\u4f53\u7684\u957f\u5ea6\u8d85\u8fc7 NAMEDATALEN\uff08\u6807\u51c6\u6784\u5efa\u4e2d\u4e3a 64 \u4e2a\u5b57\u7b26\uff09\uff0c\u6b64\u5b57\u6bb5\u4f1a\u88ab\u622a\u65ad\u3002", "aliases": ["principal", "pg_stat_gssapi"], "content_hash": "505442d421ed1df2de241489c048d00896b77d3f78932e5207e51cb97814891a", "versions": {"12": {"view": "pg_stat_gssapi", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_gssapi"}, {"label": "\u5b57\u6bb5", "value": "principal"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"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": "principal", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_gssapi/?v=12", "label": "pg_stat_gssapi \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-GSSAPI-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 12 English manual", "sha256": "3a764eaa784efc0eed1081cdfc2bf313c91bd17122d66dd16055d8b640320699", "language": "en", "original_url": "/docs/12/monitoring-stats.html#PG-STAT-GSSAPI-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 GSSAPI \u8ba4\u8bc1\u548c\u52a0\u5bc6\u7684\u4fe1\u606f\u3002\u8be6\u89c1 pg_stat_gssapi \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 principal FROM pg_catalog.pg_stat_gssapi;", "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": "text", "signature": "SELECT principal FROM pg_catalog.pg_stat_gssapi;", "documented": true, "description": ["\u7528\u4e8e\u8ba4\u8bc1\u6b64\u8fde\u63a5\u7684\u4e3b\u4f53\uff1b\u672a\u4f7f\u7528 GSSAPI \u8ba4\u8bc1\u65f6\u4e3a NULL\u3002\u5982\u679c\u4e3b\u4f53\u7684\u957f\u5ea6\u8d85\u8fc7 NAMEDATALEN\uff08\u6807\u51c6\u6784\u5efa\u4e2d\u4e3a 64 \u4e2a\u5b57\u7b26\uff09\uff0c\u6b64\u5b57\u6bb5\u4f1a\u88ab\u622a\u65ad\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[6]/div[1]/table[0]/tbody[2]/tr[5]/td[1]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).", "/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_gssapi 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 GSSAPI authentication and encryption used on this connection. See pg_stat_gssapi 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": "f834d4f0537d799059a729b0589414109dec9243b141f848c0a4935154c6084a"}, "comparison_data": {"view": "pg_stat_gssapi", "field": "principal", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "631fd18f64143ae2b551184e7a053dcc6c32836aef8071d2a173fd4629046309", "units_mentioned": []}, "13": {"view": "pg_stat_gssapi", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_gssapi"}, {"label": "\u5b57\u6bb5", "value": "principal"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"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": "principal", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_gssapi/?v=13", "label": "pg_stat_gssapi \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-GSSAPI-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 13 English manual", "sha256": "a8ec0d199d592259f260a41ccb2821e582cd6dae1014a784e1e86203740afcb0", "language": "en", "original_url": "/docs/13/monitoring-stats.html#PG-STAT-GSSAPI-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_gssapi \u89c6\u56fe\u4e3a\u6bcf\u4e2a\u540e\u7aef\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u8be5\u8fde\u63a5\u7684 GSSAPI \u4f7f\u7528\u4fe1\u606f\u3002\u53ef\u901a\u8fc7 pid \u5217\u4e0e pg_stat_activity \u6216 pg_stat_replication \u8fde\u63a5\uff0c\u4ee5\u83b7\u53d6\u8fde\u63a5\u7684\u66f4\u591a\u8be6\u60c5\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 principal FROM pg_catalog.pg_stat_gssapi;", "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": "text", "signature": "SELECT principal FROM pg_catalog.pg_stat_gssapi;", "documented": true, "description": ["\u7528\u4e8e\u8ba4\u8bc1\u6b64\u8fde\u63a5\u7684\u4e3b\u4f53\uff1b\u672a\u4f7f\u7528 GSSAPI \u8ba4\u8bc1\u65f6\u4e3a NULL\u3002\u5982\u679c\u4e3b\u4f53\u7684\u957f\u5ea6\u8d85\u8fc7 NAMEDATALEN\uff08\u6807\u51c6\u6784\u5efa\u4e2d\u4e3a 64 \u4e2a\u5b57\u7b26\uff09\uff0c\u6b64\u5b57\u6bb5\u4f1a\u88ab\u622a\u65ad\u3002"], "manual_html": "", "manual_path": "/docs/13/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [], "language": "zh", "original_text": {"/versions/13/description/0": "Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).", "/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_gssapi 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_gssapi view will contain one row per backend, showing information about GSSAPI 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": "79a36db48edbee95461db84be233dbbc593985a992ed68692d0fb95cc9671ff0"}, "comparison_data": {"view": "pg_stat_gssapi", "field": "principal", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "631fd18f64143ae2b551184e7a053dcc6c32836aef8071d2a173fd4629046309", "units_mentioned": []}, "14": {"view": "pg_stat_gssapi", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_gssapi"}, {"label": "\u5b57\u6bb5", "value": "principal"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"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": "principal", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_gssapi/?v=14", "label": "pg_stat_gssapi \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-GSSAPI-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 14 English manual", "sha256": "1852c6205d68e465d08dd8f75e3b6bfdd4a475ee8d79886e2dcff6bff8e2d243", "language": "en", "original_url": "/docs/14/monitoring-stats.html#PG-STAT-GSSAPI-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_gssapi \u89c6\u56fe\u4e3a\u6bcf\u4e2a\u540e\u7aef\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u8be5\u8fde\u63a5\u7684 GSSAPI \u4f7f\u7528\u4fe1\u606f\u3002\u53ef\u901a\u8fc7 pid \u5217\u4e0e pg_stat_activity \u6216 pg_stat_replication \u8fde\u63a5\uff0c\u4ee5\u83b7\u53d6\u8fde\u63a5\u7684\u66f4\u591a\u8be6\u60c5\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 principal FROM pg_catalog.pg_stat_gssapi;", "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": "text", "signature": "SELECT principal FROM pg_catalog.pg_stat_gssapi;", "documented": true, "description": ["\u7528\u4e8e\u8ba4\u8bc1\u6b64\u8fde\u63a5\u7684\u4e3b\u4f53\uff1b\u672a\u4f7f\u7528 GSSAPI \u8ba4\u8bc1\u65f6\u4e3a NULL\u3002\u5982\u679c\u4e3b\u4f53\u7684\u957f\u5ea6\u8d85\u8fc7 NAMEDATALEN\uff08\u6807\u51c6\u6784\u5efa\u4e2d\u4e3a 64 \u4e2a\u5b57\u7b26\uff09\uff0c\u6b64\u5b57\u6bb5\u4f1a\u88ab\u622a\u65ad\u3002"], "manual_html": "", "manual_path": "/docs/14/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [], "language": "zh", "original_text": {"/versions/14/description/0": "Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).", "/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_gssapi 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_gssapi view will contain one row per backend, showing information about GSSAPI 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": "86c7abce19c131a99364a9fb394d0e8a64b3e3a686adc12835d08c1db7cddc26"}, "comparison_data": {"view": "pg_stat_gssapi", "field": "principal", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "631fd18f64143ae2b551184e7a053dcc6c32836aef8071d2a173fd4629046309", "units_mentioned": []}, "15": {"view": "pg_stat_gssapi", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_gssapi"}, {"label": "\u5b57\u6bb5", "value": "principal"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"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": "principal", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_gssapi/?v=15", "label": "pg_stat_gssapi \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-GSSAPI-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 15 English manual", "sha256": "034c0a2e99e6707e637bf4d6cfd819d39eddc1b4b7c1ec2a00f0b4f0fdb0a078", "language": "en", "original_url": "/docs/15/monitoring-stats.html#PG-STAT-GSSAPI-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_gssapi \u89c6\u56fe\u4e3a\u6bcf\u4e2a\u540e\u7aef\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u8be5\u8fde\u63a5\u7684 GSSAPI \u4f7f\u7528\u4fe1\u606f\u3002\u53ef\u901a\u8fc7 pid \u5217\u4e0e pg_stat_activity \u6216 pg_stat_replication \u8fde\u63a5\uff0c\u4ee5\u83b7\u53d6\u8fde\u63a5\u7684\u66f4\u591a\u8be6\u60c5\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 principal FROM pg_catalog.pg_stat_gssapi;", "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": "text", "signature": "SELECT principal FROM pg_catalog.pg_stat_gssapi;", "documented": true, "description": ["\u7528\u4e8e\u8ba4\u8bc1\u6b64\u8fde\u63a5\u7684\u4e3b\u4f53\uff1b\u672a\u4f7f\u7528 GSSAPI \u8ba4\u8bc1\u65f6\u4e3a NULL\u3002\u5982\u679c\u4e3b\u4f53\u7684\u957f\u5ea6\u8d85\u8fc7 NAMEDATALEN\uff08\u6807\u51c6\u6784\u5efa\u4e2d\u4e3a 64 \u4e2a\u5b57\u7b26\uff09\uff0c\u6b64\u5b57\u6bb5\u4f1a\u88ab\u622a\u65ad\u3002"], "manual_html": "", "manual_path": "/docs/15/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [], "language": "zh", "original_text": {"/versions/15/description/0": "Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).", "/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_gssapi 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_gssapi view will contain one row per backend, showing information about GSSAPI 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": "e81f818c31730ae34c58178fb264ea73b7eceb8b8f2080c01fc6f0524f4eeba3"}, "comparison_data": {"view": "pg_stat_gssapi", "field": "principal", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "631fd18f64143ae2b551184e7a053dcc6c32836aef8071d2a173fd4629046309", "units_mentioned": []}, "16": {"view": "pg_stat_gssapi", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_gssapi"}, {"label": "\u5b57\u6bb5", "value": "principal"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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": "principal", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_gssapi/?v=16", "label": "pg_stat_gssapi \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-GSSAPI-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 16 English manual", "sha256": "a4c274defe8a41ff2895040cd542b5499063b844669ff3336de1a1317c3fe086", "language": "en", "original_url": "/docs/16/monitoring-stats.html#PG-STAT-GSSAPI-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_gssapi \u89c6\u56fe\u4e3a\u6bcf\u4e2a\u540e\u7aef\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u8be5\u8fde\u63a5\u7684 GSSAPI \u4f7f\u7528\u4fe1\u606f\u3002\u53ef\u901a\u8fc7 pid \u5217\u4e0e pg_stat_activity \u6216 pg_stat_replication \u8fde\u63a5\uff0c\u4ee5\u83b7\u53d6\u8fde\u63a5\u7684\u66f4\u591a\u8be6\u60c5\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 principal FROM pg_catalog.pg_stat_gssapi;", "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": "text", "signature": "SELECT principal FROM pg_catalog.pg_stat_gssapi;", "documented": true, "description": ["\u7528\u4e8e\u8ba4\u8bc1\u6b64\u8fde\u63a5\u7684\u4e3b\u4f53\uff1b\u672a\u4f7f\u7528 GSSAPI \u8ba4\u8bc1\u65f6\u4e3a NULL\u3002\u5982\u679c\u4e3b\u4f53\u7684\u957f\u5ea6\u8d85\u8fc7 NAMEDATALEN\uff08\u6807\u51c6\u6784\u5efa\u4e2d\u4e3a 64 \u4e2a\u5b57\u7b26\uff09\uff0c\u6b64\u5b57\u6bb5\u4f1a\u88ab\u622a\u65ad\u3002"], "manual_html": "", "manual_path": "/docs/16/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/16/protocol-overview.html", "method": "same-major semantic node", "sha256": "44bc52e9e7ea6a128300584836e839d6a6b6b161cadff330571034de65b26ac1", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).", "/versions/16/facts/0/label": "View", "/versions/16/facts/1/label": "Field", "/versions/16/facts/2/label": "SQL type", "/versions/16/facts/2/value": "text", "/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_gssapi 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_gssapi view will contain one row per backend, showing information about GSSAPI 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": "e121745417ff3cfefd7da197d5142e2e932464ad7f8b65ecc89bdf27de3f10d0"}, "comparison_data": {"view": "pg_stat_gssapi", "field": "principal", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "631fd18f64143ae2b551184e7a053dcc6c32836aef8071d2a173fd4629046309", "units_mentioned": []}, "17": {"view": "pg_stat_gssapi", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_gssapi"}, {"label": "\u5b57\u6bb5", "value": "principal"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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": "principal", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_gssapi/?v=17", "label": "pg_stat_gssapi \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-GSSAPI-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 17 English manual", "sha256": "007af6e8ab39b925963273ec3ba7f06f8ee6fbfaad821f07a1dc78383dbb9b99", "language": "en", "original_url": "/docs/17/monitoring-stats.html#PG-STAT-GSSAPI-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_gssapi \u89c6\u56fe\u4e3a\u6bcf\u4e2a\u540e\u7aef\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u8be5\u8fde\u63a5\u7684 GSSAPI \u4f7f\u7528\u4fe1\u606f\u3002\u53ef\u901a\u8fc7 pid \u5217\u4e0e pg_stat_activity \u6216 pg_stat_replication \u8fde\u63a5\uff0c\u4ee5\u83b7\u53d6\u8fde\u63a5\u7684\u66f4\u591a\u8be6\u60c5\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 principal FROM pg_catalog.pg_stat_gssapi;", "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": "text", "signature": "SELECT principal FROM pg_catalog.pg_stat_gssapi;", "documented": true, "description": ["\u7528\u4e8e\u8ba4\u8bc1\u6b64\u8fde\u63a5\u7684\u4e3b\u4f53\uff1b\u672a\u4f7f\u7528 GSSAPI \u8ba4\u8bc1\u65f6\u4e3a NULL\u3002\u5982\u679c\u4e3b\u4f53\u7684\u957f\u5ea6\u8d85\u8fc7 NAMEDATALEN\uff08\u6807\u51c6\u6784\u5efa\u4e2d\u4e3a 64 \u4e2a\u5b57\u7b26\uff09\uff0c\u6b64\u5b57\u6bb5\u4f1a\u88ab\u622a\u65ad\u3002"], "manual_html": "", "manual_path": "/docs/17/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/17/protocol-overview.html", "method": "same-major semantic node", "sha256": "de94711d992bef74aad52fe8a723d81aa9b37a606d96b711bf9faa999a7bb3f5", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).", "/versions/17/facts/0/label": "View", "/versions/17/facts/1/label": "Field", "/versions/17/facts/2/label": "SQL type", "/versions/17/facts/2/value": "text", "/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_gssapi 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_gssapi view will contain one row per backend, showing information about GSSAPI 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": "d6937c623b73880b1435b3ece3324b80414eba2e9cc98245d8d6c2c391d31d63"}, "comparison_data": {"view": "pg_stat_gssapi", "field": "principal", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "631fd18f64143ae2b551184e7a053dcc6c32836aef8071d2a173fd4629046309", "units_mentioned": []}, "18": {"view": "pg_stat_gssapi", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_gssapi"}, {"label": "\u5b57\u6bb5", "value": "principal"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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": "principal", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_gssapi/?v=18", "label": "pg_stat_gssapi \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-GSSAPI-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 18 English manual", "sha256": "aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722", "language": "en", "original_url": "/docs/18/monitoring-stats.html#PG-STAT-GSSAPI-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_gssapi \u89c6\u56fe\u4e3a\u6bcf\u4e2a\u540e\u7aef\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u8be5\u8fde\u63a5\u7684 GSSAPI \u4f7f\u7528\u4fe1\u606f\u3002\u53ef\u901a\u8fc7 pid \u5217\u4e0e pg_stat_activity \u6216 pg_stat_replication \u8fde\u63a5\uff0c\u4ee5\u83b7\u53d6\u8fde\u63a5\u7684\u66f4\u591a\u8be6\u60c5\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 principal FROM pg_catalog.pg_stat_gssapi;", "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": "text", "signature": "SELECT principal FROM pg_catalog.pg_stat_gssapi;", "documented": true, "description": ["\u7528\u4e8e\u8ba4\u8bc1\u6b64\u8fde\u63a5\u7684\u4e3b\u4f53\uff1b\u672a\u4f7f\u7528 GSSAPI \u8ba4\u8bc1\u65f6\u4e3a NULL\u3002\u5982\u679c\u4e3b\u4f53\u7684\u957f\u5ea6\u8d85\u8fc7 NAMEDATALEN\uff08\u6807\u51c6\u6784\u5efa\u4e2d\u4e3a 64 \u4e2a\u5b57\u7b26\uff09\uff0c\u6b64\u5b57\u6bb5\u4f1a\u88ab\u622a\u65ad\u3002"], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/18/protocol-overview.html", "method": "same-major semantic node", "sha256": "3f1aa8bd4dbef58e9a82e8cf4c82829a4df7416cfa83dd61c18e9e25060f22da", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).", "/versions/18/facts/0/label": "View", "/versions/18/facts/1/label": "Field", "/versions/18/facts/2/label": "SQL type", "/versions/18/facts/2/value": "text", "/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_gssapi 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_gssapi view will contain one row per backend, showing information about GSSAPI 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": "4a5e8f368e3b0aac6235d307e7ca83e34e8bf6da00db2df8075b703ca448648c"}, "comparison_data": {"view": "pg_stat_gssapi", "field": "principal", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "631fd18f64143ae2b551184e7a053dcc6c32836aef8071d2a173fd4629046309", "units_mentioned": []}, "19": {"view": "pg_stat_gssapi", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_gssapi"}, {"label": "\u5b57\u6bb5", "value": "principal"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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": "principal", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_gssapi/?v=19", "label": "pg_stat_gssapi \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-GSSAPI-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 19 English manual", "sha256": "26e1b6632bdf05ebe081987cb60ab4ded526eec7db73e41316fbd69466c494fe", "language": "en", "original_url": "/docs/19/monitoring-stats.html#PG-STAT-GSSAPI-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_gssapi \u89c6\u56fe\u4e3a\u6bcf\u4e2a\u540e\u7aef\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u8be5\u8fde\u63a5\u7684 GSSAPI \u4f7f\u7528\u4fe1\u606f\u3002\u53ef\u901a\u8fc7 pid \u5217\u4e0e pg_stat_activity \u6216 pg_stat_replication \u8fde\u63a5\uff0c\u4ee5\u83b7\u53d6\u8fde\u63a5\u7684\u66f4\u591a\u8be6\u60c5\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 principal FROM pg_catalog.pg_stat_gssapi;", "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": "text", "signature": "SELECT principal FROM pg_catalog.pg_stat_gssapi;", "documented": true, "description": ["\u7528\u4e8e\u8ba4\u8bc1\u6b64\u8fde\u63a5\u7684\u4e3b\u4f53\uff1b\u672a\u4f7f\u7528 GSSAPI \u8ba4\u8bc1\u65f6\u4e3a NULL\u3002\u5982\u679c\u4e3b\u4f53\u7684\u957f\u5ea6\u8d85\u8fc7 NAMEDATALEN\uff08\u6807\u51c6\u6784\u5efa\u4e2d\u4e3a 64 \u4e2a\u5b57\u7b26\uff09\uff0c\u6b64\u5b57\u6bb5\u4f1a\u88ab\u622a\u65ad\u3002"], "manual_html": "", "manual_path": "/docs/19/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/19/protocol-overview.html", "method": "same-major semantic node", "sha256": "4650a5af6514ccd289c59f90ba62490b00e797ee04c02359ef9e2174c1f276ed", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).", "/versions/19/facts/0/label": "View", "/versions/19/facts/1/label": "Field", "/versions/19/facts/2/label": "SQL type", "/versions/19/facts/2/value": "text", "/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_gssapi 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_gssapi view will contain one row per backend, showing information about GSSAPI 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": "a7354e1fe3c90f51e133d2cfd235c0b1f8a0d9673e1f686c16702c7749ee0619"}, "comparison_data": {"view": "pg_stat_gssapi", "field": "principal", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "631fd18f64143ae2b551184e7a053dcc6c32836aef8071d2a173fd4629046309", "units_mentioned": []}, "20": {"view": "pg_stat_gssapi", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_gssapi"}, {"label": "\u5b57\u6bb5", "value": "principal"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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": "principal", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_gssapi/?v=20", "label": "pg_stat_gssapi \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-GSSAPI-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 20 English manual", "sha256": "dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251", "language": "en", "original_url": "/docs/devel/monitoring-stats.html#PG-STAT-GSSAPI-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_gssapi \u89c6\u56fe\u4e3a\u6bcf\u4e2a\u540e\u7aef\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u8be5\u8fde\u63a5\u7684 GSSAPI \u4f7f\u7528\u4fe1\u606f\u3002\u53ef\u901a\u8fc7 pid \u5217\u4e0e pg_stat_activity \u6216 pg_stat_replication \u8fde\u63a5\uff0c\u4ee5\u83b7\u53d6\u8fde\u63a5\u7684\u66f4\u591a\u8be6\u60c5\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 principal FROM pg_catalog.pg_stat_gssapi;", "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": "text", "signature": "SELECT principal FROM pg_catalog.pg_stat_gssapi;", "documented": true, "description": ["\u7528\u4e8e\u8ba4\u8bc1\u6b64\u8fde\u63a5\u7684\u4e3b\u4f53\uff1b\u672a\u4f7f\u7528 GSSAPI \u8ba4\u8bc1\u65f6\u4e3a NULL\u3002\u5982\u679c\u4e3b\u4f53\u7684\u957f\u5ea6\u8d85\u8fc7 NAMEDATALEN\uff08\u6807\u51c6\u6784\u5efa\u4e2d\u4e3a 64 \u4e2a\u5b57\u7b26\uff09\uff0c\u6b64\u5b57\u6bb5\u4f1a\u88ab\u622a\u65ad\u3002"], "manual_html": "", "manual_path": "/docs/devel/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/devel/protocol-overview.html", "method": "same-major semantic node", "sha256": "fe7aff6a941aef6be4870c7704bca095984a81fd5019f420b67c9917f3831028", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/summary": "Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).", "/versions/20/description/0": "Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).", "/versions/20/facts/0/label": "View", "/versions/20/facts/1/label": "Field", "/versions/20/facts/2/label": "SQL type", "/versions/20/facts/2/value": "text", "/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_gssapi 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_gssapi view will contain one row per backend, showing information about GSSAPI 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": "7dc059829826bc3d1f8b3df48c11e6654c18624231a4f685803b7612946a8489"}, "comparison_data": {"view": "pg_stat_gssapi", "field": "principal", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "631fd18f64143ae2b551184e7a053dcc6c32836aef8071d2a173fd4629046309", "units_mentioned": []}}}, "snapshot": {"view": "pg_stat_gssapi", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_gssapi"}, {"label": "\u5b57\u6bb5", "value": "principal"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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": "principal", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_gssapi/?v=18", "label": "pg_stat_gssapi \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-GSSAPI-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 18 English manual", "sha256": "aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722", "language": "en", "original_url": "/docs/18/monitoring-stats.html#PG-STAT-GSSAPI-VIEW"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_gssapi \u89c6\u56fe\u4e3a\u6bcf\u4e2a\u540e\u7aef\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u8be5\u8fde\u63a5\u7684 GSSAPI \u4f7f\u7528\u4fe1\u606f\u3002\u53ef\u901a\u8fc7 pid \u5217\u4e0e pg_stat_activity \u6216 pg_stat_replication \u8fde\u63a5\uff0c\u4ee5\u83b7\u53d6\u8fde\u63a5\u7684\u66f4\u591a\u8be6\u60c5\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 principal FROM pg_catalog.pg_stat_gssapi;", "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": "text", "signature": "SELECT principal FROM pg_catalog.pg_stat_gssapi;", "documented": true, "description": ["\u7528\u4e8e\u8ba4\u8bc1\u6b64\u8fde\u63a5\u7684\u4e3b\u4f53\uff1b\u672a\u4f7f\u7528 GSSAPI \u8ba4\u8bc1\u65f6\u4e3a NULL\u3002\u5982\u679c\u4e3b\u4f53\u7684\u957f\u5ea6\u8d85\u8fc7 NAMEDATALEN\uff08\u6807\u51c6\u6784\u5efa\u4e2d\u4e3a 64 \u4e2a\u5b57\u7b26\uff09\uff0c\u6b64\u5b57\u6bb5\u4f1a\u88ab\u622a\u65ad\u3002"], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/18/protocol-overview.html", "method": "same-major semantic node", "sha256": "3f1aa8bd4dbef58e9a82e8cf4c82829a4df7416cfa83dd61c18e9e25060f22da", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).", "/versions/18/facts/0/label": "View", "/versions/18/facts/1/label": "Field", "/versions/18/facts/2/label": "SQL type", "/versions/18/facts/2/value": "text", "/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_gssapi 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_gssapi view will contain one row per backend, showing information about GSSAPI 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": "4a5e8f368e3b0aac6235d307e7ca83e34e8bf6da00db2df8075b703ca448648c"}, "comparison_data": {"view": "pg_stat_gssapi", "field": "principal", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "631fd18f64143ae2b551184e7a053dcc6c32836aef8071d2a173fd4629046309", "units_mentioned": []}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}