Instructions (not for the faint of heart) for replicating the database are posted. Questions/issues related to replication should be directed to Andrei Mamoutkine.
2024-07-26 23:10: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 | 9495 | 2013-05-07 23:11:03 | 2024-07-26 07:31:04 |
| identifications | 196982 | 2024-07-26 12:07:47 | 2024-07-26 12:07:47 |
| isolated_tracklets | 46472236 | 2024-07-26 22:58:21 | 2024-07-26 22:58:21 |
| mpc_indices | 396 | 2024-07-26 23:00:02 | 2024-07-26 23:00:02 |
| numbered_identifications | 1125961 | 2024-07-20 22:41:03 | 2024-07-20 22:41:03 |
| numbered_mps | 720000 | 2024-07-23 01:32:19 | 2024-07-23 01:32:19 |
| 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 | 439865756 | 2024-07-26 13:56:21 | 2024-07-26 18:57:23 |
| orbit_uncertainties | 785561 | 2019-06-05 12:14:34 | 2024-07-21 08:35:12 |
| orbits | 1401633 | 2024-07-26 17:46:37 | 2024-07-26 18:31:03 |
| 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 | 19 | 2024-07-26 13:33:20.464664 | 2024-07-26 23:08:13.926242 |
| neocp_events | 231384 | 2024-07-26 23:08:16.788397 | 2024-07-26 23:08:16.788397 |
| neocp_obs_archive | 588260 | 2024-07-26 23:08:13.923874 | 2024-07-26 23:08:13.923874 |
| neocp_obs | 220 | 2024-07-26 23:08:13.919772 | 2024-07-26 23:08:13.919772 |
| neocp_prev_des | 60434 | 2024-07-26 17:46:00.554151 | 2024-07-26 17:46:00.554151 |
| neocp_var | 33934 | 2024-07-26 23:08:16.758906 | 2024-07-26 23:08:16.758906 |
| current_identifications | 1910551 | 2024-07-26 17:45:42.47738 | 2024-07-26 17:46:02.523226 |
| numbered_identifications | 720783 | 2024-07-19 15:03:40.605385 | 2024-07-19 15:03:40.605385 |
| primary_objects | 1433389 | 2024-07-26 17:45:42.44674 | 2024-07-26 17:45:42.44674 |
| obs_sbn | 450688647 | 2024-07-26 18:41:03.432709-04 | 2024-07-26 19:09:42.200595-04 |
| obs_alterations_deletions | 1288256 | 2024-07-26 11:34:22.699612 | 2024-07-26 11:34:22.699612 |
| obs_alterations_redesignations | 3781 | 2024-07-25 20:55:19.871452 | 2024-07-25 20:55:19.871452 |
| obs_alterations_unassociations | 313613 | 2024-07-26 13:28:46.8113 | 2024-07-26 13:28:46.8113 |
| mpc_orbits | 1381245 | 2022-02-18 17:14:10.068948 | 2024-07-26 23:09:41.039891 |
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 | 450688609 | 2024-07-26 22:58:18.284904 | 2024-07-26 23:00:02.525863 |
| MPC_mpcweb5 | obs_sbn | 450688647 | 2024-07-26 23:09:42.200595 | 2024-07-26 23:13:04.369888 |
| SBN_to_AWS | obs_sbn | 450688656 | 2024-07-26 23:18:08.540876 | 2024-07-26 23:18:13.874195 |
| MPC_marsden | current_identifications | 1910551 | 2024-07-26 17:46:02.523226 | 2024-07-26 23:21:23.023381 |
| MPC_mpcweb5 | current_identifications | 1910551 | 2024-07-26 17:46:02.523226 | 2024-07-26 23:21:24.012464 |
| SBN_to_AWS | current_identifications | 1910551 | 2024-07-26 17:46:02.523226 | 2024-07-26 23:21:25.205284 |
| MPC_marsden | mpc_orbits | 1381245 | 2024-07-26 23:09:41.039891 | 2024-07-26 23:21:25.609231 |
| MPC_mpcweb5 | mpc_orbits | 1381245 | 2024-07-26 23:09:41.039891 | 2024-07-26 23:21:27.930057 |
| SBN_to_AWS | mpc_orbits | 1381245 | 2024-07-26 23:09:41.039891 | 2024-07-26 23:21:29.121191 |
| MPC_marsden | numbered_identifications | 720783 | 2024-07-19 15:03:40.605385 | 2024-07-26 23:21:30.083446 |
| MPC_mpcweb5 | numbered_identifications | 720783 | 2024-07-19 15:03:40.605385 | 2024-07-26 23:21:30.372092 |
| SBN_to_AWS | numbered_identifications | 720783 | 2024-07-19 15:03:40.605385 | 2024-07-26 23:21:30.649233 |
| MPC_marsden | neocp_els | 19 | 2024-07-26 23:21:06.272575 | 2024-07-26 23:21:30.830703 |
| MPC_mpcweb5 | neocp_els | 19 | 2024-07-26 23:21:06.272575 | 2024-07-26 23:21:30.920419 |
| SBN_to_AWS | neocp_els | 19 | 2024-07-26 23:21:06.272575 | 2024-07-26 23:21:31.003282 |
| MPC_marsden | neocp_events | 231387 | 2024-07-26 23:20:36.36578 | 2024-07-26 23:21:31.090066 |
| MPC_mpcweb5 | neocp_events | 231387 | 2024-07-26 23:20:36.36578 | 2024-07-26 23:21:31.278586 |
| SBN_to_AWS | neocp_events | 231387 | 2024-07-26 23:20:36.36578 | 2024-07-26 23:21:31.442397 |
| MPC_marsden | neocp_obs | 229 | 2024-07-26 23:20:35.642355 | 2024-07-26 23:21:31.567067 |
| MPC_mpcweb5 | neocp_obs | 229 | 2024-07-26 23:20:35.642355 | 2024-07-26 23:21:31.657069 |
| SBN_to_AWS | neocp_obs | 229 | 2024-07-26 23:20:35.642355 | 2024-07-26 23:21:31.741766 |
| MPC_marsden | neocp_obs_archive | 588269 | 2024-07-26 23:20:35.64762 | 2024-07-26 23:21:31.830584 |
| MPC_mpcweb5 | neocp_obs_archive | 588269 | 2024-07-26 23:20:35.64762 | 2024-07-26 23:21:31.996889 |
| SBN_to_AWS | neocp_obs_archive | 588269 | 2024-07-26 23:20:35.64762 | 2024-07-26 23:21:32.181469 |
| MPC_marsden | neocp_prev_des | 60434 | 2024-07-26 17:46:00.554151 | 2024-07-26 23:21:32.341743 |
| MPC_mpcweb5 | neocp_prev_des | 60434 | 2024-07-26 17:46:00.554151 | 2024-07-26 23:21:32.458264 |
| SBN_to_AWS | neocp_prev_des | 60434 | 2024-07-26 17:46:00.554151 | 2024-07-26 23:21:32.582669 |
| MPC_marsden | neocp_var | 33934 | 2024-07-26 23:20:36.343757 | 2024-07-26 23:21:32.688977 |
| MPC_mpcweb5 | neocp_var | 33934 | 2024-07-26 23:20:36.343757 | 2024-07-26 23:21:32.790941 |
| SBN_to_AWS | neocp_var | 35934 | 2024-07-26 23:20:36.343757 | 2024-07-26 23:21:32.879105 |
| MPC_marsden | primary_objects | 1433389 | 2024-07-26 17:45:42.44674 | 2024-07-26 23:21:32.978559 |
| MPC_mpcweb5 | primary_objects | 1433389 | 2024-07-26 17:45:42.44674 | 2024-07-26 23:21:33.654917 |
| SBN_to_AWS | primary_objects | 1433389 | 2024-07-26 17:45:42.44674 | 2024-07-26 23:21:34.450861 |
| MPC_marsden | obs_alterations_corrections | 2024-07-26 23:21:34.739873 | ||
| MPC_mpcweb5 | obs_alterations_corrections | 2024-07-26 23:21:34.832214 | ||
| SBN_to_AWS | obs_alterations_corrections | 2024-07-26 23:21:34.91499 | ||
| MPC_marsden | obs_alterations_deletions | 1288256 | 2024-07-26 11:34:22.699612 | 2024-07-26 23:21:34.99998 |
| MPC_mpcweb5 | obs_alterations_deletions | 1288256 | 2024-07-26 11:34:22.699612 | 2024-07-26 23:21:35.566193 |
| SBN_to_AWS | obs_alterations_deletions | 1288256 | 2024-07-26 11:34:22.699612 | 2024-07-26 23:21:36.211738 |
| MPC_marsden | obs_alterations_redesignations | 3781 | 2024-07-25 20:55:19.871452 | 2024-07-26 23:21:36.464439 |
| MPC_mpcweb5 | obs_alterations_redesignations | 3781 | 2024-07-25 20:55:19.871452 | 2024-07-26 23:21:36.558708 |
| SBN_to_AWS | obs_alterations_redesignations | 3781 | 2024-07-25 20:55:19.871452 | 2024-07-26 23:21:36.644517 |