Minor Planet Center Annex

@ SBN

Latest update of every table in MPC MariaDB and Postgres

2021-10-25 00:50:02 (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 11272 2021-10-22 03:54:08 2021-10-22 03:54:08
identifications 588345 2021-10-23 12:02:14 2021-10-23 12:02:14
isolated_tracklets 34430355 2021-10-24 11:32:47 2021-10-24 11:32:47
mpc_indices 396 2021-10-24 11:30:07 2021-10-24 11:30:07
numbered_identifications 965988 2021-09-30 07:03:53 2021-09-30 07:03:53
numbered_mps 594943 2021-08-24 16:16:34 2021-10-15 19:02:40
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 313625166 2021-10-24 11:55:55 2021-10-24 11:55:55
orbit_uncertainties 787250 2019-06-05 12:14:33 2021-09-30 07:12:37
orbits 1146129 2020-09-04 23:37:35 2021-10-23 16:31:03
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 23 2021-10-24 22:09:47.064143 2021-10-25 00:48:45.354759
neocp_events 108645 2021-10-25 00:48:56.968018 2021-10-25 00:48:56.968018
neocp_obs_archive 297076 2021-10-25 00:48:45.344764 2021-10-25 00:48:45.344764
neocp_obs 257 2021-10-25 00:48:45.338696 2021-10-25 00:48:45.338696
neocp_prev_des 44396 2021-10-24 23:09:51.154161 2021-10-24 23:09:51.154161
neocp_var 44441 2021-10-25 00:48:56.926048 2021-10-25 00:48:56.926048
current_identifications 1680899 2021-10-25 00:40:18.380633 2021-10-25 00:40:26.371156
numbered_identifications 595499 2021-09-29 04:42:27.391107 2021-09-29 04:42:27.391107
primary_objects 1211321 2021-09-28 18:55:58.729643 2021-09-28 18:55:58.729643
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