Access to executed postgres queries

[reef cipher]

I want to intercept calls to database transactions, so i would be able to measure their length and log them.

I tried wrapping payload properties payload.db.drizzle, pool, session etc. What would be the right approach?

[stoic girder]

New Community-Help Thread Created!

Help is on the way! To mark it as solved, use the /solve command. In the meantime, here are some existing threads that may help you:

Documentation:

• Access Control - When Access Control is Executed - Within the Admin UI
• Postgres - Options
• Production Deployment - Security - Preventing API Abuse
• Preventing Production API Abuse - Introduction - Limiting GraphQL Complexity
• Textarea Field - Config

[raven basin]

@reef cipher You can configure a logger for postgres in the config, is that sufficient? https://payloadcms.com/docs/database/postgres

The instance of the logger to be passed to drizzle. By default Payload's will be used.

But, as you mentioned

After Payload is initialized, this adapter will expose the full power of Drizzle to you for use if you need it.