E.6. MON$MEMORY_USAGE

MON$MEMORY_USAGE displays memory usage statistics.

Column NameData TypeDescription

MON$STAT_ID

INTEGER

Statistics identifier

MON$STAT_GROUP

SMALLINT

Statistics group:

0 - database 1 - connection 2 - transaction 3 - operator 4 - call

MON$MEMORY_USED

BIGINT

The amount of memory in use, in bytes. This data is about the high-level memory allocation performed by the server. It can be useful to track down memory leaks and excessive memory usage in connections, procedures, etc.

MON$MEMORY_ALLOCATED

BIGINT

The amount of memory allocated by the operating system, in bytes. This data is about the low-level memory allocation performed by the Firebird memory manager — the amount of memory allocated by the operating system — which can allow you to control the physical memory usage.

MON$MAX_MEMORY_USED

BIGINT

The maximum number of bytes used by this object

MON$MAX_MEMORY_ALLOCATED

BIGINT

The maximum number of bytes allocated for this object by the operating system

ⓘ
Note

Not all records in this table have non-zero values. MON$DATABASE and objects related to memory allocation have non-zero values. Minor memory allocations are not accrued here but are added to the database memory pool instead.