| 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 | 458909847 | 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 | | |
| e202504 | a_proximity_sum | 30878862 | 0 | 0.00 | 0.00 | | 2025-05-28 19:34:32.705747+00 | | |
| e202504 | a_stay_time | 39029265 | 0 | 0.00 | 0.00 | | 2025-05-27 12:54:06.526509+00 | | |
| e202504 | t_position_history | 474217218 | 0 | 0.00 | 0.00 | | 2025-05-29 07:00:58.97427+00 | | |
| e202504 | t_presence_history | 55949935 | 0 | 0.00 | 0.00 | | 2025-05-27 03:13:41.032342+00 | | |
| e202504 | t_sensor_history | 12827583 | 0 | 0.00 | 0.00 | | 2025-05-25 22:21:03.589633+00 | | |
| e202505 | a_proximity_sum | 25954182 | 0 | 0.00 | 0.00 | | 2025-05-26 17:56:23.690847+00 | | 2025-05-29 16:19:02.792973+00 |
| e202505 | a_stay_time | 36224475 | 0 | 0.00 | 0.00 | | 2025-05-26 18:06:11.143826+00 | | 2025-05-29 16:02:44.985667+00 |
| e202505 | t_position_history | 506186198 | 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 | 49538689 | 8072815 | 0.00 | 14.00 | | 2025-05-30 00:23:32.273537+00 | | 2025-05-30 00:25:04.224388+00 |
| e202505 | t_sensor_history | 12152289 | 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 | 8 | 0.00 | 19.00 | | 2025-05-28 09:38:39.781808+00 | | 2025-05-28 12:35:51.665267+00 |
| public | a_attendance_sum | 114760 | 18596 | 0.00 | 13.00 | | 2025-05-30 00:34:54.431617+00 | | 2025-05-30 00:49:52.430696+00 |
| public | a_plan_actual | 507916 | 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 | 2314 | 1 | 0.00 | 0.00 | | 2025-05-27 11:11:26.39329+00 | | 2025-05-27 11:11:26.410357+00 |
| public | l_group | 31485 | 26 | 0.00 | 0.00 | | 2025-05-27 11:11:26.683893+00 | | 2025-05-27 11:11:27.996149+00 |
| public | l_location | 85274 | 539 | 0.00 | 0.00 | | 2025-05-27 11:11:25.960033+00 | | 2025-05-27 11:11:26.378793+00 |
| public | l_location_zone | 67241 | 248 | 0.00 | 0.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 | 344497 | 319 | 0.00 | 0.00 | | 2025-05-27 11:11:28.531419+00 | | 2025-05-27 11:11:29.437553+00 |
| public | l_pot_category | 9973 | 6 | 0.00 | 0.00 | | 2025-05-27 11:12:25.632047+00 | | 2025-05-27 11:12:25.6537+00 |
| public | l_pot_group | 203864 | 110 | 0.00 | 0.00 | | 2025-05-27 11:12:25.900684+00 | | 2025-05-27 11:12:26.045879+00 |
| public | l_pot_tx | 82900 | 149 | 0.00 | 0.00 | | 2025-05-27 11:12:25.698626+00 | | 2025-05-27 11:12:25.810722+00 |
| public | l_role | 646 | 1 | 0.00 | 0.00 | | | | 2025-05-27 11:12:22.546994+00 |
| public | l_role_feature | 6024 | 1 | 0.00 | 0.00 | | 2025-05-27 11:15:22.632488+00 | | 2025-05-27 11:15:22.647362+00 |
| public | l_site | 225 | 4 | 0.00 | 1.00 | | | | 2025-05-27 11:11:25.791401+00 |
| public | l_tx | 124694 | 10491 | 0.00 | 7.00 | | 2025-05-27 11:11:26.478849+00 | | 2025-05-27 11:11:26.638826+00 |
| public | l_user | 53914 | 319 | 0.00 | 0.00 | | 2025-05-27 11:11:22.362279+00 | | 2025-05-27 11:11:22.891703+00 |
| public | l_zone | 8723 | 11 | 0.00 | 0.00 | | 2025-05-27 11:11:25.812029+00 | | 2025-05-27 11:11:25.89755+00 |
| public | l_zone_category | 4473 | 6 | 0.00 | 0.00 | | 2025-05-27 11:12:22.373918+00 | | 2025-05-27 11:12:22.386434+00 |
| public | m_area | 703 | 8 | 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 | 2120 | 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 | 22555 | 240 | 0.00 | 1.00 | | 2025-05-22 06:08:29.663558+00 | | |
| public | m_favorite | 224671 | 1685 | 0.00 | 0.00 | | 2025-05-23 09:50:54.237969+00 | | |
| public | m_favorite_group | 99434 | 73 | 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 | 23563 | 1888 | 0.00 | 7.00 | | 2025-05-29 14:40:59.579754+00 | | 2025-05-28 14:40:49.391098+00 |
| public | m_holiday | 34748 | 0 | 0.00 | 0.00 | | 2025-05-29 03:19:27.926386+00 | | |
| public | m_lob | 23009 | 5 | 0.00 | 0.00 | | 2025-05-29 07:02:59.355151+00 | | |
| public | m_lob_log | 1401 | 0 | 0.00 | 0.00 | | 2025-05-28 08:01:18.601693+00 | | |
| public | m_location | 39109 | 908 | 0.00 | 2.00 | | 2025-05-24 02:12:18.464624+00 | | 2025-05-23 10:14:57.815674+00 |
| public | m_notify_template | 821 | 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 | 121869 | 15377 | 0.00 | 11.00 | | 2025-05-29 00:55:12.822778+00 | | 2025-05-30 00:25:04.673857+00 |
| public | m_pot | 178529 | 19076 | 0.00 | 9.00 | | 2025-05-26 08:03:52.452517+00 | | 2025-05-29 00:20:46.85485+00 |
| public | m_pot_profile | 59906 | 0 | 0.00 | 0.00 | | 2025-05-29 23:06:19.839989+00 | | |
| public | m_provider_user | 77 | 18 | 0.00 | 18.00 | | 2025-05-23 00:57:46.827296+00 | | |
| public | m_region | 107 | 0 | 0.00 | 0.00 | | 2025-05-22 10:51:58.071253+00 | | |
| public | m_role | 649 | 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 | 19505 | 634 | 0.00 | 3.00 | | 2025-05-29 14:10:33.508759+00 | | 2025-05-29 00:16:40.903495+00 |
| public | m_setting_log | 33033 | 0 | 0.00 | 0.00 | | 2025-05-29 17:34:41.211733+00 | | 2025-05-29 12:30:13.319597+00 |
| public | m_site | 174 | 6 | 0.00 | 3.00 | | 2025-05-22 10:51:33.880466+00 | | |
| public | m_tenant | 106 | 2 | 0.00 | 1.00 | | 2025-05-22 10:51:59.02169+00 | | |
| public | m_tx | 159890 | 12141 | 0.00 | 7.00 | | 2025-05-29 00:57:21.626334+00 | | 2025-05-29 00:56:20.557029+00 |
| public | m_user | 32300 | 222 | 0.00 | 0.00 | | 2025-05-27 07:25:28.832952+00 | | 2025-05-26 02:24:57.849514+00 |
| public | m_zone | 6278 | 116 | 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 | 52008 | 760 | 0.00 | 1.00 | | 2025-05-24 09:16:50.284214+00 | | 2025-05-22 10:51:34.225911+00 |
| public | r_pot_auth | 5712 | 4 | 0.00 | 0.00 | | 2025-05-22 10:14:59.552769+00 | | 2025-05-22 10:14:59.569465+00 |
| public | r_pot_category | 13733 | 24 | 0.00 | 0.00 | | 2025-05-28 06:52:03.244902+00 | | |
| public | r_pot_group | 318710 | 152 | 0.00 | 0.00 | | 2025-05-26 01:07:37.176419+00 | | |
| public | r_pot_tx | 62887 | 125 | 0.00 | 0.00 | | 2025-05-29 00:02:58.212009+00 | | |
| public | r_pot_user | 19644 | 0 | 0.00 | 0.00 | | 2025-05-29 08:31:17.002962+00 | | 2025-05-26 02:24:57.152566+00 |
| public | r_provider_tenant | 1169 | 0 | 0.00 | 0.00 | | 2025-05-26 04:20:05.832872+00 | | 2025-05-26 04:16:58.715888+00 |
| public | r_role_feature | 5673 | 2 | 0.00 | 0.00 | | 2025-05-27 01:45:39.52967+00 | | |
| public | r_tenant_feature | 4172 | 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 | 20469 | 0 | 0.00 | 0.00 | | 2025-05-29 08:33:10.909697+00 | | |
| public | r_user_site | 5532 | 26 | 0.00 | 0.00 | | 2025-05-22 10:51:33.977226+00 | | |
| public | r_zone_category | 4230 | 0 | 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 | 2624472 | 37163 | 0.00 | 1.00 | | 2025-05-24 17:55:02.313335+00 | | |
| public | t_general | 3766 | 7 | 0.00 | 0.00 | | 2025-05-22 10:51:58.234272+00 | | |
| public | t_mobile_device_history | 1215409 | 0 | 0.00 | 0.00 | | 2025-05-23 01:31:22.51233+00 | | |
| public | t_mobile_status_history | 756100 | 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 | 5442994 | 19361 | 0.00 | 0.00 | | 2025-05-23 01:59:31.353117+00 | | |
| public | t_operation_log | 19819701 | 25 | 0.00 | 0.00 | | 2025-05-28 09:38:38.934476+00 | | |
| public | t_plan | 22821364 | 1036210 | 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 | 377987 | 38597 | 0.00 | 9.00 | | 2025-05-28 07:19:54.247181+00 | | |
| public | t_plan_detail | 39045450 | 653042 | 0.00 | 1.00 | | 2025-05-29 05:26:11.904656+00 | | 2025-05-28 10:39:50.984652+00 |
| public | t_plan_sync | 49346 | 8740 | 0.00 | 15.00 | | 2025-05-30 00:25:57.524654+00 | | 2025-05-30 00:39:51.73223+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 | 135751 | 67345 | 0.00 | 33.00 | | 2025-05-30 00:56:35.734074+00 | 2025-05-29 13:30:12.897669+00 | 2025-05-30 00:56:36.236645+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-05-22 10:15:02.420048+00 | | |
| public | t_terminal | 13672 | 2300 | 0.00 | 14.00 | | 2025-05-29 22:39:45.831858+00 | | 2025-05-30 00:27:57.677666+00 |
| public | t_terminal_log | 21169551 | 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 | 97 | 52 | 0.00 | 34.00 | | 2025-05-27 05:04:14.00739+00 | | 2025-05-28 10:15:55.432065+00 |
| public | w_latest_mobile_device | 51740 | 2458 | 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 | 50669 | 3254 | 0.00 | 6.00 | | 2025-05-30 00:25:05.752059+00 | | 2025-05-30 00:25:06.118677+00 |
| public | w_latest_position | 71397 | 17306 | 0.00 | 19.00 | | 2025-05-30 00:56:36.434374+00 | | 2025-05-30 00:56:36.653821+00 |
| public | w_latest_presence | 221150 | 95608 | 0.00 | 30.00 | | 2025-05-30 00:56:51.495005+00 | | 2025-05-30 00:56:53.257445+00 |
| public | w_latest_sensor | 386 | 235 | 0.00 | 37.00 | | 2025-05-30 00:56:37.333153+00 | | 2025-05-30 00:56:38.335619+00 |
| public | w_lock | 16870 | 0 | 0.00 | 0.00 | | 2025-05-26 23:49:50.845851+00 | | |
| public | w_master_update | 185 | 27 | 0.00 | 12.00 | | 2025-05-30 00:25:57.105474+00 | | 2025-05-30 00:25:03.268932+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 | 22755355 | 1596881 | 0.00 | 6.00 | | 2025-05-23 00:48:34.444086+00 | | 2025-05-29 09:00:14.101661+00 |