postgres extension schema syntax for custom query

Products

• DX APM SaaS

Issue/Introduction

Have a custom query which is returning multiple rows. We would like to get the schema syntax for the postgres extension to report metrics (based on data returned by the query in APM. 

Resolution

See attached Sample JSON file to add statements in schema.json file and restart the agent.

Sample-schema.json

Example path: SuperDomain|<hostname>||Infrastructure|Agent|Postgres Databases||postgres|Long Running Queries|pid

Sample-schema-2.json

Example path: SuperDomain|<hostname>||Infrastructure|Agent|Postgres Databases||postgres|Long Running Queries|<user>|pid