| 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 | 0 | 0 | 0 | | | | |
| e202409 | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| 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 | 33 | 0 | 0.00 | 0.00 | | | | |
| e202409 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| e202409 | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| e202410 | a_proximity_sum | 12988267 | 0 | 0.00 | 0.00 | | 2024-10-09 16:06:39.046812+00 | | 2024-10-09 18:04:49.037479+00 |
| e202410 | a_stay_time | 7986587 | 0 | 0.00 | 0.00 | | 2024-10-09 15:46:49.387289+00 | | 2024-10-09 17:31:11.423539+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 | 158894485 | 0 | 0.00 | 0.00 | | 2024-10-09 04:56:28.563976+00 | | 2024-10-09 17:13:04.511151+00 |
| e202410 | t_presence_history | 16274145 | 3059526 | 0.00 | 15.00 | | 2024-10-10 00:30:20.227192+00 | | 2024-10-10 00:45:51.630539+00 |
| e202410 | t_sensor_history | 2824836 | 0 | 0.00 | 0.00 | | 2024-10-09 17:04:12.983704+00 | | 2024-10-09 10:26:39.511295+00 |
| public | __digdag_status | 1 | 25 | 25.00 | 96.00 | | | | |
| public | a_attendance_sum | 40566 | 1327 | 0.00 | 3.00 | | 2024-10-10 00:51:52.100697+00 | | 2024-10-10 00:47:52.823478+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-10-09 06:15:28.415757+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-10-09 06:15:29.325826+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-10-09 06:15:04.511364+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-10-09 06:15:29.345999+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-10-09 06:15:29.366852+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-10-09 06:15:04.532521+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-10-09 06:15:04.490191+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-10-09 06:15:28.437281+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-10-09 06:15:04.554003+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-10-09 06:15:04.575424+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | | | |
| public | m_area | 659 | 1 | 0.00 | 0.00 | | 2024-10-09 03:40:47.839296+00 | | |
| public | m_auth | 0 | 0 | 0 | 0 | | | | |
| public | m_category | 1746 | 0 | 0.00 | 0.00 | | 2024-10-09 03:40:47.802213+00 | | |
| public | m_exb | 0 | 420 | 0 | 100.00 | | | | |
| public | m_favorite | 159571 | 337 | 0.00 | 0.00 | | 2024-10-08 10:00:05.603237+00 | | 2024-10-08 10:00:05.802028+00 |
| public | m_favorite_group | 46068 | 0 | 0.00 | 0.00 | | 2024-10-10 00:22:17.241147+00 | | 2024-10-10 00:35:50.576589+00 |
| public | m_feature | 163 | 0 | 0.00 | 0.00 | | 2024-10-07 23:46:25.306917+00 | | |
| public | m_group | 8 | 115 | 14.00 | 93.00 | | | | |
| public | m_holiday | 0 | 0 | 0 | 0 | | | | |
| public | m_lob | 9 | 10 | 1.00 | 52.00 | | | | |
| public | m_location | 0 | 340 | 0 | 100.00 | | | | |
| public | m_notify_template | 0 | 0 | 0 | 0 | | | | |
| public | m_outside | 0 | 0 | 0 | 0 | | | | |
| public | m_pot | 159555 | 15389 | 0.00 | 8.00 | | 2024-10-09 06:04:08.317862+00 | | 2024-10-09 23:50:36.49452+00 |
| public | m_pot_profile | 56 | 9 | 0.00 | 13.00 | | | | |
| public | m_provider_user | 71 | 1 | 0.00 | 1.00 | | 2024-10-08 00:13:06.734178+00 | | |
| public | m_region | 0 | 0 | 0 | 0 | | | | |
| public | m_role | 0 | 0 | 0 | 0 | | | | |
| public | m_sensor | 0 | 0 | 0 | 0 | | | | |
| public | m_setting | 19441 | 815 | 0.00 | 4.00 | | 2024-10-09 08:48:19.376777+00 | | 2024-10-09 08:47:00.948391+00 |
| public | m_setting_log | 28000 | 1294 | 0.00 | 4.00 | | | | 2024-10-09 02:21:18.430154+00 |
| public | m_site | 0 | 0 | 0 | 0 | | | | |
| public | m_tenant | 0 | 0 | 0 | 0 | | | | |
| public | m_tx | 99119 | 14270 | 0.00 | 12.00 | | 2024-10-09 15:24:36.19932+00 | | 2024-10-09 15:32:36.296062+00 |
| public | m_user | 30459 | 14 | 0.00 | 0.00 | | 2024-10-09 03:39:40.217567+00 | | |
| public | m_zone | 6686 | 68 | 0.00 | 1.00 | | 2024-10-08 05:34:55.375227+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | | | |
| public | r_auth_zone | 220 | 0 | 0.00 | 0.00 | | 2024-10-08 13:02:39.752995+00 | | |
| public | r_exb_sensor | 0 | 0 | 0 | 0 | | | | |
| public | r_group_auth | 588 | 118 | 0.00 | 16.00 | | | | 2024-10-08 09:38:50.736835+00 |
| public | r_location_zone | 29 | 1414 | 48.00 | 97.00 | | | | |
| public | r_pot_auth | 8660 | 29 | 0.00 | 0.00 | | 2024-10-09 03:55:37.583622+00 | | |
| public | r_pot_category | 7017 | 1 | 0.00 | 0.00 | | 2024-10-09 20:10:02.788488+00 | | 2024-10-09 20:01:40.697428+00 |
| public | r_pot_group | 95400 | 8169 | 0.00 | 7.00 | | 2024-10-10 00:36:50.917748+00 | | 2024-10-10 00:47:52.726101+00 |
| public | r_pot_tx | 74 | 433 | 5.00 | 85.00 | | | | |
| public | r_pot_user | 2 | 28 | 14.00 | 93.00 | | | | |
| public | r_provider_tenant | 0 | 6 | 0 | 100.00 | | | | |
| public | r_role_feature | 0 | 0 | 0 | 0 | | | | |
| public | r_tenant_feature | 3574 | 0 | 0.00 | 0.00 | | 2024-10-09 06:14:56.545623+00 | | |
| public | r_tx_sensor | 0 | 0 | 0 | 0 | | | | |
| public | r_user_region | 2 | 26 | 13.00 | 92.00 | | | | |
| public | r_user_site | 3 | 3 | 1.00 | 50.00 | | | | |
| public | r_zone_category | 41 | 118 | 2.00 | 74.00 | | | | |
| public | t_ai_history | 0 | 0 | 0 | 0 | | | | |
| public | t_attendance | 1448751 | 6346 | 0.00 | 0.00 | | 2024-10-09 06:15:28.394259+00 | | |
| public | t_general | 11 | 2 | 0.00 | 15.00 | | | | |
| public | t_mobile_device_history | 649463 | 0 | 0.00 | 0.00 | | 2024-10-08 21:40:17.968252+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | | | |
| public | t_notify_history | 3101889 | 7194 | 0.00 | 0.00 | | 2024-10-08 03:18:00.653461+00 | | |
| public | t_operation_log | 124022 | 14 | 0.00 | 0.00 | | | | |
| public | t_plan | 12971451 | 1455904 | 0.00 | 10.00 | | | | 2024-10-09 08:24:03.077871+00 |
| public | t_plan_detail | 22593702 | 1506688 | 0.00 | 6.00 | | | | 2024-10-09 00:05:10.443012+00 |
| public | t_plan_sync | 41375 | 4813 | 0.00 | 10.00 | | 2024-10-10 00:34:50.804702+00 | | 2024-10-10 00:36:51.19671+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | | | |
| public | t_recv_position_history | 118230 | 84087 | 0.00 | 41.00 | | 2024-10-10 00:52:51.277251+00 | 2024-10-09 13:30:06.342062+00 | 2024-10-10 00:52:51.659144+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| public | t_terminal | 96878 | 4119 | 0.00 | 4.00 | | | | 2024-10-09 23:15:38.716309+00 |
| public | t_terminal_log | 80380 | 0 | 0.00 | 0.00 | | | | |
| public | w_arrival_notify | 85 | 23 | 0.00 | 21.00 | | 2024-10-09 00:17:16.832111+00 | | 2024-10-09 00:16:18.456317+00 |
| public | w_latest_position | 61141 | 15430 | 0.00 | 20.00 | | 2024-10-10 00:52:51.793311+00 | | 2024-10-10 00:52:51.90992+00 |
| public | w_latest_presence | 194296 | 130350 | 0.00 | 40.00 | | 2024-10-10 00:52:53.177941+00 | | 2024-10-10 00:52:53.568478+00 |
| public | w_latest_sensor | 344 | 214 | 0.00 | 38.00 | | 2024-10-10 00:52:51.993188+00 | | 2024-10-10 00:52:52.105447+00 |
| public | w_lock | 18 | 0 | 0.00 | 0.00 | | | | |
| public | w_master_update | 170 | 46 | 0.00 | 21.00 | | 2024-10-09 23:25:38.589868+00 | | 2024-10-09 22:01:40.226077+00 |
| public | w_migration | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_with_detail | 12978120 | 619513 | 0.00 | 4.00 | | 2024-10-08 00:53:32.178273+00 | | 2024-10-09 08:23:51.6147+00 |