This is a configuration issue with PostgresSQL temp table size.
Maybe there is a solution by using a recursive query in pgsql.
Or increase the size of temp_file_limit, to get the distinct query more space to work.
Error in grafana
2022-10-17 11:27:54 | {"level":"error","error":"ERROR #53400 temporary file size exceeds temp_file_limit (1021877kB)","time":"2022-10-17T16:27:54Z","message":"get distinct publickey count 0"}
-- | --
This is a configuration issue with PostgresSQL temp table size.
Maybe there is a solution by using a recursive query in pgsql.
Or increase the size of temp_file_limit, to get the distinct query more space to work.
Error in grafana