| 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 |
|---|
| e202311 | a_proximity_sum | 25957632 | 0 | 0.00 | 0.00 | | 2024-01-23 01:21:08.043759+00 | | |
| e202311 | a_stay_time | 16925298 | 0 | 0.00 | 0.00 | | 2024-01-21 03:13:14.017868+00 | | |
| e202311 | l_position_history | 0 | 0 | 0 | 0 | | 2024-01-11 18:15:10.83858+00 | | |
| e202311 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-11 18:15:10.86015+00 | | |
| e202311 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-01-11 18:15:10.849354+00 | | |
| e202311 | t_position_history | 302211431 | 0 | 0.00 | 0.00 | | 2024-01-20 12:36:39.328762+00 | | |
| e202311 | t_presence_history | 54971094 | 0 | 0.00 | 0.00 | | 2024-01-19 09:26:22.68257+00 | | |
| e202311 | t_sensor_history | 4607063 | 0 | 0.00 | 0.00 | | 2024-01-22 09:05:17.924462+00 | | |
| e202312 | a_proximity_sum | 29521889 | 0 | 0.00 | 0.00 | | 2024-01-17 01:24:59.366166+00 | | 2023-12-29 12:50:02.455693+00 |
| e202312 | a_stay_time | 17019683 | 0 | 0.00 | 0.00 | | 2024-01-22 01:44:52.307376+00 | | 2023-12-29 15:07:06.176602+00 |
| e202312 | l_position_history | 0 | 0 | 0 | 0 | | 2024-01-12 11:30:53.742634+00 | | |
| e202312 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-12 11:30:53.731397+00 | | |
| e202312 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-01-12 11:30:53.720171+00 | | |
| e202312 | t_position_history | 322290880 | 95 | 0.00 | 0.00 | | 2024-01-15 05:51:36.10079+00 | | 2023-12-30 17:24:31.17066+00 |
| e202312 | t_presence_history | 54449819 | 0 | 0.00 | 0.00 | | 2024-01-13 14:10:20.440943+00 | | 2023-12-31 14:43:53.221525+00 |
| e202312 | t_sensor_history | 11899877 | 2603 | 0.00 | 0.00 | | 2024-01-20 10:26:38.021132+00 | | 2023-12-29 13:16:55.682719+00 |
| e202401 | a_proximity_sum | 20591921 | 0 | 0.00 | 0.00 | | 2024-01-21 16:19:14.89277+00 | | 2024-01-23 15:47:28.851106+00 |
| e202401 | a_stay_time | 12848120 | 0 | 0.00 | 0.00 | | 2024-01-24 16:12:32.532481+00 | | 2024-01-23 16:05:50.688242+00 |
| e202401 | l_position_history | 0 | 0 | 0 | 0 | | 2024-01-17 01:24:59.377292+00 | | |
| e202401 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-17 01:24:59.399172+00 | | |
| e202401 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-01-17 01:24:59.388249+00 | | |
| e202401 | t_position_history | 265904483 | 0 | 0.00 | 0.00 | | 2024-01-23 08:50:21.816508+00 | | 2024-01-25 07:04:09.227486+00 |
| e202401 | t_presence_history | 29443489 | 4606379 | 0.00 | 13.00 | | 2024-01-25 07:16:47.160386+00 | | 2024-01-25 07:34:02.592126+00 |
| e202401 | t_sensor_history | 11053349 | 0 | 0.00 | 0.00 | | 2024-01-25 00:47:59.089856+00 | | 2024-01-23 07:12:24.927798+00 |
| public | __digdag_status | 8 | 12 | 1.00 | 60.00 | | 2024-01-24 08:30:27.596321+00 | | 2024-01-23 12:30:29.523607+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-11 06:48:58.423594+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-01-11 06:48:58.411976+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-01-18 05:18:52.150828+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-01-18 05:19:45.34937+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-01-18 05:18:52.061537+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-01-18 05:19:45.371422+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-01-18 05:19:45.392989+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-01-18 05:18:52.08301+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-01-18 05:18:52.039452+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-01-18 05:18:52.172242+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-01-18 05:18:52.105085+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-01-18 05:18:52.127864+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-01-11 06:48:58.834872+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-11 06:48:58.823823+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-01-11 06:48:58.812727+00 | | |
| public | m_area | 621 | 28 | 0.00 | 4.00 | | 2024-01-15 03:40:46.327856+00 | | 2024-01-18 08:43:32.882494+00 |
| public | m_auth | 84 | 1 | 0.00 | 1.00 | | 2024-01-11 06:48:58.44349+00 | | |
| public | m_category | 1575 | 0 | 0.00 | 0.00 | | 2024-01-15 03:40:46.352682+00 | | |
| public | m_exb | 18636 | 20 | 0.00 | 0.00 | | 2024-01-24 08:20:27.009168+00 | | 2024-01-16 03:37:31.276285+00 |
| public | m_favorite | 143813 | 701 | 0.00 | 0.00 | | 2024-01-12 03:22:37.786443+00 | | 2024-01-18 07:33:40.519402+00 |
| public | m_feature | 148 | 0 | 0.00 | 0.00 | | 2024-01-12 01:52:28.768367+00 | | |
| public | m_group | 13393 | 351 | 0.00 | 2.00 | | 2024-01-18 17:40:08.645201+00 | | 2024-01-01 03:10:40.774873+00 |
| public | m_holiday | 12752 | 0 | 0.00 | 0.00 | | 2024-01-11 04:27:16.336938+00 | | |
| public | m_lob | 17873 | 17 | 0.00 | 0.00 | | 2024-01-23 14:35:24.314694+00 | | |
| public | m_location | 33002 | 2679 | 0.00 | 7.00 | | 2024-01-12 09:15:29.699989+00 | | 2024-01-18 01:18:56.165985+00 |
| public | m_notify_template | 716 | 4 | 0.00 | 0.00 | | 2024-01-11 06:48:58.543192+00 | | 2023-12-25 06:37:18.875076+00 |
| public | m_outside | 269 | 0 | 0.00 | 0.00 | | 2024-01-21 04:00:18.87303+00 | | |
| public | m_pot | 262503 | 40477 | 0.00 | 13.00 | | 2024-01-17 00:04:05.701109+00 | | 2024-01-24 23:52:20.806526+00 |
| public | m_pot_profile | 31877 | 678 | 0.00 | 2.00 | | 2024-01-12 02:07:50.445542+00 | | 2024-01-17 00:25:12.254289+00 |
| public | m_provider_user | 24 | 0 | 0.00 | 0.00 | | 2024-01-11 06:48:58.596841+00 | | |
| public | m_region | 97 | 0 | 0.00 | 0.00 | | 2024-01-11 06:48:58.658114+00 | | |
| public | m_role | 511 | 2 | 0.00 | 0.00 | | 2024-01-11 06:48:58.641581+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-01-11 06:48:58.482563+00 | | |
| public | m_setting | 18512 | 494 | 0.00 | 2.00 | | 2024-01-25 07:25:47.671748+00 | | 2024-01-25 06:15:53.586968+00 |
| public | m_setting_log | 68028 | 0 | 0.00 | 0.00 | | 2024-01-25 01:56:22.019661+00 | | 2024-01-25 01:55:23.569428+00 |
| public | m_site | 164 | 3 | 0.00 | 1.00 | | 2024-01-11 06:48:58.503568+00 | | |
| public | m_tenant | 96 | 0 | 0.00 | 0.00 | | 2024-01-11 06:48:58.77251+00 | | |
| public | m_tx | 79746 | 15783 | 0.00 | 16.00 | | 2024-01-23 08:59:20.886799+00 | | 2024-01-24 08:09:56.63571+00 |
| public | m_user | 28797 | 1156 | 0.00 | 3.00 | | 2024-01-15 02:07:50.052558+00 | | 2024-01-21 00:05:10.573968+00 |
| public | m_zone | 4085 | 205 | 0.00 | 4.00 | | 2024-01-12 17:56:28.899622+00 | | 2024-01-23 03:36:19.668472+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-01-11 06:48:58.376158+00 | | |
| public | r_auth_zone | 184 | 0 | 0.00 | 0.00 | | 2024-01-11 06:48:58.461502+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-01-11 06:48:58.56775+00 | | |
| public | r_group_auth | 428 | 0 | 0.00 | 0.00 | | 2024-01-11 11:30:55.254159+00 | | |
| public | r_location_zone | 31688 | 2279 | 0.00 | 6.00 | | 2024-01-23 03:48:20.164491+00 | | 2024-01-23 07:01:52.030012+00 |
| public | r_pot_auth | 689 | 1 | 0.00 | 0.00 | | 2024-01-19 23:20:21.985998+00 | | |
| public | r_pot_category | 5907 | 0 | 0.00 | 0.00 | | 2024-01-25 06:34:06.19294+00 | | 2024-01-25 06:02:23.657997+00 |
| public | r_pot_group | 92492 | 4967 | 0.00 | 5.00 | | 2024-01-25 04:09:00.634118+00 | | 2024-01-25 06:02:23.626686+00 |
| public | r_pot_tx | 44236 | 87 | 0.00 | 0.00 | | 2024-01-24 03:20:57.089596+00 | | 2024-01-18 06:37:02.552979+00 |
| public | r_pot_user | 18712 | 44 | 0.00 | 0.00 | | 2024-01-18 22:28:38.567983+00 | | 2024-01-11 06:16:34.031162+00 |
| public | r_role_feature | 5320 | 4 | 0.00 | 0.00 | | 2024-01-18 17:40:08.437341+00 | | 2024-01-18 08:22:54.488926+00 |
| public | r_tenant_feature | 3273 | 2 | 0.00 | 0.00 | | 2024-01-17 00:03:57.918143+00 | | |
| public | r_tx_sensor | 406 | 0 | 0.00 | 0.00 | | 2024-01-20 10:25:11.836697+00 | | 2024-01-11 06:06:37.871266+00 |
| public | r_user_region | 19239 | 36 | 0.00 | 0.00 | | 2024-01-18 22:28:38.377932+00 | | 2024-01-11 06:16:33.903871+00 |
| public | r_user_site | 5291 | 49 | 0.00 | 0.00 | | 2024-01-11 06:16:33.967409+00 | | 2024-01-11 06:16:33.979684+00 |
| public | r_zone_category | 2826 | 310 | 0.00 | 9.00 | | 2024-01-22 01:43:51.497834+00 | | 2024-01-23 05:12:39.85601+00 |
| public | t_attendance | 665534 | 42737 | 0.00 | 6.00 | | 2024-01-17 00:04:20.434406+00 | | 2024-01-25 04:10:00.912629+00 |
| public | t_general | 1237 | 6 | 0.00 | 0.00 | | 2024-01-11 06:48:58.755304+00 | | 2023-12-29 09:51:42.752784+00 |
| public | t_mobile_device_history | 363998 | 0 | 0.00 | 0.00 | | 2024-01-14 15:11:09.859175+00 | | 2024-01-05 09:31:07.694373+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-01-11 06:48:58.62033+00 | | |
| public | t_notify_history | 1775953 | 59999 | 0.00 | 3.00 | | 2024-01-12 09:41:10.370313+00 | | 2024-01-16 00:59:55.814007+00 |
| public | t_operation_log | 6966483 | 37751 | 0.00 | 0.00 | | 2024-01-22 04:54:40.973434+00 | | 2024-01-13 23:02:29.019919+00 |
| public | t_plan | 8404046 | 1386926 | 0.00 | 14.00 | | 2024-01-13 10:08:24.184381+00 | | 2024-01-24 09:10:53.890689+00 |
| public | t_plan_detail | 13166130 | 1547352 | 0.00 | 10.00 | | 2024-01-17 10:05:37.916049+00 | | 2024-01-25 02:45:49.290619+00 |
| public | t_plan_sync | 36324 | 1329 | 0.00 | 3.00 | | 2024-01-25 03:40:14.516522+00 | | 2024-01-25 03:39:14.224514+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-01-11 06:48:58.801089+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-01-11 06:48:58.387976+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-01-11 06:48:58.680531+00 | | |
| public | t_recv_position_history | 111882 | 45648 | 0.00 | 28.00 | | 2024-01-25 07:46:03.776016+00 | 2024-01-24 12:30:12.13914+00 | 2024-01-25 07:46:04.30408+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-01-11 06:48:58.399845+00 | | |
| public | t_terminal | 15312 | 1500 | 0.00 | 8.00 | | 2024-01-25 03:41:15.220181+00 | | 2024-01-25 06:39:06.966738+00 |
| public | t_terminal_log | 4204019 | 0 | 0.00 | 0.00 | | 2024-01-21 17:23:20.847235+00 | | 2024-01-23 00:05:24.194059+00 |
| public | w_arrival_notify | 56 | 34 | 0.00 | 37.00 | | 2024-01-13 03:39:53.80872+00 | | 2024-01-18 02:26:23.059754+00 |
| public | w_latest_position | 41656 | 9228 | 0.00 | 18.00 | | 2024-01-25 07:45:58.64117+00 | | 2024-01-25 07:45:58.809223+00 |
| public | w_latest_presence | 190013 | 49017 | 0.00 | 20.00 | 2024-01-18 12:30:06.016796+00 | 2024-01-25 07:45:59.629841+00 | 2024-01-18 12:30:06.178604+00 | 2024-01-25 07:46:00.036214+00 |
| public | w_latest_sensor | 393 | 202 | 0.00 | 33.00 | | 2024-01-25 07:46:00.051662+00 | | 2024-01-25 07:46:00.166604+00 |
| public | w_lock | 10803 | 0 | 0.00 | 0.00 | | 2024-01-18 07:02:06.178567+00 | | 2023-12-21 09:08:38.175559+00 |
| public | w_master_update | 232 | 3 | 0.00 | 1.00 | | 2024-01-25 07:37:58.259361+00 | | 2024-01-25 05:24:07.406203+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-01-11 06:48:58.855779+00 | | |
| public | w_plan_with_detail | 8421116 | 254551 | 0.00 | 2.00 | | 2024-01-24 07:59:32.637322+00 | | 2024-01-24 09:25:07.606034+00 |