I'm looking for a way to browse the time based database raw data, in a way similar to how SQL Server Management Studio gives you access to the raw data held within the relational database SQL creates. It can be a GUI or console based, because with SQL you can do either or, I'm really hoping for some kind of graphical interface though. Is there a way to browse through the data?
Or can someone simply explain how the raw data would look, if there were such a way? With SSMS, I'm able to get so much information about the tables, fields and rows, and see how it's all structured and related.
I do understand that it's kind of apples and oranges when talking about the differences between a Time Based DB and a Relational DB, but surely there's a way to browse through the database itself? Or is it just using PromQL?
The Web UI doesn't seem to provide anything like this, where I can see a way to browse through the ingested data.
Prometheus provides an ability to query data with PromQL via /api/v1/query and /api/v1/query_range HTTP APIs.
If you need querying raw samples for some time series matching the given series selectors on a specified time range (t-d ... t]
, then the following query to /api/v1/query
HTTP API can be issued:
curl 'http://prometheus-host:9090/api/v1/query?query=some_series_selector[d]&time=t`
For example, http://demo.robustperception.io:9090/api/v1/query?query=up[5m]
See this article for details.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With