Prisma経由のDBクエリをチューニングする際のTIPS

// クエリログイベントを有効化
const prisma = new PrismaClient({
  log: [
    {
      emit: 'event',
      level: 'query',
    },
  ],
})

// クエリログイベントを$onでListenした上で、コンソールにログ出力(全件出力する場合)
prisma.$on('query', async (e) => {
  console.log(`${e.duration}ms: ${e.query} ${e.params}`)
})

// クエリログイベントを$onでListenした上で、コンソールにログ出力(指定時間以上かかったものだけ出力する場合)
prisma.$on('query', (e) => {
  if (e.duration > 10) {
    console.log(`${e.duration}ms: ${e.query} ${e.params}`)
  }
})

const users = await prisma.user.findMany({
  relationLoadStrategy: 'join', // or 'query'
  select: {
    posts: true,
  },
})

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["tracing"]
}

// Imports
import { SEMRESATTRS_SERVICE_NAME, SEMRESATTRS_SERVICE_VERSION } from '@opentelemetry/semantic-conventions'
import { OTLPTraceExporter } from '@opentelemetry/exporter-trace-otlp-http'
import { registerInstrumentations } from '@opentelemetry/instrumentation'
import { SimpleSpanProcessor } from '@opentelemetry/sdk-trace-base'
import { NodeTracerProvider } from '@opentelemetry/sdk-trace-node'
import { PrismaInstrumentation } from '@prisma/instrumentation'
import { Resource } from '@opentelemetry/resources'

// Configure the trace provider
const provider = new NodeTracerProvider({
  resource: new Resource({
    [SEMRESATTRS_SERVICE_NAME]: 'example application',
    [SEMRESATTRS_SERVICE_VERSION]: '0.0.1',
  }),
})

// Configure how spans are processed and exported. In this case we're sending spans
// as we receive them to an OTLP-compatible collector (e.g. Jaeger).
provider.addSpanProcessor(new SimpleSpanProcessor(new OTLPTraceExporter()))

// Register your auto-instrumentors
registerInstrumentations({
  tracerProvider: provider,
  instrumentations: [new PrismaInstrumentation()],
})

// Register the provider globally
provider.register()