How to monitor the memory usage of particular query in neo4j and its memory usage stats?

[akshat_mittal]

Hello Team,

Need your help in knowing the below query -

How to monitor the memory usage of particular query in neo4j? Also want to know its memory usage stats?

Regards
Akshat

[stefan_armbrust]

In Enterprise edition there's query logging: https://neo4j.com/docs/operations-manual/current/monitoring/logging/query-logging/
Use the dbms.logs.query.allocation_logging_enabled=true in your config.

[akshat_mittal]

Hi Stefan ,

Thanks for your quick reply.

I have added that parameter in conf file.

Now where i can see the stats ( In which logs ?? )?

Regards
Akshat

[dana_canzano]

in which logs? Per the initial response of https://neo4j.com/docs/operations-manual/current/monitoring/logging/query-logging/ this page then includes details which states

12.2.1.1. Log configuration
The name of the log file is query.log and it resides in the logs directory (see Section 4.2, “File locations”).

Rotation of the query log can be configured in the neo4j.conf configuration file. The following parameters are available:

so the logging would be to the query.log.

Also setting dbms.logs.query.allocation_logging_enabled=true alone is not sufficient as you also need to configure dbms.logs.query.enabled