Massive log monitoring from database

[sga-solita]

Current Behavior

We have been running Dependency Track for about a month and just now I can see that there are a LOT of log entries in Application Insights from the database queries

This is causing our Log Analytics Workspace to be responsible for most of our costs:

How do I reduce or disable database query output? I did search through the documentation, but was unable to find something specifically for this problem.

Steps to Reproduce

1. Use Dependency Track
2. Check logs

Expected Behavior

Possibility to reduce or disable log output from database queries.

Dependency-Track Version

4.11.7

Dependency-Track Distribution

Container Image

Database Server

PostgreSQL

Database Server Version

No response

Browser

Google Chrome

Checklist

• [X] I have read and understand the contributing guidelines
• [X] I have checked the existing issues for whether this defect was already reported

[nscuro]

DT doesn't log any queries by default. This looks like you configured Postgres to log queries in Azure, and you're using Azure's log analytics service on top of that.

You'll need to check your Azure config to disable that.

[sga-solita]

@nscuro I did think of that possibility, but the cloud_RoleName is DT backend (redacted here, but screenshot for clarity)

[nscuro]

DT doesn't know about any cloud and roles within it. Your Postgres database has verbose query logging enabled, but that configuration is entirely on your side and nothing DT can change or even see.

[sga-solita]

I just tried to disable Application Insights for my backend (DT). Logs stopped coming. I also checked server log configuration for my database, and it has never been enabled.