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.
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 |
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 |
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