hook.go (1831B)
1 // GoToSocial 2 // Copyright (C) GoToSocial Authors admin@gotosocial.org 3 // SPDX-License-Identifier: AGPL-3.0-or-later 4 // 5 // This program is free software: you can redistribute it and/or modify 6 // it under the terms of the GNU Affero General Public License as published by 7 // the Free Software Foundation, either version 3 of the License, or 8 // (at your option) any later version. 9 // 10 // This program is distributed in the hope that it will be useful, 11 // but WITHOUT ANY WARRANTY; without even the implied warranty of 12 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13 // GNU Affero General Public License for more details. 14 // 15 // You should have received a copy of the GNU Affero General Public License 16 // along with this program. If not, see <http://www.gnu.org/licenses/>. 17 18 package bundb 19 20 import ( 21 "context" 22 "time" 23 24 "codeberg.org/gruf/go-kv" 25 "codeberg.org/gruf/go-logger/v2/level" 26 "github.com/superseriousbusiness/gotosocial/internal/log" 27 "github.com/uptrace/bun" 28 ) 29 30 // queryHook implements bun.QueryHook 31 type queryHook struct{} 32 33 func (queryHook) BeforeQuery(ctx context.Context, _ *bun.QueryEvent) context.Context { 34 return ctx // do nothing 35 } 36 37 // AfterQuery logs the time taken to query, the operation (select, update, etc), and the query itself as translated by bun. 38 func (queryHook) AfterQuery(ctx context.Context, event *bun.QueryEvent) { 39 // Get the DB query duration 40 dur := time.Since(event.StartTime) 41 42 switch { 43 // Warn on slow database queries 44 case dur > time.Second: 45 log.WithContext(ctx). 46 WithFields(kv.Fields{ 47 {"duration", dur}, 48 {"query", event.Query}, 49 }...).Warn("SLOW DATABASE QUERY") 50 51 // On trace, we log query information, 52 // manually crafting so DB query not escaped. 53 case log.Level() >= level.TRACE: 54 log.Printf("level=TRACE duration=%s query=%s", dur, event.Query) 55 } 56 }