| 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 | 452405386 | 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 | 9170482 | 0 | 0.00 | 0.00 | | 2024-11-12 18:09:00.93874+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 | 488420860 | 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 | 15061739 | 0 | 0.00 | 0.00 | | 2024-11-12 15:49:54.094884+00 | | 2024-11-13 15:34:23.828959+00 |
| e202411 | a_stay_time | 13178837 | 0 | 0.00 | 0.00 | | 2024-11-13 17:20:22.376622+00 | | 2024-11-13 18:33:24.421081+00 |
| e202411 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-14 00:47:48.198714+00 | | |
| e202411 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-14 00:47:48.20967+00 | | |
| e202411 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-14 00:47:48.220822+00 | | |
| e202411 | t_position_history | 197085087 | 0 | 0.00 | 0.00 | | 2024-11-13 07:06:38.011486+00 | | 2024-11-13 12:26:38.339307+00 |
| e202411 | t_presence_history | 20922107 | 2781301 | 0.00 | 11.00 | | 2024-11-14 00:37:19.510516+00 | | 2024-11-14 00:37:20.125426+00 |
| e202411 | t_sensor_history | 4112581 | 0 | 0.00 | 0.00 | | 2024-11-12 16:14:08.122508+00 | | 2024-11-13 04:59:02.288412+00 |
| public | __digdag_status | 32 | 32 | 1.00 | 50.00 | | 2024-11-11 08:30:11.638495+00 | | 2024-11-10 12:30:57.55255+00 |
| public | a_attendance_sum | 52433 | 3110 | 0.00 | 5.00 | | 2024-11-14 00:46:28.627586+00 | | 2024-11-14 00:45:28.429435+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:48.127203+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:41.947683+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-14 00:25:14.490202+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-14 00:25:14.471602+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-14 00:25:14.453845+00 | | |
| public | m_area | 660 | 4 | 0.00 | 0.00 | | 2024-11-06 11:16:23.009611+00 | | |
| public | m_auth | 121 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.144126+00 | | |
| public | m_category | 1732 | 1 | 0.00 | 0.00 | | 2024-11-06 11:16:22.983095+00 | | |
| public | m_exb | 21313 | 0 | 0.00 | 0.00 | | 2024-11-13 10:45:45.105168+00 | | 2024-11-05 15:49:31.712072+00 |
| public | m_favorite | 213782 | 1174 | 0.00 | 0.00 | | 2024-11-06 02:17:45.689012+00 | | 2024-10-08 10:00:05.802028+00 |
| public | m_favorite_group | 71973 | 57 | 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 | 17888 | 11 | 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 | 22090 | 12 | 0.00 | 0.00 | | 2024-11-12 05:05:06.276836+00 | | |
| public | m_location | 37662 | 19 | 0.00 | 0.00 | | 2024-11-10 03:13:01.104895+00 | | |
| public | m_notify_template | 735 | 1 | 0.00 | 0.00 | | 2024-11-13 23:00:48.284114+00 | | |
| public | m_outside | 319 | 0 | 0.00 | 0.00 | | 2024-11-10 23:40:29.34044+00 | | |
| public | m_pot | 161397 | 28029 | 0.00 | 14.00 | | 2024-11-12 06:09:19.996876+00 | | 2024-11-14 00:12:09.371042+00 |
| public | m_pot_profile | 48666 | 1 | 0.00 | 0.00 | | 2024-11-12 16:50:48.014279+00 | | |
| public | m_provider_user | 71 | 6 | 0.00 | 7.00 | | 2024-11-05 06:26:01.906602+00 | | |
| public | m_region | 98 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.366725+00 | | |
| public | m_role | 561 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.352412+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.23576+00 | | |
| public | m_setting | 19575 | 1117 | 0.00 | 5.00 | | 2024-11-13 03:33:28.780537+00 | | 2024-11-12 14:08:40.342125+00 |
| public | m_setting_log | 28683 | 0 | 0.00 | 0.00 | | 2024-11-13 07:13:54.34253+00 | | 2024-11-13 20:39:36.899731+00 |
| public | m_site | 176 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.252323+00 | | |
| public | m_tenant | 97 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.488374+00 | | |
| public | m_tx | 100405 | 14479 | 0.00 | 12.00 | | 2024-11-12 07:41:03.965757+00 | | 2024-11-12 08:11:41.96379+00 |
| public | m_user | 30617 | 112 | 0.00 | 0.00 | | 2024-11-06 11:16:16.619931+00 | | |
| public | m_zone | 6601 | 41 | 0.00 | 0.00 | | 2024-11-05 15:33:52.249132+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:40.783368+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-13 23:00:48.310067+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 | 39612 | 105 | 0.00 | 0.00 | | 2024-11-11 05:22:50.032617+00 | | 2024-11-11 05:23:51.432532+00 |
| public | r_pot_auth | 8389 | 76 | 0.00 | 0.00 | | 2024-11-06 11:53:37.67393+00 | | 2024-11-06 01:49:00.707869+00 |
| public | r_pot_category | 7015 | 0 | 0.00 | 0.00 | | 2024-11-13 20:09:35.077356+00 | | 2024-11-13 20:01:23.55773+00 |
| public | r_pot_group | 166831 | 3 | 0.00 | 0.00 | | 2024-11-14 00:42:31.796028+00 | | 2024-11-14 00:12:05.918102+00 |
| public | r_pot_tx | 57309 | 125 | 0.00 | 0.00 | | 2024-11-12 12:06:51.456986+00 | | 2024-10-29 10:18:54.209249+00 |
| public | r_pot_user | 18986 | 35 | 0.00 | 0.00 | | 2024-11-08 19:00:29.396246+00 | | |
| public | r_provider_tenant | 1361 | 0 | 0.00 | 0.00 | | 2024-11-12 05:51:24.323614+00 | | 2024-11-12 05:51:24.327858+00 |
| public | r_role_feature | 5136 | 33 | 0.00 | 0.00 | | 2024-11-08 19:00:29.426378+00 | | |
| public | r_tenant_feature | 3618 | 1 | 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 | 19220 | 36 | 0.00 | 0.00 | | 2024-11-08 19:00:22.467752+00 | | |
| public | r_user_site | 5094 | 1 | 0.00 | 0.00 | | 2024-11-13 23:00:48.214018+00 | | |
| public | r_zone_category | 3368 | 21 | 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 | 1631119 | 41228 | 0.00 | 2.00 | | 2024-11-06 22:01:32.841628+00 | | 2024-11-04 23:45:17.608246+00 |
| public | t_general | 2728 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.473778+00 | | 2024-11-13 03:43:51.184966+00 |
| public | t_mobile_device_history | 666348 | 0 | 0.00 | 0.00 | | 2024-11-06 06:01:41.437322+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.331152+00 | | |
| public | t_notify_history | 3521273 | 20598 | 0.00 | 0.00 | | 2024-11-05 09:48:44.694461+00 | | 2024-11-13 02:26:04.171404+00 |
| public | t_operation_log | 13242625 | 3 | 0.00 | 0.00 | | 2024-11-11 06:32:26.37063+00 | | 2024-11-10 23:44:26.901532+00 |
| public | t_plan | 14370937 | 887201 | 0.00 | 5.00 | | 2024-11-08 05:09:31.354411+00 | | 2024-11-13 08:00:28.890102+00 |
| public | t_plan_detail | 24747589 | 680110 | 0.00 | 2.00 | | 2024-11-12 02:39:26.755885+00 | | 2024-11-13 22:29:47.475106+00 |
| public | t_plan_sync | 42101 | 5346 | 0.00 | 11.00 | | 2024-11-14 00:37:29.555162+00 | | 2024-11-14 00:37:29.829769+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.511443+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:40.843385+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:48.38748+00 | | |
| public | t_recv_position_history | 121012 | 43735 | 0.00 | 26.00 | | 2024-11-14 00:51:29.175891+00 | 2024-11-13 13:30:08.601837+00 | 2024-11-14 00:51:29.582472+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:40.903751+00 | | |
| public | t_terminal | 106961 | 1780 | 0.00 | 1.00 | | 2024-11-12 12:06:53.337707+00 | | 2024-11-13 17:13:54.920115+00 |
| public | t_terminal_log | 12499145 | 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 | 85 | 50 | 0.00 | 37.00 | | 2024-11-11 15:00:33.139866+00 | | 2024-11-14 00:19:36.902148+00 |
| public | w_latest_position | 62031 | 7460 | 0.00 | 10.00 | | 2024-11-14 00:51:29.894444+00 | | 2024-11-14 00:51:30.014183+00 |
| public | w_latest_presence | 229425 | 51813 | 0.00 | 18.00 | | 2024-11-14 00:51:35.266665+00 | | 2024-11-14 00:51:35.940392+00 |
| public | w_latest_sensor | 340 | 0 | 0.00 | 0.00 | | 2024-11-14 00:51:30.031178+00 | | 2024-11-14 00:51:30.146294+00 |
| public | w_lock | 14780 | 0 | 0.00 | 0.00 | | 2024-11-08 10:44:50.504866+00 | | |
| public | w_master_update | 168 | 0 | 0.00 | 0.00 | | 2024-11-14 00:46:28.285791+00 | | 2024-11-14 00:45:28.315047+00 |
| public | w_migration | 795 | 0 | 0.00 | 0.00 | | 2024-11-14 00:25:14.51583+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2024-11-13 09:39:14.035575+00 | | |
| public | w_plan_with_detail | 14388076 | 1436258 | 0.00 | 9.00 | | 2024-11-05 06:56:57.073794+00 | | 2024-11-13 07:46:15.146953+00 |