Can I track the transactionId in the log? I don't seem to have found such an API.

[Shonke]

Question

Can it be obtained, or do we need to submit a feature request?
Similar issues are here #17959
But I hope to retrieve them from the query log (which is something else, inside Prisma rather than from the database)

Track in debug:

How to reproduce (optional)

No response

Expected behavior (optional)

No response

Information about Prisma Schema, Client Queries and Environment (optional)

prisma.$on('query', (x: QueryEvent) => {
    console.error(`Executing (default) [${Math.trunc(x.duration)}ms]: SQL:${x.query}; params:${x.params}`)
})

// transaction test
await prisma.$transaction(async (tx) => {
      await tx.$queryRaw`SELECT 1`
      await tx.$queryRaw`SELECT 2`
 })

output

Executing (default) [0ms]: SQL:SELECT 1; params:[]
Executing (default) [0ms]: SQL:SELECT 2; params:[]

• OS: macOS
• Database: PostgreSQL
• Node.js version: v20.19.5

prisma : 7.0.1
@prisma/client : 6.19.0
Operating System : darwin
Architecture : arm64
Node.js : v20.19.5
TypeScript : 5.6.3
Query Compiler : enabled
PSL : @prisma/prisma-schema-wasm 7.1.0-2.f09f2815f091dbba658cdcd2264306d88bb5bda6
Schema Engine : schema-engine-cli f09f2815f091dbba658cdcd2264306d88bb5bda6 (at node_modules/@prisma/engines/schema-engine-darwin-arm64)
Default Engines Hash : f09f2815f091dbba658cdcd2264306d88bb5bda6
Studio : 0.8.2

[nurul3101]

Hey @Shonke!

Just to confirm, you want to get the transaction Id when you have enabled logging at Prisma level, like this:

const prisma = new PrismaClient({ adapter, log:['query'] });

Not like the solution mentioned here?
#17959 (comment)

[Shonke]

Hi @nurul3101, Thank you for your reply

This is different from what I thought:

1. Unable to retrieve the transaction ID from the callback of the $on query event
2. I just want to concatenate these SQL operations, not a real thing transaction ID from the database. Using SELECT txid_current in every SQL log will slow me down

[nurul3101]

Okay, I would recommend creating a feature request in this case so that our ORM team can have a look.

[github-actions[bot]]

Hi,

As we have not heard back from you, we are closing this discussion to keep our discussions organized.

Feel free to start a new discussion if this remains relevant.

Thank you for being part of the community!