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.

MariaDB mpc_development:

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

No change in Maria mpc_development database structure.

Postgres mpcbeta:

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

No change to Postgres mpcbeta database structure

Postgres mpc_sbn:

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

No change to Postgres mpc_sbn database structure

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

Replication status view MPC-master → [SBN] → MPC-replica:

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