| 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 |
|---|
| e202409 | a_proximity_sum | 43700818 | 1913278 | 0.00 | 4.00 | | 2024-11-08 07:45:25.469907+00 | | 2024-11-09 02:35:11.414101+00 |
| e202409 | a_stay_time | 21852473 | 0 | 0.00 | 0.00 | | 2024-11-10 07:29:07.396043+00 | | 2024-10-31 04:06:41.049298+00 |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-11 13:45:24.086962+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-11 13:45:24.122342+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-11 13:45:24.10452+00 | | |
| e202409 | t_position_history | 452405384 | 0 | 0.00 | 0.00 | | 2024-11-08 09:00:25.075648+00 | | |
| e202409 | t_presence_history | 45407307 | 0 | 0.00 | 0.00 | | 2024-11-11 10:27:00.859434+00 | | |
| e202409 | t_sensor_history | 9170515 | 0 | 0.00 | 0.00 | | 2024-11-03 01:23:30.782582+00 | | |
| e202410 | a_proximity_sum | 37730325 | 2424514 | 0.00 | 6.00 | | 2024-11-05 12:07:46.204076+00 | | 2024-11-09 02:35:10.823595+00 |
| e202410 | a_stay_time | 23736788 | 1693134 | 0.00 | 6.00 | | 2024-11-06 01:44:46.868255+00 | | 2024-11-09 02:26:51.673576+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-12 00:51:24.1411+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-12 00:51:24.172377+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-12 00:51:24.15688+00 | | |
| e202410 | t_position_history | 488420424 | 0 | 0.00 | 0.00 | | 2024-11-10 05:09:32.283859+00 | | 2024-10-30 02:43:29.948815+00 |
| e202410 | t_presence_history | 53882485 | 0 | 0.00 | 0.00 | | 2024-11-10 03:38:26.334859+00 | | 2024-10-31 14:26:50.9548+00 |
| e202410 | t_sensor_history | 9420693 | 0 | 0.00 | 0.00 | | 2024-11-05 06:10:50.413169+00 | | 2024-10-29 03:17:40.973549+00 |
| e202411 | a_proximity_sum | 11745477 | 61688 | 0.00 | 0.00 | | 2024-11-11 15:13:08.794377+00 | | 2024-11-12 00:34:24.139158+00 |
| e202411 | a_stay_time | 9820430 | 89525 | 0.00 | 0.00 | | 2024-11-11 15:47:17.82856+00 | | 2024-11-11 17:17:22.016445+00 |
| e202411 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-05 01:20:55.917399+00 | | |
| e202411 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-05 01:20:55.928394+00 | | |
| e202411 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-05 01:20:55.939698+00 | | |
| e202411 | t_position_history | 157583558 | 0 | 0.00 | 0.00 | | 2024-11-11 12:10:43.39397+00 | | 2024-11-12 00:44:25.187946+00 |
| e202411 | t_presence_history | 16787785 | 3590885 | 0.00 | 17.00 | | 2024-11-12 00:27:13.712942+00 | | 2024-11-12 00:49:24.532172+00 |
| e202411 | t_sensor_history | 3493776 | 0 | 0.00 | 0.00 | | 2024-11-10 09:28:22.484955+00 | | 2024-11-12 00:21:12.696986+00 |
| public | __digdag_status | 31 | 9 | 0.00 | 22.00 | | 2024-11-11 08:30:11.638495+00 | | 2024-11-10 12:30:57.55255+00 |
| public | a_attendance_sum | 43172 | 7286 | 0.00 | 14.00 | | 2024-11-12 00:43:24.689129+00 | | 2024-11-12 00:50:24.122058+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-05 00:04:23.476002+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-11-05 00:04:17.623703+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-11-06 22:02:36.609503+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-11-06 22:11:37.99731+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-11-06 22:01:02.988725+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-11-06 22:11:38.008858+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-11-06 22:11:38.020417+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-11-06 22:01:02.999769+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-11-06 22:01:02.977197+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-11-06 22:02:36.620623+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-11-06 22:01:03.010785+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-11-06 22:01:03.021779+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-05 00:57:21.898449+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-05 00:57:21.887252+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-05 00:57:21.875912+00 | | |
| public | m_area | 656 | 1 | 0.00 | 0.00 | | 2024-11-06 11:16:23.009611+00 | | |
| public | m_auth | 121 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.495393+00 | | |
| public | m_category | 1722 | 1 | 0.00 | 0.00 | | 2024-11-06 11:16:22.983095+00 | | |
| public | m_exb | 20975 | 472 | 0.00 | 2.00 | | 2024-11-04 11:54:27.707728+00 | | 2024-11-05 15:49:31.712072+00 |
| public | m_favorite | 213310 | 691 | 0.00 | 0.00 | | 2024-11-06 02:17:45.689012+00 | | 2024-10-08 10:00:05.802028+00 |
| public | m_favorite_group | 71150 | 33 | 0.00 | 0.00 | | 2024-11-08 11:44:07.922907+00 | | 2024-10-31 02:08:28.243557+00 |
| public | m_feature | 164 | 0 | 0.00 | 0.00 | | 2024-11-05 06:02:20.826151+00 | | |
| public | m_group | 17886 | 5 | 0.00 | 0.00 | | 2024-11-08 19:00:29.636158+00 | | |
| public | m_holiday | 25249 | 0 | 0.00 | 0.00 | | 2024-11-12 00:28:24.302035+00 | | |
| public | m_lob | 22062 | 79 | 0.00 | 0.00 | | 2024-11-02 01:10:13.539251+00 | | |
| public | m_location | 37662 | 4 | 0.00 | 0.00 | | 2024-11-10 03:13:01.104895+00 | | |
| public | m_notify_template | 731 | 17 | 0.00 | 2.00 | | 2024-11-05 00:04:23.648702+00 | | |
| public | m_outside | 319 | 0 | 0.00 | 0.00 | | 2024-11-10 23:40:29.34044+00 | | |
| public | m_pot | 161253 | 29451 | 0.00 | 15.00 | | 2024-11-08 08:22:29.046579+00 | | 2024-11-12 00:07:58.357057+00 |
| public | m_pot_profile | 49655 | 109 | 0.00 | 0.00 | | 2024-11-03 00:12:22.963099+00 | | |
| public | m_provider_user | 71 | 4 | 0.00 | 5.00 | | 2024-11-05 06:26:01.906602+00 | | |
| public | m_region | 97 | 3 | 0.00 | 3.00 | | 2024-11-05 00:04:23.740702+00 | | |
| public | m_role | 557 | 10 | 0.00 | 1.00 | | 2024-11-05 00:04:23.718635+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.601048+00 | | |
| public | m_setting | 19235 | 919 | 0.00 | 4.00 | | 2024-11-11 06:52:43.171541+00 | | 2024-11-11 04:10:49.619442+00 |
| public | m_setting_log | 28558 | 2366 | 0.00 | 7.00 | | 2024-11-08 03:27:21.248234+00 | | 2024-11-11 12:30:30.908427+00 |
| public | m_site | 175 | 3 | 0.00 | 1.00 | | 2024-11-05 00:04:23.621472+00 | | |
| public | m_tenant | 96 | 3 | 0.00 | 3.00 | | 2024-11-05 00:04:23.889476+00 | | |
| public | m_tx | 100304 | 17621 | 0.00 | 14.00 | | 2024-11-11 05:23:43.668126+00 | | 2024-11-11 06:23:50.085018+00 |
| public | m_user | 30603 | 87 | 0.00 | 0.00 | | 2024-11-06 11:16:16.619931+00 | | |
| public | m_zone | 6597 | 34 | 0.00 | 0.00 | | 2024-11-05 15:33:52.249132+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-11-05 00:03:18.801691+00 | | |
| public | r_auth_zone | 222 | 0 | 0.00 | 0.00 | | 2024-11-06 03:52:28.108281+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.672867+00 | | |
| public | r_group_auth | 588 | 0 | 0.00 | 0.00 | | 2024-11-07 08:03:08.2434+00 | | 2024-10-08 09:38:50.736835+00 |
| public | r_location_zone | 39609 | 6 | 0.00 | 0.00 | | 2024-11-11 05:22:50.032617+00 | | 2024-11-11 05:23:51.432532+00 |
| public | r_pot_auth | 8390 | 67 | 0.00 | 0.00 | | 2024-11-06 11:53:37.67393+00 | | 2024-11-06 01:49:00.707869+00 |
| public | r_pot_category | 6973 | 2 | 0.00 | 0.00 | | 2024-11-11 20:09:34.295675+00 | | 2024-11-11 20:01:25.249597+00 |
| public | r_pot_group | 150874 | 3284 | 0.00 | 2.00 | | 2024-11-12 00:40:24.192387+00 | | 2024-11-12 00:07:54.332264+00 |
| public | r_pot_tx | 57238 | 1381 | 0.00 | 2.00 | | 2024-11-02 18:58:25.722067+00 | | 2024-10-29 10:18:54.209249+00 |
| public | r_pot_user | 18978 | 27 | 0.00 | 0.00 | | 2024-11-08 19:00:29.396246+00 | | |
| public | r_provider_tenant | 1359 | 170 | 0.00 | 11.00 | | 2024-11-06 07:34:09.948857+00 | | 2024-11-06 07:34:09.9535+00 |
| public | r_role_feature | 5143 | 0 | 0.00 | 0.00 | | 2024-11-08 19:00:29.426378+00 | | |
| public | r_tenant_feature | 3569 | 0 | 0.00 | 0.00 | | 2024-11-06 22:00:57.414772+00 | | |
| public | r_tx_sensor | 313 | 0 | 0.00 | 0.00 | | 2024-11-08 08:12:36.00724+00 | | |
| public | r_user_region | 19212 | 27 | 0.00 | 0.00 | | 2024-11-08 19:00:22.467752+00 | | |
| public | r_user_site | 5090 | 16 | 0.00 | 0.00 | | 2024-11-05 00:04:23.577201+00 | | |
| public | r_zone_category | 3368 | 9 | 0.00 | 0.00 | | 2024-11-11 05:22:49.857283+00 | | 2024-10-21 14:08:10.484709+00 |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2024-11-08 00:21:33.428976+00 | | |
| public | t_attendance | 1614806 | 24623 | 0.00 | 1.00 | | 2024-11-06 22:01:32.841628+00 | | 2024-11-04 23:45:17.608246+00 |
| public | t_general | 2750 | 10 | 0.00 | 0.00 | | 2024-11-05 00:04:23.871727+00 | | |
| public | t_mobile_device_history | 658144 | 0 | 0.00 | 0.00 | | 2024-11-06 06:01:41.437322+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.697153+00 | | |
| public | t_notify_history | 3389562 | 14447 | 0.00 | 0.00 | | 2024-11-05 09:48:44.694461+00 | | 2024-10-24 22:46:31.398488+00 |
| public | t_operation_log | 13141857 | 0 | 0.00 | 0.00 | | 2024-11-11 06:32:26.37063+00 | | 2024-11-10 23:44:26.901532+00 |
| public | t_plan | 14279130 | 487377 | 0.00 | 3.00 | | 2024-11-08 05:09:31.354411+00 | | 2024-11-11 03:10:38.568753+00 |
| public | t_plan_detail | 24540837 | 1556758 | 0.00 | 5.00 | | 2024-11-01 16:22:50.242868+00 | | 2024-11-11 23:28:49.894352+00 |
| public | t_plan_sync | 42064 | 5505 | 0.00 | 11.00 | | 2024-11-12 00:40:24.426673+00 | | 2024-11-12 00:40:24.714546+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.918041+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-11-05 00:03:18.824769+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-11-05 00:04:23.752067+00 | | |
| public | t_recv_position_history | 121853 | 507732 | 4.00 | 80.00 | | 2024-11-12 00:52:23.450201+00 | 2024-11-11 13:30:09.555728+00 | 2024-11-12 00:52:23.869319+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-11-05 00:03:18.855061+00 | | |
| public | t_terminal | 105899 | 7757 | 0.00 | 6.00 | | 2024-11-02 18:58:26.981845+00 | | 2024-11-11 23:19:14.590861+00 |
| public | t_terminal_log | 12427006 | 0 | 0.00 | 0.00 | | 2024-11-11 02:23:23.066273+00 | | 2024-11-11 00:59:08.212201+00 |
| public | w_arrival_notify | 78 | 14 | 0.00 | 15.00 | | 2024-11-11 15:00:33.139866+00 | | 2024-11-10 21:33:46.035994+00 |
| public | w_latest_position | 61991 | 181586 | 2.00 | 74.00 | | 2024-11-12 00:52:23.985589+00 | | 2024-11-12 00:52:24.105024+00 |
| public | w_latest_presence | 215295 | 1012304 | 4.00 | 82.00 | | 2024-11-12 00:51:24.589124+00 | | 2024-11-12 00:51:25.00683+00 |
| public | w_latest_sensor | 340 | 1506 | 4.00 | 81.00 | | 2024-11-12 00:51:24.186448+00 | | 2024-11-12 00:51:24.300221+00 |
| public | w_lock | 14770 | 0 | 0.00 | 0.00 | | 2024-11-08 10:44:50.504866+00 | | |
| public | w_master_update | 168 | 52 | 0.00 | 23.00 | | 2024-11-11 22:03:06.55192+00 | | 2024-11-11 21:10:10.917532+00 |
| public | w_migration | 795 | 29 | 0.00 | 3.00 | | 2024-11-05 00:57:21.916025+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2024-11-04 10:00:57.243378+00 | | |
| public | w_plan_with_detail | 14294721 | 1081082 | 0.00 | 7.00 | | 2024-11-05 06:56:57.073794+00 | | 2024-11-11 02:57:28.125049+00 |