STATISTICS VIEW · Statistics view

pg_stat_gssapi

PostgreSQL documentation ↗Source definition ↗

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.

First seen PG 12Last seen PG 19Columns 5

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

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

Columns PostgreSQL 18

pg_stat_gssapi

COLUMN	TYPE	DESCRIPTION
`pid`	`integer`	Process ID of a backend
`gss_authenticated`	`boolean`	True if GSSAPI authentication was used for this connection
`principal`	`text`	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).
`encrypted`	`boolean`	True if GSSAPI encryption is in use on this connection
`credentials_delegated`	`boolean`	True if GSSAPI credentials were delegated on this connection.

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

Column evolution matrix

Hover a cell for the column type

PresentAdded / type or attribute changeRemoved

COLUMN	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15
`pid`	–	–	–	–	–	–	–	–	–
`gss_authenticated`	–	–	–	–	–	–	–	–	–
`principal`	–	–	–	–	–	–	–	–	–
`encrypted`	–	–	–	–	–	–	–	–	–
`credentials_delegated`	–	–	–	–	–	–	–	–	–	–	–	–	–

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

Evolution timeline

Changes between adjacent majors

PostgreSQL 16 ← 15

+ credentials_delegated

PostgreSQL 13 ← 12

Catalog description updated

PostgreSQL 12 ← 11Catalog added

+ pid+ gss_authenticated+ principal+ encrypted

Compare any two versions

FROMTOInclude description updates

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