Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

23 May 2022

  1. Nominal.

Please report concerns!

KEY

Latest update of every table in MPC MariaDB and Postgres

2022-05-27 18:30: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 11583 2022-05-24 23:49:29 2022-05-25 00:31:08
identifications 601015 2022-05-18 12:06:18 2022-05-18 12:06:18
isolated_tracklets 37885511 2022-05-27 15:38:35 2022-05-27 15:38:35
mpc_indices 396 2022-05-27 18:30:01 2022-05-27 18:30:01
numbered_identifications 992545 2022-04-06 04:57:08 2022-04-06 04:57:08
numbered_mps 614690 2011-10-27 01:11:38 2022-05-02 20:31:33
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 335211677 2022-05-27 14:08:55 2022-05-27 14:08:55
orbit_uncertainties 787203 2019-06-05 12:14:32 2022-04-06 05:08:53
orbits 1208218 2016-12-30 15:53:00 2022-05-27 14: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 67 2022-05-24 12:27:47.860705 2022-05-27 16:17:49.722794
neocp_events 136109 2022-05-27 16:17:54.306279 2022-05-27 16:17:54.306279
neocp_obs_archive 368437 2022-05-27 16:17:49.712074 2022-05-27 16:17:49.712074
neocp_obs 747 2022-05-27 16:17:49.705053 2022-05-27 16:17:49.705053
neocp_prev_des 48035 2022-05-27 14:39:54.586211 2022-05-27 14:39:54.586211
neocp_var 128184 2022-05-27 16:17:54.288889 2022-05-27 16:17:54.288889
current_identifications 1739280 2022-05-27 18:20:23.073459 2022-05-27 18:20:42.258355
numbered_identifications 615294 2022-04-04 19:27:12.775535 2022-04-04 19:27:12.775535
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