In Datadog APM, the EXEC TIME (Execution Time) column specifically shows the duration of each span's operation. For database queries, this represents the actual time taken to execute the query. This metric directly answers the question of which database query is taking the longest time. By sorting or examining the EXEC TIME column values, you can identify the database span with the highest execution time, which is the longest-running query.

A. Check the SPANS column: Shows span names/types but not their duration or performance metrics.

C. Check the ERRORS column: Indicates error occurrences, not execution time or duration.

D. Check the LATENCY column: Represents end-to-end trace latency, not individual span execution time.

1. Datadog Documentation - "Trace View" - APM > Trace Search & Analytics section, specifically the "Span List" subsection describing column definitions

2. Datadog Documentation - "Key APM Terminology" - APM > Getting Started, defining execution time vs latency

3. Datadog Learning Center - "APM Fundamentals" course module on span analysis and performance metrics