Logging queries

bundebug

For quick debugging, you can print executed queries to stdout. First, you need to install bundebug package:

go get github.com/uptrace/bun/extra/bundebug

Then add the provided query hook which by default only prints failed queries:

import "github.com/uptrace/bun/extra/bundebug"
db := bun.NewDB(sqldb, dialect)
db.AddQueryHook(bundebug.NewQueryHook())

To print all queries, use WithVerbose option:

bundebug.NewQueryHook(bundebug.WithVerbose(true))

You can also disable the hook by default and use environment variables to enable it when needed:

bundebug.NewQueryHook(
    // disable the hook
    bundebug.WithEnabled(false),
    // BUNDEBUG=1 logs failed queries
    // BUNDEBUG=2 logs all queries
    bundebug.FromEnv("BUNDEBUG"),
)

Logrus hook

You can also use logrusbunopen in new window to log executed queries using Logrusopen in new window

go get github.com/oiime/logrusbun

Use QueryHookOptions to adjust log levels and behavior:

db := bun.NewDB(sqldb, dialect)
log := logrus.New()
db.AddQueryHook(logrusbun.NewQueryHook(logrusbun.QueryHookOptions{Logger: log}))