SolarWinds Observability DBO - samples for MySQL or Postgres not displaying

In on-host installations, the most common reason for not seeing query samples is either that they are either disabled for some or all of your hosts by your administrator, or you are logged in as a user without proper permissions for MySQL or Postgres to view query samples;  We will also be unable to capture prepared statements which are executed as part of a long-running connection.

In off-host configurations, the most common reasons are not having events_statements_history_long (MySQL) or pg_stat_activity (PostgreSQL) enabled and collecting query data, or that the DBO user does not have sufficient privileges to access that data. We are also unable to collect query samples for prepared statements for MySQL (as query samples are not made available by the database). PostgreSQL does not provide query samples with the literals included, so we do not show this text as it is identical to the query digest.

Samples can also be disabled in the dbo-global.conf file. This file is located at /etc/solarwinds/dbo-global.conf in Linux and C:\ProgramData\SolarWinds\UAMSClient\plugin-storage\dbo-global.conf in Windows.