| 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 |
|---|
| e202408 | a_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202408 | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202408 | l_position_history | 0 | 0 | 0 | 0 | | | | |
| e202408 | l_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202408 | l_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202408 | t_position_history | 1 | 0 | 0.00 | 0.00 | | | | |
| e202408 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| e202408 | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| e202409 | a_proximity_sum | 0 | 26256 | 0 | 100.00 | | | | |
| e202409 | a_stay_time | 0 | 16007 | 0 | 100.00 | | | | |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202409 | t_position_history | 30788006 | 0 | 0.00 | 0.00 | | 2024-10-10 00:16:09.874667+00 | | |
| e202409 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| e202409 | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| e202410 | a_proximity_sum | 334462 | 0 | 0.00 | 0.00 | | 2024-10-09 15:31:16.1738+00 | | 2024-10-09 15:31:16.326006+00 |
| e202410 | a_stay_time | 1019962 | 0 | 0.00 | 0.00 | | 2024-10-09 15:30:21.198269+00 | | 2024-10-09 15:30:21.524661+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202410 | t_position_history | 12559396 | 0 | 0.00 | 0.00 | | 2024-10-09 02:10:17.481057+00 | | 2024-10-09 07:37:28.635145+00 |
| e202410 | t_presence_history | 2117264 | 148952 | 0.00 | 6.00 | | 2024-10-10 01:40:53.231734+00 | | 2024-10-10 01:43:51.407773+00 |
| e202410 | t_sensor_history | 377153 | 0 | 0.00 | 0.00 | | 2024-10-09 18:12:36.809719+00 | | 2024-10-09 11:02:32.317101+00 |
| public | __digdag_status | 0 | 23 | 0 | 100.00 | | | | |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-09 07:14:43.449001+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-10-09 07:13:27.029831+00 | | |
| public | b_attendance_group | 456391 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:42.769996+00 | | |
| public | b_attendance_hour | 6832426 | 0 | 0.00 | 0.00 | | 2024-10-09 09:40:36.564569+00 | | |
| public | b_attendance_pot | 5668 | 0 | 0.00 | 0.00 | | | | |
| public | b_attendance_pot_hour | 87990 | 0 | 0.00 | 0.00 | | | | |
| public | b_check_in | 3721295 | 0 | 0.00 | 0.00 | | 2024-10-09 10:21:24.702644+00 | | |
| public | b_check_in_hour | 55753104 | 0 | 0.00 | 0.00 | | 2024-10-09 09:42:02.180083+00 | | |
| public | b_check_in_pot | 1878 | 0 | 0.00 | 0.00 | | | | |
| public | b_check_in_pot_hour | 43020 | 0 | 0.00 | 0.00 | | | | |
| public | b_proximity_group | 32918391 | 0 | 0.00 | 0.00 | | 2024-10-09 10:12:17.361729+00 | | |
| public | b_proximity_info | 184430 | 34534 | 0.00 | 15.00 | | | | |
| public | b_seat_reserve | 833804 | 0 | 0.00 | 0.00 | | 2024-10-09 09:52:58.312448+00 | | |
| public | b_seat_reserve_hour | 15642215 | 0 | 0.00 | 0.00 | | 2024-10-09 07:13:26.760924+00 | | |
| public | b_usage | 933736 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.572422+00 | | |
| public | b_usage_hour | 17086762 | 0 | 0.00 | 0.00 | | 2024-10-09 09:35:09.518929+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-09 07:19:41.620747+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-09 07:19:41.609929+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-09 07:19:41.599105+00 | | |
| public | m_area | 93 | 0 | 0.00 | 0.00 | | 2024-10-09 10:26:25.212598+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-10-09 09:42:02.88044+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.680384+00 | | |
| public | m_exb | 4638 | 0 | 0.00 | 0.00 | | 2024-10-08 23:30:28.216494+00 | | |
| public | m_favorite | 33470 | 119 | 0.00 | 0.00 | | 2024-10-08 09:37:31.712087+00 | | 2024-10-08 09:37:31.834203+00 |
| public | m_favorite_group | 6329 | 4 | 0.00 | 0.00 | | 2024-10-08 09:38:33.212195+00 | | 2024-10-09 07:57:32.850634+00 |
| public | m_feature | 164 | 0 | 0.00 | 0.00 | | 2024-10-09 10:30:42.582653+00 | | |
| public | m_group | 2319 | 4 | 0.00 | 0.00 | | 2024-10-08 14:53:12.179711+00 | | |
| public | m_holiday | 5624 | 0 | 0.00 | 0.00 | | 2024-10-09 07:19:41.637455+00 | | |
| public | m_lob | 1170 | 0 | 0.00 | 0.00 | | 2024-10-08 14:54:12.405964+00 | | |
| public | m_location | 5374 | 0 | 0.00 | 0.00 | | 2024-10-08 14:53:12.337115+00 | | |
| public | m_notify_template | 124 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.604965+00 | | |
| public | m_outside | 63 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.465532+00 | | |
| public | m_pot | 25956 | 1274 | 0.00 | 4.00 | | 2024-10-10 00:10:34.78526+00 | | 2024-10-10 00:10:35.523526+00 |
| public | m_pot_profile | 668 | 5 | 0.00 | 0.00 | | 2024-10-09 09:36:10.03224+00 | | |
| public | m_provider_user | 59 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.420363+00 | | |
| public | m_region | 17 | 0 | 0.00 | 0.00 | | 2024-10-09 10:26:26.701981+00 | | |
| public | m_role | 79 | 0 | 0.00 | 0.00 | | 2024-10-09 10:26:26.664682+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-10-09 10:21:18.50321+00 | | |
| public | m_setting | 3511 | 186 | 0.00 | 5.00 | | 2024-10-09 05:29:15.612982+00 | | 2024-10-09 05:28:15.511914+00 |
| public | m_setting_log | 4716 | 862 | 0.00 | 15.00 | | | | 2024-10-09 08:02:33.110874+00 |
| public | m_site | 26 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.590239+00 | | |
| public | m_tenant | 17 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.386887+00 | | |
| public | m_tx | 17 | 925 | 54.00 | 98.00 | | | | |
| public | m_user | 3288 | 0 | 0.00 | 0.00 | | 2024-10-09 21:49:57.370023+00 | | |
| public | m_zone | 751 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.704303+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-10-09 09:52:58.323569+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-10-09 10:21:18.483407+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.628252+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-10-09 09:52:56.572914+00 | | |
| public | r_location_zone | 2 | 6 | 3.00 | 75.00 | | | | |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-10-09 09:42:02.904055+00 | | |
| public | r_pot_category | 988 | 0 | 0.00 | 0.00 | | 2024-10-09 09:42:04.145778+00 | | |
| public | r_pot_group | 11344 | 902 | 0.00 | 7.00 | | 2024-10-09 23:13:12.055797+00 | | 2024-10-09 23:36:40.481751+00 |
| public | r_pot_tx | 15 | 4 | 0.00 | 21.00 | | | | |
| public | r_pot_user | 3023 | 0 | 0.00 | 0.00 | | 2024-10-09 21:49:57.308533+00 | | |
| public | r_provider_tenant | 0 | 0 | 0 | 0 | | | | |
| public | r_role_feature | 598 | 0 | 0.00 | 0.00 | | 2024-10-08 11:52:09.866521+00 | | |
| public | r_tenant_feature | 645 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.402833+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.66127+00 | | |
| public | r_user_region | 3081 | 0 | 0.00 | 0.00 | | 2024-10-09 21:49:57.334509+00 | | |
| public | r_user_site | 0 | 0 | 0 | 0 | | | | |
| public | r_zone_category | 684 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.437588+00 | | |
| public | t_ai_history | 6 | 0 | 0.00 | 0.00 | | | | |
| public | t_attendance | 561212 | 301 | 0.00 | 0.00 | | 2024-10-09 10:27:31.080331+00 | | |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2024-10-09 10:26:26.685653+00 | | |
| public | t_mobile_device_history | 96172 | 0 | 0.00 | 0.00 | | 2024-10-09 07:42:10.963281+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-10-09 07:14:45.639166+00 | | |
| public | t_notify_history | 502143 | 733 | 0.00 | 0.00 | | 2024-10-09 10:26:29.959895+00 | | |
| public | t_operation_log | 2261396 | 0 | 0.00 | 0.00 | | 2024-10-09 07:29:53.60034+00 | | |
| public | t_plan | 3805944 | 74353 | 0.00 | 1.00 | | 2024-10-09 00:50:12.430957+00 | | |
| public | t_plan_detail | 4435106 | 284277 | 0.00 | 6.00 | | | | 2024-10-09 04:56:34.593525+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | | | |
| public | t_plan_sync | 209028 | 22370 | 0.00 | 9.00 | | 2024-10-08 09:38:33.195037+00 | | 2024-10-09 21:05:30.42292+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-10-09 07:14:43.37047+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-10-09 09:34:38.046241+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-10-09 09:42:02.924486+00 | | |
| public | t_recv_position_history | 6548 | 2022 | 0.00 | 23.00 | | 2024-10-10 01:44:51.118498+00 | 2024-10-09 12:42:01.501592+00 | 2024-10-10 01:44:51.147671+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-10-09 09:35:38.063282+00 | | |
| public | t_terminal | 21701 | 1523 | 0.00 | 6.00 | | | | 2024-10-09 22:44:22.986797+00 |
| public | t_terminal_log | 4768368 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:49.174752+00 | | |
| public | w_arrival_notify | 1 | 0 | 0.00 | 0.00 | | 2024-10-09 07:19:57.728771+00 | | |
| public | w_latest_position | 10623 | 1728 | 0.00 | 13.00 | | 2024-10-10 01:44:51.055504+00 | | 2024-10-10 01:44:51.07853+00 |
| public | w_latest_presence | 17063 | 19166 | 1.00 | 52.00 | | 2024-10-10 01:44:51.233477+00 | | 2024-10-10 01:44:51.32497+00 |
| public | w_latest_sensor | 113 | 27 | 0.00 | 19.00 | | 2024-10-10 01:44:50.79953+00 | | 2024-10-10 01:44:51.038856+00 |
| public | w_lock | 1023 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.064582+00 | | |
| public | w_master_update | 17 | 21 | 1.00 | 55.00 | | 2024-10-09 06:00:35.808916+00 | | 2024-10-09 05:11:50.048217+00 |
| public | w_plan_with_detail | 3804446 | 92876 | 0.00 | 2.00 | | 2024-10-08 10:35:35.849558+00 | | |
| public | w_plan_with_detail_new | 0 | 0 | 0 | 0 | | | | |