goosemania

SELECT pid, query_start, age(clock_timestamp(), query_start), usename, query
    FROM pg_stat_activity WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' ORDER BY query_start desc;

goosemania

# count number of units with compressed repodata (5 is id of Binary data)
mongo pulp_database --eval 'db.units_rpm.find({"repodata.primary": {$type: 5}}).count()'

# count total number of units
mongo pulp_database --eval 'db.units_rpm.count()'

# migration trackers status
mongo pulp_database --eval 'db.migration_trackers.find().shellPrint()'