Check peak memory usage of a query

#1

Is there a way to check the peak memory usage of a query?

#2

Hi Jim,

Yes, you can check peak memory usage using Query-level monitoring feature that was introduced in TigerGraph 3.1 version. The memory utilization information is stored in the logs. I can provide details if you are interested.

Thanks
Rayees

#3

@Rayees_Pasha,

Thanks for your quick reply! Yes, I am very much interested. I am benchmarking a dataset and constantly running into memory issues. Having a way to monitor the memory usage will be super helpful.

#4

Hi Jim,

Query level stats are stored in RESTPP logs. You can query the logs to check the size of the memory by query id.

Here’s the sample output:

Query Level Stats (RESTPP logs)

I0330 08:49:36.576620 625 requestrecord.cpp:258] ReturnResult|REST- 12000 | 16192ms |GPE_3_1|196613.RESTPP_1_1.1585558160384.N|/query/tpc_graph/get_items_d|graph_id=1&query=get_items_d&src=3573&src.type=lineitem&steps=2|213
I0330 08:39:02.578809 6385 requestrecord.cpp:258] ReturnResult|0| 13464ms |GPE_3_1|16974453.RESTPP_1_1.1585557529114.N|/query/tpc_graph/get_items_d|graph_id=1&query=get_items_d&src=3573&src.type=lineitem&steps=4|24067

Thanks
Rayeesstrong text

2 Likes
#5

Great. I will check the RESTPP logs. Thanks!