1 files changed, 29 insertions, 0 deletions
diff --git a/src/go/plugin/go.d/modules/clickhouse/collect_system_processes.go b/src/go/plugin/go.d/modules/clickhouse/collect_system_processes.go
new file mode 100644
index 000000000..53698ea6c
--- /dev/null
+++ b/src/go/plugin/go.d/modules/clickhouse/collect_system_processes.go
@@ -0,0 +1,29 @@
+// SPDX-License-Identifier: GPL-3.0-or-later
+
+package clickhouse
+
+import (
+	"strconv"
+
+	"github.com/netdata/netdata/go/plugins/plugin/go.d/pkg/web"
+)
+
+const queryLongestQueryTime = `
+SELECT
+    toString(max(elapsed)) as value 
+FROM
+    system.processes FORMAT CSVWithNames
+`
+
+func (c *ClickHouse) collectLongestRunningQueryTime(mx map[string]int64) error {
+	req, _ := web.NewHTTPRequest(c.Request)
+	req.URL.RawQuery = makeURLQuery(queryLongestQueryTime)
+
+	return c.doOKDecodeCSV(req, func(column, value string, lineEnd bool) {
+		if column == "value" {
+			if v, err := strconv.ParseFloat(value, 64); err == nil {
+				mx["LongestRunningQueryTime"] = int64(v * precision)
+			}
+		}
+	})
+}