Skip to content
Snippets Groups Projects
Select Git revision
  • c589c4b35c947409673ccbc078ba48d1d20e28f6
  • main default protected
  • idacs_experiments
  • postgres_idacs
  • memgraph_fabian
  • postgres_julian
  • dev_ma
  • test_results
  • FZ_changed_code
  • FZ_Memgraph
10 results

docker-compose.yml

Blame
  • monitor_hshinfo 638 B
    #!/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;400:;200: hshinfo.seq_raw_library_ids"
    echo "P watch_luh_ids remaining_luh_ids=$REMAINING_LUH_IDS;2000:;500: hshinfo.usernames_luh with allocated = false"