The DB user must have access to all databases you wish to monitor. The agent will only query system tables and views and make use of a few system functions in order to gather operational data.
The SUPERUSER or relevant privilege is only required in order to make use of various administration functions and requesting some explain plans through the Foglight console, if enabled in the agent. A separate user can be provided to the agent to perform those functions exclusively. Usage of these functions is restricted to Foglight users who have been granted the “PostgreSQL Administrator” role.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center