Minor Planet Center Annex

@ SBN

Latest update of every table in MPC MariaDB and Postgres

2021-01-05 03:25:01 (GMT)

Status of all major tables from MariaDB (mpc_development) and PostgresDB (mpcbeta). 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 10646 2020-12-14 04:11:21 2020-12-14 04:31:03
identifications 560395 2021-01-04 12:03:26 2021-01-04 12:03:26
isolated_tracklets 29888545 2013-09-26 21:41:34 2021-01-05 00:11:51
mpc_indices 55 2021-01-05 03:00:01 2021-01-05 03:00:01
numbered_identifications 899468 2020-12-17 18:00:55 2020-12-17 18:00:55
numbered_mps 546846 2011-10-27 14:22:17 2020-12-17 18:10:31
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 280735752 2021-01-05 03:19:21 2021-01-05 03:19:21
orbit_uncertainties 787375 2019-06-03 12:14:48 2020-10-19 14:32:50
orbits 1042806 2021-01-05 03:19:24 2021-01-05 03:19:24
perturbed_orbits 175741560 2018-09-27 13:20:33 2018-09-27 13: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 54 2021-01-04 04:19:35.702031 2021-01-05 03:23:44.933329
neocp_events 73615 2021-01-05 03:23:52.284353 2021-01-05 03:23:52.284353
neocp_obs_archive 213132 2021-01-05 03:23:44.924942 2021-01-05 03:23:44.924942
neocp_obs 799 2021-01-05 03:23:44.918942 2021-01-05 03:23:44.918942
neocp_prev_des 39351 2021-01-05 03:19:10.311911 2021-01-05 03:19:10.311911
neocp_var 119891 2021-01-05 03:23:52.270231 2021-01-05 03:23:52.270231
current_identifications 1586770 2021-01-05 03:18:58.598704 2021-01-05 03:19:10.565572
numbered_identifications 547402 2020-10-13 19:34:34.129247 2020-10-13 19:34:34.129247
primary_objects 1139119 2021-01-05 03:18:58.583322 2021-01-05 03:18:58.583322
No change to Postgres mpcbeta 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