| 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 | 31875043 | 0 | 0.00 | 0.00 | | 2025-08-26 08:13:00.615066+00 | | |
| e202506 | a_stay_time | 42841987 | 0 | 0.00 | 0.00 | | 2025-08-25 23:19:52.473101+00 | | |
| e202506 | t_position_history | 547026601 | 0 | 0.00 | 0.00 | | 2025-08-27 11:06:49.177973+00 | | |
| e202506 | t_presence_history | 67840651 | 0 | 0.00 | 0.00 | | 2025-08-26 19:31:47.153914+00 | | |
| e202506 | t_sensor_history | 11758352 | 0 | 0.00 | 0.00 | | 2025-08-25 05:23:36.372604+00 | | |
| e202507 | a_proximity_sum | 57061161 | 0 | 0.00 | 0.00 | | 2025-08-28 04:11:00.867822+00 | | |
| e202507 | a_stay_time | 47407727 | 0 | 0.00 | 0.00 | | 2025-08-24 02:01:16.763315+00 | | |
| e202507 | t_position_history | 610147780 | 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 | 32668980 | 0 | 0.00 | 0.00 | | 2025-08-28 05:51:15.974026+00 | | 2025-08-27 17:06:53.560857+00 |
| e202508 | a_stay_time | 34325512 | 0 | 0.00 | 0.00 | | 2025-08-28 15:21:13.177374+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 546152972 | 106 | 0.00 | 0.00 | | 2025-08-26 07:29:14.725515+00 | | 2025-08-27 07:48:48.230771+00 |
| e202508 | t_presence_history | 50737364 | 9934544 | 0.00 | 16.00 | | 2025-08-28 23:55:40.754741+00 | | 2025-08-29 00:28:15.705911+00 |
| e202508 | t_sensor_history | 11007216 | 0 | 0.00 | 0.00 | | 2025-08-25 23:05:13.740337+00 | | 2025-08-28 22:46:31.047543+00 |
| public | __digdag_status | 33 | 3 | 0.00 | 8.00 | | 2025-08-28 03:47:37.696146+00 | | 2025-08-28 12:30:18.362409+00 |
| public | a_attendance_sum | 147850 | 24109 | 0.00 | 14.00 | | 2025-08-28 01:41:58.658146+00 | | 2025-08-29 00:42:01.252157+00 |
| public | a_plan_actual | 926786 | 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-26 07:41:34.392053+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:49.671035+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-08-26 04:24:03.325027+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:00.355582+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-08-26 04:24:03.35024+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-08-26 04:24:03.370724+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:00.375533+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:00.331476+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-08-26 04:24:01.496523+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:00.397932+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:00.419021+00 | | |
| public | l_area | 1532 | 11 | 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 | 2684 | 12 | 0.00 | 0.00 | | 2025-08-24 05:40:47.411463+00 | | |
| public | l_group | 35213 | 12 | 0.00 | 0.00 | | 2025-08-24 05:40:49.728758+00 | | |
| public | l_lob | 1920 | 10 | 0.00 | 0.00 | | 2025-08-26 10:11:39.840951+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 103379 | 563 | 0.00 | 0.00 | | 2025-08-24 05:40:47.253199+00 | | |
| public | l_location_zone | 99973 | 144 | 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 | 428559 | 5031 | 0.00 | 1.00 | | 2025-08-24 05:40:55.59138+00 | | |
| public | l_pot_category | 13078 | 171 | 0.00 | 1.00 | | 2025-08-24 05:40:47.386698+00 | | |
| public | l_pot_group | 227211 | 2005 | 0.00 | 0.00 | | 2025-08-24 05:40:49.401816+00 | | |
| public | l_pot_tx | 99881 | 814 | 0.00 | 0.00 | | 2025-08-24 05:40:48.158613+00 | | |
| public | l_role | 769 | 3 | 0.00 | 0.00 | | 2025-08-24 05:40:44.919122+00 | | |
| public | l_role_feature | 6291 | 58 | 0.00 | 0.00 | | 2025-08-24 05:40:44.903732+00 | | |
| public | l_site | 254 | 7 | 0.00 | 2.00 | | 2025-08-24 05:40:46.187691+00 | | |
| public | l_tx | 133897 | 593 | 0.00 | 0.00 | | 2025-08-28 04:19:14.852905+00 | | 2025-08-25 09:56:16.570679+00 |
| public | l_user | 62033 | 798 | 0.00 | 1.00 | | 2025-08-24 05:40:44.807064+00 | | |
| public | l_zone | 10002 | 21 | 0.00 | 0.00 | | 2025-08-24 05:40:46.705754+00 | | |
| public | l_zone_category | 5432 | 3 | 0.00 | 0.00 | | 2025-08-24 05:40:43.879377+00 | | |
| public | m_area | 783 | 10 | 0.00 | 1.00 | | 2025-08-26 01:14:55.996512+00 | | |
| public | m_auth | 140 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.454948+00 | | |
| public | m_category | 2421 | 11 | 0.00 | 0.00 | | 2025-08-26 01:14:55.663505+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-08-26 10:09:39.884392+00 | | |
| public | m_exb | 26632 | 27 | 0.00 | 0.00 | | 2025-08-24 23:53:07.74175+00 | | |
| public | m_favorite | 239224 | 708 | 0.00 | 0.00 | | 2025-08-25 12:13:48.901453+00 | | |
| public | m_favorite_group | 113262 | 52 | 0.00 | 0.00 | | 2025-08-27 04:11:18.789539+00 | | |
| public | m_feature | 168 | 1 | 0.00 | 0.00 | | 2025-08-25 04:18:39.329469+00 | | |
| public | m_group | 27904 | 294 | 0.00 | 1.00 | | 2025-08-27 02:15:21.692043+00 | | 2025-08-27 14:40:41.460277+00 |
| public | m_holiday | 43942 | 0 | 0.00 | 0.00 | | 2025-08-28 07:28:59.552994+00 | | |
| public | m_lob | 24503 | 5 | 0.00 | 0.00 | | 2025-08-28 12:37:15.856479+00 | | |
| public | m_lob_log | 1949 | 0 | 0.00 | 0.00 | | 2025-08-28 03:08:18.640809+00 | | |
| public | m_location | 44557 | 483 | 0.00 | 1.00 | | 2025-08-25 23:22:15.217914+00 | | |
| public | m_notify_template | 1224 | 9 | 0.00 | 0.00 | | 2025-08-25 02:08:24.835812+00 | | |
| public | m_outside | 372 | 0 | 0.00 | 0.00 | | 2025-08-27 22:21:30.813856+00 | | |
| public | m_personal_setting | 132061 | 16699 | 0.00 | 11.00 | | 2025-08-27 07:10:30.84288+00 | | 2025-08-29 00:22:06.980226+00 |
| public | m_pot | 200488 | 21878 | 0.00 | 9.00 | | 2025-08-25 06:50:55.353411+00 | | 2025-08-28 08:43:56.785549+00 |
| public | m_pot_profile | 52345 | 0 | 0.00 | 0.00 | | 2025-08-29 00:24:59.621977+00 | | |
| public | m_provider_user | 84 | 0 | 0.00 | 0.00 | | 2025-08-25 05:25:37.057324+00 | | |
| public | m_region | 113 | 1 | 0.00 | 0.00 | | 2025-08-25 02:08:24.922998+00 | | |
| public | m_role | 772 | 3 | 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 | 15980 | 2898 | 0.00 | 15.00 | | 2025-08-27 08:43:49.972144+00 | | 2025-08-28 20:56:22.770823+00 |
| public | m_setting_log | 36406 | 0 | 0.00 | 0.00 | | 2025-08-24 14:25:30.266674+00 | | 2025-08-28 14:02:52.882846+00 |
| public | m_site | 187 | 7 | 0.00 | 3.00 | | 2025-08-25 02:08:24.434366+00 | | |
| public | m_tenant | 112 | 1 | 0.00 | 0.00 | | 2025-08-25 02:08:24.967481+00 | | |
| public | m_tx | 120892 | 11328 | 0.00 | 8.00 | | 2025-08-26 04:06:54.952255+00 | | 2025-08-28 08:21:48.001857+00 |
| public | m_user | 36313 | 96 | 0.00 | 0.00 | | 2025-08-27 07:58:40.272056+00 | | |
| public | m_zone | 7846 | 75 | 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-26 08:13:00.546406+00 | | |
| public | r_location_zone | 54243 | 53 | 0.00 | 0.00 | | 2025-08-26 01:14:55.631973+00 | | |
| public | r_pot_auth | 8057 | 1 | 0.00 | 0.00 | | 2025-08-28 04:10:54.559129+00 | | |
| public | r_pot_category | 13517 | 32 | 0.00 | 0.00 | | 2025-08-28 02:16:28.437743+00 | | |
| public | r_pot_group | 435389 | 77 | 0.00 | 0.00 | | 2025-08-26 10:09:39.838734+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 | 69896 | 245 | 0.00 | 0.00 | | 2025-08-28 06:41:32.962464+00 | | |
| public | r_pot_user | 20057 | 0 | 0.00 | 0.00 | | 2025-08-28 14:02:52.624522+00 | | |
| public | r_provider_tenant | 940 | 12 | 0.00 | 1.00 | | 2025-08-24 13:05:25.71702+00 | | |
| public | r_role_feature | 5937 | 23 | 0.00 | 0.00 | | 2025-08-27 04:26:37.059589+00 | | |
| public | r_tenant_feature | 4419 | 34 | 0.00 | 0.00 | | 2025-08-26 03:37:52.872125+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-08-27 02:15:21.703208+00 | | |
| public | r_user_region | 21416 | 0 | 0.00 | 0.00 | | 2025-08-28 14:02:51.893863+00 | | |
| public | r_user_site | 5556 | 1 | 0.00 | 0.00 | | 2025-08-25 02:08:24.571028+00 | | |
| public | r_zone_category | 4964 | 0 | 0.00 | 0.00 | | 2025-08-28 03:08:18.608534+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-08-26 18:00:01.5338+00 | | |
| public | t_attendance | 3188633 | 30450 | 0.00 | 0.00 | | 2025-08-26 03:38:49.64713+00 | | |
| public | t_general | 4159 | 4 | 0.00 | 0.00 | | 2025-08-26 07:32:50.956286+00 | | |
| public | t_general_20250618 | 3410 | 0 | 0.00 | 0.00 | | 2025-08-27 17:02:52.764855+00 | | |
| public | t_job | 31 | 15 | 0.00 | 32.00 | | | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 951065 | 2 | 0.00 | 0.00 | | 2025-08-25 06:01:22.867229+00 | | |
| public | t_mobile_status_history | 1823186 | 0 | 0.00 | 0.00 | | 2025-08-28 10:21:25.44824+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-08-25 02:08:24.88515+00 | | |
| public | t_notify_history | 6481816 | 12466 | 0.00 | 0.00 | | 2025-08-25 06:17:31.445402+00 | | |
| public | t_operation_log | 21903540 | 10 | 0.00 | 0.00 | | 2025-08-28 03:47:37.590212+00 | | |
| public | t_plan | 27435563 | 840841 | 0.00 | 2.00 | | 2025-08-27 01:10:39.679048+00 | | 2025-08-27 01:17:16.258795+00 |
| public | t_plan_cancel_history | 589489 | 908 | 0.00 | 0.00 | | 2025-08-28 23:05:37.563117+00 | | |
| public | t_plan_detail | 46693193 | 350437 | 0.00 | 0.00 | | 2025-08-28 10:03:48.699853+00 | | 2025-08-27 03:17:58.113105+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 | 65936 | 8453 | 0.00 | 11.00 | | 2025-08-29 00:21:07.343382+00 | | 2025-08-29 00:43:00.952121+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 | 152894 | 19405 | 0.00 | 11.00 | | 2025-08-29 00:55:06.685693+00 | 2025-08-28 13:30:09.20192+00 | 2025-08-29 00:55:06.981002+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-08-25 02:08:17.640349+00 | | |
| public | t_terminal | 20927 | 1620 | 0.00 | 7.00 | | 2025-08-28 20:37:33.926476+00 | | 2025-08-29 00:37:02.25611+00 |
| public | t_terminal_log | 27870510 | 0 | 0.00 | 0.00 | | 2025-08-28 01:39:25.712669+00 | | |
| public | temp_pivot_table | 240184 | 0 | 0.00 | 0.00 | | 2025-08-29 00:25:06.94772+00 | | |
| public | w_arrival_notify | 98 | 59 | 0.00 | 37.00 | | 2025-08-24 02:01:16.786809+00 | | 2025-08-27 23:53:09.287893+00 |
| public | w_latest_mobile_device | 56325 | 596 | 0.00 | 1.00 | | 2025-08-26 22:47:03.156676+00 | | 2025-08-25 02:17:24.507308+00 |
| public | w_latest_mobile_status | 55294 | 5376 | 0.00 | 8.00 | | 2025-08-28 23:58:01.830642+00 | | 2025-08-29 00:48:07.945048+00 |
| public | w_latest_position | 79168 | 20343 | 0.00 | 20.00 | | 2025-08-29 00:55:07.165806+00 | | 2025-08-29 00:55:07.393463+00 |
| public | w_latest_presence | 301023 | 80308 | 0.00 | 21.00 | | 2025-08-29 00:55:20.822986+00 | | 2025-08-29 00:54:22.414382+00 |
| public | w_latest_sensor | 386 | 204 | 0.00 | 34.00 | | 2025-08-29 00:55:07.409358+00 | | 2025-08-29 00:55:07.52073+00 |
| public | w_lock | 18361 | 0 | 0.00 | 0.00 | | 2025-08-27 03:17:30.783256+00 | | |
| public | w_master_update | 112 | 64 | 0.00 | 36.00 | | 2025-08-29 00:43:00.604724+00 | | 2025-08-29 00:54:07.334652+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-08-25 03:03:55.881779+00 | | |
| public | w_plan_sync_retry | 0 | 38 | 0 | 100.00 | | 2025-08-28 23:35:27.399071+00 | | 2025-08-29 00:31:06.678577+00 |
| public | w_plan_with_detail | 27357883 | 1442755 | 0.00 | 5.00 | | 2025-08-25 05:23:09.446544+00 | | 2025-08-27 01:19:10.217508+00 |