diff options
| author |  tobi <31960611+tsmethurst@users.noreply.github.com> | 2022-03-07 11:33:18 +0100 |
|---|---|---|
| committer |  GitHub <noreply@github.com> | 2022-03-07 11:33:18 +0100 |
| commit | 8de928b5e9441d3968e5f79860f4de08d52f24ed (patch) | |
| tree | c5a4188e61294d59e73e0e3a1f0c684c7be112fd /internal/db/bundb/trace.go | |
| parent | [feature] Clean up/uncache remote media (#407) (diff) | |
| download | gotosocial-8de928b5e9441d3968e5f79860f4de08d52f24ed.tar.xz | |
[performance] Database optimizations (#419)v0.2.1
* create first index on notifications
* tidy up + add tests
* log queries for trace, ops for debug
* index commonly used fields
* rearrange query
* add a few more indexes
* remove schema-breaking index
(add this back in later)
* re-add cleanup query index
Diffstat (limited to 'internal/db/bundb/trace.go')
| -rw-r--r-- | internal/db/bundb/trace.go | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/internal/db/bundb/trace.go b/internal/db/bundb/trace.go index 9eaad6880..93c231785 100644 --- a/internal/db/bundb/trace.go +++ b/internal/db/bundb/trace.go @@ -47,5 +47,9 @@ func (q *debugQueryHook) AfterQuery(_ context.Context, event *bun.QueryEvent) { "operation": event.Operation(), }) - l.Tracef("[%s] %s", dur, event.Operation()) + if logrus.GetLevel() == logrus.TraceLevel { + l.Tracef("[%s] %s", dur, event.Query) + } else { + l.Debugf("[%s] %s", dur, event.Operation()) + } } |