The Performance Investigator (PI) API provides comprehensive database performance monitoring capabilities that help identify performance bottlenecks and optimize query execution. These APIs allow you to retrieve detailed performance statistics, execution plans, dimension trees, and monitoring metrics for supported database platforms including SQL Server, Oracle, Azure SQL, MySQL, and PostgreSQL.
The Performance Investigator API supports the following database domains: SQL_SERVER, ORACLE, SSAS, AZURE, MYSQL, POSTGRES.
Please refer to the online documentation at docs.foglight.com under the Using Rest API category for more details.https://docs.foglight.com/