Knowing how much memory utilized by a query/request in Tigergraph DB

 1) Find the request id from restpp.

$ grun_p all 'grep -i "requestinfo" $(gadmin config get System.LogRoot)/restpp/RESTPP#*.INFO | grep -v "__INTERNAL_API__" | tail'

Example from one of the node:

/tigergraph/logs/restpp/RESTPP#4.INFO:I0513 23:01:51.869751 386354 handler.cpp:569] RequestInfo|,17766.RESTPP_4_1.1714777311869.N,NNN,0,0,0,0,S|user:tigergraph|api:v2|function:|graph_name:bypramod|libudf:

(or)

Get running query details from Graph studio UI

2) Once the query is finished take the request id from above and grep for watermark in GPE logs and sum it up for overall usage across cluster.

$ grun_p all 'grep -i "1714777311869" $(gadmin config get System.LogRoot)/gpe/log.INFO | grep -i "Finished in" | grep "mem watermark"'

***

Add on:

To get complete info about the request

In restpp logs

$ grun_p all 'grep -i "1714777296251" $(gadmin config get System.LogRoot)/restpp/RESTPP#*.INFO'