DX Infrastructure Manager

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

    Posted 12-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?

    Broadcom Employee


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

    Posted 12-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?

    Broadcom Employee
    Posted 12-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 12-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.