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

# Include Query Timings

> Client language: PHP. Also available for [C#](https://docs.ravendb.net/6.2/client-api/session/querying/debugging/query-timings.md), [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), [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 the `timings()` method 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

```php
$timings = new QueryTimings();

/** @var array<Product> $resultsWithTimings */
$resultsWithTimings = $session->advanced()->documentQuery(Product::class)
  ->timings($timings)
  ->search("Name", "Syrup")
  ->toList();

/** @var array<QueryTimings> $timingsMap */
$timingsMap = $timings->getTimings();
```

### RQL

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

## View timings

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

- 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

```php
function timings(QueryTimings &$timings): DocumentQueryInterface;
```

| Parameter | Type | Description |
| - | - | - |
| **&$timings** | `QueryTimings` | A callback function (action) that takes `QueryTimings` as an argument. It will be called by the client with the resulting `QueryTimings`. You can interact with the resulting `QueryTimings` inside your callback. |

## 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).
