Multiple queries under 1 metric

[LumePart]

Hello!
It would be very useful to allow for multiple select (and other) queries under 1 metric

An example use case:
Monitoring query completion time

DECLARE @t1 DATETIME;
DECLARE @t2 DATETIME;

SET @t1 = GETDATE();
SELECT /* query */;
SET @t2 = GETDATE();
SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;

And elapsed_ms could go in values to be scraped

It seems that right now, the exporter only takes the first select query and ignores others whether it has a AS command or not

[burningalchemist]

Hi @nootb, let me take a look and thanks for the example. 👍

[burningalchemist]

@nootb, sql_exporter is using database/sql package as the interface for the available drivers. As per documentation there are existing limitations.

As far as I know there's a proposal to enable batch queries in database/sql, but it's not merged yet anyway.

If you're interested specifically in query duration, I think this could be possible to fetch from query logs from the underlying drivers. But I've taken a look and there's no standard, so this unfortunately won't work at the moment.

I'd probably design a dedicated exporter for such needs, working with a specific driver directly, so I could utilize features available outside of database/sql interface.

[LumePart]

Thanks for the detailed answer!