22 May 2023
Please report concerns!
Instructions (not for the faint of heart) for replicating the database are on the SBN Wiki. Questions/issues related to replication should be directed to Andrei Mamoutkine.
2023-05-30 17:20:01 (GMT)
Status of all major tables from MariaDB (mpc_development) and two parallel Postgres databases (mpcbeta and mpc_sbn). It includes list of all major tables, number of records in each tables, the latest updated record in each table. A color code corresponds to records updated less than 1 day, from 1 to 3 days and older than 3 days. Updated every 5 min. GMT timestamp of update is at the top left of the page.
Source file of data: statusDB.csv
| Table | Count | Created_at | Updated_at |
| close_approaches | 223366 | 2019-05-23 19:22:13 | 2019-05-23 19:22:13 |
| comet_names | 4586 | 2017-03-15 16:46:33 | 2017-03-15 16:46:33 |
| comet_orbit_uncertainties | 1015 | 2019-06-04 12:15:27 | 2019-06-04 12:15:27 |
| comet_orbits | 12245 | 2023-05-30 05:09:32 | 2023-05-30 05:31:04 |
| identifications | 611660 | 2023-05-29 12:06:10 | 2023-05-29 12:06:10 |
| isolated_tracklets | 40161554 | 2023-05-30 10:58:32 | 2023-05-30 10:58:32 |
| mpc_indices | 396 | 2023-05-30 17:00:05 | 2023-05-30 17:00:05 |
| numbered_identifications | 1000438 | 2023-04-21 05:37:41 | 2023-04-21 05:37:41 |
| numbered_mps | 620108 | 2011-10-27 00:36:35 | 2023-05-26 17:36:43 |
| obs_request_observers | 52 | 2019-07-24 16:57:48 | 2019-07-24 16:57:48 |
| obs_request_users | 7 | 2015-12-04 00:25:22 | 2015-12-04 00:25:22 |
| observations | 386669307 | 2023-05-30 15:22:19 | 2023-05-30 15:22:19 |
| orbit_uncertainties | 787153 | 2019-06-03 12:14:53 | 2023-04-21 05:47:13 |
| orbits | 1284454 | 2023-05-30 15:22:24 | 2023-05-30 15:31:03 |
| perturbed_orbits | 175724170 | 2018-09-27 17:20:33 | 2018-09-27 17:20:33 |
| radar_observations | 1507 | 2019-05-30 03:12:41 | 2019-05-30 03:12:41 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 54 | 2023-05-27 07:21:25.998092 | 2023-05-30 17:18:22.439352 |
| neocp_events | 182149 | 2023-05-30 17:18:25.262286 | 2023-05-30 17:18:25.262286 |
| neocp_obs_archive | 475956 | 2023-05-30 17:18:22.434535 | 2023-05-30 17:18:22.434535 |
| neocp_obs | 734 | 2023-05-30 17:18:22.431153 | 2023-05-30 17:18:22.431153 |
| neocp_prev_des | 54028 | 2023-05-30 16:19:56.442957 | 2023-05-30 16:19:56.442957 |
| neocp_var | 101864 | 2023-05-30 17:18:25.230089 | 2023-05-30 17:18:25.230089 |
| current_identifications | 1812543 | 2023-05-30 13:41:52.426829 | 2023-05-30 17:11:17.89389 |
| numbered_identifications | 620865 | 2023-04-20 04:45:11.100617 | 2023-04-20 04:45:11.100617 |
| primary_objects | 1211321 | 2021-09-28 18:55:58.729643 | 2021-09-28 18:55:58.729643 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 54 | 2023-05-27 07:21:25.998092 | 2023-05-30 17:18:22.439352 |
| neocp_events | 182149 | 2023-05-30 17:18:25.262286 | 2023-05-30 17:18:25.262286 |
| neocp_obs_archive | 475956 | 2023-05-30 17:18:22.434535 | 2023-05-30 17:18:22.434535 |
| neocp_obs | 734 | 2023-05-30 17:18:22.431153 | 2023-05-30 17:18:22.431153 |
| neocp_prev_des | 54028 | 2023-05-30 16:19:56.442957 | 2023-05-30 16:19:56.442957 |
| neocp_var | 101864 | 2023-05-30 17:18:25.230089 | 2023-05-30 17:18:25.230089 |
| current_identifications | 1812543 | 2023-05-30 13:41:52.426829 | 2023-05-30 17:11:17.89389 |
| numbered_identifications | 620865 | 2023-04-20 04:45:11.100617 | 2023-04-20 04:45:11.100617 |
| primary_objects | 1341575 | 2023-05-30 16:19:31.613295 | 2023-05-30 16:19:31.613295 |
| obs_sbn | 395863683 | 2023-05-22 18:56:03.155628-04 | 2023-05-30 13:21:21.786499-04 |
| obs_alterations_deletions | 906180 | 2023-05-30 16:40:39.815808 | 2023-05-30 16:40:39.815808 |
| obs_alterations_redesignations | 2396 | 2023-05-26 15:10:51.15547 | 2023-05-26 15:10:51.15547 |
| obs_alterations_unassociations | 19176 | 2023-05-29 22:01:21.026704 | 2023-05-29 22:01:21.026704 |
| mpc_orbits | 1275587 | 2023-05-30 17:28:31.539972 | 2023-05-30 17:28:35.47953 |
YYYY-MM-DD - latest record is older than 3 days
YYYY-MM-DD - latest record is older than 1 day
YYYY-MM-DD - latest record is less than 1 day old
| Server | Table | Count | Updated_at | Queried_at |
| MPC_marsden | obs_sbn | 395857530 | 2023-05-30 12:05:43.38574 | 2023-05-30 12:25:15.783031 |
| MPC_mpcweb5 | obs_sbn | 395857655 | 2023-05-30 12:34:33.637 | 2023-05-30 12:35:15.343147 |
| SBN_to_AWS | obs_sbn | 395857679 | 2023-05-30 12:42:00.561331 | 2023-05-30 12:42:10.212944 |
| MPC_marsden | current_identifications | 1812374 | 2023-05-30 12:52:20.031081 | 2023-05-30 12:52:24.065929 |
| MPC_mpcweb5 | current_identifications | 1812374 | 2023-05-30 12:52:20.031081 | 2023-05-30 12:52:24.598884 |
| SBN_to_AWS | current_identifications | 1812374 | 2023-05-30 12:52:20.031081 | 2023-05-30 12:52:24.743037 |
| MPC_marsden | mpc_orbits | 1275407 | 2023-05-30 12:51:54.137254 | 2023-05-30 12:52:24.982314 |
| MPC_mpcweb5 | mpc_orbits | 1275407 | 2023-05-30 12:51:54.137254 | 2023-05-30 12:52:26.599534 |
| SBN_to_AWS | mpc_orbits | 1275407 | 2023-05-30 12:51:54.137254 | 2023-05-30 12:52:26.759288 |
| MPC_marsden | numbered_identifications | 620865 | 2023-04-20 04:45:11.100617 | 2023-05-30 12:52:26.957209 |
| MPC_mpcweb5 | numbered_identifications | 620865 | 2023-04-20 04:45:11.100617 | 2023-05-30 12:52:27.168529 |
| SBN_to_AWS | numbered_identifications | 620865 | 2023-04-20 04:45:11.100617 | 2023-05-30 12:52:27.274958 |
| MPC_marsden | neocp_els | 53 | 2023-05-30 11:45:47.782862 | 2023-05-30 12:52:27.403267 |
| MPC_mpcweb5 | neocp_els | 53 | 2023-05-30 11:45:47.782862 | 2023-05-30 12:52:27.482528 |
| SBN_to_AWS | neocp_els | 53 | 2023-05-30 11:45:47.782862 | 2023-05-30 12:52:27.560263 |
| MPC_marsden | neocp_events | 182103 | 2023-05-30 11:45:51.447388 | 2023-05-30 12:52:27.639888 |
| MPC_mpcweb5 | neocp_events | 182103 | 2023-05-30 11:45:51.447388 | 2023-05-30 12:52:27.764658 |
| SBN_to_AWS | neocp_events | 182103 | 2023-05-30 11:45:51.447388 | 2023-05-30 12:52:27.857126 |
| MPC_marsden | neocp_obs | 726 | 2023-05-30 11:45:47.772374 | 2023-05-30 12:52:27.95331 |
| MPC_mpcweb5 | neocp_obs | 726 | 2023-05-30 11:45:47.772374 | 2023-05-30 12:52:28.033366 |
| SBN_to_AWS | neocp_obs | 726 | 2023-05-30 11:45:47.772374 | 2023-05-30 12:52:28.111361 |
| MPC_marsden | neocp_obs_archive | 475935 | 2023-05-30 11:45:47.777844 | 2023-05-30 12:52:28.190629 |
| MPC_mpcweb5 | neocp_obs_archive | 475935 | 2023-05-30 11:45:47.777844 | 2023-05-30 12:52:28.369417 |
| SBN_to_AWS | neocp_obs_archive | 475935 | 2023-05-30 11:45:47.777844 | 2023-05-30 12:52:28.462562 |
| MPC_marsden | neocp_prev_des | 54027 | 2023-05-30 11:08:43.39271 | 2023-05-30 12:52:28.574802 |
| MPC_mpcweb5 | neocp_prev_des | 54027 | 2023-05-30 11:08:43.39271 | 2023-05-30 12:52:28.677046 |
| SBN_to_AWS | neocp_prev_des | 54027 | 2023-05-30 11:08:43.39271 | 2023-05-30 12:52:28.762222 |
| MPC_marsden | neocp_var | 97720 | 2023-05-30 11:45:51.420906 | 2023-05-30 12:52:28.848203 |
| MPC_mpcweb5 | neocp_var | 97720 | 2023-05-30 11:45:51.420906 | 2023-05-30 12:52:28.974194 |
| SBN_to_AWS | neocp_var | 97720 | 2023-05-30 11:45:51.420906 | 2023-05-30 12:52:29.074741 |
| MPC_marsden | primary_objects | 1341406 | 2023-05-30 12:52:20.01741 | 2023-05-30 12:52:29.171582 |
| MPC_mpcweb5 | primary_objects | 1341406 | 2023-05-30 12:52:20.01741 | 2023-05-30 12:52:29.530853 |
| SBN_to_AWS | primary_objects | 1341406 | 2023-05-30 12:52:20.01741 | 2023-05-30 12:52:29.666005 |
| MPC_marsden | obs_alterations_corrections | 2023-05-30 12:52:29.876196 | ||
| MPC_mpcweb5 | obs_alterations_corrections | 2023-05-30 12:52:29.956036 | ||
| SBN_to_AWS | obs_alterations_corrections | 2023-05-30 12:52:30.033727 | ||
| MPC_marsden | obs_alterations_deletions | 906176 | 2023-05-29 22:01:14.000798 | 2023-05-30 12:52:30.112582 |
| MPC_mpcweb5 | obs_alterations_deletions | 906176 | 2023-05-29 22:01:14.000798 | 2023-05-30 12:52:30.614257 |
| SBN_to_AWS | obs_alterations_deletions | 906176 | 2023-05-29 22:01:14.000798 | 2023-05-30 12:52:30.725211 |
| MPC_marsden | obs_alterations_redesignations | 2396 | 2023-05-26 15:10:51.15547 | 2023-05-30 12:52:30.869086 |
| MPC_mpcweb5 | obs_alterations_redesignations | 2396 | 2023-05-26 15:10:51.15547 | 2023-05-30 12:52:30.950618 |
| SBN_to_AWS | obs_alterations_redesignations | 2396 | 2023-05-26 15:10:51.15547 | 2023-05-30 12:52:31.028796 |