Identify Slow or Repetitive Queries

By default, details of search queries are logged in /<DATADIR>/run/searchserver-ss0/search-reporting/search.csv. You can build your own monitoring based on this file.

See Also
Display Historic and Real-Time Data
Troubleshoot Issues with Performance Monitoring
Build Your Own Monitoring

Example:

#timestamp;apiclient_ip;query_logic;query_target;query_querystring;query_language;query_start;query_hf;
    answer_nmatches;answer_nhits;time_total;query_full;query_id;query_origin;answer_status
"2018/10/07 15:10:26.443";"192.168.206.157";"sl0";"st0";"log";"xx";"0";"10";"7";"7";"549803";"q=log";"8";
"";"ok"
"2018/10/07 15:10:40.137";"192.168.206.157";"sl0";"st0";"test";"xx";"0";"10";"10";"10";"375940";
"q=test";"10";"";"ok"
"2018/10/07 15:10:55.535";"192.168.206.157";"sl0";"st0";"troubleshooting";"xx";"0";"10";"7";"7";"344747";
"q=troubleshooting";"12";"";"ok"
"2018/10/07 15:11:05.523";"192.168.206.157";"sl0";"st0";"rollback";"xx";"0";"10";"2";"2";"159574";
"q=rollback";"14";"";"ok"

From the Administration Console > Reporting, you can:

  • Change the default format of the output file

  • Add/remove fields written to file

  • Define rotation parameters

For more information, see Analyzing User Queries with Reporters in the Exalead CloudView Configuration Guide.