IBM Support

MustGather: Instana PostgreSQL Sensor

Troubleshooting


Problem

This guide provides essential steps for collecting data related to Instana PostgreSQL Sensor. Before contacting IBM® support for assistance, please review the information below to familiarize yourself with the troubleshooting process.

Resolving The Problem

To explore potential solutions, search for issues, access documentation, or visit support forums, head to the IBM® Support page. If you are aware of the affected component, refer to the relevant MustGather details below:
 
MustGather Data Collection Requirements for Instana PostgreSQL Sensor

Monitored environment details:
 
  • Kind of deployment (Single host , Kubernetes, docker, podman, AWS Fargate)
  • OS (Linux/ Windows) and version
  • PostgreSQL version
  • Names of PostgreSQL instance(s) & database(s) being monitored
 
Agent logs:
 
  • Collect debug log of Instana agent:
    • See the MustGather page for Instana Agent for more details
 
Agent configuration:
 
  • Collect the <instana-agent-dir>/etc/instana/configuration.yaml file 
 
Additional output & files to collect:
 
  • Confirm that the following postgresql.conf related entries are uncommented and the values are turned "on"
    • track_activities = on
    • track_counts = on    
    • track_io_timing = on
  • PostgreSQL Databases and Permissions Information
    • Login to the postgresql shell via psql using the command: 
      • psql -U <username> -d <database name> -h <hostname> -p <port on which postgres runs>
    • Once logged in, please run the below commands and upload the output to the case:
      • Statistics collection Parameters:
        • SHOW track_activities;  SHOW track_counts;  SHOW track_io_timing;
      • Relation Details for pg_stat_database (To check if user has the SELECT privilege):
        • SELECT relname, relkind, relacl FROM pg_class WHERE relname = 'pg_stat_database';
      • Listing All Databases (To verify the Connect privilage):
        • \l

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSE1JP5","label":"IBM Instana Observability"},"ARM Category":[{"code":"a8m3p000000UoUBAA0","label":"Sensors - Setup \u0026 Discovery"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.281;1.0.282;1.0.283;1.0.284;1.0.285;1.0.286;1.0.287;1.0.288;1.0.289;1.0.290;1.0.291;1.0.292;1.0.293;1.0.294;1.0.295;1.0.296;1.0.297;1.0.298;1.0.299;1.0.300;1.0.301;1.0.302;1.0.303;1.0.304;1.0.305;1.0.307"}]

Document Information

Modified date:
08 November 2025

UID

ibm17245672

Page Feedback