---
title: Operations
description: The Operations tab breaks a database down into its operations - each a class of query - with time-consuming, query-time, throughput, and failure charts, and a per-operation table you can drill into for query spans.
url: https://coralogix.com/docs/user-guides/apm-v2/features/operations/
product: apm
feature: APM Overview
feature_id: apm-general
feature_identifier: apm/apm-general
last_updated: '2026-10-11'
---

# 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

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

The table below the charts lists each operation with:

* **Operation**: the database operation or command that ran.
* **Table**: the table or collection the operation targeted.
* **Calling services**: how many services issued the operation.
* **Avg** and **P50**-**P99**: query response time, on average and by percentile.
* **Total queries** and **Queries/s**: query volume and throughput.
* **Total failures**, **Failure rate**, **Failures/s**, and **Failures/min**: failed-query counts and rates.
* **Total time spent**: the operation's share of total query time over the selected range.

Use **Search operations** to find one by name, **Manage columns** to choose which columns show, and **Export** to download the table.

## Operation drilldown

Select an operation - by selecting its row, or with **Enter** or **Space** - to open a drawer scoped to that one operation.

[![The database operation drawer for a single operation, showing the Avg time, P95, Total queries, Total failures, and Failure rate metrics, the Query time, Queries/s, and Failures/s charts, and the spans table.](/docs/assets/images/operation-drilldown-9e26b46c9f4ffedc7c9851d299300eb5.webp)](https://coralogix.com/docs/assets/images/operation-drilldown-9e26b46c9f4ffedc7c9851d299300eb5.webp)

The drawer's header carries the operation and table names with their own time picker, and a toolbar with **Copy operation name**, **Copy link**, expand, **Previous operation** / **Next operation**, and close. **Copy link** produces a deep link that reopens the drawer.

The drawer then reports five metrics for the operation - **Avg time**, **P95**, **Total queries**, **Total failures**, and **Failure rate** - alongside three charts:

* **Query time**: response time at a percentile you select.
* **Queries/s**: query throughput for the operation.
* **Failures/s**: failed queries per second.

At the bottom, a spans table lists the most recent spans recorded for the operation, so you can inspect an individual query and open the trace it belongs to.

## Next steps

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