Count number of scidb queries per day and by user

Below I am

  • Counting queries issued in 2020 only
  • Omitting save(show(.. queries issued by scidbR / scidb-py to interpret query schema.

Number of queries per day

grep -r "^2020.*Executing" scidb.log | grep -v "save(show" | awk '{print $1}' | sort | uniq -c2020-01-06: 29

yields

2020-01-09: 48
2020-01-10: 147
2020-01-13: 329
...

Number of queries per user

grep -r "^2020.*Executing" scidb.log | grep -v "save(show" | awk '{print $8}' | sort | uniq -c | awk '{print $2": "$1}'

yields

user:ksenshar,: 2
user:scidbadmin,: 102
user:scidb-public-...,: 317
...