the same connection will be reused
# spicedb
j
the same connection will be reused multiple times in the pool
s
I understand that. As far as I know each datastore operation acquires and then returns connection to the pool. So my logic is the following: QueryRelationships doesn't use cache, so whenever
sum(spicedb_datastore_query_latency_count{operation="QueryRelationships"})
is incremented -> we actually issued datastore query -> we acquired and then returned connection from/to the pool. so I assume the above sum should be equal to (or at least be close to, taking into account other db operation)
sum(pgxpool_acquire_count)
. but with my local docker-compose installation I get like x3.3 difference (with
sum(pgxpool_acquire_count)
being smaller).
🤔 maybe I am missing something and there is a cache for QueryRelationships datastore operation?
maybe query gets cancelled before it even reaches pgxpool, but there's no way to tell this by metrics
2 Views