topic Re: Possibility to visualize data in postgress by querying in Open Q&A

Possibility to visualize data in postgress by querying

Jomon — Fri, 12 May 2023 07:00:33 GMT

Hi i am new to dynatrace. Actually I was using grafana before for monitoring purposes. In dynatrace is there is any option to view data from a postgres table by using sql queries. As of now i could able to find the performance metrices of postgres

Re: Possibility to visualize data in postgress by querying

Julius_Loman — Thu, 11 May 2023 14:18:46 GMT

Hi!

welcome to Dynatrace 🙂 Sure there are options for both.

For metrics - just use this extension 2.0 - https://www.dynatrace.com/hub/detail/postgresdb-remote-monitoring/
For data collected using queries defined by you, you can use this extension https://www.dynatrace.com/hub/detail/custom-database-queries/ or you can create your own Extension 2.0 using the Postgres SQL data source - see more here https://www.dynatrace.com/support/help/shortlink/extensions20

Re: Possibility to visualize data in postgress by querying

Jomon — Tue, 16 May 2023 07:45:09 GMT

I have received the above error while establishing the postgres connection. What could be the reason? The Dynatrace Token which i have provided is taken from the 'Access token' tab from settings and with API v2 scope type.

Re: Possibility to visualize data in postgress by querying

Julius_Loman — Sat, 15 Jul 2023 16:31:42 GMT

Please check the log files on the activegate. Did you also unzip the extension on the activegate?