postgrespro / memstat Goto Github PK

Module adds statistic report about memory contexts in local and all backends.

Functions:

setof (name text, level integer, nblocks bigint, freechunks bigint, totalspace bigint, freespace bigint) local_memory_stats()

prints memory context's statistic for current backend

setof (pid integer, name text, level integer, nblocks bigint, freechunks bigint, totalspace bigint, freespace bigint) instance_memory_stats()

prints memory context's statistic for all alive backend, works if library was preloaded via shared_preload_libraries.

view memory_stats

prints per backend summary memory statistics

To use instance_memory_stats() it's needed to add memstat library to shared_preload_libraries. And it should be last in that list!

GUC variable:

memstat.period = 10 # seconds

Module collects memory statistics at a begining of each query and it could be expensive on highloaded instances, so, this variable set minimal time between statistic obtaining.

Copyright (c) 2016, Teodor Sigaev [email protected]