Minor Planet Center Annex

@ SBN

SBN Postgres database service dashboard

We are pleased to announce an upcoming enhancement to our MPC_SBN Postgres Database Dashboard. This upgrade will provide a more comprehensive view of the status of logical replication to multiple subscribers, with a primary focus on identifying critical conditions.

The primary objective of this update is to promptly identify and address critical conditions, such as inactive replication slots or subscribers falling significantly behind. These conditions have the potential to result in the accumulation of a substantial number of Write-Ahead Log (WAL) files, leading to increased disk space utilization. In the most extreme cases, they may even lead to the suspension of the Postgres service on the SBN side.

Currently, the Dashboard serves as an informational tool, including warnings in critical situations. With this update, we aim to gather statistical data to establish more reliable thresholds for the automatic removal of specific replication slots in the most critical scenarios.

We believe that this enhancement will greatly improve our ability to maintain the health and efficiency of our MPC_SBN Postgres Database, ensuring uninterrupted service and optimal resource utilization.

Stay tuned for further updates and implementation details. If you have any questions or concerns, please do not hesitate to reach out to Andrei Mamoutkine.

Local Time: 2024-07-18 08:09:02
Institution/Individual Alias Status ReplicationLagBytes Institution/Individual Alias Status ReplicationLagBytes
Sputnik_other_tables Active 0 Sputnik_obs Active 0
SDS_other_tables Active 0 SDS_obs Active 0
ESA_other_tables Active 0 ODP_other_tables Active 0
ODP_obs Active 0 Rubin_other_tables Active 0
Rubin_usdf_other_tables Active 0 AsteroidInst_obs Active 0
PanSTARRS_obs Active 0 ADoppler_other_tables Active 0
ADoppler_obs Active 0 CalTech2_other_tables Active 0
CalTech2_obs Active 0 JPL_other_tables Active 0
JPL_obs Active 0 Rubin_usdf_obs Active 0
AsteroidInst_other_tables Active 0 PVanWylen_obs Active 0
PVanWylen_other_tables Active 0 CSS_sibyl_obs Active 0
PanSTARRS_other_tables Active 0 CSS_sibyl_other_tables Active 0
LSST_BrazilProd_obs Active 0 Rubin_obs Active 0
LSST_BrazilProd_other_tables Active 0 PMO_other_tables Active 0
PMO_obs Active 0
Number of inactive replication slots 0
Number of replication slots 32
MaxXMIN 735913444
Difference[MaxXmin-MinXmin] 0
Fully synchronized LSN 623/acf9fed0
Replications stats rows 32
Number of locks processes 30
Disk space used 536G
Disk used % 29%
Disk %util 0.00%
pg_wal dir size 2.1G
Number of WAL-files 129