I try to use apm.service.datastore.operation.duration to monitor the operations on a database table. I started to look at the chats in APM > Databases like " Top database operations", in the query, it has something like:
SELECT sum(apm.service.datastore.operation.duration) * 1000 …
Why “* 1000”?
The y-axis label in this chat shows “s” (second) but If I run the query in the query builder, the y-axis becomes 1000 times larger. E.g., 3s in the original chart becomes 3k in query builder! Is this “x 1000” only for the display in the pre-defined chart?
The bottom line is: what is the “unit” in this metric? Second? Millisecond?