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.…