| schema | table | live_tupple | dead_tupple | ratio_of_dead_to_each_live | percent_of_dead | last_vacuum_at | last_autovacuum_at | last_analyze_at | last_autoanalyze_at |
|---|
| e202408 | a_proximity_sum | 37770822 | 5057 | 0.00 | 0.00 | | 2024-09-26 23:33:26.150565+00 | | 2024-08-30 18:04:15.752996+00 |
| e202408 | a_stay_time | 23714541 | 178547 | 0.00 | 0.00 | | 2024-09-26 00:22:22.294226+00 | | 2024-08-29 16:01:01.429933+00 |
| e202408 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-03 09:42:48.000008+00 | | |
| e202408 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-03 09:42:48.022708+00 | | |
| e202408 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-03 09:42:48.011372+00 | | |
| e202408 | t_position_history | 443789780 | 0 | 0.00 | 0.00 | | 2024-10-03 09:53:30.336819+00 | | 2024-08-30 04:23:42.833544+00 |
| e202408 | t_presence_history | 45854744 | 0 | 0.00 | 0.00 | | 2024-09-25 08:19:50.628561+00 | | 2024-08-31 14:39:59.767121+00 |
| e202408 | t_sensor_history | 8983455 | 0 | 0.00 | 0.00 | | 2024-10-03 06:57:39.004226+00 | | 2024-08-31 12:53:22.897625+00 |
| e202409 | a_proximity_sum | 45148507 | 475 | 0.00 | 0.00 | | 2024-10-02 05:46:14.311227+00 | | 2024-09-30 01:05:36.54641+00 |
| e202409 | a_stay_time | 22311916 | 291679 | 0.00 | 1.00 | | 2024-10-03 06:45:50.137609+00 | | 2024-10-03 06:45:52.333043+00 |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-09-25 22:51:46.453552+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-09-25 22:51:46.475627+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-09-25 22:51:46.464711+00 | | |
| e202409 | t_position_history | 452367559 | 0 | 0.00 | 0.00 | | 2024-10-02 07:51:45.874737+00 | | 2024-09-27 17:22:34.067672+00 |
| e202409 | t_presence_history | 47238977 | 7893397 | 0.00 | 14.00 | | 2024-09-30 13:53:43.718288+00 | | 2024-09-30 14:29:43.597787+00 |
| e202409 | t_sensor_history | 9210434 | 0 | 0.00 | 0.00 | | 2024-09-26 22:35:21.419526+00 | | 2024-09-28 11:54:18.332205+00 |
| e202410 | a_proximity_sum | 5068421 | 0 | 0.00 | 0.00 | | 2024-10-03 16:07:32.054247+00 | | 2024-10-03 17:57:00.814897+00 |
| e202410 | a_stay_time | 3424858 | 0 | 0.00 | 0.00 | | 2024-10-03 17:41:03.39824+00 | | 2024-10-03 18:36:05.466719+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | 2024-09-26 02:41:42.784356+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-09-26 02:41:42.840172+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-09-26 02:41:42.829062+00 | | |
| e202410 | t_position_history | 66306267 | 0 | 0.00 | 0.00 | | 2024-10-03 08:51:08.359367+00 | | 2024-10-03 11:07:02.317577+00 |
| e202410 | t_presence_history | 6714685 | 1352110 | 0.00 | 16.00 | | 2024-10-04 00:41:13.360785+00 | | 2024-10-04 00:45:57.820795+00 |
| e202410 | t_sensor_history | 1034482 | 0 | 0.00 | 0.00 | | 2024-10-03 23:29:47.526128+00 | | 2024-10-03 18:00:00.405326+00 |
| public | __digdag_status | 32 | 48 | 1.00 | 60.00 | | 2024-09-30 03:30:51.045735+00 | | 2024-10-03 03:30:18.661786+00 |
| public | a_attendance_sum | 29204 | 5870 | 0.00 | 16.00 | | 2024-10-04 00:42:57.856104+00 | | 2024-10-04 00:47:57.789209+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-09-28 00:05:01.197601+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-09-28 00:05:01.131708+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-09-30 17:46:47.827671+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-09-30 17:46:50.200132+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-09-30 17:46:21.127516+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-09-30 17:46:50.221686+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-09-30 17:46:50.243194+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-09-30 17:46:21.148869+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-09-30 17:46:21.103862+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-09-30 17:46:47.873348+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-09-30 17:46:21.171523+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-09-30 17:46:21.193061+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-09-28 00:05:01.804827+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-09-28 00:05:01.794023+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-09-28 00:05:01.783117+00 | | |
| public | m_area | 659 | 1 | 0.00 | 0.00 | | 2024-09-30 09:51:53.192793+00 | | 2024-09-22 07:28:40.141859+00 |
| public | m_auth | 119 | 1 | 0.00 | 0.00 | | 2024-09-28 00:05:01.247551+00 | | 2024-10-02 01:08:38.356854+00 |
| public | m_category | 1745 | 0 | 0.00 | 0.00 | | 2024-09-30 09:51:53.161764+00 | | 2024-06-25 09:59:15.889653+00 |
| public | m_exb | 20869 | 304 | 0.00 | 1.00 | | 2024-09-27 10:54:02.817303+00 | | 2024-09-24 09:02:43.621131+00 |
| public | m_favorite | 175364 | 2062 | 0.00 | 1.00 | | 2024-09-29 01:01:03.648775+00 | | 2024-09-17 01:02:37.332475+00 |
| public | m_feature | 163 | 0 | 0.00 | 0.00 | | 2024-09-28 21:28:23.510461+00 | | |
| public | m_group | 17697 | 4 | 0.00 | 0.00 | | 2024-10-02 12:09:00.506792+00 | | 2024-09-30 23:32:34.381087+00 |
| public | m_holiday | 26301 | 0 | 0.00 | 0.00 | | 2024-09-26 02:17:24.079635+00 | | 2024-07-08 03:20:43.009936+00 |
| public | m_lob | 21360 | 242 | 0.00 | 1.00 | | 2024-09-26 06:28:04.007026+00 | | 2024-08-10 12:19:11.748312+00 |
| public | m_location | 37646 | 9 | 0.00 | 0.00 | | 2024-10-03 05:16:07.79105+00 | | 2024-09-24 09:18:23.731916+00 |
| public | m_notify_template | 739 | 0 | 0.00 | 0.00 | | 2024-09-28 00:05:01.432763+00 | | 2024-08-29 07:15:16.864762+00 |
| public | m_outside | 315 | 0 | 0.00 | 0.00 | | 2024-10-03 12:27:48.227433+00 | | 2024-07-03 01:58:21.092861+00 |
| public | m_pot | 159261 | 21760 | 0.00 | 12.00 | | 2024-10-03 00:03:11.178642+00 | | 2024-10-03 23:58:51.537343+00 |
| public | m_pot_profile | 45174 | 29 | 0.00 | 0.00 | | 2024-09-26 20:50:30.943567+00 | | 2024-08-23 08:02:32.125598+00 |
| public | m_provider_user | 71 | 9 | 0.00 | 11.00 | | 2024-09-28 22:58:14.623658+00 | | 2024-09-06 06:53:59.132463+00 |
| public | m_region | 99 | 0 | 0.00 | 0.00 | | 2024-09-28 00:05:01.518521+00 | | |
| public | m_role | 562 | 0 | 0.00 | 0.00 | | 2024-09-28 00:05:01.499044+00 | | 2024-09-24 06:40:14.717909+00 |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-09-28 00:05:01.366707+00 | | |
| public | m_setting | 20306 | 814 | 0.00 | 3.00 | | 2024-10-03 09:01:24.892564+00 | | 2024-10-03 02:34:25.269897+00 |
| public | m_setting_log | 27923 | 0 | 0.00 | 0.00 | | 2024-10-03 00:39:16.755271+00 | | 2024-10-03 23:33:46.466654+00 |
| public | m_site | 177 | 1 | 0.00 | 0.00 | | 2024-09-28 00:05:01.391262+00 | | |
| public | m_tenant | 98 | 1 | 0.00 | 1.00 | | 2024-09-28 00:05:01.652371+00 | | |
| public | m_tx | 103044 | 1353 | 0.00 | 1.00 | | 2024-10-03 06:37:34.78822+00 | | 2024-10-03 06:34:34.456466+00 |
| public | m_user | 30640 | 110 | 0.00 | 0.00 | | 2024-09-30 09:50:47.042166+00 | | 2024-10-01 00:13:28.507887+00 |
| public | m_zone | 6518 | 29 | 0.00 | 0.00 | | 2024-09-29 15:55:41.132155+00 | | 2024-09-10 09:55:19.944808+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-09-28 00:04:54.71993+00 | | |
| public | r_auth_zone | 220 | 0 | 0.00 | 0.00 | | 2024-09-30 03:38:51.446372+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-09-28 00:05:01.454359+00 | | |
| public | r_group_auth | 478 | 0 | 0.00 | 0.00 | | 2024-10-01 07:35:12.92514+00 | | 2024-09-27 09:33:33.095538+00 |
| public | r_location_zone | 40254 | 1720 | 0.00 | 4.00 | | 2024-09-25 08:03:09.048954+00 | | 2024-09-30 02:13:42.552343+00 |
| public | r_pot_auth | 8580 | 1067 | 0.00 | 11.00 | | 2024-09-30 10:11:58.727342+00 | | 2024-10-03 01:01:12.403251+00 |
| public | r_pot_category | 6946 | 1 | 0.00 | 0.00 | | 2024-10-03 20:07:45.694898+00 | | 2024-10-03 20:01:38.582498+00 |
| public | r_pot_group | 151864 | 3389 | 0.00 | 2.00 | | 2024-10-04 00:37:57.733261+00 | | 2024-10-04 00:10:48.538411+00 |
| public | r_pot_tx | 56542 | 2124 | 0.00 | 3.00 | | 2024-09-26 15:00:17.212239+00 | | 2024-09-24 08:17:18.823526+00 |
| public | r_pot_user | 18537 | 12 | 0.00 | 0.00 | | 2024-10-02 12:09:00.258889+00 | | 2024-09-30 09:30:40.792434+00 |
| public | r_provider_tenant | 2029 | 0 | 0.00 | 0.00 | | 2024-10-03 10:38:31.736678+00 | | 2024-10-03 10:37:30.179382+00 |
| public | r_role_feature | 5177 | 16 | 0.00 | 0.00 | | 2024-10-02 12:09:00.287206+00 | | 2024-07-17 09:12:16.595823+00 |
| public | r_tenant_feature | 3574 | 1 | 0.00 | 0.00 | | 2024-09-30 17:46:20.071336+00 | | 2024-07-03 07:47:27.286426+00 |
| public | r_tx_sensor | 327 | 0 | 0.00 | 0.00 | | 2024-10-02 06:13:39.794563+00 | | 2024-05-08 03:36:41.526083+00 |
| public | r_user_region | 19268 | 12 | 0.00 | 0.00 | | 2024-10-02 12:08:53.025457+00 | | 2024-09-26 15:46:09.045868+00 |
| public | r_user_site | 5102 | 25 | 0.00 | 0.00 | | 2024-09-28 00:05:01.331816+00 | | 2024-09-30 00:46:37.084234+00 |
| public | r_zone_category | 3322 | 51 | 0.00 | 1.00 | | 2024-09-25 07:51:52.085345+00 | | 2024-09-10 09:55:19.881206+00 |
| public | t_ai_history | 7 | 0 | 0.00 | 0.00 | | 2024-10-01 23:12:13.317532+00 | | |
| public | t_attendance | 1420497 | 25907 | 0.00 | 1.00 | | 2024-09-30 17:46:47.805908+00 | | 2024-10-03 09:00:24.314361+00 |
| public | t_general | 2548 | 7 | 0.00 | 0.00 | | 2024-09-28 00:05:01.6361+00 | | 2024-09-11 10:45:57.392285+00 |
| public | t_mobile_device_history | 640897 | 0 | 0.00 | 0.00 | | 2024-09-30 05:14:16.318467+00 | | 2024-09-25 00:00:31.986407+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-09-28 00:05:01.47643+00 | | |
| public | t_notify_history | 2991116 | 14850 | 0.00 | 0.00 | | 2024-09-29 08:00:19.06246+00 | | 2024-09-19 22:05:29.508494+00 |
| public | t_operation_log | 11916540 | 672 | 0.00 | 0.00 | | 2024-09-25 09:01:43.574878+00 | | 2024-09-27 03:46:27.672288+00 |
| public | t_plan | 12710414 | 550640 | 0.00 | 4.00 | | 2024-10-02 03:34:47.348939+00 | | 2024-10-03 23:30:48.661334+00 |
| public | t_plan_detail | 22152969 | 2418401 | 0.00 | 9.00 | | 2024-09-26 04:24:29.058588+00 | | 2024-10-03 00:50:10.828624+00 |
| public | t_plan_sync | 71960 | 4644 | 0.00 | 6.00 | | 2024-10-04 00:37:58.046148+00 | | 2024-10-04 00:35:57.527197+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-09-28 00:05:01.682417+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-09-28 00:04:54.751688+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-09-28 00:05:01.537605+00 | | |
| public | t_recv_position_history | 124475 | 54282 | 0.00 | 30.00 | | 2024-10-04 00:50:57.148078+00 | 2024-10-03 13:30:05.213003+00 | 2024-10-04 00:50:57.517701+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-09-28 00:04:54.777871+00 | | |
| public | t_terminal | 95084 | 4570 | 0.00 | 4.00 | | 2024-09-26 15:00:18.528731+00 | | 2024-10-03 19:06:06.763292+00 |
| public | t_terminal_log | 11063556 | 0 | 0.00 | 0.00 | | 2024-10-03 22:43:25.053153+00 | | 2024-09-19 08:24:31.396176+00 |
| public | w_arrival_notify | 79 | 66 | 0.00 | 45.00 | | 2024-10-01 01:24:44.522331+00 | | 2024-10-02 23:59:03.759641+00 |
| public | w_latest_position | 60994 | 10865 | 0.00 | 15.00 | | 2024-10-04 00:50:57.644349+00 | | 2024-10-04 00:50:57.748248+00 |
| public | w_latest_presence | 201578 | 88418 | 0.00 | 30.00 | | 2024-10-04 00:50:58.958694+00 | | 2024-10-04 00:50:59.337585+00 |
| public | w_latest_sensor | 344 | 194 | 0.00 | 36.00 | | 2024-10-04 00:50:57.830346+00 | | 2024-10-04 00:50:57.940546+00 |
| public | w_lock | 14434 | 0 | 0.00 | 0.00 | | 2024-10-02 08:12:58.507454+00 | | 2024-08-21 00:53:41.629677+00 |
| public | w_master_update | 172 | 63 | 0.00 | 26.00 | | 2024-10-03 23:33:46.484781+00 | | 2024-10-03 23:32:46.367749+00 |
| public | w_migration | 824 | 0 | 0.00 | 0.00 | | 2024-09-28 00:05:01.824163+00 | | |
| public | w_plan_with_detail | 12732766 | 1265449 | 0.00 | 9.00 | | 2024-09-29 00:18:20.212179+00 | | 2024-10-03 06:55:56.066448+00 |