---
title: "Include Query Timings"
url: "https://docs.ravendb.net/6.2/client-api/session/querying/debugging/query-timings"
version: "6.2"
language: "csharp"
---

# Include Query Timings

> Client language: C#. Also available for [Java](https://docs.ravendb.net/6.2/client-api/session/querying/debugging/query-timings.java.md), [Python](https://docs.ravendb.net/6.2/client-api/session/querying/debugging/query-timings.python.md), [PHP](https://docs.ravendb.net/6.2/client-api/session/querying/debugging/query-timings.php.md), [Node.js](https://docs.ravendb.net/6.2/client-api/session/querying/debugging/query-timings.nodejs.md).
>
> RavenDB publishes an official agent skill for coding assistants at https://docs.ravendb.net/skills/ravendb/SKILL.md (also installable with `npx skills add ravendb/skills`). The skill describes itself as: "Read this before writing any RavenDB query, client call or /databases/ request. Covers server setup, document modelling, the Node.js, .NET and Python clients, RQL, indexes, vector search and AI agents. Code written from recall tends to run and return the wrong rows, because RQL resembles SQL and the clients take field names as plain strings."

> **Note**
>
> - When making a query,  
>   you can request to get detailed stats of the time spent by RavenDB on each part of the query.  
>   E.g. duration of search, loading documents, transforming results, total duration, etc.
>
> - By default, the timings stats are Not included in the query results, to avoid the measuring overhead.
>
> - **To include the query timings** in the query results:  
>   add a call to `Timings()` in your query code, or add `include timings()` to an RQL query.  
>   See examples below.
>
> - In this page:
>   - [Include timings in a query](#include-timings-in-a-query)
>   - [View timings](#view-timings)
>   - [Syntax](#syntax)
>   - [Timings in a sharded database](#timings-in-a-sharded-database)

## Include timings in a query

### Query-sync

```csharp
// Define an object that will receive the query timings
QueryTimings timings = null;

var results = session.Query<Product>()
  // Use the Customize method to Call Timings, provide an out param for the timings results
  .Customize(x => x.Timings(out timings))
  // Define query criteria
  // i.e. search for docs containing Syrup -or- Lager in their Name field
  .Search(x => x.Name, "Syrup Lager")
  // Execute the query
  .ToList();

// Get total query duration:
// =========================
var totalQueryDuration = timings.DurationInMs;

// Get specific parts duration: 
// ============================
IDictionary<string, QueryTimings> timingsDictionary = timings.Timings;
var optimizerDuration = timingsDictionary["Optimizer"].DurationInMs;
var luceneDuration = timingsDictionary["Query"].Timings["Lucene"].DurationInMs;
```

### Query-async

```csharp
// Define an object that will receive the query timings
QueryTimings timings = null;

var results = await asyncSession.Query<Product>()
  // Use the Customize method to Call Timings, provide an out param for the timings results
  .Customize(x => x.Timings(out timings))
  // Define the search criteria
  // Search for docs containing Syrup -or- Lager in their Name field
  .Search(x => x.Name, "Syrup Lager")
  // Execute the query
  .ToListAsync();

// Get total query duration:
// =========================
var totalQueryDuration = timings.DurationInMs;

// Get specific parts duration: 
// ============================
IDictionary<string, QueryTimings> timingsDictionary = timings.Timings;
var optimizerDuration = timingsDictionary["Optimizer"].DurationInMs;
var luceneDuration = timingsDictionary["Query"].Timings["Lucene"].DurationInMs;
```

### DocumentQuery-sync

```csharp
var results = session.Advanced.DocumentQuery<Product>()
  // Call Timings, provide an out param for the timings results
  .Timings(out QueryTimings timings)
  // Define query criteria
  // i.e. search for docs containing Syrup -or- Lager in their Name field
  .Search(x => x.Name, "Syrup Lager")
  // Execute the query
  .ToList();

// Get total query duration:
// =========================
var totalQueryDuration = timings.DurationInMs;

// Get specific parts duration:
// ============================
IDictionary<string, QueryTimings> timingsDictionary = timings.Timings;
var optimizerDuration = timingsDictionary["Optimizer"].DurationInMs;
var luceneDuration = timingsDictionary["Query"].Timings["Lucene"].DurationInMs;
```

### DocumentQuery-async

```csharp
var results = await asyncSession.Advanced.AsyncDocumentQuery<Product>()
  // Call Timings, provide an out param for the timings results
  .Timings(out QueryTimings timings)
   // Define the search criteria
   // Search for docs containing Syrup -or- Lager in their Name field
  .Search(x => x.Name, "Syrup Lager")
   // Execute the query
  .ToListAsync();

// Get total query duration:
// =========================
var totalQueryDuration = timings.DurationInMs;

// Get specific parts duration: 
// ============================
IDictionary<string, QueryTimings> timingsDictionary = timings.Timings;
var optimizerDuration = timingsDictionary["Optimizer"].DurationInMs;
var luceneDuration = timingsDictionary["Query"].Timings["Lucene"].DurationInMs;
```

### RQL

```sql
from "Products"
where search(Name, "Syrup") or search(Name, "Lager")
include timings()
```

## View timings

- The detailed timings can be viewed from the [Query view](https://docs.ravendb.net/6.2/studio/database/queries/query-view.md) in the Studio.

- Running an RQL query with `include timings()` will show an additional **Timings Tab**  
  with a graphical representation of the time spent in each query part.

![Figure 1. Include timings graphical results](https://docs.ravendb.net/assets/images/include-timings-15db05cff6a6735293893839af694192.png)

## Syntax

```csharp
IDocumentQueryCustomization Timings(out QueryTimings timings);
```

| Parameter | Type | Description |
| - | - | - |
| **timings** | `QueryTimings` | An *out* param that will be filled with the timings results |

| `QueryTimings` | | |
| - | - | - |
| **DurationInMs** | `long` | Total duration |
| **Timings** | `IDictionary<string, QueryTimings>` | Dictionary with `QueryTimings` info per time part |

## Timings in a sharded database

- In a sharded database, timings for each part are provided **per shard**.

- Learn more in [timings in a sharded database](https://docs.ravendb.net/6.2/sharding/querying.md#timing-queries).
