| 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 |
|---|
| e202507 | a_proximity_sum | 57061161 | 0 | 0.00 | 0.00 | | 2025-08-28 04:11:00.867822+00 | | |
| e202507 | a_stay_time | 47407726 | 0 | 0.00 | 0.00 | | 2025-08-29 01:19:12.377192+00 | | |
| e202507 | t_position_history | 610147580 | 0 | 0.00 | 0.00 | | 2025-08-29 05:11:18.352514+00 | | |
| e202507 | t_presence_history | 55790761 | 0 | 0.00 | 0.00 | | 2025-08-29 03:31:56.746341+00 | | |
| e202507 | t_sensor_history | 11690426 | 0 | 0.00 | 0.00 | | 2025-08-29 09:20:05.086305+00 | | |
| e202508 | a_proximity_sum | 32489797 | 1641880 | 0.00 | 4.00 | | 2025-08-28 05:51:15.974026+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36284973 | 64272 | 0.00 | 0.00 | | 2025-08-28 15:21:13.177374+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 582228728 | 1036294 | 0.00 | 0.00 | | 2025-08-26 07:29:14.725515+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 53820966 | 699802 | 0.00 | 1.00 | | 2025-08-31 14:22:36.67427+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11924182 | 0 | 0.00 | 0.00 | | 2025-08-31 02:11:59.210078+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-08-27 04:11:18.827139+00 | | |
| e202509 | a_stay_time | 0 | 0 | 0 | 0 | | 2025-08-27 04:11:18.87515+00 | | |
| e202509 | t_position_history | 5820456 | 49176 | 0.00 | 0.00 | | 2025-09-01 00:09:35.14299+00 | | 2025-09-01 00:11:30.618382+00 |
| e202509 | t_presence_history | 627110 | 5323807 | 8.00 | 89.00 | | 2025-09-01 00:17:32.977805+00 | | 2025-09-01 00:17:33.509015+00 |
| e202509 | t_sensor_history | 159802 | 0 | 0.00 | 0.00 | | 2025-08-31 22:49:33.726392+00 | | 2025-08-31 23:45:32.334866+00 |
| public | __digdag_status | 32 | 16 | 0.00 | 33.00 | | 2025-08-28 03:47:37.696146+00 | | 2025-08-28 12:30:18.362409+00 |
| public | a_attendance_sum | 185145 | 13593 | 0.00 | 6.00 | | 2025-08-31 23:48:42.316911+00 | | 2025-08-31 23:44:33.290802+00 |
| public | a_plan_actual | 933695 | 0 | 0.00 | 0.00 | | 2025-08-30 23:36:05.630777+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:45.556903+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:44.85802+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:43.56926+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-31 13:33:02.783709+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:09.289939+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.386749+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:09.300939+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:09.311824+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.397995+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.374961+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:05.9155+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.409231+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.420554+00 | | |
| public | l_area | 1541 | 10 | 0.00 | 0.00 | | 2025-08-29 02:39:03.624866+00 | | |
| public | l_auth | 173 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:03.531273+00 | | |
| public | l_category | 2684 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:05.006558+00 | | |
| public | l_group | 35421 | 25 | 0.00 | 0.00 | | 2025-08-29 02:39:07.069636+00 | | |
| public | l_lob | 1925 | 13 | 0.00 | 0.00 | | 2025-08-26 10:11:39.840951+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 103154 | 446 | 0.00 | 0.00 | | 2025-08-29 02:39:04.798722+00 | | |
| public | l_location_zone | 100294 | 1702 | 0.00 | 1.00 | | 2025-08-29 02:39:04.037808+00 | | |
| public | l_outside | 441 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:03.559857+00 | | |
| public | l_pot | 432403 | 1327 | 0.00 | 0.00 | | 2025-08-29 02:39:13.107243+00 | | |
| public | l_pot_category | 13390 | 156 | 0.00 | 1.00 | | 2025-08-29 02:39:04.916179+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 227767 | 558 | 0.00 | 0.00 | | 2025-08-29 02:39:06.870491+00 | | |
| public | l_pot_tx | 98594 | 213 | 0.00 | 0.00 | | 2025-08-29 02:39:05.678988+00 | | |
| public | l_role | 770 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:01.364422+00 | | |
| public | l_role_feature | 6223 | 3 | 0.00 | 0.00 | | 2025-08-29 02:39:01.28785+00 | | |
| public | l_site | 255 | 1 | 0.00 | 0.00 | | 2025-08-29 02:39:03.652806+00 | | |
| public | l_tx | 140914 | 10305 | 0.00 | 6.00 | | 2025-08-30 04:31:36.816025+00 | | 2025-08-30 04:33:36.638613+00 |
| public | l_user | 62102 | 274 | 0.00 | 0.00 | | 2025-08-29 02:39:01.147802+00 | | |
| public | l_zone | 9977 | 6 | 0.00 | 0.00 | | 2025-08-29 02:39:04.132076+00 | | |
| public | l_zone_category | 5212 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:00.228516+00 | | |
| public | m_area | 783 | 2 | 0.00 | 0.00 | | 2025-08-31 07:12:17.78997+00 | | |
| public | m_auth | 141 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.588843+00 | | |
| public | m_category | 2421 | 0 | 0.00 | 0.00 | | 2025-08-31 07:12:17.760777+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-08-26 10:09:39.884392+00 | | |
| public | m_exb | 26434 | 97 | 0.00 | 0.00 | | 2025-08-29 08:31:43.277481+00 | | |
| public | m_favorite | 235440 | 167 | 0.00 | 0.00 | | 2025-08-30 15:17:27.111905+00 | | |
| public | m_favorite_group | 113333 | 185 | 0.00 | 0.00 | | 2025-08-27 04:11:18.789539+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-08-29 20:56:34.194737+00 | | |
| public | m_group | 27914 | 1389 | 0.00 | 4.00 | | 2025-08-27 02:15:21.692043+00 | | 2025-08-31 14:41:00.773862+00 |
| public | m_holiday | 43942 | 0 | 0.00 | 0.00 | | 2025-08-28 07:28:59.552994+00 | | |
| public | m_lob | 24485 | 38 | 0.00 | 0.00 | | 2025-08-28 12:37:15.856479+00 | | |
| public | m_lob_log | 1976 | 0 | 0.00 | 0.00 | | 2025-08-28 03:08:18.640809+00 | | |
| public | m_location | 44581 | 1 | 0.00 | 0.00 | | 2025-08-31 02:41:50.263825+00 | | 2025-08-29 11:38:48.027813+00 |
| public | m_notify_template | 1224 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.923329+00 | | |
| public | m_outside | 372 | 0 | 0.00 | 0.00 | | 2025-08-27 22:21:30.813856+00 | | |
| public | m_personal_setting | 132034 | 18327 | 0.00 | 12.00 | | 2025-08-27 07:10:30.84288+00 | | 2025-08-31 23:52:35.425919+00 |
| public | m_pot | 200771 | 15560 | 0.00 | 7.00 | | 2025-08-30 04:00:41.329102+00 | | 2025-08-31 23:44:32.576796+00 |
| public | m_pot_profile | 52353 | 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-30 00:11:13.188894+00 | | |
| public | m_region | 113 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:46.065754+00 | | |
| public | m_role | 773 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:46.022102+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.717675+00 | | |
| public | m_setting | 28016 | 1118 | 0.00 | 3.00 | | 2025-08-31 07:25:16.682896+00 | | 2025-08-30 17:58:57.592314+00 |
| public | m_setting_log | 36224 | 1506 | 0.00 | 3.00 | | 2025-08-29 02:36:01.163381+00 | | 2025-08-30 23:12:05.256488+00 |
| public | m_site | 187 | 1 | 0.00 | 0.00 | | 2025-08-29 12:01:45.577023+00 | | |
| public | m_tenant | 112 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:46.099196+00 | | |
| public | m_tx | 120935 | 6886 | 0.00 | 5.00 | | 2025-08-30 04:37:19.578142+00 | | 2025-08-30 04:37:19.766451+00 |
| public | m_user | 36315 | 220 | 0.00 | 0.00 | | 2025-08-27 07:58:40.272056+00 | | |
| public | m_zone | 7847 | 0 | 0.00 | 0.00 | | 2025-08-30 06:30:41.401825+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:43.541931+00 | | |
| public | r_auth_zone | 214 | 0 | 0.00 | 0.00 | | 2025-08-30 18:03:57.632279+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.950491+00 | | |
| public | r_group_auth | 557 | 0 | 0.00 | 0.00 | | 2025-08-26 08:13:00.546406+00 | | |
| public | r_location_zone | 54128 | 0 | 0.00 | 0.00 | | 2025-08-31 07:12:17.601543+00 | | 2025-08-29 08:17:47.919486+00 |
| public | r_pot_auth | 8118 | 5 | 0.00 | 0.00 | | 2025-08-28 04:10:54.559129+00 | | |
| public | r_pot_category | 11653 | 361 | 0.00 | 3.00 | | 2025-08-28 02:16:28.437743+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 435337 | 635 | 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-30 07:02:06.507248+00 | | |
| public | r_pot_tx | 69754 | 506 | 0.00 | 0.00 | | 2025-08-28 06:41:32.962464+00 | | |
| public | r_pot_user | 20041 | 19 | 0.00 | 0.00 | | 2025-08-28 14:02:52.624522+00 | | |
| public | r_provider_tenant | 1241 | 0 | 0.00 | 0.00 | | 2025-08-29 05:33:21.593808+00 | | |
| public | r_role_feature | 5974 | 26 | 0.00 | 0.00 | | 2025-08-27 04:26:37.059589+00 | | |
| public | r_tenant_feature | 4516 | 0 | 0.00 | 0.00 | | 2025-08-31 13:32:10.069592+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-08-27 02:15:21.703208+00 | | |
| public | r_user_region | 21399 | 19 | 0.00 | 0.00 | | 2025-08-28 14:02:51.893863+00 | | |
| public | r_user_site | 6255 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.686288+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 | 3160020 | 315 | 0.00 | 0.00 | | 2025-08-31 13:33:02.7707+00 | | |
| public | t_general | 4171 | 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 | 919663 | 0 | 0.00 | 0.00 | | 2025-08-30 01:44:15.681829+00 | | |
| public | t_mobile_status_history | 1838694 | 0 | 0.00 | 0.00 | | 2025-08-28 10:21:25.44824+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.972227+00 | | |
| public | t_notify_history | 6467096 | 3496 | 0.00 | 0.00 | | 2025-08-30 02:30:31.165877+00 | | |
| public | t_operation_log | 21969662 | 2352 | 0.00 | 0.00 | | 2025-08-28 03:47:37.590212+00 | | |
| public | t_plan | 27435948 | 1194658 | 0.00 | 4.00 | | 2025-08-27 01:10:39.679048+00 | | 2025-08-31 22:35:31.099886+00 |
| public | t_plan_cancel_history | 592027 | 20055 | 0.00 | 3.00 | | 2025-08-28 23:05:37.563117+00 | | |
| public | t_plan_detail | 47036642 | 1379210 | 0.00 | 2.00 | | 2025-08-28 10:03:48.699853+00 | | 2025-08-29 02:50:54.584931+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-08-30 07:02:06.48947+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-08-30 07:02:06.463177+00 | | |
| public | t_plan_sync | 65972 | 16919 | 0.00 | 20.00 | | 2025-08-31 23:17:30.019596+00 | | 2025-08-31 23:45:29.507186+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:46.13182+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:43.603149+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:46.077048+00 | | |
| public | t_recv_position_history | 154093 | 633557 | 4.00 | 80.00 | | 2025-09-01 00:18:28.770102+00 | 2025-08-31 13:30:02.025806+00 | 2025-09-01 00:18:29.027279+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:43.839998+00 | | |
| public | t_terminal | 20944 | 3643 | 0.00 | 14.00 | | 2025-08-31 19:30:11.238771+00 | | 2025-09-01 00:18:31.261655+00 |
| public | t_terminal_log | 28112603 | 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 | 13 | 0.00 | 11.00 | | 2025-08-29 01:19:12.397653+00 | | 2025-08-27 23:53:09.287893+00 |
| public | w_latest_mobile_device | 56350 | 867 | 0.00 | 1.00 | | 2025-08-26 22:47:03.156676+00 | | 2025-08-31 11:26:59.109828+00 |
| public | w_latest_mobile_status | 55321 | 4614 | 0.00 | 7.00 | | 2025-09-01 00:10:30.890731+00 | | 2025-08-31 23:52:36.28674+00 |
| public | w_latest_position | 78787 | 565524 | 7.00 | 87.00 | | 2025-09-01 00:18:29.135334+00 | | 2025-09-01 00:18:29.291459+00 |
| public | w_latest_presence | 235671 | 5323803 | 22.00 | 95.00 | | 2025-09-01 00:17:48.721275+00 | | 2025-09-01 00:17:51.188073+00 |
| public | w_latest_sensor | 386 | 2057 | 5.00 | 84.00 | | 2025-09-01 00:17:34.146096+00 | | 2025-09-01 00:17:34.259627+00 |
| public | w_lock | 18406 | 5 | 0.00 | 0.00 | | 2025-08-27 03:17:30.783256+00 | | |
| public | w_master_update | 195 | 51 | 0.00 | 20.00 | | 2025-09-01 00:08:31.174168+00 | | 2025-08-31 23:21:28.998416+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-08-29 14:40:13.993678+00 | | |
| public | w_plan_sync_retry | 0 | 52 | 0 | 100.00 | | 2025-08-29 12:52:32.087854+00 | | 2025-08-31 23:15:28.791027+00 |
| public | w_plan_with_detail | 27470839 | 245367 | 0.00 | 0.00 | | 2025-08-29 23:38:14.910805+00 | | 2025-08-31 22:13:29.722609+00 |