MEMORY_EVENTS

Records events related to Vertica memory usage.

Column Name	Data Type	Description
`NODE_NAME`	VARCHAR	Node where the event occurred
`EVENT_TIME`	TIMESTAMPTZ	Event start time
`EVENT_TYPE`	VARCHAR	Type of event, one of the following: `MEMORY_REPORT`: The Vertica memory poller created a report on memory usage, for the reason specified in `EVENT_REASON`. For details, see Memory usage reporting. `MALLOC_TRIM`: Vertica ran the glibc function `malloc_trim()` to reclaim glibc-allocated memory. For details, see Memory trimming.
`EVENT_REASON`	VARCHAR	Reason for the event—for example, trim threshold was greater than `RSS` / `available-memory`.
`EVENT_DETAILS`	VARCHAR	Additional information about the event—for example, how much memory `malloc_trim()` reclaimed.
`DURATION_US`	INTEGER	Duration of the event in microseconds (µs).

Privileges

None

Examples

=> SELECT * FROM MEMORY_EVENTS;
-[ RECORD 1 ]-+-----------------------------------------------------------------
event_time    | 2019-05-02 13:17:20.700892-04
node_name     | v_vmart_node0001
event_type    | MALLOC_TRIM
event_reason  | memory_trim()
event_details | pre-trim RSS 378822656 post-trim RSS 372129792 benefit 0.0176675
duration_us   | 7724