Skip to content
Snippets Groups Projects
Select Git revision
  • 02c531f1645941531beccfba75acbc9d907514dc
  • master default protected
2 results

monitor_hshinfo

Blame
    • monitor_hshinfo 639 B
    1
    2
    3
    4
    5
    6
    7
    8 
    

    

    

    #!/bin/bash

REMAINING_LIBRARY_IDS=$(sudo -u postgres -- psql -qtAX -d hshinfo -c "select (maximum_value::bigint - (SELECT last_value FROM hshinfo.seq_raw_library_id)) from information_schema.sequences where sequence_schema = 'hshinfo' and sequence_name = 'seq_raw_library_id';")

REMAINING_LUH_IDS=$(sudo -u postgres -- psql -qtAX -d hshinfo -c "select count(*) from hshinfo.username_luh where allocated = false;")

echo "P watch_lib_ids remaining_library_ids=$REMAINING_LIBRARY_IDS;2000:;500: hshinfo.seq_raw_library_ids"
echo "P watch_luh_ids remaining_luh_ids=$REMAINING_LUH_IDS;2000:;500: hshinfo.usernames_luh with allocated = false"