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

[mattias_wessma1]

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? 🙂

[Mike_L · Accepted solution]

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

[mattias_wessma1]

Sounds good, will do. Thanks!

[mattias_wessma1]

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

[Mike_L]

Great to hear, well done!

[rawvi]

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?

[PacoPorro]

Hi, check this 

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

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

[AntonioSousa · Accepted solution]

There is now a generic way to do this:

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