Menu

1 / 3

Database observability Dynatrace: slow queries with PostgreSQL

DEV Community: database·Span Observer·3 days ago
#iw7UcNyZ
#devtodatabase#devto#dev#database#extension
Reading 0:00
15s threshold

It is 10:40, checkout takes eight seconds to respond, and the application dashboard points a finger at « the database ». Database observability Dynatrace offers a way past that vague suspicion: an application called Databases, fed by an extension that an ActiveGate uses to query PostgreSQL. Here is how I would run it, from the suspicious trace down to the execution-plan node that burns the time.

One framing note first: everything below is about Dynatrace SaaS . The pages I read talk about Grail, the Hub and the Platform Subscription, and nothing says Managed behaves the same, so I do not claim it. If you only want the extension itself, another post covers it: the database extension article . This one starts from the symptom.

Database observability Dynatrace: from symptom to query

A trace shows a SQL call lasting several seconds. That proves the database is making someone wait, nothing more.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.