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.
| Institution/Individual Alias | Status | ReplicationLagBytes | Institution/Individual Alias | Status | ReplicationLagBytes |
|---|---|---|---|---|---|
| CSS_sibyl_obs | Active | 0 | TLinder_obs | Active | 0 |
| PVanWylen_obs | Active | 0 | AsteroidInst_other_tables | Active | 0 |
| LSST_BrazilProd_other_tables | Active | 0 | Rubin_other_tables | Active | 0 |
| ODP_obs | Active | 0 | ODP_other_tables | Active | 0 |
| Sputnik_other_tables | Active | 0 | CSS_sibyl_other_tables | Active | 0 |
| CalTech2_other_tables | Active | 0 | LSST_BrazilProd_obs | Active | 0 |
| MPC_loop_other_tables | Active | 0 | CalTech2_obs | Active | 0 |
| ADoppler_obs | Active | 0 | PVanWylen_other_tables | Active | 0 |
| TLinder_other_tables | Active | 0 | ADoppler_other_tables | Active | 0 |
| PMO_obs | Active | 0 | JPL_obs | Active | 0 |
| PanSTARRS_other_tables | Active | 0 | PanSTARRS_obs | Active | 0 |
| ESA_obs | Active | 0 | SDS_obs | Active | 0 |
| MPC_loop_obs | Active | 0 | SDS_other_tables | Active | 0 |
| Sputnik_obs | Active | 0 | ESA_other_tables | Active | 0 |
| Rubin_usdf_other_tables | Active | 0 | Rubin_obs | Active | 0 |
| JPL_other_tables | Active | 0 | AsteroidInst_obs | Active | 0 |
| PMO_other_tables | Active | 0 | Rubin_usdf_obs | Active | 0 |
| Number of inactive replication slots | 0 |
| Number of replication slots | 34 |
| MaxXMIN | 712999513 |
| Difference[MaxXmin-MinXmin] | 0 |
| Fully synchronized LSN | 5f6/2b2e5b00 |
| Replications stats rows | 34 |
| Number of locks processes | 13 |
| Disk space used | 524G |
| Disk used % | 29% |
| Disk %util | 0.44% |
| pg_wal dir size | 2.1G |
| Number of WAL-files | 129 |