Quering a prometheus database as SQL, not prometheus is slow

I want to query a prometheus database as SQL.
But it is enormous slow and creates lots of disc activity.
Is it a bug or am i doing something wrong.

The query is simple and should be fast,
SELECT
“time” AS “time”,
value
FROM metrics2
ORDER BY 1 limit 10

This topic was automatically closed after 365 days. New replies are no longer allowed.