Database MonitoringQueries · Explain plans · Deadlocks · Lock waits

AI-Powered Database Monitoring

7 engines, self-hosted and managedQuery samples and explain plansRead-only agent user
Database monitoringAI overview
Database monitoring
01 / Slow queries

Your worst queries, ranked.

Sort by time or calls. Open one to see its plan and a suggested fix.

liveSort by

Normalized query signatures · sample data

02 / Deadlocks

Catch the deadlock. See who blocked whom.

SQL Server deadlocks with the victim, the survivor and every lock they fought over.

Deadlock eventDetected Oct 27, 15:56:56
Database type
sqlserver
DB host
mssql-prod-1
Victim process
process2129d330ca8
Survivor process
process2128c403088
Database
orders_db
Table
orders
SQL Server deadlock
SPID 65victim · rolled backSPID 70survivorKEY lock · ordersPK__orders__3213E83FKEY lock · inventoryPK__inventory__0A1B2C…
owner holds the lockwaiter requests itHover a process · sample data
03 / In the product

Read an explain plan in seconds.

Explain plansDatabase monitoring
Atatus database monitoring explain plan map for a SQL Server query
04 / Before you connect

Know what needs a restart.

Pick an engine. For PostgreSQL, check the settings the agent needs and see which ones restart your database.

PostgreSQL · AWS RDS parameter groupSHOW shared_preload_libraries; SHOW track_activity_query_size; …
ParameterNeedsRunning nowApply
shared_preload_librariesRequired. Without it there are no query metrics.pg_stat_statementsnot checkedstatic
track_activity_query_sizeLonger SQL is cut off and cannot be explained.4096not checkedstatic
pg_stat_statements.trackIncludes statements run inside functions.allnot checkeddynamic
pg_stat_statements.maxKeeps more normalized queries on a busy database.10000not checkeddynamic
pg_stat_statements.track_utilitySkips PREPARE and EXPLAIN noise.offnot checkeddynamic
track_io_timingOptional. Adds block read and write timings.onnot checkeddynamic

Static settings only take effect after the database restarts. Dynamic ones apply on the next parameter group refresh.

IAM database authentication is a dynamic change and needs no reboot. --apply-immediately also applies every other pending change.

Sample values from one RDS instance

05 / More screens

Database Monitoring, screen by screen.

Real screens from the Atatus app.

Database MonitoringQuery metrics
Database Monitoring: Query metrics
Customers

Powering better performance for modern teams

"Solid Product even better support." The integration path is incredibly simple/easy and the overall interface is very intuitive. That said, I had a handful of odd use cases that the support team was incredibly responsive in helping me work through.

Wes DSite Reliability Engineer
FAQ

Questions about database monitoring

Pricing, deployment, data and the agent. If something is missing, a person will answer it on a demo call.

Talk to an engineer
  • The Atatus Infrastructure Agent collects database telemetry by connecting to your database as a read-only user. It reads query statistics the database already keeps, such as pg_stat_statements in PostgreSQL, and requests explain plans through a function you create for it. Nothing runs inside your application.

  • Atatus uses AI to read query execution plans and point out expensive operations such as full scans or inefficient joins, with index guidance. It explains what to change and does not make changes to your database.

  • Database monitoring is priced per database host, and each host keeps up to 200 normalized queries. Retention is configurable by tier, so you decide how long query data is kept.

  • Yes. Atatus shows SQL Server deadlocks with the victim and survivor process, their queries and the locks they held and waited for. Query samples show lock waits, and replication metrics are collected for MySQL, PostgreSQL and SQL Server.

  • Install the Atatus Infrastructure Agent, create a read-only database user for it, and enable the settings it reads from. For PostgreSQL that means loading pg_stat_statements; some of these settings only take effect after a restart, so check them before you plan any downtime. Then point the agent at your database. Each engine and hosting option, from self-hosted to RDS, Aurora, Cloud SQL and Azure, has its own guide.

  • Yes. Atatus correlates database queries with application traces, logs and infrastructure metrics. APM shows the queries your code runs, and database monitoring shows the database's own side, with query samples, explain plans and locks.

  • Teams typically reduce time spent diagnosing database issues and improve performance through targeted query optimization. Results vary by workload, so a short pilot is recommended to measure impact.

  • By centralizing query behavior, execution context, and related application data, Atatus helps teams troubleshoot issues faster without switching between tools.

Get started

Find the query. Fix the cause.

Rank slow queries, read explain plans and catch deadlocks across every database you run.

  • SaaS
  • On-premises
  • Hybrid
  • BYOC
  • No per-user pricing

Compare Atatus with Datadog · Redgate · Releem