18 Sep 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-09-25 06:00:02 (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 | 9083 | 2023-09-21 21:32:38 | 2023-09-21 21:32:38 |
| identifications | 613066 | 2023-09-12 12:17:45 | 2023-09-12 12:17:45 |
| isolated_tracklets | 40795805 | 2023-09-25 05:58:19 | 2023-09-25 05:58:19 |
| mpc_indices | 396 | 2023-09-25 06:00:03 | 2023-09-25 06:00:03 |
| numbered_identifications | 1005134 | 2023-07-19 20:18:28 | 2023-07-19 20:18:28 |
| numbered_mps | 623827 | 2011-10-27 01:30:19 | 2023-08-14 21:24:27 |
| 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 | 397012657 | 2023-09-25 02:17:14 | 2023-09-25 04:11:35 |
| orbit_uncertainties | 787153 | 2019-06-03 12:14:53 | 2023-04-21 05:47:13 |
| orbits | 1313568 | 2023-09-25 02:17:26 | 2023-09-25 02:31:04 |
| 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 | 107 | 2023-09-24 09:08:53.602276 | 2023-09-25 06:01:39.618246 |
| neocp_events | 196759 | 2023-09-25 06:01:41.920021 | 2023-09-25 06:01:41.920021 |
| neocp_obs_archive | 508660 | 2023-09-25 06:01:39.616828 | 2023-09-25 06:01:39.616828 |
| neocp_obs | 1006 | 2023-09-25 06:01:39.612968 | 2023-09-25 06:01:39.612968 |
| neocp_prev_des | 55817 | 2023-09-25 05:37:03.605046 | 2023-09-25 05:37:03.605046 |
| neocp_var | 205401 | 2023-09-25 06:01:41.898048 | 2023-09-25 06:01:41.898048 |
| current_identifications | 1837594 | 2023-09-25 05:36:37.59433 | 2023-09-25 05:36:37.59433 |
| numbered_identifications | 624590 | 2020-07-30 16:51:34.796062 | 2023-08-28 16:21:41.295108 |
| 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 | 107 | 2023-09-24 09:08:53.602276 | 2023-09-25 06:01:39.618246 |
| neocp_events | 196759 | 2023-09-25 06:01:41.920021 | 2023-09-25 06:01:41.920021 |
| neocp_obs_archive | 508660 | 2023-09-25 06:01:39.616828 | 2023-09-25 06:01:39.616828 |
| neocp_obs | 1006 | 2023-09-25 06:01:39.612968 | 2023-09-25 06:01:39.612968 |
| neocp_prev_des | 55817 | 2023-09-25 05:37:03.605046 | 2023-09-25 05:37:03.605046 |
| neocp_var | 205401 | 2023-09-25 06:01:41.898048 | 2023-09-25 06:01:41.898048 |
| current_identifications | 1837594 | 2023-09-25 05:36:37.59433 | 2023-09-25 05:36:37.59433 |
| numbered_identifications | 624590 | 2020-07-30 16:51:34.796062 | 2023-08-28 16:21:41.295108 |
| primary_objects | 1365941 | 2023-09-25 05:36:37.56658 | 2023-09-25 05:36:37.56658 |
| obs_sbn | 408647124 | 2023-09-25 01:56:03.828367-04 | 2023-09-25 02:00:38.393905-04 |
| obs_alterations_deletions | 908635 | 2023-09-25 02:20:57.768853 | 2023-09-25 02:20:57.768853 |
| obs_alterations_redesignations | 2707 | 2023-08-28 22:22:13.362713 | 2023-08-28 22:22:13.362713 |
| obs_alterations_unassociations | 37608 | 2023-09-25 02:43:49.954093 | 2023-09-25 02:43:49.954093 |
| mpc_orbits | 1303856 | 2021-02-04 01:10:21.383471 | 2023-09-25 06:05:24.957169 |
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 | 408647025 | 2023-09-25 04:50:33.032399 | 2023-09-25 05:00:02.69682 |
| MPC_mpcweb5 | obs_sbn | 408647040 | 2023-09-25 05:08:12.892515 | 2023-09-25 05:10:42.13983 |
| SBN_to_AWS | obs_sbn | 408647042 | 2023-09-25 05:15:21.616532 | 2023-09-25 05:17:51.228645 |
| MPC_marsden | current_identifications | 1837593 | 2023-09-25 04:23:21.340915 | 2023-09-25 05:24:52.771284 |
| MPC_mpcweb5 | current_identifications | 1837593 | 2023-09-25 04:23:21.340915 | 2023-09-25 05:24:53.228839 |
| SBN_to_AWS | current_identifications | 1837593 | 2023-09-25 04:23:21.340915 | 2023-09-25 05:24:53.366089 |
| MPC_marsden | mpc_orbits | 1303855 | 2023-09-25 05:15:21.002376 | 2023-09-25 05:24:53.758092 |
| MPC_mpcweb5 | mpc_orbits | 1303855 | 2023-09-25 05:15:21.002376 | 2023-09-25 05:24:55.589106 |
| SBN_to_AWS | mpc_orbits | 1303855 | 2023-09-25 05:15:21.002376 | 2023-09-25 05:24:55.704049 |
| MPC_marsden | numbered_identifications | 624590 | 2023-08-28 16:21:41.295108 | 2023-09-25 05:24:55.935498 |
| MPC_mpcweb5 | numbered_identifications | 624590 | 2023-08-28 16:21:41.295108 | 2023-09-25 05:24:56.144414 |
| SBN_to_AWS | numbered_identifications | 624590 | 2023-08-28 16:21:41.295108 | 2023-09-25 05:24:56.242737 |
| MPC_marsden | neocp_els | 106 | 2023-09-25 05:09:41.629564 | 2023-09-25 05:24:56.3952 |
| MPC_mpcweb5 | neocp_els | 106 | 2023-09-25 05:09:41.629564 | 2023-09-25 05:24:56.467088 |
| SBN_to_AWS | neocp_els | 106 | 2023-09-25 05:09:41.629564 | 2023-09-25 05:24:56.535531 |
| MPC_marsden | neocp_events | 196752 | 2023-09-25 05:09:44.112162 | 2023-09-25 05:24:56.609622 |
| MPC_mpcweb5 | neocp_events | 196752 | 2023-09-25 05:09:44.112162 | 2023-09-25 05:24:56.735266 |
| SBN_to_AWS | neocp_events | 196752 | 2023-09-25 05:09:44.112162 | 2023-09-25 05:24:56.820077 |
| MPC_marsden | neocp_obs | 1002 | 2023-09-25 05:09:41.62343 | 2023-09-25 05:24:56.927395 |
| MPC_mpcweb5 | neocp_obs | 1002 | 2023-09-25 05:09:41.62343 | 2023-09-25 05:24:56.999164 |
| SBN_to_AWS | neocp_obs | 1002 | 2023-09-25 05:09:41.62343 | 2023-09-25 05:24:57.067942 |
| MPC_marsden | neocp_obs_archive | 508640 | 2023-09-25 05:09:41.627135 | 2023-09-25 05:24:57.145121 |
| MPC_mpcweb5 | neocp_obs_archive | 508640 | 2023-09-25 05:09:41.627135 | 2023-09-25 05:24:57.318282 |
| SBN_to_AWS | neocp_obs_archive | 508640 | 2023-09-25 05:09:41.627135 | 2023-09-25 05:24:57.405033 |
| MPC_marsden | neocp_prev_des | 55816 | 2023-09-25 05:05:48.888617 | 2023-09-25 05:24:57.55915 |
| MPC_mpcweb5 | neocp_prev_des | 55816 | 2023-09-25 05:05:48.888617 | 2023-09-25 05:24:57.648671 |
| SBN_to_AWS | neocp_prev_des | 55816 | 2023-09-25 05:05:48.888617 | 2023-09-25 05:24:57.724876 |
| MPC_marsden | neocp_var | 203410 | 2023-09-25 05:09:44.089516 | 2023-09-25 05:24:57.811246 |
| MPC_mpcweb5 | neocp_var | 203410 | 2023-09-25 05:09:44.089516 | 2023-09-25 05:24:57.962816 |
| SBN_to_AWS | neocp_var | 203410 | 2023-09-25 05:09:44.089516 | 2023-09-25 05:24:58.05121 |
| MPC_marsden | primary_objects | 1365940 | 2023-09-25 04:22:40.065105 | 2023-09-25 05:24:58.194622 |
| MPC_mpcweb5 | primary_objects | 1365940 | 2023-09-25 04:22:40.065105 | 2023-09-25 05:24:58.60167 |
| SBN_to_AWS | primary_objects | 1365940 | 2023-09-25 04:22:40.065105 | 2023-09-25 05:24:58.733189 |
| MPC_marsden | obs_alterations_corrections | 2023-09-25 05:24:58.987942 | ||
| MPC_mpcweb5 | obs_alterations_corrections | 2023-09-25 05:24:59.058797 | ||
| SBN_to_AWS | obs_alterations_corrections | 2023-09-25 05:24:59.127079 | ||
| MPC_marsden | obs_alterations_deletions | 908635 | 2023-09-25 02:20:57.768853 | 2023-09-25 05:24:59.198797 |
| MPC_mpcweb5 | obs_alterations_deletions | 908635 | 2023-09-25 02:20:57.768853 | 2023-09-25 05:24:59.744136 |
| SBN_to_AWS | obs_alterations_deletions | 908635 | 2023-09-25 02:20:57.768853 | 2023-09-25 05:24:59.849307 |
| MPC_marsden | obs_alterations_redesignations | 2707 | 2023-08-28 22:22:13.362713 | 2023-09-25 05:25:00.034976 |
| MPC_mpcweb5 | obs_alterations_redesignations | 2707 | 2023-08-28 22:22:13.362713 | 2023-09-25 05:25:00.10831 |
| SBN_to_AWS | obs_alterations_redesignations | 2707 | 2023-08-28 22:22:13.362713 | 2023-09-25 05:25:00.177133 |