Copy as Markdown[Open in ChatGPT](https://chatgpt.com/?q=Read%20https%3A%2F%2Fcoralogix.com%2Fdocs%2Fuser-guides%2Fapm-v2%2Ffeatures%2Foperations.md%20and%20help%20me%20with%20my%20question%20about%20this%20Coralogix%20documentation%20page.)[Open in Claude](https://claude.ai/new?q=Read%20https%3A%2F%2Fcoralogix.com%2Fdocs%2Fuser-guides%2Fapm-v2%2Ffeatures%2Foperations.md%20and%20help%20me%20with%20my%20question%20about%20this%20Coralogix%20documentation%20page.)

# Operations

The **Operations** tab breaks a database down into its operations - each a class of query, such as a `SELECT` against a given table - so you can find the slowest or busiest and drill into its query spans. It is the database analog of a service's [Transactions](https://coralogix.com/docs/user-guides/apm-v2/features/transactions.md) tab.

Use the **Top N** selector (**Top 5**, **Top 20** by default, or **Top 100**) to set how many operations to return; they are ranked by total time spent. The selection applies to both the charts and the table.

[![The Operations tab for a database: the Time consuming, Query time, Queries/s, and Failures/s charts above the per-operation table.](/docs/assets/images/database-operations-e63742d482d99e2d18bdb365e9aa2c42.webp)](https://coralogix.com/docs/assets/images/database-operations-e63742d482d99e2d18bdb365e9aa2c42.webp)

## Charts[​](#charts "Direct link to Charts")

Four charts summarize the selected operations:

* **Time consuming**: cumulative time spent per operation. The tallest bands are the operations the database spends the most time on.
* **Query time**: query duration per operation at a selected percentile (Avg, P50, P75, P90, P95, or P99).
* **Queries/s**: query throughput per operation.
* **Failures/s**: failed queries per second, per operation.

## Operations table[​](#operations-table "Direct link to Operations table")

The table below the charts lists each operation with:

* **Operation**: the database statement or command the row aggregates.
* **Table**: the table or collection the operation reads or writes.
* **Calling services**: how many services issued the operation.
* **Avg** and **P50**-**P99**: query duration, on average and by percentile.
* **Total requests** and **Queries/s**: query volume and throughput.
* **Total errors**, **Errors%**, **Failures/s**, and **Errors/min**: failed-query counts and rates.
* **Time consuming**: the operation's cumulative time and its share of the operations shown.

Use **Search operations** to find one by name, **Manage columns** to choose which columns show, and **Export** to download the table. Select an operation to open its drilldown, where you can inspect the individual query spans and open the traces they belong to.

## Next steps[​](#next-steps "Direct link to Next steps")

Triage a database's failing queries in [Errors](https://coralogix.com/docs/user-guides/apm-v2/features/errors.md).