| 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 |
|---|
| e202403 | a_proximity_sum | 676307 | 0 | 0.00 | 0.00 | | 2024-05-20 01:05:16.065171+00 | | |
| e202403 | a_stay_time | 2220173 | 0 | 0.00 | 0.00 | | 2024-05-20 03:45:51.625943+00 | | |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-14 14:56:19.476721+00 | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-14 14:56:19.712258+00 | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-14 13:00:53.87342+00 | | |
| e202403 | t_position_history | 31270592 | 0 | 0.00 | 0.00 | | 2024-05-10 02:50:37.680742+00 | | |
| e202403 | t_presence_history | 9346778 | 0 | 0.00 | 0.00 | | 2024-05-14 04:26:30.990537+00 | | |
| e202403 | t_sensor_history | 1264956 | 0 | 0.00 | 0.00 | | 2024-05-22 04:03:03.484984+00 | | |
| e202404 | a_proximity_sum | 3117539 | 0 | 0.00 | 0.00 | | 2024-05-11 17:34:40.934916+00 | | |
| e202404 | a_stay_time | 2915987 | 0 | 0.00 | 0.00 | | 2024-05-22 06:11:33.971169+00 | | |
| e202404 | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-13 06:53:24.641169+00 | | |
| e202404 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-14 14:56:19.498021+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-14 14:56:19.487395+00 | | |
| e202404 | t_position_history | 47382773 | 0 | 0.00 | 0.00 | | 2024-05-09 19:18:51.210079+00 | | |
| e202404 | t_presence_history | 6867143 | 0 | 0.00 | 0.00 | | 2024-05-15 06:28:14.379432+00 | | 2024-04-30 14:47:32.149293+00 |
| e202404 | t_sensor_history | 1154996 | 0 | 0.00 | 0.00 | | 2024-05-12 08:14:14.116057+00 | | 2024-04-28 22:43:41.720491+00 |
| e202405 | a_proximity_sum | 1498267 | 0 | 0.00 | 0.00 | | 2024-05-22 15:32:12.500698+00 | | 2024-05-22 15:32:14.667788+00 |
| e202405 | a_stay_time | 1945098 | 0 | 0.00 | 0.00 | | 2024-05-21 17:01:10.661616+00 | | 2024-05-21 17:01:11.156634+00 |
| e202405 | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-13 06:53:24.652146+00 | | |
| e202405 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-14 14:56:19.519649+00 | | |
| e202405 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-14 14:56:19.50898+00 | | |
| e202405 | t_position_history | 33366510 | 0 | 0.00 | 0.00 | | 2024-05-22 02:24:29.591193+00 | | 2024-05-22 13:15:05.216353+00 |
| e202405 | t_presence_history | 4393626 | 107049 | 0.00 | 2.00 | | 2024-05-23 01:43:41.628745+00 | | 2024-05-23 01:43:43.319762+00 |
| e202405 | t_sensor_history | 928695 | 0 | 0.00 | 0.00 | | 2024-05-19 14:17:47.228108+00 | | 2024-05-21 16:08:36.105386+00 |
| public | __digdag_status | 7 | 19 | 2.00 | 73.00 | | 2024-05-21 00:11:12.566992+00 | | 2024-05-21 00:11:12.569682+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-13 06:47:49.562102+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-05-13 06:47:49.534261+00 | | |
| public | b_attendance_group | 408934 | 8780 | 0.00 | 2.00 | | 2024-05-13 06:47:48.401169+00 | | 2024-05-13 17:45:28.28103+00 |
| public | b_attendance_hour | 6135939 | 135340 | 0.00 | 2.00 | | 2024-05-13 11:31:42.923437+00 | | 2024-05-12 18:30:45.192135+00 |
| public | b_attendance_pot | 10082 | 886 | 0.00 | 8.00 | | 2024-05-11 03:20:19.884276+00 | | 2024-05-19 16:51:01.386532+00 |
| public | b_attendance_pot_hour | 149383 | 5010 | 0.00 | 3.00 | | 2024-05-20 18:01:06.115388+00 | | 2024-05-18 19:27:04.148018+00 |
| public | b_check_in | 3354162 | 79660 | 0.00 | 2.00 | | 2024-05-13 13:01:21.036564+00 | | 2024-05-13 13:02:16.932229+00 |
| public | b_check_in_hour | 49834704 | 1165500 | 0.00 | 2.00 | | 2024-05-13 11:33:27.844926+00 | | 2024-05-13 11:33:31.827589+00 |
| public | b_check_in_pot | 8850 | 0 | 0.00 | 0.00 | | 2024-05-14 13:37:51.404808+00 | | 2024-05-17 16:51:19.994601+00 |
| public | b_check_in_pot_hour | 132822 | 0 | 0.00 | 0.00 | | 2024-05-16 16:51:19.883671+00 | | 2024-05-22 16:51:13.392525+00 |
| public | b_proximity_group | 40297393 | 1162093 | 0.00 | 2.00 | | 2024-05-13 12:26:12.512154+00 | | 2024-05-16 18:35:09.969807+00 |
| public | b_proximity_info | 34330879 | 91612 | 0.00 | 0.00 | | 2024-05-13 11:31:26.817385+00 | | 2024-05-22 16:06:13.743869+00 |
| public | b_seat_reserve | 706338 | 16340 | 0.00 | 2.00 | | 2024-05-13 12:05:31.739397+00 | | 2024-05-12 18:34:43.576137+00 |
| public | b_seat_reserve_hour | 13500872 | 294300 | 0.00 | 2.00 | | 2024-05-13 06:47:40.944407+00 | | 2024-05-13 17:38:01.276617+00 |
| public | b_usage | 795895 | 16340 | 0.00 | 2.00 | | 2024-05-13 06:47:52.058825+00 | | 2024-05-13 17:34:00.932987+00 |
| public | b_usage_hour | 14490430 | 294300 | 0.00 | 1.00 | | 2024-05-13 11:26:23.300117+00 | | 2024-05-13 17:46:28.118293+00 |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-13 06:51:22.882359+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-13 06:51:22.871534+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-13 06:51:22.86069+00 | | |
| public | m_area | 97 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.764016+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-05-13 11:31:42.94183+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:52.240305+00 | | |
| public | m_exb | 3790 | 166 | 0.00 | 4.00 | | 2024-05-13 13:07:30.811731+00 | | |
| public | m_favorite | 35947 | 565 | 0.00 | 1.00 | | 2024-05-13 11:33:32.274346+00 | | |
| public | m_feature | 161 | 0 | 0.00 | 0.00 | | 2024-05-13 13:09:31.014217+00 | | |
| public | m_group | 2612 | 0 | 0.00 | 0.00 | | 2024-05-21 11:10:31.38581+00 | | |
| public | m_holiday | 5822 | 0 | 0.00 | 0.00 | | 2024-05-13 06:51:22.909806+00 | | |
| public | m_lob | 2271 | 10 | 0.00 | 0.00 | | 2024-05-13 11:36:31.511653+00 | | |
| public | m_location | 5357 | 124 | 0.00 | 2.00 | | 2024-05-13 06:47:49.759572+00 | | |
| public | m_notify_template | 119 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:52.094639+00 | | |
| public | m_outside | 57 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:49.932585+00 | | |
| public | m_pot | 23813 | 952 | 0.00 | 3.00 | | 2024-05-23 00:10:05.229551+00 | | 2024-05-23 00:10:07.661756+00 |
| public | m_pot_profile | 667 | 28 | 0.00 | 4.00 | | 2024-05-13 11:31:27.704216+00 | | |
| public | m_provider_user | 58 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:49.522889+00 | | |
| public | m_region | 15 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.880976+00 | | |
| public | m_role | 76 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.842935+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-05-13 13:01:13.579029+00 | | |
| public | m_setting | 3163 | 78 | 0.00 | 2.00 | | 2024-05-22 18:01:55.476262+00 | | 2024-05-22 10:22:53.195183+00 |
| public | m_setting_log | 4262 | 0 | 0.00 | 0.00 | | 2024-05-22 12:30:14.213678+00 | | 2024-05-22 12:30:14.342803+00 |
| public | m_site | 22 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:52.077075+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:49.480738+00 | | |
| public | m_tx | 14932 | 1997 | 0.00 | 11.00 | | 2024-05-17 09:49:36.301144+00 | | 2024-05-22 10:43:45.349889+00 |
| public | m_user | 972 | 3 | 0.00 | 0.00 | | 2024-05-15 05:24:17.845591+00 | | |
| public | m_zone | 742 | 11 | 0.00 | 1.00 | | 2024-05-13 06:47:52.286374+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-05-13 12:05:47.720658+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-05-13 13:01:13.556501+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:52.116082+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-05-13 12:05:29.8704+00 | | |
| public | r_location_zone | 3316 | 416 | 0.00 | 11.00 | | 2024-05-13 05:40:53.113325+00 | | 2024-05-17 09:40:01.219765+00 |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-05-13 11:31:42.965339+00 | | |
| public | r_pot_category | 972 | 3 | 0.00 | 0.00 | | 2024-05-13 11:36:31.590838+00 | | |
| public | r_pot_group | 10891 | 831 | 0.00 | 7.00 | | 2024-05-22 23:13:24.618205+00 | | 2024-05-22 23:34:30.160432+00 |
| public | r_pot_tx | 8226 | 36 | 0.00 | 0.00 | | 2024-05-13 06:47:52.199425+00 | | |
| public | r_pot_user | 694 | 4 | 0.00 | 0.00 | | 2024-05-15 05:24:17.650352+00 | | |
| public | r_provider_tenant | 189 | 0 | 0.00 | 0.00 | | 2024-05-10 06:33:07.536094+00 | | |
| public | r_role_feature | 688 | 5 | 0.00 | 0.00 | | 2024-05-13 13:07:30.826875+00 | | |
| public | r_tenant_feature | 541 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:49.502293+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:52.217277+00 | | |
| public | r_user_region | 843 | 3 | 0.00 | 0.00 | | 2024-05-15 05:24:17.717816+00 | | |
| public | r_user_site | 736 | 2 | 0.00 | 0.00 | | 2024-05-15 05:24:17.691913+00 | | |
| public | r_zone_category | 662 | 10 | 0.00 | 1.00 | | 2024-05-13 06:47:49.550814+00 | | 2024-05-15 11:06:59.505804+00 |
| public | t_ai_history | 0 | 0 | 0 | 0 | | 2024-05-15 03:52:59.366364+00 | | |
| public | t_attendance | 305507 | 17125 | 0.00 | 5.00 | | 2024-05-13 13:07:01.11428+00 | | 2024-05-17 18:32:24.911297+00 |
| public | t_general | 30 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.86548+00 | | |
| public | t_mobile_device_history | 77023 | 0 | 0.00 | 0.00 | | 2024-05-13 07:26:27.003484+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-05-13 06:47:52.126999+00 | | |
| public | t_notify_history | 409561 | 13262 | 0.00 | 3.00 | | 2024-05-13 13:07:34.298953+00 | | 2024-05-15 02:13:17.214552+00 |
| public | t_operation_log | 1675527 | 41182 | 0.00 | 2.00 | | 2024-05-13 07:14:14.014771+00 | | 2024-05-22 05:27:44.476293+00 |
| public | t_plan | 3208198 | 374324 | 0.00 | 10.00 | | 2024-05-13 11:35:30.301556+00 | | 2024-05-20 09:02:58.478038+00 |
| public | t_plan_detail | 3624796 | 356978 | 0.00 | 8.00 | | 2024-05-13 13:10:07.054646+00 | | 2024-05-22 01:16:54.944777+00 |
| public | t_plan_sync | 16534 | 2755 | 0.00 | 14.00 | | 2024-05-22 21:50:11.886855+00 | | 2024-05-22 23:34:26.907801+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-05-13 06:47:49.464122+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-05-13 11:25:50.228895+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-05-13 11:36:31.530663+00 | | |
| public | t_recv_position_history | 7394 | 2366 | 0.00 | 24.00 | | 2024-05-23 01:44:52.246567+00 | 2024-05-22 12:42:00.714835+00 | 2024-05-23 01:44:52.277764+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-05-13 11:30:24.044351+00 | | |
| public | t_terminal | 14997 | 1430 | 0.00 | 8.00 | | 2024-05-19 05:38:57.632115+00 | | 2024-05-22 22:07:46.500693+00 |
| public | t_terminal_log | 3821157 | 0 | 0.00 | 0.00 | | 2024-05-13 06:48:01.548953+00 | | |
| public | w_arrival_notify | 1 | 5 | 5.00 | 83.00 | | 2024-05-13 06:53:24.784094+00 | | |
| public | w_latest_position | 10834 | 1906 | 0.00 | 14.00 | | 2024-05-23 01:44:52.125171+00 | | 2024-05-23 01:44:52.150636+00 |
| public | w_latest_presence | 17299 | 28975 | 1.00 | 62.00 | | 2024-05-23 01:44:52.405522+00 | | 2024-05-23 01:44:52.606687+00 |
| public | w_latest_sensor | 113 | 67 | 0.00 | 37.00 | | 2024-05-23 01:42:46.340833+00 | | 2024-05-23 01:42:48.367+00 |
| public | w_lock | 988 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:48.901898+00 | | |
| public | w_master_update | 15 | 33 | 2.00 | 68.00 | | 2024-05-22 03:24:34.405064+00 | | 2024-05-23 01:04:42.219853+00 |
| public | w_plan_with_detail | 3209094 | 388154 | 0.00 | 10.00 | | 2024-05-13 07:26:21.957432+00 | | 2024-05-21 16:51:09.107545+00 |