Skip to content

User statistics

dickgroenenberg edited this page Oct 27, 2020 · 4 revisions

Galaxydb user statistics

Obtain Galaxy-database user statistics with a PSQL query invoked
and sorted with a bash shell script (stat_users.sh).

This script presumes galaxydb is installed under user postgres
and is executed from a user account that has sudo permissions

For our Galaxy instances this means that stat_users.sh should
be executed as user ubuntu

The output file will be named "user_stats_{date_&_time}.txt"
and will show disk_usage & whether or not an account is deleted,
purged or activated.

The top half are accounts that are not hashed and sorted on email address.
The bottom half are hashed entries sorted by disk usage.

user_stats.jpg

Clone this wiki locally