SYSTEM CATALOGS / STATISTICS VIEWS
pg_stat_kind_info
Read PG 20 devel manual ↗The pg_stat_kind_info view contains one row for each registered statistics kind, including both built-in and custom kinds.
Development snapshot. These definitions may change before release.
- Kind
- Statistics views
- Columns in this snapshot
- 7
- Definition source
- English manual
Columns 7
| 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
- PG 19 → 20added
Definition snapshot: english-manuals:fbb5830463a487a246c4edf438b… · English manual source