supabase / auth / 17980540058

69%

push

github

feat: add advisor to notify you when to double the max connection pool (#2167)

Adds a simple advisor that emits a log message every hour, if the number
of [DBStats](https://pkg.go.dev/database/sql#DBStats) samples exceeds:

- 1/3 or more samples indicate more than 1ms wait for every millisecond
in the sampling interval
- 1/3 or more samples indicate 2 or more goroutines have been waiting to
acquire a connection from the pool

For instance, if you set `GOTRUE_DB_ADVISOR_SAMPLING_INTERVAL="100ms"`
and `GOTRUE_DB_ADVISOR_OBSERVATION_INTERVAL="1s"` then:

- There are 1000 / 100 = 10 samples
- Every 100ms a sample is taken and the conditions are checked
- Log message is emitted if either one of the conditions are met at most
once per hour

40 of 70 new or added lines in 2 files covered. (57.14%)

13084 of 19345 relevant lines covered (67.64%)

65.46 hits per line