System Catalogs / Statistics views
pg_stat_kind_info
Read the PG 20 devel manualThe pg_stat_kind_info view contains one row for each registered statistics kind, including both built-in and custom kinds.
Reading PG 20devel·documented in 1 of 24 versions, 20 to 20
Development snapshot. These definitions may change before release.
- Kind
- Statistics views
- Columns in this snapshot
- 7
- Definition source
- English manual
Columns 7
As listed in the PostgreSQL 20 devel manual.
| Column | Type | Description / reference |
|---|---|---|
id | integer | Numeric identifier of the statistics kind. |
name | text | Name of the statistics kind. |
builtin | boolean | True if this is a built-in statistics kind, false if it was registered by an extension. |
fixed_amount | boolean | True if this kind tracks a fixed amount of data (a single, statically allocated entry), false if it tracks a variable number of entries keyed by object identifier. |
accessed_across_databases | boolean | True if entries of this kind are accessed across databases (cluster-wide statistics), false if they are scoped to a single database. |
write_to_file | boolean | True if entries of this kind are persisted to the statistics file at shutdown and reloaded on startup, false if they are kept only in shared memory. |
entry_count | bigint | Number of tracked entries for this kind. For variable-numbered kinds, this is the number of objects currently tracked. NULL for fixed-sized statistics kinds, or if the kind does not track entry counts. |
Column history across versions
Version history 1
- 19 → 20 added
Definition snapshot: english-manuals:4322434d4b8b8fb4e425997c64f… · English manual source