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.
2024-04-27 02:50:01 (GMT)
Status of all major tables from MariaDB (mpc_development) and Postgres database (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 | 9355 | 2024-04-26 18:40:43 | 2024-04-26 18:40:43 |
| identifications | 192858 | 2024-04-26 12:08:20 | 2024-04-26 12:08:20 |
| isolated_tracklets | 45619485 | 2024-04-27 02:48:04 | 2024-04-27 02:48:04 |
| mpc_indices | 396 | 2024-02-28 22:30:01 | 2024-02-28 22:30:01 |
| numbered_identifications | 1075938 | 2024-04-13 00:27:39 | 2024-04-13 00:27:39 |
| numbered_mps | 680000 | 2013-03-28 19:49:14 | 2024-04-22 15:44:00 |
| 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 | 432057741 | 2024-04-26 19:09:22 | 2024-04-26 19:09:22 |
| orbit_uncertainties | 785635 | 2019-06-05 12:14:33 | 2024-04-12 19:27:19 |
| orbits | 1374724 | 2024-04-03 12:22:05 | 2024-04-26 12:31:31 |
| perturbed_orbits | 175724170 | 2018-09-27 17:20:33 | 2018-09-27 17:20:33 |
| radar_observations | 1507 | 2023-06-23 18:31:24 | 2023-06-23 18:31:24 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 26 | 2024-04-26 17:53:31.960763 | 2024-04-26 23:50:20.827476 |
| neocp_events | 223619 | 2024-04-26 23:50:24.334816 | 2024-04-26 23:50:24.334816 |
| neocp_obs_archive | 570721 | 2024-04-26 23:50:20.825102 | 2024-04-26 23:50:20.825102 |
| neocp_obs | 413 | 2024-04-26 23:50:20.820299 | 2024-04-26 23:50:20.820299 |
| neocp_prev_des | 59455 | 2024-04-26 09:48:02.996578 | 2024-04-26 09:48:02.996578 |
| neocp_var | 51301 | 2024-04-26 23:50:24.308857 | 2024-04-26 23:50:24.308857 |
| current_identifications | 1885165 | 2024-04-26 22:15:45.470965 | 2024-04-26 22:15:45.470965 |
| numbered_identifications | 680780 | 2024-04-02 18:08:30.5031 | 2024-04-02 18:08:30.5031 |
| primary_objects | 1410007 | 2024-04-26 22:15:45.439155 | 2024-04-26 22:15:45.439155 |
| obs_sbn | 443076787 | 2024-04-26 22:40:04.270844-04 | 2024-04-26 22:48:08.51285-04 |
| obs_alterations_deletions | 1271517 | 2024-04-26 21:51:52.909002 | 2024-04-26 21:51:52.909002 |
| obs_alterations_redesignations | 3680 | 2024-04-15 21:22:02.424668 | 2024-04-15 21:22:02.424668 |
| obs_alterations_unassociations | 131927 | 2024-04-27 00:10:16.874613 | 2024-04-27 00:10:16.874613 |
| mpc_orbits | 1354318 | 2021-02-04 00:04:15.56764 | 2024-04-27 02:39:59.888845 |
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 | 443076609 | 2024-04-27 01:48:08.160871 | 2024-04-27 02:00:03.021823 |
| MPC_mpcweb5 | obs_sbn | 443076681 | 2024-04-27 02:09:30.521414 | 2024-04-27 02:14:15.124738 |
| SBN_to_AWS | obs_sbn | 443076720 | 2024-04-27 02:18:24.799439 | 2024-04-27 02:22:23.665583 |
| MPC_marsden | current_identifications | 1885165 | 2024-04-26 22:15:45.470965 | 2024-04-27 02:35:47.863311 |
| MPC_mpcweb5 | current_identifications | 1885165 | 2024-04-26 22:15:45.470965 | 2024-04-27 02:35:48.333336 |
| SBN_to_AWS | current_identifications | 1885165 | 2024-04-26 22:15:45.470965 | 2024-04-27 02:35:48.469845 |
| MPC_marsden | mpc_orbits | 1354318 | 2024-04-27 02:09:29.581253 | 2024-04-27 02:35:48.717186 |
| MPC_mpcweb5 | mpc_orbits | 1354318 | 2024-04-27 02:09:29.581253 | 2024-04-27 02:35:49.430225 |
| SBN_to_AWS | mpc_orbits | 1354318 | 2024-04-27 02:09:29.581253 | 2024-04-27 02:35:49.56668 |
| MPC_marsden | numbered_identifications | 680780 | 2024-04-02 18:08:30.5031 | 2024-04-27 02:35:49.776838 |
| MPC_mpcweb5 | numbered_identifications | 680780 | 2024-04-02 18:08:30.5031 | 2024-04-27 02:35:49.954147 |
| SBN_to_AWS | numbered_identifications | 680780 | 2024-04-02 18:08:30.5031 | 2024-04-27 02:35:50.047702 |
| MPC_marsden | neocp_els | 26 | 2024-04-26 23:50:20.827476 | 2024-04-27 02:35:50.163884 |
| MPC_mpcweb5 | neocp_els | 26 | 2024-04-26 23:50:20.827476 | 2024-04-27 02:35:50.226009 |
| SBN_to_AWS | neocp_els | 26 | 2024-04-26 23:50:20.827476 | 2024-04-27 02:35:50.285993 |
| MPC_marsden | neocp_events | 223619 | 2024-04-26 23:50:24.334816 | 2024-04-27 02:35:50.347261 |
| MPC_mpcweb5 | neocp_events | 223619 | 2024-04-26 23:50:24.334816 | 2024-04-27 02:35:50.453189 |
| SBN_to_AWS | neocp_events | 223619 | 2024-04-26 23:50:24.334816 | 2024-04-27 02:35:50.527478 |
| MPC_marsden | neocp_obs | 413 | 2024-04-26 23:50:20.820299 | 2024-04-27 02:35:50.610566 |
| MPC_mpcweb5 | neocp_obs | 413 | 2024-04-26 23:50:20.820299 | 2024-04-27 02:35:50.673062 |
| SBN_to_AWS | neocp_obs | 413 | 2024-04-26 23:50:20.820299 | 2024-04-27 02:35:50.733199 |
| MPC_marsden | neocp_obs_archive | 570721 | 2024-04-26 23:50:20.825102 | 2024-04-27 02:35:50.794613 |
| MPC_mpcweb5 | neocp_obs_archive | 570721 | 2024-04-26 23:50:20.825102 | 2024-04-27 02:35:50.957586 |
| SBN_to_AWS | neocp_obs_archive | 570721 | 2024-04-26 23:50:20.825102 | 2024-04-27 02:35:51.035872 |
| MPC_marsden | neocp_prev_des | 59455 | 2024-04-26 09:48:02.996578 | 2024-04-27 02:35:51.139489 |
| MPC_mpcweb5 | neocp_prev_des | 59455 | 2024-04-26 09:48:02.996578 | 2024-04-27 02:35:51.221191 |
| SBN_to_AWS | neocp_prev_des | 59455 | 2024-04-26 09:48:02.996578 | 2024-04-27 02:35:51.290248 |
| MPC_marsden | neocp_var | 51301 | 2024-04-26 23:50:24.308857 | 2024-04-27 02:35:51.359093 |
| MPC_mpcweb5 | neocp_var | 51301 | 2024-04-26 23:50:24.308857 | 2024-04-27 02:35:51.438466 |
| SBN_to_AWS | neocp_var | 53301 | 2024-04-26 23:50:24.308857 | 2024-04-27 02:35:51.509774 |
| MPC_marsden | primary_objects | 1410007 | 2024-04-26 22:15:45.439155 | 2024-04-27 02:35:51.579037 |
| MPC_mpcweb5 | primary_objects | 1410007 | 2024-04-26 22:15:45.439155 | 2024-04-27 02:35:51.997395 |
| SBN_to_AWS | primary_objects | 1410007 | 2024-04-26 22:15:45.439155 | 2024-04-27 02:35:52.128873 |
| MPC_marsden | obs_alterations_corrections | 2024-04-27 02:35:52.35157 | ||
| MPC_mpcweb5 | obs_alterations_corrections | 2024-04-27 02:35:52.413707 | ||
| SBN_to_AWS | obs_alterations_corrections | 2024-04-27 02:35:52.473519 | ||
| MPC_marsden | obs_alterations_deletions | 1271517 | 2024-04-26 21:51:52.909002 | 2024-04-27 02:35:52.534649 |
| MPC_mpcweb5 | obs_alterations_deletions | 1271517 | 2024-04-26 21:51:52.909002 | 2024-04-27 02:35:52.844792 |
| SBN_to_AWS | obs_alterations_deletions | 1271517 | 2024-04-26 21:51:52.909002 | 2024-04-27 02:35:52.952852 |
| MPC_marsden | obs_alterations_redesignations | 3680 | 2024-04-15 21:22:02.424668 | 2024-04-27 02:35:53.114401 |
| MPC_mpcweb5 | obs_alterations_redesignations | 3680 | 2024-04-15 21:22:02.424668 | 2024-04-27 02:35:53.178538 |
| SBN_to_AWS | obs_alterations_redesignations | 3680 | 2024-04-15 21:22:02.424668 | 2024-04-27 02:35:53.23909 |