A page for developers and ops staff recording handy queries and updates

For Devs: Get a psql console in the k8s cluster by finding the pod name of one of the running psql instances and running kubectl exec PODNMAE -n dcb-dev -it -- psql

List bib record counts by source system

select h.name, c.count 
from ( select source_system_id id, count(*) count from bib_record group by source_system_id ) c,
     host_lms h 
where c.id = h.id;

Refresh the stats (Will improve performance on ingest and reclaim deleted space)

vacuum analyze;
possibly better:
vacuum (verbose, analyze, skip_locked);

Check for deleted cluster records (There should be NO clusters with no bib record where is_deleted is null)

select is_deleted,
       count(*) 
from cluster_record cr 
where not exists ( select br. from bib_record br where br.contributes_to = cr.id ) 
group by is_deleted;

Switch on a specific source for ingest

Ingest status

Useful current status info

DCB

Handy SQL for DCB Ops

List bib record counts by source system

Refresh the stats (Will improve performance on ingest and reclaim deleted space)

Check for deleted cluster records (There should be NO clusters with no bib record where is_deleted is null)