SYSTEM CATALOGS / SYSTEM VIEWS
pg_backend_memory_contexts
Read PG 18 manual ↗The view pg_backend_memory_contexts displays all the memory contexts of the server process attached to the current session.
- Kind
- System views
- Columns in this snapshot
- 10
- Definition source
- English manual
Columns 10
| Column | Type | Description / reference |
|---|---|---|
name | text | Name of the memory context |
ident | text | Identification information of the memory context. This field is truncated at 1024 bytes |
type | text | Type of the memory context |
level | int4 | The 1-based level of the context in the memory context hierarchy. The level of a context also shows the position of that context in the path column. |
path | int4[] | Array of transient numerical identifiers to describe the memory context hierarchy. The first element is for TopMemoryContext, subsequent elements contain intermediate parents and the final element contains the identifier for the current context. |
total_bytes | int8 | Total bytes allocated for this memory context |
total_nblocks | int8 | Total number of blocks allocated for this memory context |
free_bytes | int8 | Free space in bytes |
free_chunks | int8 | Total number of free chunks |
used_bytes | int8 | Used space in bytes |
Column history across versions
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
name | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
ident | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
parent | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | · | · | · |
level | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
total_bytes | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
total_nblocks | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
free_bytes | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
free_chunks | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
used_bytes | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
type | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
path | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
Version history 2
- PG 17 → 18changed
- PG 13 → 14added
Definition snapshot: english-manuals:4d2a7c4ecfc7543ba2ac5fca931… · English manual source