Minor Planet Center Annex

@ SBN

Latest update of every table in MPC MariaDB and Postgres

2021-03-03 08: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 10753 2021-02-26 04:49:07 2021-02-26 05:31:03
identifications 562307 2021-03-02 12:30:18 2021-03-02 12:30:18
isolated_tracklets 31479929 2021-03-03 03:05:30 2021-03-03 03:05:30
mpc_indices 295 2021-03-03 08:00:02 2021-03-03 08:00:02
numbered_identifications 901097 2021-02-23 06:47:23 2021-02-23 06:47:23
numbered_mps 547239 2021-02-23 06:57:14 2021-02-23 06:57:14
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 283355437 2021-03-03 08:25:16 2021-03-03 08:25:16
orbit_uncertainties 787334 2019-06-03 12:14:48 2021-02-23 06:55:40
orbits 1069052 2019-05-29 12:23:49 2021-03-02 13:31:34
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 31 2021-03-03 05:59:31.966546 2021-03-03 08:17:54.242784
neocp_events 80109 2021-03-03 08:18:03.174706 2021-03-03 08:18:03.174706
neocp_obs_archive 229163 2021-03-03 08:17:54.234313 2021-03-03 08:17:54.234313
neocp_obs 607 2021-03-03 08:17:54.227682 2021-03-03 08:17:54.227682
neocp_prev_des 40325 2021-03-03 03:05:31.128187 2021-03-03 03:05:31.128187
neocp_var 87359 2021-03-03 08:18:03.157178 2021-03-03 08:18:03.157178
current_identifications 1609958 2020-10-30 05:51:00.442782 2021-03-03 03:20:08.05003
numbered_identifications 548522 2021-02-13 03:53:19.680904 2021-02-13 03:53:19.680904
primary_objects 1158806 2021-02-25 18:50:27.003326 2021-02-25 18:50:27.003326
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