---
title: "Configure Solr query logging"
slug: "configure-solr-query-logging"
abstract: "How to configure Solr query logging to track Solr queries in xConnect logs."
---
# Configure Solr query logging

This logging feature lets you track Solr queries in xConnect logs. It is disabled by default.

## Enable Solr query logging

To enable Solr query logging:

- Enable the file `\App_Data\Config\Sitecore\CollectionSearch\sc.Xdb.Collection.IndexReader.SOLR.Logging.xml.disabled` by renaming the file to `\App_Data\Config\Sitecore\CollectionSearch\sc.Xdb.Collection.IndexReader.SOLR.Logging.xml`.

### Solr query log output example

The Solr query log output contains log entries for each query. Log records consist of the query transcript and the sorting used. For example:

```text
2021-05-31 `20:59`:49.703 +`03:00` [Verbose] Executing SOLR query
{
  "query": "(x_type_s:(\"ContactDataRecord\") AND lastmodified_dt:[* TO \"2021\\-05\\-31T17\\:59\\:49.6847180Z\"])",
  "sort": "id asc"
}

2021-05-31 `20:59`:51.212 +`03:00` [Verbose] Executing SOLR query
{
  "query": "(x_type_s:(\"ContactDataRecord\") AND *:*)",
  "sort": "id asc"
}

2021-05-31 `21:00`:30.518 +`03:00` [Verbose] Executing SOLR query
{
  "query": "(x_type_s:(\"ContactDataRecord\") AND (facets.addresses.preferredkey_s:(\"Work\") OR (_query_:(\"\\{\\!type=parent which=x_type_s\\:\\(\\\"ContactDataRecord\\\"\\)\\}\\(path_s\\:\\(\\\"Facets.Addresses.Others\\\"\\) AND value.city_s\\:\\(\\\"Dniprobd15759b\\\\\\-e439\\\\\\-47f7\\\\\\-9d33\\\\\\-1787d9027530\\\"\\)\\)\") AND _query_:(\"\\{\\!type=parent which=x_type_s\\:\\(\\\"ContactDataRecord\\\"\\)\\}\\(path_s\\:\\(\\\"Facets.Addresses.Others\\\"\\) AND value.postalcode_s\\:\\(\\\"49000bd15759b\\\\\\-e439\\\\\\-47f7\\\\\\-9d33\\\\\\-1787d9027530\\\"\\)\\)\"))))",
  "sort": "id asc"
}

2021-05-31 `21:00`:30.612 +`03:00` [Verbose] Executing SOLR query
{
  "query": "(x_type_s:(\"ContactDataRecord\") AND (facets.addresses.preferredkey_s:(\"Work\") OR (_query_:(\"\\{\\!type=parent which=x_type_s\\:\\(\\\"ContactDataRecord\\\"\\)\\}\\(path_s\\:\\(\\\"Facets.Addresses.Others\\\"\\) AND value.city_s\\:\\(\\\"Dniprobd15759b\\\\\\-e439\\\\\\-47f7\\\\\\-9d33\\\\\\-1787d9027530\\\"\\)\\)\") AND _query_:(\"\\{\\!type=parent which=x_type_s\\:\\(\\\"ContactDataRecord\\\"\\)\\}\\(path_s\\:\\(\\\"Facets.Addresses.Others\\\"\\) AND value.postalcode_s\\:\\(\\\"49000bd15759b\\\\\\-e439\\\\\\-47f7\\\\\\-9d33\\\\\\-1787d9027530\\\"\\)\\)\"))))",
  "sort": "id asc"
}
```

## Change the log level

You can configure the log level for Solr query logging. The extended XConnect Solr query log entry level is `Trace` by default.

To change the log level:

- Open the config file `\App_Data\Config\Sitecore\CollectionSearch\sc.Xdb.Collection.IndexReader.SOLR.Logging.xml` and modify the value of the `Settings/Sitecore/XConnect/CollectionSearch/Services/Solr.SolrReaderSettings/Options/ExtendedLogLevel` node to `Trace`, `Debug`, or `Information`.

    ```xml
    <ExtendedLogLevel>Trace</ExtendedLogLevel>
    ```