| 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 |
|---|
| e202409 | a_proximity_sum | 881183 | 0 | 0.00 | 0.00 | | 2024-10-24 06:28:40.754451+00 | | |
| e202409 | a_stay_time | 2549792 | 0 | 0.00 | 0.00 | | 2024-11-01 05:09:51.913601+00 | | |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-01 06:44:26.8741+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-01 06:44:26.855516+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-01 06:44:44.855543+00 | | |
| e202409 | t_position_history | 30787930 | 0 | 0.00 | 0.00 | | 2024-10-29 01:17:53.199012+00 | | |
| e202409 | t_presence_history | 6027195 | 0 | 0.00 | 0.00 | | 2024-11-01 17:42:58.958968+00 | | |
| e202409 | t_sensor_history | 1163362 | 0 | 0.00 | 0.00 | | 2024-11-01 02:55:43.301618+00 | | |
| e202410 | a_proximity_sum | 1036281 | 0 | 0.00 | 0.00 | | 2024-10-31 17:01:33.766561+00 | | 2024-10-30 15:32:18.858546+00 |
| e202410 | a_stay_time | 3104064 | 0 | 0.00 | 0.00 | | 2024-10-28 09:36:46.005156+00 | | 2024-10-30 15:31:17.628148+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-01 12:18:33.260613+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-01 12:18:33.242983+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-01 12:18:21.465801+00 | | |
| e202410 | t_position_history | 37799870 | 0 | 0.00 | 0.00 | | 2024-10-31 05:27:45.93225+00 | | 2024-10-29 23:37:01.175338+00 |
| e202410 | t_presence_history | 6478696 | 534360 | 0.00 | 7.00 | | 2024-10-31 14:43:28.235734+00 | | 2024-10-31 14:52:46.384793+00 |
| e202410 | t_sensor_history | 1268926 | 0 | 0.00 | 0.00 | | 2024-10-30 07:40:04.115722+00 | | 2024-10-29 03:22:14.031407+00 |
| e202411 | a_proximity_sum | 37621 | 0 | 0.00 | 0.00 | | 2024-11-01 17:00:58.289055+00 | | 2024-11-01 17:25:59.6545+00 |
| e202411 | a_stay_time | 122145 | 0 | 0.00 | 0.00 | | 2024-11-01 17:00:58.133032+00 | | 2024-11-01 17:00:58.249212+00 |
| e202411 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-25 11:20:11.891693+00 | | |
| e202411 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-25 11:20:11.946973+00 | | |
| e202411 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-25 11:19:31.058484+00 | | |
| e202411 | t_position_history | 1696745 | 0 | 0.00 | 0.00 | | 2024-11-01 10:35:23.499458+00 | | 2024-11-01 20:06:42.098498+00 |
| e202411 | t_presence_history | 303475 | 77332 | 0.00 | 20.00 | | 2024-11-02 01:42:32.408111+00 | | 2024-11-02 01:44:32.292815+00 |
| e202411 | t_sensor_history | 58207 | 0 | 0.00 | 0.00 | | 2024-11-01 20:32:42.978998+00 | | 2024-11-02 00:26:01.781151+00 |
| public | __digdag_status | 6 | 14 | 2.00 | 70.00 | | 2024-10-31 21:20:08.959718+00 | | 2024-11-01 13:10:36.454379+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2024-10-30 03:27:18.099277+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:55.147438+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-10-28 08:14:35.379014+00 | | |
| public | b_attendance_group | 491465 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.372943+00 | | |
| public | b_attendance_hour | 7374841 | 0 | 0.00 | 0.00 | | 2024-10-28 11:23:46.743681+00 | | |
| public | b_attendance_pot | 279189 | 0 | 0.00 | 0.00 | | 2024-10-24 16:17:19.106803+00 | | 2024-10-24 18:41:00.274672+00 |
| public | b_attendance_pot_hour | 4325033 | 0 | 0.00 | 0.00 | | 2024-10-24 05:08:57.742587+00 | | 2024-10-24 18:41:04.314104+00 |
| public | b_check_in | 3962681 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:31.544344+00 | | |
| public | b_check_in_hour | 59461891 | 0 | 0.00 | 0.00 | | 2024-10-28 11:24:04.27664+00 | | |
| public | b_check_in_pot | 150009 | 0 | 0.00 | 0.00 | | 2024-10-25 02:17:18.464078+00 | | 2024-10-22 18:20:35.817639+00 |
| public | b_check_in_pot_hour | 2887471 | 0 | 0.00 | 0.00 | | 2024-10-24 07:00:42.188658+00 | | 2024-11-01 18:26:05.689469+00 |
| public | b_proximity_group | 33173569 | 0 | 0.00 | 0.00 | | 2024-10-28 12:11:21.020351+00 | | |
| public | b_proximity_info | 29696175 | 0 | 0.00 | 0.00 | | 2024-10-25 02:16:16.54021+00 | | |
| public | b_seat_reserve | 894935 | 0 | 0.00 | 0.00 | | 2024-10-28 11:42:26.31841+00 | | |
| public | b_seat_reserve_hour | 16799184 | 0 | 0.00 | 0.00 | | 2024-10-28 08:14:35.244134+00 | | |
| public | b_usage | 1005546 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.850154+00 | | |
| public | b_usage_hour | 18400027 | 0 | 0.00 | 0.00 | | 2024-10-28 11:14:40.66615+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-28 08:20:37.601081+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-28 08:20:37.583442+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-28 08:21:00.98664+00 | | |
| public | m_area | 93 | 0 | 0.00 | 0.00 | | 2024-10-28 12:33:18.585557+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-10-28 11:28:05.307697+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.941145+00 | | |
| public | m_exb | 4297 | 15 | 0.00 | 0.00 | | 2024-10-28 00:31:57.781913+00 | | |
| public | m_favorite | 35318 | 343 | 0.00 | 0.00 | | 2024-10-27 09:43:20.750605+00 | | 2024-10-08 09:37:31.834203+00 |
| public | m_favorite_group | 7565 | 12 | 0.00 | 0.00 | | 2024-10-30 01:37:29.427463+00 | | 2024-10-25 08:55:40.648705+00 |
| public | m_feature | 165 | 0 | 0.00 | 0.00 | | 2024-10-28 12:42:32.844822+00 | | |
| public | m_group | 2320 | 1 | 0.00 | 0.00 | | 2024-10-27 18:33:14.838391+00 | | |
| public | m_holiday | 5588 | 0 | 0.00 | 0.00 | | 2024-10-28 08:20:37.621813+00 | | |
| public | m_lob | 1168 | 11 | 0.00 | 0.00 | | 2024-10-27 18:33:15.040979+00 | | |
| public | m_location | 5434 | 23 | 0.00 | 0.00 | | 2024-10-27 18:33:14.965317+00 | | |
| public | m_notify_template | 124 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.904151+00 | | |
| public | m_outside | 63 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.163872+00 | | |
| public | m_pot | 26120 | 33 | 0.00 | 0.00 | | 2024-11-02 00:11:01.481848+00 | | 2024-11-02 00:11:02.361882+00 |
| public | m_pot_profile | 674 | 26 | 0.00 | 3.00 | | 2024-10-28 11:23:43.470573+00 | | 2024-10-31 01:38:07.653388+00 |
| public | m_provider_user | 59 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.118745+00 | | |
| public | m_region | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 12:32:17.633999+00 | | |
| public | m_role | 79 | 0 | 0.00 | 0.00 | | 2024-10-28 12:33:18.568388+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:30.439106+00 | | |
| public | m_setting | 3537 | 142 | 0.00 | 3.00 | | 2024-11-01 10:06:19.642815+00 | | 2024-11-01 08:50:26.901063+00 |
| public | m_setting_log | 4809 | 428 | 0.00 | 8.00 | | 2024-10-30 12:30:30.821522+00 | | 2024-11-01 21:21:47.270984+00 |
| public | m_site | 26 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.885637+00 | | |
| public | m_tenant | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.082778+00 | | |
| public | m_tx | 27346 | 2131 | 0.00 | 7.00 | | 2024-11-01 08:53:27.27751+00 | | 2024-11-01 08:52:27.085739+00 |
| public | m_user | 3253 | 2 | 0.00 | 0.00 | | 2024-10-28 23:56:22.596594+00 | | |
| public | m_zone | 751 | 3 | 0.00 | 0.00 | | 2024-10-28 08:17:55.23092+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-10-28 11:43:25.973878+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:30.418866+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.187193+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-10-28 11:42:25.984069+00 | | |
| public | r_location_zone | 5983 | 28 | 0.00 | 0.00 | | 2024-11-01 00:12:39.448777+00 | | |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-10-28 11:28:05.330443+00 | | |
| public | r_pot_category | 989 | 9 | 0.00 | 0.00 | | 2024-10-28 11:27:05.306361+00 | | |
| public | r_pot_group | 12044 | 966 | 0.00 | 7.00 | | 2024-11-01 23:13:00.988131+00 | | 2024-11-01 23:33:00.843456+00 |
| public | r_pot_tx | 10152 | 11 | 0.00 | 0.00 | | 2024-10-31 06:05:20.606701+00 | | |
| public | r_pot_user | 3024 | 1 | 0.00 | 0.00 | | 2024-10-28 23:56:22.497034+00 | | |
| public | r_provider_tenant | 161 | 0 | 0.00 | 0.00 | | 2024-10-24 13:27:47.373242+00 | | |
| public | r_role_feature | 598 | 0 | 0.00 | 0.00 | | 2024-10-27 13:31:54.74472+00 | | |
| public | r_tenant_feature | 645 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.101252+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.208593+00 | | |
| public | r_user_region | 3082 | 2 | 0.00 | 0.00 | | 2024-10-28 23:56:22.536161+00 | | |
| public | r_user_site | 356 | 1 | 0.00 | 0.00 | | 2024-10-25 01:57:04.488697+00 | | |
| public | r_zone_category | 684 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.135814+00 | | |
| public | t_ai_history | 33 | 0 | 0.00 | 0.00 | | 2024-10-29 11:21:06.475001+00 | | |
| public | t_attendance | 376127 | 6105 | 0.00 | 1.00 | | 2024-10-28 12:33:25.971598+00 | | 2024-10-31 08:47:16.370632+00 |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2024-10-28 12:32:17.617736+00 | | |
| public | t_mobile_device_history | 96783 | 0 | 0.00 | 0.00 | | 2024-10-28 08:45:04.064105+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:36.915455+00 | | |
| public | t_notify_history | 538473 | 6085 | 0.00 | 1.00 | | 2024-10-28 12:32:19.904995+00 | | 2024-10-24 15:03:15.635118+00 |
| public | t_operation_log | 2455054 | 0 | 0.00 | 0.00 | | 2024-10-28 08:31:04.238095+00 | | |
| public | t_plan | 4105212 | 255250 | 0.00 | 5.00 | | 2024-10-28 01:39:53.550293+00 | | 2024-10-29 21:03:39.044527+00 |
| public | t_plan_detail | 4980902 | 133387 | 0.00 | 2.00 | | 2024-10-30 17:43:19.08068+00 | | 2024-10-31 12:21:34.234277+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-10-30 02:04:11.585106+00 | | |
| public | t_plan_sync | 233318 | 30434 | 0.00 | 11.00 | | 2024-10-24 10:49:15.456696+00 | | 2024-11-01 09:17:29.291294+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:55.066068+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-10-28 11:14:33.256327+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-10-28 11:27:05.267224+00 | | |
| public | t_recv_position_history | 5487 | 2384 | 0.00 | 30.00 | | 2024-11-02 01:44:32.330207+00 | 2024-11-01 12:42:00.634673+00 | 2024-11-02 01:44:32.353901+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-10-28 11:16:33.309088+00 | | |
| public | t_terminal | 22716 | 658 | 0.00 | 2.00 | | 2024-11-01 00:15:46.15212+00 | | 2024-11-01 21:24:47.894299+00 |
| public | t_terminal_log | 4937011 | 0 | 0.00 | 0.00 | | 2024-10-28 08:18:00.652956+00 | | |
| public | w_arrival_notify | 1 | 4 | 4.00 | 80.00 | | 2024-10-28 08:21:01.038349+00 | | |
| public | w_latest_position | 10692 | 1438 | 0.00 | 11.00 | | 2024-11-01 17:46:59.363033+00 | | 2024-11-02 01:37:28.454626+00 |
| public | w_latest_presence | 17226 | 21995 | 1.00 | 56.00 | | 2024-11-02 01:44:32.431293+00 | | 2024-11-02 01:44:32.526859+00 |
| public | w_latest_sensor | 163 | 60 | 0.00 | 26.00 | | 2024-11-02 01:43:31.893471+00 | | 2024-11-02 01:42:31.805863+00 |
| public | w_lock | 1052 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:54.791118+00 | | |
| public | w_master_update | 17 | 25 | 1.00 | 59.00 | | 2024-11-01 08:48:26.781301+00 | | 2024-11-01 23:13:01.37262+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_with_detail | 4095455 | 289413 | 0.00 | 6.00 | | 2024-10-27 11:32:59.532396+00 | | 2024-10-29 16:59:03.742098+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-10-30 01:51:29.897995+00 | | |