DOWNTIME ANNOUNCEMENT01 Feb 2023: There may be brief power/network outages on Wed 01 Feb 2023 between 6-8 EST (11:00-13:00 UTC) due to electrical work in the building.
|
27 Jan 2023
Please report concerns!
2023-01-29 18:40: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 | 12117 | 2014-02-10 15:54:22 | 2023-01-28 04:31:05 |
identifications | 610270 | 2023-01-27 12:11:21 | 2023-01-27 12:11:21 |
isolated_tracklets | 39652498 | 2023-01-29 16:06:08 | 2023-01-29 16:06:08 |
mpc_indices | 396 | 2023-01-29 18:30:03 | 2023-01-29 18:30:03 |
numbered_identifications | 1000224 | 2022-11-19 08:43:22 | 2022-11-19 08:43:22 |
numbered_mps | 619999 | 2013-03-28 19:29:15 | 2022-12-02 20:26:41 |
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 | 364998535 | 2023-01-29 17:43:03 | 2023-01-29 17:43:03 |
orbit_uncertainties | 787161 | 2019-06-03 12:14:44 | 2022-11-19 08:56:04 |
orbits | 1264934 | 2023-01-29 17:43:07 | 2023-01-29 18:31:04 |
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 | 84 | 2022-12-24 11:48:22.992896 | 2023-01-29 17:31:32.99238 |
neocp_events | 168878 | 2023-01-29 17:42:23.143472 | 2023-01-29 17:42:23.143472 |
neocp_obs_archive | 444344 | 2023-01-29 17:31:32.988171 | 2023-01-29 17:31:32.988171 |
neocp_obs | 1316 | 2023-01-29 17:31:32.98249 | 2023-01-29 17:31:32.98249 |
neocp_prev_des | 52324 | 2023-01-29 17:42:23.123242 | 2023-01-29 17:42:23.123242 |
neocp_var | 159901 | 2023-01-29 17:31:33.709755 | 2023-01-29 17:31:33.709755 |
current_identifications | 1795298 | 2023-01-29 17:41:54.561626 | 2023-01-29 17:42:23.395078 |
numbered_identifications | 620748 | 2022-11-18 15:30:54.523925 | 2022-11-18 15:30:54.523925 |
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 | 84 | 2022-12-24 11:48:22.992896 | 2023-01-29 17:31:32.99238 |
neocp_events | 168878 | 2023-01-29 17:42:23.143472 | 2023-01-29 17:42:23.143472 |
neocp_obs_archive | 444344 | 2023-01-29 17:31:32.988171 | 2023-01-29 17:31:32.988171 |
neocp_obs | 1316 | 2023-01-29 17:31:32.98249 | 2023-01-29 17:31:32.98249 |
neocp_prev_des | 52324 | 2023-01-29 17:42:23.123242 | 2023-01-29 17:42:23.123242 |
neocp_var | 159901 | 2023-01-29 17:31:33.709755 | 2023-01-29 17:31:33.709755 |
current_identifications | 1795298 | 2023-01-29 17:41:54.561626 | 2023-01-29 17:42:23.395078 |
numbered_identifications | 620748 | 2022-11-18 15:30:54.523925 | 2022-11-18 15:30:54.523925 |
primary_objects | 0 | 1970-01-01 00:00:00.0 | 1970-01-01 00:00:00.0 |
obs_sbn | 374647004 | 2023-01-25 23:08:03.859468-05 | 2023-01-25 23:09:19.366977-05 |
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 | 375123820 | 2023-01-29 17:55:17.408861 | 2023-01-29 18:00:01.869895 |
MPC_mpcweb5 | obs_sbn | 375123855 | 2023-01-29 18:10:17.106387 | 2023-01-29 18:11:03.274448 |
SBN_to_AWS | obs_sbn | 2023-01-29 18:17:27.480481 | ||
MPC_marsden | current_identifications | 1795298 | 2023-01-29 17:42:23.395078 | 2023-01-29 18:17:27.560508 |
MPC_mpcweb5 | current_identifications | 1795298 | 2023-01-29 17:42:23.395078 | 2023-01-29 18:17:27.983797 |
SBN_to_AWS | current_identifications | 1795298 | 2023-01-29 17:42:23.395078 | 2023-01-29 18:17:28.122804 |
MPC_marsden | numbered_identifications | 620748 | 2022-11-18 15:30:54.523925 | 2023-01-29 18:17:28.341353 |
MPC_mpcweb5 | numbered_identifications | 620748 | 2022-11-18 15:30:54.523925 | 2023-01-29 18:17:28.551469 |
SBN_to_AWS | numbered_identifications | 620748 | 2022-11-18 15:30:54.523925 | 2023-01-29 18:17:28.650601 |
MPC_marsden | neocp_els | 83 | 2023-01-29 17:31:32.99238 | 2023-01-29 18:17:28.767876 |
MPC_mpcweb5 | neocp_els | 83 | 2023-01-29 17:31:32.99238 | 2023-01-29 18:17:28.841059 |
SBN_to_AWS | neocp_els | 83 | 2023-01-29 17:31:32.99238 | 2023-01-29 18:17:28.911139 |
MPC_marsden | neocp_events | 168878 | 2023-01-29 17:42:23.143472 | 2023-01-29 18:17:28.982508 |
MPC_mpcweb5 | neocp_events | 168878 | 2023-01-29 17:42:23.143472 | 2023-01-29 18:17:29.107064 |
SBN_to_AWS | neocp_events | 168878 | 2023-01-29 17:42:23.143472 | 2023-01-29 18:17:29.19763 |
MPC_marsden | neocp_obs | 1300 | 2023-01-29 17:31:32.98249 | 2023-01-29 18:17:29.288508 |
MPC_mpcweb5 | neocp_obs | 1300 | 2023-01-29 17:31:32.98249 | 2023-01-29 18:17:29.362747 |
SBN_to_AWS | neocp_obs | 1300 | 2023-01-29 17:31:32.98249 | 2023-01-29 18:17:29.433229 |
MPC_marsden | neocp_obs_archive | 444344 | 2023-01-29 17:31:32.988171 | 2023-01-29 18:17:29.504937 |
MPC_mpcweb5 | neocp_obs_archive | 444344 | 2023-01-29 17:31:32.988171 | 2023-01-29 18:17:29.686196 |
SBN_to_AWS | neocp_obs_archive | 444344 | 2023-01-29 17:31:32.988171 | 2023-01-29 18:17:29.786243 |
MPC_marsden | neocp_prev_des | 52324 | 2023-01-29 17:42:23.123242 | 2023-01-29 18:17:29.889503 |
MPC_mpcweb5 | neocp_prev_des | 52324 | 2023-01-29 17:42:23.123242 | 2023-01-29 18:17:29.980549 |
SBN_to_AWS | neocp_prev_des | 52324 | 2023-01-29 17:42:23.123242 | 2023-01-29 18:17:30.057872 |
MPC_marsden | neocp_var | 157995 | 2023-01-29 17:31:33.709755 | 2023-01-29 18:17:30.135928 |
MPC_mpcweb5 | neocp_var | 157995 | 2023-01-29 17:31:33.709755 | 2023-01-29 18:17:30.280498 |
SBN_to_AWS | neocp_var | 157995 | 2023-01-29 17:31:33.709755 | 2023-01-29 18:17:30.368786 |