https://authzed.com logo
#spicedb
Title
# spicedb
c

costap.

10/25/2021, 9:48 AM
Hi folks Im doing a poc with spicedb and trying to understand why a check query is taking 8s after adding some data while before was only 3ms. Looking at the logs seems the problem is somewhere between these two queries:
Copy code
{"level":"info","module":"pgx","args":[],"pid":10491,"rowCount":1,"sql":"SELECT NOW()","time":1.220158,"time":"2021-10-25T09:38:59Z","message":"Query"}

{"level":"info","module":"pgx","args":["2021-10-25T09:38:54.987366Z"],"pid":10491,"rowCount":1,"sql":"SELECT MIN(id), MAX(id) FROM relation_tuple_transaction WHERE timestamp >= $1","time":8444.964599,"time":"2021-10-25T09:39:08Z","message":"Query"}
Missing an index for that second query maybe?