| 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 |
|---|
| e202506 | a_proximity_sum | 31875067 | 0 | 0.00 | 0.00 | | 2025-08-20 23:24:14.839377+00 | | |
| e202506 | a_stay_time | 42842031 | 0 | 0.00 | 0.00 | | 2025-08-20 05:01:45.939519+00 | | |
| e202506 | t_position_history | 547026656 | 0 | 0.00 | 0.00 | | 2025-08-22 01:32:34.366317+00 | | |
| e202506 | t_presence_history | 67840699 | 0 | 0.00 | 0.00 | | 2025-08-21 04:04:43.167384+00 | | |
| e202506 | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| e202507 | a_proximity_sum | 57061220 | 0 | 0.00 | 0.00 | | 2025-08-22 11:00:08.053041+00 | | |
| e202507 | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202507 | t_position_history | 2 | 0 | 0.00 | 0.00 | | | | |
| e202507 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| e202507 | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| e202508 | a_proximity_sum | 26771714 | 0 | 0.00 | 0.00 | | 2025-08-22 16:11:01.124689+00 | | 2025-08-21 18:06:30.73464+00 |
| e202508 | a_stay_time | 26171723 | 0 | 0.00 | 0.00 | | 2025-08-21 17:38:14.945368+00 | | 2025-08-22 17:16:18.58493+00 |
| e202508 | t_position_history | 423639540 | 4 | 0.00 | 0.00 | | 2025-08-21 07:52:01.664096+00 | | 2025-08-22 12:06:48.471877+00 |
| e202508 | t_presence_history | 38837857 | 5433489 | 0.00 | 12.00 | | 2025-08-23 00:21:47.914363+00 | | 2025-08-23 00:48:17.407399+00 |
| e202508 | t_sensor_history | 8670435 | 0 | 0.00 | 0.00 | | 2025-08-21 07:58:17.099633+00 | | 2025-08-21 18:06:29.911819+00 |
| public | __digdag_status | 32 | 4 | 0.00 | 11.00 | | 2025-08-22 10:06:05.83482+00 | | |
| public | a_attendance_sum | 144949 | 21818 | 0.00 | 13.00 | | 2025-08-21 23:47:10.18321+00 | | 2025-08-22 11:27:45.225678+00 |
| public | a_plan_actual | 891176 | 2 | 0.00 | 0.00 | | 2025-08-20 03:53:13.715266+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| public | aaa | 0 | 0 | 0 | 0 | | | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-08-20 22:22:03.424818+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-08-20 09:15:37.973017+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-08-20 10:33:04.921351+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-08-20 09:14:48.148493+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-08-20 10:33:04.940405+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-08-20 10:33:04.959906+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-08-20 09:14:48.185826+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-08-20 09:14:48.127309+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-08-20 10:33:02.495433+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-08-20 09:14:48.207216+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-08-20 09:14:48.227509+00 | | |
| public | l_area | 4 | 4 | 1.00 | 50.00 | | | | |
| public | l_auth | 0 | 0 | 0 | 0 | | | | |
| public | l_category | 11 | 0 | 0.00 | 0.00 | | | | |
| public | l_group | 153 | 161 | 1.00 | 51.00 | | | | |
| public | l_location | 734 | 718 | 0.00 | 49.00 | | | | |
| public | l_location_zone | 1480 | 1641 | 1.00 | 52.00 | | | | |
| public | l_outside | 0 | 0 | 0 | 0 | | | | |
| public | l_pot | 7108 | 3584 | 0.00 | 33.00 | | | | |
| public | l_pot_category | 400 | 389 | 0.00 | 49.00 | | | | |
| public | l_pot_group | 3553 | 420 | 0.00 | 10.00 | | | | |
| public | l_pot_tx | 835 | 864 | 1.00 | 50.00 | | | | |
| public | l_role | 4 | 0 | 0.00 | 0.00 | | | | |
| public | l_role_feature | 35 | 7 | 0.00 | 16.00 | | | | |
| public | l_site | 1 | 0 | 0.00 | 0.00 | | | | |
| public | l_tx | 140558 | 18845 | 0.00 | 11.00 | | 2025-08-22 12:04:58.343131+00 | | 2025-08-22 12:10:45.995975+00 |
| public | l_user | 664 | 788 | 1.00 | 54.00 | | | | |
| public | l_zone | 20 | 4 | 0.00 | 16.00 | | | | |
| public | l_zone_category | 48 | 0 | 0.00 | 0.00 | | | | |
| public | m_area | 782 | 5 | 0.00 | 0.00 | | 2025-08-20 06:48:09.780375+00 | | |
| public | m_auth | 0 | 0 | 0 | 0 | | | | |
| public | m_category | 2432 | 1 | 0.00 | 0.00 | | 2025-08-20 06:48:09.750743+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-08-21 01:07:59.420833+00 | | |
| public | m_exb | 0 | 38 | 0 | 100.00 | | | | |
| public | m_favorite | 232450 | 429 | 0.00 | 0.00 | | 2025-08-20 01:53:29.620797+00 | | |
| public | m_favorite_group | 112472 | 27 | 0.00 | 0.00 | | 2025-08-21 10:03:27.740203+00 | | |
| public | m_feature | 0 | 0 | 0 | 0 | | | | |
| public | m_group | 27893 | 1223 | 0.00 | 4.00 | | 2025-08-21 07:52:49.953942+00 | | 2025-08-21 14:40:45.694865+00 |
| public | m_holiday | 44100 | 0 | 0.00 | 0.00 | | 2025-08-22 23:30:04.392057+00 | | |
| public | m_lob | 69 | 43 | 0.00 | 38.00 | | | | |
| public | m_lob_log | 1962 | 0 | 0.00 | 0.00 | | 2025-08-22 09:20:42.931174+00 | | |
| public | m_location | 44525 | 1329 | 0.00 | 2.00 | | 2025-08-20 05:02:47.018286+00 | | |
| public | m_notify_template | 6 | 0 | 0.00 | 0.00 | | | | |
| public | m_outside | 372 | 0 | 0.00 | 0.00 | | 2025-08-22 04:46:03.341714+00 | | |
| public | m_personal_setting | 131679 | 15150 | 0.00 | 10.00 | | 2025-08-21 19:33:40.885074+00 | | 2025-08-22 10:55:04.562424+00 |
| public | m_pot | 199455 | 18827 | 0.00 | 8.00 | | 2025-08-19 17:13:11.148703+00 | | 2025-08-21 14:40:44.390559+00 |
| public | m_pot_profile | 177 | 23 | 0.00 | 11.00 | | | | |
| public | m_provider_user | 1 | 5 | 5.00 | 83.00 | | | | |
| public | m_region | 1 | 0 | 0.00 | 0.00 | | | | |
| public | m_role | 4 | 0 | 0.00 | 0.00 | | | | |
| public | m_sensor | 0 | 0 | 0 | 0 | | | | |
| public | m_setting | 15816 | 2496 | 0.00 | 13.00 | | 2025-08-21 11:35:00.37485+00 | | 2025-08-22 23:11:02.898601+00 |
| public | m_setting_log | 35968 | 0 | 0.00 | 0.00 | | | | 2025-08-23 00:14:06.750304+00 |
| public | m_site | 1 | 0 | 0.00 | 0.00 | | | | |
| public | m_tenant | 1 | 0 | 0.00 | 0.00 | | | | |
| public | m_tx | 173813 | 7085 | 0.00 | 3.00 | | 2025-08-22 12:35:17.390339+00 | | 2025-08-22 12:25:16.292051+00 |
| public | m_user | 37224 | 267 | 0.00 | 0.00 | | 2025-08-21 22:44:12.102824+00 | | |
| public | m_zone | 7845 | 30 | 0.00 | 0.00 | | 2025-08-19 21:58:45.253055+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | | | |
| public | r_auth_zone | 213 | 0 | 0.00 | 0.00 | | 2025-08-20 02:26:29.924536+00 | | |
| public | r_exb_sensor | 0 | 0 | 0 | 0 | | | | |
| public | r_group_auth | 555 | 0 | 0.00 | 0.00 | | 2025-08-20 23:24:14.768288+00 | | |
| public | r_location_zone | 54256 | 1521 | 0.00 | 2.00 | | 2025-08-20 06:48:09.729389+00 | | |
| public | r_pot_auth | 8151 | 0 | 0.00 | 0.00 | | 2025-08-22 11:00:03.096581+00 | | |
| public | r_pot_category | 11697 | 0 | 0.00 | 0.00 | | 2025-08-22 08:17:59.140943+00 | | |
| public | r_pot_group | 433566 | 356 | 0.00 | 0.00 | | 2025-08-21 01:07:57.767321+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-08-19 22:31:53.780118+00 | | |
| public | r_pot_tx | 69628 | 0 | 0.00 | 0.00 | | 2025-08-22 20:33:36.735896+00 | | |
| public | r_pot_user | 214 | 121 | 0.00 | 36.00 | | | | |
| public | r_provider_tenant | 4 | 20 | 5.00 | 83.00 | | | | |
| public | r_role_feature | 6083 | 0 | 0.00 | 0.00 | | 2025-08-21 10:26:45.980237+00 | | |
| public | r_tenant_feature | 4440 | 0 | 0.00 | 0.00 | | 2025-08-20 09:14:45.668323+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-08-21 07:52:49.98141+00 | | |
| public | r_user_region | 213 | 121 | 0.00 | 36.00 | | | | |
| public | r_user_site | 4 | 1 | 0.00 | 20.00 | | | | |
| public | r_zone_category | 5001 | 0 | 0.00 | 0.00 | | 2025-08-22 09:20:42.903478+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-08-21 03:46:39.658808+00 | | |
| public | t_attendance | 3150215 | 22701 | 0.00 | 0.00 | | 2025-08-20 09:15:37.943742+00 | | |
| public | t_general | 4133 | 0 | 0.00 | 0.00 | | 2025-08-20 22:05:44.811173+00 | | |
| public | t_general_20250618 | 3464 | 0 | 0.00 | 0.00 | | 2025-08-22 03:33:57.005639+00 | | |
| public | t_mobile_device_history | 4455 | 0 | 0.00 | 0.00 | | | | |
| public | t_mobile_status_history | 42096 | 0 | 0.00 | 0.00 | | | | |
| public | t_news | 0 | 0 | 0 | 0 | | | | |
| public | t_notify_history | 49669 | 9716 | 0.00 | 16.00 | | | | |
| public | t_operation_log | 21766217 | 3 | 0.00 | 0.00 | | 2025-08-22 10:06:05.76108+00 | | |
| public | t_plan | 26974216 | 597495 | 0.00 | 2.00 | | 2025-08-21 06:52:35.985713+00 | | 2025-08-22 08:10:00.726417+00 |
| public | t_plan_cancel_history | 6523 | 69803 | 10.00 | 91.00 | | | | |
| public | t_plan_detail | 46191139 | 2789091 | 0.00 | 5.00 | | | | 2025-08-21 09:32:21.407526+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-08-19 22:31:53.758287+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-08-19 22:31:53.737747+00 | | |
| public | t_plan_sync | 101375 | 1412 | 0.00 | 1.00 | | 2025-08-23 00:38:16.936095+00 | | 2025-08-23 00:36:16.688584+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | | | |
| public | t_recv_position_history | 141414 | 26131 | 0.00 | 15.00 | | 2025-08-23 00:52:16.573118+00 | 2025-08-22 13:30:05.098263+00 | 2025-08-23 00:53:11.367245+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| public | t_terminal | 20890 | 3558 | 0.00 | 14.00 | | 2025-08-22 07:05:32.291072+00 | | 2025-08-23 00:22:12.577157+00 |
| public | t_terminal_log | 27435829 | 0 | 0.00 | 0.00 | | 2025-08-22 07:29:31.594021+00 | | |
| public | temp_pivot_table | 0 | 0 | 0 | 0 | | | | |
| public | w_arrival_notify | 98 | 63 | 0.00 | 39.00 | | | | 2025-08-21 04:51:48.10795+00 |
| public | w_latest_mobile_device | 56206 | 268 | 0.00 | 0.00 | | 2025-08-21 04:52:51.565861+00 | | |
| public | w_latest_mobile_status | 55174 | 4867 | 0.00 | 8.00 | | 2025-08-22 08:35:59.826618+00 | | 2025-08-22 12:16:45.702975+00 |
| public | w_latest_position | 78892 | 6650 | 0.00 | 7.00 | | 2025-08-23 00:51:11.446898+00 | | 2025-08-23 00:52:16.944947+00 |
| public | w_latest_presence | 237831 | 142641 | 0.00 | 37.00 | | 2025-08-23 00:52:34.066388+00 | | 2025-08-23 00:52:34.434059+00 |
| public | w_latest_sensor | 386 | 61 | 0.00 | 13.00 | | 2025-08-23 00:53:11.383247+00 | | 2025-08-23 00:53:11.494482+00 |
| public | w_lock | 18228 | 0 | 0.00 | 0.00 | | 2025-08-21 08:54:17.336319+00 | | |
| public | w_master_update | 199 | 35 | 0.00 | 14.00 | | 2025-08-22 21:40:43.948891+00 | | 2025-08-22 21:08:48.361316+00 |
| public | w_migration | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_sync_retry | 0 | 45 | 0 | 100.00 | | 2025-08-22 02:30:46.61229+00 | | 2025-08-22 07:21:03.087571+00 |
| public | w_plan_with_detail | 27009478 | 1212892 | 0.00 | 4.00 | | | | 2025-08-22 08:02:53.881533+00 |