Minor Planet Center Annex

@ SBN

Latest update of every table in MPC MariaDB and Postgres

2021-05-15 14:10: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 10924 2021-05-06 05:52:45 2021-05-06 06:31:03
identifications 567723 2021-05-15 12:13:04 2021-05-15 12:13:04
isolated_tracklets 32049231 2021-05-15 12:32:27 2021-05-15 12:32:27
mpc_indices 396 2021-05-15 14:00:02 2021-05-15 14:00:02
numbered_identifications 907400 2021-04-27 19:32:25 2021-04-27 19:32:25
numbered_mps 547966 2011-10-26 23:57:09 2021-04-27 19:42:05
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 295107226 2021-05-15 14:00:45 2021-05-15 14:00:45
orbit_uncertainties 787327 2019-06-05 12:14:32 2021-04-27 19:40:34
orbits 1091946 2020-07-29 01:43:09 2021-05-15 14:00:49
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 74 2021-05-13 18:27:38.689934 2021-05-15 13:52:36.928015
neocp_events 88998 2021-05-15 13:52:44.404486 2021-05-15 13:52:44.404486
neocp_obs_archive 251783 2021-05-15 13:52:36.920451 2021-05-15 13:52:36.920451
neocp_obs 1112 2021-05-15 13:52:36.915015 2021-05-15 13:52:36.915015
neocp_prev_des 41531 2021-05-15 11:05:37.338236 2021-05-15 11:05:37.338236
neocp_var 143068 2021-05-15 13:52:44.386304 2021-05-15 13:52:44.386304
current_identifications 1624314 2020-07-30 16:05:52.449144 2021-05-15 13:20:09.876794
numbered_identifications 553006 2021-04-16 17:59:27.872284 2021-04-16 17:59:27.872284
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