MOT Monitoring

All syntax for monitoring of PG-based FDW tables is supported. This includes Table or Index sizes (as described below). In addition, special functions exist for monitoring MOT memory consumption, including MOT Global Memory, MOT Local Memory and a single client session.

Table and Index Sizes
The size of tables and indexes can be monitored by querying pg_relation_size.

For example

Data Size

Index

MOT GLOBAL Memory Details
Check the size of MOT global memory, which includes primarily the data and indexes.

Result –

Where –

· -1 is the total memory.

· 0..7 are NUMA memory nodes.

MOT LOCAL Memory Details
Check the size of MOT local memory, which includes session memory.

Result –

Where –

· -1 is the total memory.
· 0..7 are NUMA memory nodes.
Session Memory
Memory for session management is taken from the MOT local memory.

Memory usage by all active sessions (connections) is possible using the following query –

Result –

Legend –

· total_size – is allocated for the session
· free_size – not in use
· used_size – In actual use
The following query enables a DBA to determine the state of local memory used by the current session –

Result –