topic Re: Custom metric that fetches database statistics using a SQL-query? in Open Q&A

Custom metric that fetches database statistics using a SQL-query?

mattias_wessma1 — Wed, 04 Dec 2019 15:50:17 GMT

Hi!

I would like to fetch statistics from a PostgreSQL-database (e.g. from pg_stat) using a custom SQL. This calls for custom metrics; but before fiddling with that: are there any repository for this? This has surely been done before, right? 🙂

Re: Custom metric that fetches database statistics using a SQL-query?

Mike_L — Wed, 04 Dec 2019 15:54:52 GMT

Hi,

I don't know of any open source plugin that fetches data from PostgreSQL.

That being said, our services department has created several such plugins in the past, so if you want help with it you can reach out to us through your account/delivery manager.

Mike

Re: Custom metric that fetches database statistics using a SQL-query?

mattias_wessma1 — Wed, 04 Dec 2019 16:04:23 GMT

Sounds good, will do. Thanks!

Re: Custom metric that fetches database statistics using a SQL-query?

mattias_wessma1 — Fri, 13 Dec 2019 12:17:18 GMT

Hi! I've now been able to successfully develop and deploy a custom plugin myself - reading blocked locks from PostgreSQL. Just FYI 🙂

Re: Custom metric that fetches database statistics using a SQL-query?

Mike_L — Fri, 13 Dec 2019 15:41:06 GMT

Great to hear, well done!

Re: Custom metric that fetches database statistics using a SQL-query?

rawvi — Wed, 14 Jul 2021 17:59:53 GMT

Can you direct me where can I find that information about developing and deploying a custom plugin to dynatrace?

Where can I find that information and the ways to implement it from the documentation.

Is this developed by a SDK or any python program that ingest the data into dynatrace?

Re: Custom metric that fetches database statistics using a SQL-query?

PacoPorro — Fri, 16 Jul 2021 06:45:29 GMT

Hi, check this

https://dynatrace.github.io/plugin-sdk/readme.html

https://www.dynatrace.com/news/blog/extend-dynatrace-custom-monitoring-plugins/

Re: Custom metric that fetches database statistics using a SQL-query?

AntonioSousa — Sun, 01 May 2022 15:43:38 GMT

There is now a generic way to do this:

https://community.dynatrace.com/t5/Dynatrace-tips/Custom-Database-Queries/td-p/185781