Open-source APMGolang HTTP routerGolang ClickHouseBlog
Bun

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}))

Zap hook

You can also use bunzapopen in new window to log executed queries using Zapopen in new window

go get github.com/alexlast/bunzap

Example:

db := bun.NewDB(sqldb, dialect) logger, err := zap.NewProduction() db.AddQueryHook(bunzap.NewQueryHook(bunzap.QueryHookOptions{ Logger: logger, SlowDuration: 200 * time.Millisecond, // Omit to log all operations as debug }))