Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

13 Sep 2022

  1. Nominal.

Please report concerns!

KEY

Latest update of every table in MPC MariaDB and Postgres

2022-09-24 22:20:01 (GMT)

Status of all major tables from MariaDB (mpc_development) and two parallel Postgres databases (mpcbeta and mpc_sbn). 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 11820 2022-09-20 04:13:50 2022-09-20 04:31:03
identifications 604675 2022-09-24 12:24:59 2022-09-24 12:24:59
isolated_tracklets 38675878 2022-09-24 20:21:10 2022-09-24 20:21:10
mpc_indices 396 2022-09-24 22:00:04 2022-09-24 22:00:04
numbered_identifications 999025 2022-09-17 06:29:26 2022-09-17 06:29:26
numbered_mps 619150 2022-09-17 06:40:13 2022-09-17 06:40:13
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 346038500 2022-09-24 22:20:11 2022-09-24 22:20:11
orbit_uncertainties 787168 2019-06-03 12:14:44 2022-09-17 06:39:59
orbits 1233563 2022-09-24 20:47:48 2022-09-24 21: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 122 2022-09-14 21:09:40.887521 2022-09-24 22:13:45.629016
neocp_events 150010 2022-09-24 22:13:47.357261 2022-09-24 22:13:47.357261
neocp_obs_archive 400915 2022-09-24 22:13:45.625401 2022-09-24 22:13:45.625401
neocp_obs 1520 2022-09-24 22:13:45.623006 2022-09-24 22:13:45.623006
neocp_prev_des 49836 2022-09-24 20:47:02.949981 2022-09-24 20:47:02.949981
neocp_var 238869 2022-09-24 22:13:47.32326 2022-09-24 22:13:47.32326
current_identifications 1764637 2022-09-24 22:21:13.433479 2022-09-24 22:21:13.433479
numbered_identifications 619761 2022-09-16 18:46:46.323085 2022-09-16 18:46:46.323085
primary_objects 1211321 2021-09-28 18:55:58.729643 2021-09-28 18:55:58.729643
No change to Postgres mpcbeta database structure

Postgres mpc_sbn:

Table Count Created_at Updated_at
neocp_events 150010 2022-09-24 22:13:47.357261 2022-09-24 22:13:47.357261
neocp_obs_archive 400915 2022-09-24 22:13:45.625401 2022-09-24 22:13:45.625401
neocp_obs 1520 2022-09-24 22:13:45.623006 2022-09-24 22:13:45.623006
neocp_prev_des 49836 2022-09-24 20:47:02.949981 2022-09-24 20:47:02.949981
neocp_var 238869 2022-09-24 22:13:47.32326 2022-09-24 22:13:47.32326
current_identifications 1764637 2022-09-24 22:21:13.433479 2022-09-24 22:21:13.433479
numbered_identifications 619761 2022-09-16 18:46:46.323085 2022-09-16 18:46:46.323085
primary_objects 0 1970-01-01 00:00:00.0 1970-01-01 00:00:00.0
obs_sbn 357441841 2022-09-24 03:12:30.393251-04 2022-09-24 18:21:14.529449-04
No change to Postgres mpc_sbn 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