Getting memory usage of a query in Tigergraph DB

a) Get the request id from RESTPP log file or from Admin UI under running queries.

In the restpp log directory.

$ grep -i "requestinfo" RESTPP#1.INFO | grep -v "__INTERNAL_API__"

I0418 13:11:58.809935 1828010 handler.cpp:569] RequestInfo|,16777217.RESTPP_1_1.1713445918809.N,NNN,0,0,0,0,S|user:tigergraph|api:v2|function:queryDispatcher|graph_name:bypramod|libudf:libudf_bypramod_1

I0418 13:23:12.551373 1828012 handler.cpp:569] RequestInfo|,16842762.RESTPP_1_1.1713446592551.N,NNN,0,0,0,0,S|user:tigergraph|api:v2|function:queryDispatcher|graph_name:bypramod|libudf:libudf_bypramod_1

Here, one of the request id is "1713445918809"

b) Getting how much memory being used by each running query.

$ grun_p all "grep -ai '<request_id>' $(gadmin config get System.LogRoot)/gpe/log.INFO | grep -i "querymem""


$ grun_p all "grep -ai '1713445918809' $(gadmin config get System.LogRoot)/gpe/log.INFO | grep -i "querymem""

***