2021-01-05 03: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 | 10646 | 2020-12-14 04:11:21 | 2020-12-14 04:31:03 |
identifications | 560395 | 2021-01-04 12:03:26 | 2021-01-04 12:03:26 |
isolated_tracklets | 29888545 | 2013-09-26 21:41:34 | 2021-01-05 00:11:51 |
mpc_indices | 55 | 2021-01-05 03:00:01 | 2021-01-05 03:00:01 |
numbered_identifications | 899468 | 2020-12-17 18:00:55 | 2020-12-17 18:00:55 |
numbered_mps | 546846 | 2011-10-27 14:22:17 | 2020-12-17 18:10:31 |
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 | 280735752 | 2021-01-05 03:19:21 | 2021-01-05 03:19:21 |
orbit_uncertainties | 787375 | 2019-06-03 12:14:48 | 2020-10-19 14:32:50 |
orbits | 1042806 | 2021-01-05 03:19:24 | 2021-01-05 03:19:24 |
perturbed_orbits | 175741560 | 2018-09-27 13:20:33 | 2018-09-27 13: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 | 54 | 2021-01-04 04:19:35.702031 | 2021-01-05 03:23:44.933329 |
neocp_events | 73615 | 2021-01-05 03:23:52.284353 | 2021-01-05 03:23:52.284353 |
neocp_obs_archive | 213132 | 2021-01-05 03:23:44.924942 | 2021-01-05 03:23:44.924942 |
neocp_obs | 799 | 2021-01-05 03:23:44.918942 | 2021-01-05 03:23:44.918942 |
neocp_prev_des | 39351 | 2021-01-05 03:19:10.311911 | 2021-01-05 03:19:10.311911 |
neocp_var | 119891 | 2021-01-05 03:23:52.270231 | 2021-01-05 03:23:52.270231 |
current_identifications | 1586770 | 2021-01-05 03:18:58.598704 | 2021-01-05 03:19:10.565572 |
numbered_identifications | 547402 | 2020-10-13 19:34:34.129247 | 2020-10-13 19:34:34.129247 |
primary_objects | 1139119 | 2021-01-05 03:18:58.583322 | 2021-01-05 03:18:58.583322 |
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