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-10-14 08:34:02
Institution/Individual Alias Status ReplicationLagBytes Institution/Individual Alias Status ReplicationLagBytes
LSST_BrazilProd_other_tables Active 0 LSST_BrazilProd_obs Active 0
Rubin_other_tables Active 0 Rubin_obs Active 0
Number of inactive replication slots 0
Number of replication slots 4
MaxXMIN 777966369
Difference[MaxXmin-MinXmin] 0
Fully synchronized LSN 676/4f51c998
Replications stats rows 4
Number of locks processes 13
Disk space used 534G
Disk used % 29%
Disk %util 56.60%
pg_wal dir size 2.1G
Number of WAL-files 129