| 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 |
|---|
| e202503 | a_proximity_sum | 30294796 | 0 | 0.00 | 0.00 | | 2025-05-28 01:09:35.275088+00 | | |
| e202503 | a_stay_time | 37339215 | 0 | 0.00 | 0.00 | | 2025-05-26 08:36:13.541033+00 | | |
| e202503 | t_position_history | 458909852 | 0 | 0.00 | 0.00 | | 2025-05-26 05:41:23.788652+00 | | |
| e202503 | t_presence_history | 47512303 | 0 | 0.00 | 0.00 | | 2025-05-27 11:57:13.991345+00 | | |
| e202503 | t_sensor_history | 13280502 | 0 | 0.00 | 0.00 | | 2025-05-27 04:02:57.295094+00 | | |
| e202505 | a_proximity_sum | 27142875 | 0 | 0.00 | 0.00 | | 2025-05-30 04:08:31.560882+00 | | 2025-05-29 16:19:02.792973+00 |
| e202505 | a_stay_time | 38023334 | 0 | 0.00 | 0.00 | | 2025-05-30 04:09:58.429718+00 | | 2025-05-29 16:02:44.985667+00 |
| e202505 | t_position_history | 525713651 | 0 | 0.00 | 0.00 | | 2025-05-28 04:58:55.750785+00 | | 2025-05-29 09:21:32.439172+00 |
| e202505 | t_presence_history | 51536764 | 8664197 | 0.00 | 14.00 | | 2025-05-31 00:23:13.902934+00 | | 2025-05-31 01:01:08.815118+00 |
| e202505 | t_sensor_history | 12542656 | 0 | 0.00 | 0.00 | | 2025-05-28 05:11:36.349708+00 | | 2025-05-29 19:52:27.630154+00 |
| public | __digdag_status | 33 | 12 | 0.00 | 26.00 | | 2025-05-28 09:38:39.781808+00 | | 2025-05-28 12:35:51.665267+00 |
| public | a_attendance_sum | 114786 | 20637 | 0.00 | 15.00 | | 2025-05-31 00:35:40.251173+00 | | 2025-05-31 00:47:38.15642+00 |
| public | a_plan_actual | 513780 | 0 | 0.00 | 0.00 | | 2025-05-29 03:50:48.741604+00 | | 2025-05-28 16:40:47.032705+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-05-22 10:26:01.943639+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-05-22 10:22:23.735882+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-05-22 10:14:59.605906+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-05-25 06:33:37.86406+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:50.508171+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:51.55819+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.667563+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:51.577661+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:51.597435+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.686497+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.645265+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:50.528949+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.707344+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.72768+00 | | |
| public | l_area | 1330 | 10 | 0.00 | 0.00 | | 2025-05-27 11:11:25.765295+00 | | 2025-05-27 11:11:25.775817+00 |
| public | l_auth | 152 | 0 | 0.00 | 0.00 | | | | 2025-05-27 11:12:25.457228+00 |
| public | l_category | 2331 | 1 | 0.00 | 0.00 | | 2025-05-27 11:11:26.39329+00 | | 2025-05-27 11:11:26.410357+00 |
| public | l_group | 31486 | 28 | 0.00 | 0.00 | | 2025-05-27 11:11:26.683893+00 | | 2025-05-27 11:11:27.996149+00 |
| public | l_location | 86983 | 1687 | 0.00 | 1.00 | | 2025-05-27 11:11:25.960033+00 | | 2025-05-27 11:11:26.378793+00 |
| public | l_location_zone | 70097 | 2889 | 0.00 | 3.00 | | 2025-05-27 11:12:25.509799+00 | | 2025-05-27 11:12:25.615825+00 |
| public | l_outside | 402 | 4 | 0.00 | 0.00 | | | | 2025-05-27 11:12:25.473139+00 |
| public | l_pot | 347544 | 2294 | 0.00 | 0.00 | | 2025-05-27 11:11:28.531419+00 | | 2025-05-27 11:11:29.437553+00 |
| public | l_pot_category | 9978 | 38 | 0.00 | 0.00 | | 2025-05-27 11:12:25.632047+00 | | 2025-05-27 11:12:25.6537+00 |
| public | l_pot_group | 203945 | 232 | 0.00 | 0.00 | | 2025-05-27 11:12:25.900684+00 | | 2025-05-27 11:12:26.045879+00 |
| public | l_pot_tx | 82980 | 218 | 0.00 | 0.00 | | 2025-05-27 11:12:25.698626+00 | | 2025-05-27 11:12:25.810722+00 |
| public | l_role | 649 | 1 | 0.00 | 0.00 | | | | 2025-05-27 11:12:22.546994+00 |
| public | l_role_feature | 6049 | 11 | 0.00 | 0.00 | | 2025-05-27 11:15:22.632488+00 | | 2025-05-27 11:15:22.647362+00 |
| public | l_site | 227 | 5 | 0.00 | 2.00 | | | | 2025-05-27 11:11:25.791401+00 |
| public | l_tx | 126354 | 19514 | 0.00 | 13.00 | | 2025-05-27 11:11:26.478849+00 | | 2025-05-30 03:30:57.992274+00 |
| public | l_user | 54049 | 466 | 0.00 | 0.00 | | 2025-05-27 11:11:22.362279+00 | | 2025-05-27 11:11:22.891703+00 |
| public | l_zone | 8771 | 15 | 0.00 | 0.00 | | 2025-05-27 11:11:25.812029+00 | | 2025-05-27 11:11:25.89755+00 |
| public | l_zone_category | 4521 | 10 | 0.00 | 0.00 | | 2025-05-27 11:12:22.373918+00 | | 2025-05-27 11:12:22.386434+00 |
| public | m_area | 703 | 9 | 0.00 | 1.00 | | 2025-05-24 09:16:50.429727+00 | | |
| public | m_auth | 128 | 1 | 0.00 | 0.00 | | 2025-05-22 10:51:33.902365+00 | | |
| public | m_category | 2137 | 1 | 0.00 | 0.00 | | 2025-05-24 09:16:50.389205+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-05-26 01:49:36.63992+00 | | |
| public | m_exb | 23572 | 0 | 0.00 | 0.00 | | 2025-05-30 16:56:09.034986+00 | | |
| public | m_favorite | 224872 | 2145 | 0.00 | 0.00 | | 2025-05-23 09:50:54.237969+00 | | |
| public | m_favorite_group | 99785 | 207 | 0.00 | 0.00 | | 2025-05-27 00:53:40.214436+00 | | |
| public | m_feature | 167 | 0 | 0.00 | 0.00 | | 2025-05-22 23:18:16.010146+00 | | |
| public | m_group | 25708 | 3691 | 0.00 | 12.00 | | 2025-05-29 14:40:59.579754+00 | | 2025-05-30 14:40:39.423138+00 |
| public | m_holiday | 34748 | 0 | 0.00 | 0.00 | | 2025-05-29 03:19:27.926386+00 | | |
| public | m_lob | 23002 | 17 | 0.00 | 0.00 | | 2025-05-29 07:02:59.355151+00 | | |
| public | m_lob_log | 1413 | 0 | 0.00 | 0.00 | | 2025-05-28 08:01:18.601693+00 | | |
| public | m_location | 39931 | 3549 | 0.00 | 8.00 | | 2025-05-24 02:12:18.464624+00 | | 2025-05-30 05:23:29.847873+00 |
| public | m_notify_template | 825 | 1 | 0.00 | 0.00 | | 2025-05-22 10:51:34.056568+00 | | |
| public | m_outside | 340 | 3 | 0.00 | 0.00 | | 2025-05-28 01:09:34.950703+00 | | |
| public | m_personal_setting | 122294 | 13029 | 0.00 | 9.00 | | 2025-05-29 00:55:12.822778+00 | | 2025-05-31 00:02:04.426115+00 |
| public | m_pot | 179707 | 28360 | 0.00 | 13.00 | | 2025-05-26 08:03:52.452517+00 | | 2025-05-30 09:43:37.497615+00 |
| public | m_pot_profile | 59932 | 4 | 0.00 | 0.00 | | 2025-05-29 23:06:19.839989+00 | | |
| public | m_provider_user | 77 | 20 | 0.00 | 20.00 | | 2025-05-23 00:57:46.827296+00 | | |
| public | m_region | 108 | 0 | 0.00 | 0.00 | | 2025-05-22 10:51:58.071253+00 | | |
| public | m_role | 652 | 1 | 0.00 | 0.00 | | 2025-05-22 10:51:34.254744+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-05-22 10:51:34.000525+00 | | |
| public | m_setting | 14608 | 2091 | 0.00 | 12.00 | | 2025-05-29 14:10:33.508759+00 | | 2025-05-30 06:56:41.743866+00 |
| public | m_setting_log | 33107 | 0 | 0.00 | 0.00 | | 2025-05-29 17:34:41.211733+00 | | 2025-05-30 17:22:30.153139+00 |
| public | m_site | 175 | 7 | 0.00 | 3.00 | | 2025-05-22 10:51:33.880466+00 | | |
| public | m_tenant | 107 | 2 | 0.00 | 1.00 | | 2025-05-22 10:51:59.02169+00 | | |
| public | m_tx | 164220 | 50 | 0.00 | 0.00 | | 2025-05-30 09:51:28.210033+00 | | 2025-05-30 09:29:21.925069+00 |
| public | m_user | 32313 | 300 | 0.00 | 0.00 | | 2025-05-27 07:25:28.832952+00 | | 2025-05-26 02:24:57.849514+00 |
| public | m_zone | 6326 | 120 | 0.00 | 1.00 | | 2025-05-23 05:13:22.356128+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-05-22 10:14:59.582079+00 | | |
| public | r_auth_zone | 203 | 0 | 0.00 | 0.00 | | 2025-05-23 12:14:19.090635+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-05-22 10:51:34.081412+00 | | |
| public | r_group_auth | 528 | 0 | 0.00 | 0.00 | | 2025-05-25 23:40:57.04958+00 | | |
| public | r_location_zone | 49783 | 3401 | 0.00 | 6.00 | | 2025-05-24 09:16:50.284214+00 | | 2025-05-30 09:29:34.54286+00 |
| public | r_pot_auth | 5590 | 142 | 0.00 | 2.00 | | 2025-05-22 10:14:59.552769+00 | | 2025-05-22 10:14:59.569465+00 |
| public | r_pot_category | 13705 | 57 | 0.00 | 0.00 | | 2025-05-28 06:52:03.244902+00 | | |
| public | r_pot_group | 318669 | 274 | 0.00 | 0.00 | | 2025-05-26 01:07:37.176419+00 | | |
| public | r_pot_tx | 62895 | 197 | 0.00 | 0.00 | | 2025-05-29 00:02:58.212009+00 | | |
| public | r_pot_user | 19644 | 10 | 0.00 | 0.00 | | 2025-05-29 08:31:17.002962+00 | | 2025-05-26 02:24:57.152566+00 |
| public | r_provider_tenant | 1171 | 177 | 0.00 | 13.00 | | 2025-05-26 04:20:05.832872+00 | | 2025-05-30 01:40:20.095227+00 |
| public | r_role_feature | 5688 | 12 | 0.00 | 0.00 | | 2025-05-27 01:45:39.52967+00 | | |
| public | r_tenant_feature | 4224 | 0 | 0.00 | 0.00 | | 2025-05-24 17:50:05.433606+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-05-26 13:50:53.168236+00 | | |
| public | r_user_region | 20473 | 6 | 0.00 | 0.00 | | 2025-05-29 08:33:10.909697+00 | | |
| public | r_user_site | 5531 | 30 | 0.00 | 0.00 | | 2025-05-22 10:51:33.977226+00 | | |
| public | r_zone_category | 4274 | 4 | 0.00 | 0.00 | | 2025-05-28 08:01:18.561223+00 | | |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2025-05-26 05:41:23.370326+00 | | |
| public | t_attendance | 2628641 | 45230 | 0.00 | 1.00 | | 2025-05-24 17:55:02.313335+00 | | |
| public | t_general | 3773 | 11 | 0.00 | 0.00 | | 2025-05-22 10:51:58.234272+00 | | |
| public | t_mobile_device_history | 1216532 | 0 | 0.00 | 0.00 | | 2025-05-23 01:31:22.51233+00 | | |
| public | t_mobile_status_history | 772647 | 0 | 0.00 | 0.00 | | 2025-05-29 05:26:38.053337+00 | | 2025-05-28 01:51:31.590592+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-05-22 10:51:34.102627+00 | | |
| public | t_notify_history | 5452787 | 21703 | 0.00 | 0.00 | | 2025-05-23 01:59:31.353117+00 | | |
| public | t_operation_log | 19855459 | 33 | 0.00 | 0.00 | | 2025-05-28 09:38:38.934476+00 | | |
| public | t_plan | 22873322 | 1195653 | 0.00 | 4.00 | | 2025-05-26 10:46:58.08304+00 | | 2025-05-29 09:34:12.263267+00 |
| public | t_plan_cancel_history | 379175 | 67715 | 0.00 | 15.00 | | 2025-05-28 07:19:54.247181+00 | | |
| public | t_plan_detail | 39191052 | 1192288 | 0.00 | 2.00 | | 2025-05-29 05:26:11.904656+00 | | 2025-05-30 08:59:29.208665+00 |
| public | t_plan_sync | 49362 | 7457 | 0.00 | 13.00 | | 2025-05-31 00:28:40.093532+00 | | 2025-05-31 00:37:37.598565+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-05-22 10:51:59.046068+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-05-22 10:14:59.663586+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-05-22 10:51:58.094496+00 | | |
| public | t_recv_position_history | 101954 | 85615 | 0.00 | 45.00 | | 2025-05-31 01:01:07.49672+00 | 2025-05-30 13:30:13.262066+00 | 2025-05-31 01:01:08.016113+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-05-22 10:15:02.420048+00 | | |
| public | t_terminal | 19350 | 746 | 0.00 | 3.00 | | 2025-05-31 00:36:37.606537+00 | | 2025-05-31 00:30:39.924935+00 |
| public | t_terminal_log | 21233958 | 0 | 0.00 | 0.00 | | 2025-05-28 05:43:47.323415+00 | | |
| public | temp_pivot_table | 241036 | 0 | 0.00 | 0.00 | | 2025-05-29 23:08:26.883548+00 | | |
| public | w_arrival_notify | 94 | 59 | 0.00 | 38.00 | | 2025-05-27 05:04:14.00739+00 | | 2025-05-30 04:59:50.324906+00 |
| public | w_latest_mobile_device | 51932 | 2345 | 0.00 | 4.00 | | 2025-05-26 07:20:53.109502+00 | | 2025-05-29 00:26:28.563749+00 |
| public | w_latest_mobile_status | 50863 | 7551 | 0.00 | 12.00 | | 2025-05-30 05:23:30.772232+00 | | 2025-05-30 11:09:22.998191+00 |
| public | w_latest_position | 71432 | 10796 | 0.00 | 13.00 | | 2025-05-31 00:59:40.094955+00 | | 2025-05-31 01:01:08.200226+00 |
| public | w_latest_presence | 226935 | 228618 | 1.00 | 50.00 | | 2025-05-31 01:01:23.920536+00 | | 2025-05-31 01:01:26.149887+00 |
| public | w_latest_sensor | 386 | 534 | 1.00 | 58.00 | | 2025-05-31 01:01:08.832863+00 | | 2025-05-31 01:01:09.853004+00 |
| public | w_lock | 16873 | 0 | 0.00 | 0.00 | | 2025-05-26 23:49:50.845851+00 | | |
| public | w_master_update | 189 | 53 | 0.00 | 21.00 | | 2025-05-30 20:10:24.596995+00 | | 2025-05-30 20:09:24.723953+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-05-22 13:35:40.342833+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-05-22 10:08:42.858149+00 | | |
| public | w_plan_with_detail | 22807313 | 1805779 | 0.00 | 7.00 | | 2025-05-23 00:48:34.444086+00 | | 2025-05-29 09:00:14.101661+00 |