DX Unified Infrastructure Management

  • Private Community

  • 1.  Can we get the list of queries which the MCS Profile type uses for PostgreSQL monitoring?

    Posted Dec 10, 2018 09:43 AM

    Is there any list of queries which the MCS Profile type uses for PostgreSQL monitoring similar to what we know for sqlserver and oracle probes for instance.



  • 2.  Re: Can we get the list of queries which the MCS Profile type uses for PostgreSQL monitoring?



  • 3.  Re: Can we get the list of queries which the MCS Profile type uses for PostgreSQL monitoring?

    Posted Dec 11, 2018 10:04 AM

    Thanks David.
    If a run the queries individually from jdbc_response it gives me output as 'it has xx rows and xx cloumns'
    Is it the normal behaviour for these queries or something I'm missing.



  • 4.  Re: Can we get the list of queries which the MCS Profile type uses for PostgreSQL monitoring?

    Posted Dec 11, 2018 10:22 AM

    Sorry, I don't have a database to test this against and provide an answer.



  • 5.  Re: Can we get the list of queries which the MCS Profile type uses for PostgreSQL monitoring?

    Posted Dec 12, 2018 07:40 AM

    Also though the queries are there it does not correspond to what metrics in the MCS config a particular query points.