# How to get monitoring data?

**URL:** <https://forums.percona.com/t/how-to-get-monitoring-data/14499>\
**Category:** PMM 2.x\
**Created:** [February 21, 2022, 10:24am UTC](https://forums.percona.com/t/how-to-get-monitoring-data/14499 "2022-02-21T10:24:24Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![xiangqianforth](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/xiangqianforth/32/5910_2.png) [@xiangqianforth](https://forums.percona.com/u/xiangqianforth)\
**Post date:** [February 21, 2022, 10:24am UTC](https://forums.percona.com/t/how-to-get-monitoring-data/14499/1 "2022-02-21T10:24:24Z")

</div>

1. how to get monitoring data through the interface (API)? Can you provide some examples?

2. Can the monitoring data be obtained by directly reading the database or middleware?

thanks

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [February 21, 2022, 11:07am UTC](https://forums.percona.com/t/how-to-get-monitoring-data/14499/2 "2022-02-21T11:07:23Z")

</div>

Hi @xiangqianforth

> [@xiangqianforth](#):
>
> - how to get monitoring data through the interface (API)? Can you provide some examples?

 ![Screenshot 2022-02-21 at 13.00.13](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/b/bcb51bbc6bb1d50f495d42b7c6913daa12672f9d.png)

> [@xiangqianforth](#):
>
> Can the monitoring data be obtained by directly reading the database or middleware?

Data can be fetch from the used victoriametrics time series  
database.

> **[HTTP API | Prometheus](https://prometheus.io/docs/prometheus/latest/querying/api/#finding-series-by-label-matchers)**
>
> An open-source monitoring system with a dimensional data model, flexible query language, efficient time series database and modern alerting approach.

---

<div class="post-metadata">

**Author:** ![xiangqianforth](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/xiangqianforth/32/5910_2.png) [@xiangqianforth](https://forums.percona.com/u/xiangqianforth)\
**Post date:** [February 22, 2022, 1:25am UTC](https://forums.percona.com/t/how-to-get-monitoring-data/14499/3 "2022-02-22T01:25:23Z")

</div>

Thank you for your reply

---

<div class="post-metadata">

**Author:** ![xiangqianforth](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/xiangqianforth/32/5910_2.png) [@xiangqianforth](https://forums.percona.com/u/xiangqianforth)\
**Post date:** [February 25, 2022, 7:17am UTC](https://forums.percona.com/t/how-to-get-monitoring-data/14499/4 "2022-02-25T07:17:11Z")

</div>

1. Thank you very much. I have obtained the monitoring data of indicators such as CPU/memory through the API. Can query-analytics data be obtained using API? Can you provide some examples?  

2. Can you use Python or Java code to get data directly from Victoria-metrics-database?

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [February 25, 2022, 7:34pm UTC](https://forums.percona.com/t/how-to-get-monitoring-data/14499/5 "2022-02-25T19:34:21Z")

</div>

> [@xiangqianforth](#):
>
> Can query-analytics data be obtained using API? Can you provide some examples?

> **[GitHub - percona/qan-api2: qan-api for PMM 2.x.](https://github.com/percona/qan-api2)**
>
> qan-api for PMM 2.x. Contribute to percona/qan-api2 development by creating an account on GitHub.

---

<div class="post-metadata">

**Author:** ![xiangqianforth](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/xiangqianforth/32/5910_2.png) [@xiangqianforth](https://forums.percona.com/u/xiangqianforth)\
**Post date:** [March 1, 2022, 11:32am UTC](https://forums.percona.com/t/how-to-get-monitoring-data/14499/8 "2022-03-01T11:32:02Z")

</div>

I want to get the monitoring data of two indicators in a certain period of time. I used the following command to obtain the data of query-analysis, but an error was reported.  
(1) command:  
curl -s -X POST -d ’ {“period\_start\_from”: “2022-02-27T00:00:00Z”, “period\_start\_to”: “2022-02-27T01:00:00Z”, “order\_by”: “num\_queries”, “columns”: [“lock\_time”, “sort\_scan”], “group\_by”: “server”} ’ [http://username](http://username/):passwd@my\_server\_ip/v0/qan/GetReport | jq  
(2) return:  
{error:internal server error, code:13, message:internal server error}

---

<div class="post-metadata">

**Author:** ![xiangqianforth](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/xiangqianforth/32/5910_2.png) [@xiangqianforth](https://forums.percona.com/u/xiangqianforth)\
**Post date:** [March 2, 2022, 5:54am UTC](https://forums.percona.com/t/how-to-get-monitoring-data/14499/9 "2022-03-02T05:54:51Z")

</div>

please hep me,thanks!!!