Sentry Postgres Integration does not detect database events

[RodoVJ]

Environment

SaaS (https://sentry.io/)

What are you trying to accomplish?

My team wants to use the Sentry Postgres integration to monitor the performance of our database. We are using Postgres as our database and use Typeorm as our ORM to make database operations.

How are you getting stuck?

Sentry does not seem to pick up any activity coming from Postgres and we don't see any metrics related to it. Is the reason Sentry can't pick up activity coming form Postgres because we are using Typeorm to interact with Postgres? If that's the case, is there a way to get around this issue? We introduced other automatic integrations (GraphQL and Express) and those are working fine.

Where in the product are you?

Performance

Link

No response

DSN

No response

Version

No response

[getsantry]

Assigning to @getsentry/support for routing ⏲️

[getsantry]

Routing to @getsentry/product-owners-performance for triage ⏲️

[mjq-sentry]

Hi @RodoVJ, thanks for writing in! We don't have a direct integration with TypeORM, but it looks like it uses the pg library for its Postgres support, so I'd expect that to work. I'm going to transfer this issue to the SDK for that team to take a look.

[AbhiPrasad]

Hey @RodoVJ thanks for writing in! If you supply the debug: true attribute to your Sentry.init and use the sentry postgres integration, what gets logged out?

[RodoVJ]

Hi @AbhiPrasad, thank you for your response!

When our app first starts up, I get the following with debug: true:

Sentry Logger [log]: Integration installed: InboundFilters
Sentry Logger [log]: Integration installed: FunctionToString
Sentry Logger [log]: Integration installed: Console
Sentry Logger [log]: Integration installed: Http
Sentry Logger [log]: Integration installed: Undici
Sentry Logger [log]: Integration installed: OnUncaughtException
Sentry Logger [log]: Integration installed: OnUnhandledRejection
Sentry Logger [log]: Integration installed: ContextLines
Sentry Logger [log]: Integration installed: LocalVariables
Sentry Logger [log]: Integration installed: Context
Sentry Logger [log]: Integration installed: Modules
Sentry Logger [log]: Integration installed: RequestData
Sentry Logger [log]: Integration installed: LinkedErrors
Sentry Logger [log]: Integration installed: Express
Sentry Logger [log]: Integration installed: Apollo
Sentry Logger [log]: Integration installed: GraphQL
Sentry Logger [log]: Integration installed: Postgres
Sentry Logger [log]: Integration installed: CaptureConsole

When I perform an action that triggers a GET call to our API that uses Postgres, I get several of the following console logs:
(I couldn't spot any Postgres related events)

Sentry Logger [log]: [Tracing] starting http.server transaction - POST /graphql
Sentry Logger [log]: [Tracing] Starting 'middleware.express.use' span on transaction 'POST /graphql' (<manually removed it for privacy>).
Sentry Logger [log]: [Tracing] Finishing 'middleware.express.use' span on transaction 'POST /graphql' (<manually removed it for privacy>).
Sentry Logger [log]: [Tracing] Starting 'middleware.express.use' span on transaction 'POST /graphql' (<manually removed it for privacy>).
Sentry Logger [log]: [Tracing] Starting 'http.client' span on transaction 'POST /graphql' ().
Sentry Logger [log]: [Tracing] Adding sentry-trace header <manually removed it for privacy> to outgoing request to <manually removed it for privacy>:
Sentry Logger [log]: [Tracing] Finishing 'http.client' span on transaction 'POST /graphql' (82edce63fe913792).
Sentry Logger [log]: [Tracing] Finishing 'middleware.express.use' span on transaction 'POST /graphql' (<manually removed it for privacy>).
Sentry Logger [log]: [Tracing] Starting 'middleware.express.use' span on transaction 'POST /graphql' (<manually removed it for privacy>).
Sentry Logger [log]: [Tracing] Finishing 'middleware.express.use' span on transaction 'POST /graphql' (<manually removed it for privacy>).
Sentry Logger [log]: [Tracing] Starting 'middleware.express.use' span on transaction 'POST /graphql' (<manually removed it for privacy>).
Sentry Logger [log]: [Tracing] Finishing 'middleware.express.use' span on transaction 'POST /graphql' (<manually removed it for privacy>).
Sentry Logger [log]: [Tracing] Starting 'middleware.express.use' span on transaction 'POST /graphql' (<manually removed it for privacy>).
Sentry Logger [log]: [Tracing] Finishing 'middleware.express.use' span on transaction 'POST /graphql' (<manually removed it for privacy>).
Sentry Logger [log]: [Tracing] Starting 'middleware.express.use' span on transaction 'POST /graphql' (<manually removed it for privacy>).
--- AFTER 'Team' LOADED: <manually removed it for privacy>
Sentry Logger [log]: [Tracing] Starting 'graphql.execute' span on transaction 'POST /graphql' (<manually removed it for privacy>).