Missing PostgresqlDatabaseSample in PostgreSQL data

Hi,
I’ve integrated our PostgreSQL cluster via infrastructure agent. I see data from PostgresqlInstanceSample but cannot see data from PostgresqlDatabaseSample. Is there any thought about it?
Please also include all pertinent information;

  • Operating system & version
    Kubernetes runs on Flatcar Container Linux by Kinvolk 2765.2.2 (Oklo)

  • Infrastructure agent version
    newrelic/infrastructure-k8s:2.7.0

  • Infrastructure agent log snippets
    I saw something like this under the verbose=1 condition

time=“2021-09-09T14:02:00Z” level=debug msg=“Integration stderr (not parsed).” component=integrations.runner.Runner env=production integration_name=nri-postgresql line="[WARN] Crosstab function not available; database lock metric gathering not possible." role=postgresql

time=“2021-09-09T14:02:00Z” level=debug msg=“Integration stderr (not parsed).” component=integrations.runner.Runner env=production integration_name=nri-postgresql line="[WARN] To enable database lock metrics, enable the ‘tablefunc’ extension on the public" role=postgresql

time=“2021-09-09T14:02:00Z” level=debug msg=“Integration stderr (not parsed).” component=integrations.runner.Runner env=production integration_name=nri-postgresql line="[WARN] schema of your database. You can do so by:" role=postgresql

time=“2021-09-09T14:02:00Z” level=debug msg=“Integration stderr (not parsed).” component=integrations.runner.Runner env=production integration_name=nri-postgresql line="[WARN] 1. Installing the postgresql contribs package for your OS; and" role=postgresql

time=“2021-09-09T14:02:00Z” level=debug msg=“Integration stderr (not parsed).” component=integrations.runner.Runner env=production integration_name=nri-postgresql line="[WARN] 2. Run the query ‘CREATE EXTENSION tablefunc;’ against your database’s public schema" role=postgresql

  • Infrastructure integration (cloud or on-host) information
    on-host but not sure if postgres installed on k8s. It’s an external service
1 Like

@vsahin It looks as though in the github this happens when the connection doesn’t return the extensions we are looking for to be able to gather table lock metrics. https://github.com/newrelic/nri-postgresql/blob/915da342ad74e5092006978000712798e6f423dd/src/metrics/metrics.go#L300-L313. However I don’t think that should break your other metrics. Do you see any instances of “level=error” in association with the nri-postgresql integration?