Prometheus is not a SQL database: it's a time series database and has its
own query language, PromQL.
Each timeseries is uniquely identified by a metric name (which describes
the type of thing you're measuring) and a set of labels (which taken
together identify one particular instance of that thing). A common label
is "instance" which normally identifies the host the metric came from. Here
are a few simple PromQL queries:
node_filesystem_avail_bytes
node_filesystem_avail_bytes{instance="server1"}
node_filesystem_avail_bytes{instance="server1",mountpoint="/"}
The first query returns a vector with available space on all filesystems.
The second query returns a vector with available space on all filesystems
on one particular host (which still may be multiple results)
The third instance constrains the query more specifically to a single
filesystem.
There is lots of documentation online, both official and various blogs,
which can tell you more.
On Tuesday, 22 February 2022 at 19:56:58 UTC [email protected] wrote:
> Good afternoon,
> is it possible to use prometheus for such a scenario:
> One database, one request but with different parameters?
> Example:
> select value from perfmon where hostname = 'some hostname'
> There are many such hostnames, I would like to have one configuration file
> for all hosts. Is it possible?
> Hostnames are specified in grafana variables.
>
--
You received this message because you are subscribed to the Google Groups
"Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/prometheus-users/88b1cde7-54a4-4433-a84a-3fde45b3ee5an%40googlegroups.com.
