| 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 | 42841987 | 0 | 0.00 | 0.00 | | 2025-08-25 23:19:52.473101+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 | 11758352 | 0 | 0.00 | 0.00 | | 2025-08-25 05:23:36.372604+00 | | |
| e202507 | a_proximity_sum | 57061220 | 0 | 0.00 | 0.00 | | 2025-08-22 11:00:08.053041+00 | | |
| e202507 | a_stay_time | 47407727 | 0 | 0.00 | 0.00 | | 2025-08-24 02:01:16.763315+00 | | |
| e202507 | t_position_history | 610147772 | 0 | 0.00 | 0.00 | | 2025-08-24 12:10:03.540215+00 | | |
| e202507 | t_presence_history | 55790809 | 0 | 0.00 | 0.00 | | 2025-08-24 07:46:06.862831+00 | | |
| e202507 | t_sensor_history | 11690430 | 0 | 0.00 | 0.00 | | 2025-08-25 00:39:33.248244+00 | | |
| e202508 | a_proximity_sum | 28251378 | 0 | 0.00 | 0.00 | | 2025-08-22 16:11:01.124689+00 | | 2025-08-25 17:38:14.240699+00 |
| e202508 | a_stay_time | 28366753 | 0 | 0.00 | 0.00 | | 2025-08-24 14:16:16.877187+00 | | 2025-08-25 18:36:49.645734+00 |
| e202508 | t_position_history | 470101604 | 1 | 0.00 | 0.00 | | 2025-08-21 07:52:01.664096+00 | | 2025-08-25 09:19:09.729179+00 |
| e202508 | t_presence_history | 43259922 | 3767442 | 0.00 | 8.00 | | 2025-08-26 00:33:29.691997+00 | | 2025-08-26 00:33:56.028059+00 |
| e202508 | t_sensor_history | 9777979 | 0 | 0.00 | 0.00 | | 2025-08-25 23:05:13.740337+00 | | 2025-08-23 20:34:11.822404+00 |
| public | __digdag_status | 33 | 15 | 0.00 | 31.00 | | 2025-08-22 10:06:05.83482+00 | | |
| public | a_attendance_sum | 146139 | 25135 | 0.00 | 14.00 | | 2025-08-25 00:37:36.698807+00 | | 2025-08-26 00:25:10.374099+00 |
| public | a_plan_actual | 898506 | 0 | 0.00 | 0.00 | | 2025-08-25 19:44:13.32388+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-08-25 02:08:24.408053+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-08-25 02:08:18.710951+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:17.503874+00 | | |
| 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 | 1524 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:46.162154+00 | | |
| public | l_auth | 172 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:46.109959+00 | | |
| public | l_category | 2696 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:47.411463+00 | | |
| public | l_group | 35206 | 4 | 0.00 | 0.00 | | 2025-08-24 05:40:49.728758+00 | | |
| public | l_location | 102894 | 69 | 0.00 | 0.00 | | 2025-08-24 05:40:47.253199+00 | | |
| public | l_location_zone | 99950 | 75 | 0.00 | 0.00 | | 2025-08-24 05:40:46.632324+00 | | |
| public | l_outside | 441 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:46.130419+00 | | |
| public | l_pot | 423666 | 365 | 0.00 | 0.00 | | 2025-08-24 05:40:55.59138+00 | | |
| public | l_pot_category | 13032 | 138 | 0.00 | 1.00 | | 2025-08-24 05:40:47.386698+00 | | |
| public | l_pot_group | 227001 | 29 | 0.00 | 0.00 | | 2025-08-24 05:40:49.401816+00 | | |
| public | l_pot_tx | 99116 | 239 | 0.00 | 0.00 | | 2025-08-24 05:40:48.158613+00 | | |
| public | l_role | 771 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:44.919122+00 | | |
| public | l_role_feature | 6267 | 19 | 0.00 | 0.00 | | 2025-08-24 05:40:44.903732+00 | | |
| public | l_site | 247 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:46.187691+00 | | |
| public | l_tx | 140608 | 21507 | 0.00 | 13.00 | | 2025-08-22 12:04:58.343131+00 | | 2025-08-25 09:56:16.570679+00 |
| public | l_user | 61663 | 429 | 0.00 | 0.00 | | 2025-08-24 05:40:44.807064+00 | | |
| public | l_zone | 9988 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:46.705754+00 | | |
| public | l_zone_category | 5428 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:43.879377+00 | | |
| public | m_area | 782 | 5 | 0.00 | 0.00 | | 2025-08-20 06:48:09.780375+00 | | |
| public | m_auth | 140 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.454948+00 | | |
| 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 | 26653 | 0 | 0.00 | 0.00 | | 2025-08-24 23:53:07.74175+00 | | |
| public | m_favorite | 238501 | 23 | 0.00 | 0.00 | | 2025-08-25 12:13:48.901453+00 | | |
| public | m_favorite_group | 112699 | 53 | 0.00 | 0.00 | | 2025-08-21 10:03:27.740203+00 | | |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-08-25 04:18:39.329469+00 | | |
| public | m_group | 27897 | 1609 | 0.00 | 5.00 | | 2025-08-21 07:52:49.953942+00 | | 2025-08-25 14:40:49.775714+00 |
| public | m_holiday | 44100 | 0 | 0.00 | 0.00 | | 2025-08-22 23:30:04.392057+00 | | |
| public | m_lob | 24513 | 12 | 0.00 | 0.00 | | 2025-08-23 09:15:30.702631+00 | | |
| public | m_lob_log | 1969 | 0 | 0.00 | 0.00 | | 2025-08-22 09:20:42.931174+00 | | |
| public | m_location | 44549 | 28 | 0.00 | 0.00 | | 2025-08-25 23:22:15.217914+00 | | |
| public | m_notify_template | 1118 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.835812+00 | | |
| public | m_outside | 372 | 0 | 0.00 | 0.00 | | 2025-08-22 04:46:03.341714+00 | | |
| public | m_personal_setting | 131825 | 16789 | 0.00 | 11.00 | | 2025-08-21 19:33:40.885074+00 | | 2025-08-26 00:21:10.071268+00 |
| public | m_pot | 199829 | 5529 | 0.00 | 2.00 | | 2025-08-25 06:50:55.353411+00 | | 2025-08-23 14:40:42.674661+00 |
| public | m_pot_profile | 53050 | 36 | 0.00 | 0.00 | | 2025-08-23 23:38:21.181987+00 | | |
| public | m_provider_user | 84 | 0 | 0.00 | 0.00 | | 2025-08-25 05:25:37.057324+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.922998+00 | | |
| public | m_role | 774 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.901638+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.594615+00 | | |
| public | m_setting | 24978 | 765 | 0.00 | 2.00 | | 2025-08-25 13:31:05.331666+00 | | 2025-08-24 22:32:03.66246+00 |
| public | m_setting_log | 36015 | 1516 | 0.00 | 4.00 | | 2025-08-24 14:25:30.266674+00 | | 2025-08-25 12:30:53.812148+00 |
| public | m_site | 185 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.434366+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.967481+00 | | |
| public | m_tx | 120779 | 22436 | 0.00 | 15.00 | | 2025-08-25 13:21:05.931003+00 | | 2025-08-25 23:46:02.500602+00 |
| public | m_user | 37232 | 412 | 0.00 | 1.00 | | 2025-08-21 22:44:12.102824+00 | | |
| public | m_zone | 7845 | 28 | 0.00 | 0.00 | | 2025-08-25 07:48:17.883557+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-08-25 02:08:17.477926+00 | | |
| public | r_auth_zone | 213 | 0 | 0.00 | 0.00 | | 2025-08-25 13:21:06.214384+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.860888+00 | | |
| public | r_group_auth | 555 | 0 | 0.00 | 0.00 | | 2025-08-20 23:24:14.768288+00 | | |
| public | r_location_zone | 54257 | 1593 | 0.00 | 2.00 | | 2025-08-20 06:48:09.729389+00 | | |
| public | r_pot_auth | 8153 | 0 | 0.00 | 0.00 | | 2025-08-22 11:00:03.096581+00 | | |
| public | r_pot_category | 11661 | 147 | 0.00 | 1.00 | | 2025-08-22 08:17:59.140943+00 | | |
| public | r_pot_group | 433581 | 415 | 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-25 08:00:37.796162+00 | | |
| public | r_pot_tx | 69701 | 248 | 0.00 | 0.00 | | 2025-08-22 20:33:36.735896+00 | | |
| public | r_pot_user | 20702 | 3 | 0.00 | 0.00 | | 2025-08-23 10:51:31.733432+00 | | |
| public | r_provider_tenant | 942 | 10 | 0.00 | 1.00 | | 2025-08-24 13:05:25.71702+00 | | |
| public | r_role_feature | 6128 | 19 | 0.00 | 0.00 | | 2025-08-21 10:26:45.980237+00 | | |
| public | r_tenant_feature | 4461 | 5 | 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 | 21554 | 3 | 0.00 | 0.00 | | 2025-08-23 10:51:30.848351+00 | | |
| public | r_user_site | 5556 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.571028+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 | 3164928 | 33384 | 0.00 | 1.00 | | 2025-08-20 09:15:37.943742+00 | | |
| public | t_general | 4146 | 5 | 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 | 947239 | 0 | 0.00 | 0.00 | | 2025-08-25 06:01:22.867229+00 | | |
| public | t_mobile_status_history | 1805892 | 0 | 0.00 | 0.00 | | 2025-08-23 06:06:30.852064+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.88515+00 | | |
| public | t_notify_history | 6432977 | 3298 | 0.00 | 0.00 | | 2025-08-25 06:17:31.445402+00 | | |
| public | t_operation_log | 21849403 | 24 | 0.00 | 0.00 | | 2025-08-22 10:06:05.76108+00 | | |
| public | t_plan | 27096547 | 1072237 | 0.00 | 3.00 | | 2025-08-21 06:52:35.985713+00 | | 2025-08-22 08:10:00.726417+00 |
| public | t_plan_cancel_history | 581666 | 25373 | 0.00 | 4.00 | | 2025-08-23 19:31:59.762045+00 | | |
| public | t_plan_detail | 46397214 | 1266968 | 0.00 | 2.00 | | 2025-08-23 05:32:06.733415+00 | | 2025-08-25 04:55:01.211744+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-08-25 08:00:37.77739+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-08-25 08:00:37.756937+00 | | |
| public | t_plan_sync | 65875 | 7736 | 0.00 | 10.00 | | 2025-08-25 23:25:15.807892+00 | | 2025-08-26 00:40:49.527859+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.997618+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-08-25 02:08:17.567068+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-08-25 02:08:24.945173+00 | | |
| public | t_recv_position_history | 155054 | 10579 | 0.00 | 6.00 | | 2025-08-26 00:52:54.464291+00 | 2025-08-25 13:30:04.484289+00 | 2025-08-26 00:52:54.772618+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-08-25 02:08:17.640349+00 | | |
| public | t_terminal | 31345 | 1267 | 0.00 | 3.00 | | 2025-08-26 00:13:06.141375+00 | | 2025-08-26 00:01:04.548846+00 |
| public | t_terminal_log | 27668542 | 0 | 0.00 | 0.00 | | 2025-08-22 07:29:31.594021+00 | | |
| public | temp_pivot_table | 240255 | 0 | 0.00 | 0.00 | | 2025-08-23 23:38:27.7035+00 | | |
| public | w_arrival_notify | 101 | 23 | 0.00 | 18.00 | | 2025-08-24 02:01:16.786809+00 | | 2025-08-25 06:05:21.441203+00 |
| public | w_latest_mobile_device | 56251 | 685 | 0.00 | 1.00 | | 2025-08-21 04:52:51.565861+00 | | 2025-08-25 02:17:24.507308+00 |
| public | w_latest_mobile_status | 55219 | 2246 | 0.00 | 3.00 | | 2025-08-26 00:40:50.454546+00 | | 2025-08-26 00:13:05.67938+00 |
| public | w_latest_position | 79091 | 7632 | 0.00 | 8.00 | | 2025-08-26 00:52:54.943182+00 | | 2025-08-26 00:52:55.080148+00 |
| public | w_latest_presence | 185344 | 188574 | 1.00 | 50.00 | | 2025-08-26 00:52:10.574569+00 | | 2025-08-26 00:52:11.003181+00 |
| public | w_latest_sensor | 386 | 56 | 0.00 | 12.00 | | 2025-08-26 00:52:55.096456+00 | | 2025-08-26 00:52:55.209782+00 |
| public | w_lock | 18324 | 0 | 0.00 | 0.00 | | 2025-08-21 08:54:17.336319+00 | | |
| public | w_master_update | 194 | 33 | 0.00 | 14.00 | | 2025-08-26 00:43:49.875438+00 | | 2025-08-26 00:39:48.950093+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-08-25 03:03:55.881779+00 | | |
| public | w_plan_sync_retry | 0 | 43 | 0 | 100.00 | | 2025-08-25 22:25:27.154652+00 | | 2025-08-25 22:32:51.782903+00 |
| public | w_plan_with_detail | 26934335 | 368464 | 0.00 | 1.00 | | 2025-08-25 05:23:09.446544+00 | | 2025-08-22 08:02:53.881533+00 |