| 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 |
|---|
| e202402 | a_proximity_sum | 612116 | 0 | 0.00 | 0.00 | | 2024-04-24 09:36:56.377999+00 | | 2024-02-29 17:01:50.42159+00 |
| e202402 | a_stay_time | 2085758 | 0 | 0.00 | 0.00 | | 2024-04-24 09:36:56.350509+00 | | 2024-02-29 15:30:46.695619+00 |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-12 12:43:26.620619+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-12 13:38:20.979022+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-12 12:43:26.631601+00 | | |
| e202402 | t_position_history | 29297216 | 0 | 0.00 | 0.00 | | 2024-04-11 11:37:26.135284+00 | | 2024-02-29 05:55:59.50972+00 |
| e202402 | t_presence_history | 5905667 | 0 | 0.00 | 0.00 | | 2024-04-19 11:53:38.544626+00 | | 2024-02-29 14:49:45.707015+00 |
| e202402 | t_sensor_history | 1364689 | 0 | 0.00 | 0.00 | | 2024-04-23 07:11:00.804476+00 | | 2024-02-28 15:02:44.476238+00 |
| e202403 | a_proximity_sum | 676427 | 0 | 0.00 | 0.00 | | 2024-04-19 10:10:32.717059+00 | | 2024-03-27 17:01:22.117269+00 |
| e202403 | a_stay_time | 2220231 | 0 | 0.00 | 0.00 | | 2024-04-19 16:25:32.589219+00 | | 2024-03-29 15:31:24.472534+00 |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-14 13:51:28.632785+00 | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-14 13:51:29.087652+00 | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-14 12:22:51.809715+00 | | |
| e202403 | t_position_history | 31270909 | 0 | 0.00 | 0.00 | | 2024-04-24 06:40:31.505801+00 | | 2024-03-28 10:35:22.309871+00 |
| e202403 | t_presence_history | 9346840 | 0 | 0.00 | 0.00 | | 2024-04-13 20:35:05.032265+00 | | 2024-03-31 14:59:07.156357+00 |
| e202403 | t_sensor_history | 1265002 | 0 | 0.00 | 0.00 | | 2024-04-22 10:49:36.704263+00 | | 2024-03-30 15:27:03.173399+00 |
| e202404 | a_proximity_sum | 2757515 | 0 | 0.00 | 0.00 | | 2024-04-18 15:31:17.197044+00 | | 2024-04-22 15:32:44.692828+00 |
| e202404 | a_stay_time | 2499311 | 0 | 0.00 | 0.00 | | 2024-04-22 15:30:50.139947+00 | | 2024-04-24 15:31:28.601059+00 |
| e202404 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-12 12:43:26.642717+00 | | |
| e202404 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-14 13:51:28.654881+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-14 13:51:28.643583+00 | | |
| e202404 | t_position_history | 40478333 | 0 | 0.00 | 0.00 | | 2024-04-24 01:39:13.164604+00 | | 2024-04-24 22:18:31.955894+00 |
| e202404 | t_presence_history | 6373161 | 279864 | 0.00 | 4.00 | | 2024-04-25 01:45:14.626843+00 | | 2024-04-25 01:36:03.599132+00 |
| e202404 | t_sensor_history | 925535 | 0 | 0.00 | 0.00 | | 2024-04-21 10:32:55.412638+00 | | 2024-04-22 16:07:18.906024+00 |
| public | __digdag_status | 6 | 2 | 0.00 | 25.00 | | 2024-04-24 21:56:23.387966+00 | | 2024-04-24 21:56:23.391899+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-12 12:37:09.485796+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-04-12 12:37:09.45808+00 | | |
| public | b_attendance_group | 395378 | 10984 | 0.00 | 2.00 | | 2024-04-12 12:37:08.261436+00 | | 2024-04-14 17:58:39.932635+00 |
| public | b_attendance_hour | 5918344 | 156107 | 0.00 | 2.00 | | 2024-04-12 23:33:13.926078+00 | | 2024-04-10 17:45:32.721124+00 |
| public | b_attendance_pot | 7776 | 0 | 0.00 | 0.00 | | 2024-04-10 22:21:09.090039+00 | | 2024-04-21 16:51:03.978657+00 |
| public | b_attendance_pot_hour | 116640 | 0 | 0.00 | 0.00 | | 2024-04-20 16:51:19.023006+00 | | 2024-04-24 16:51:25.857925+00 |
| public | b_check_in | 3173983 | 93808 | 0.00 | 2.00 | | 2024-04-13 01:13:02.337221+00 | | 2024-04-12 17:43:09.406078+00 |
| public | b_check_in_hour | 47605699 | 1364686 | 0.00 | 2.00 | | 2024-04-12 23:34:52.695126+00 | | 2024-04-11 18:32:22.016507+00 |
| public | b_check_in_pot | 5658 | 0 | 0.00 | 0.00 | | 2024-04-14 13:05:21.943596+00 | | 2024-04-20 16:51:19.265727+00 |
| public | b_check_in_pot_hour | 84947 | 0 | 0.00 | 0.00 | | 2024-04-17 05:41:19.544643+00 | | 2024-04-24 16:51:27.321492+00 |
| public | b_proximity_group | 41764205 | 1336492 | 0.00 | 3.00 | | 2024-04-13 00:34:43.372759+00 | | 2024-04-13 00:34:49.786797+00 |
| public | b_proximity_info | 31086230 | 71673 | 0.00 | 0.00 | | 2024-04-12 23:32:55.040992+00 | | 2024-04-23 16:06:49.948651+00 |
| public | b_seat_reserve | 694706 | 19302 | 0.00 | 2.00 | | 2024-04-13 00:11:22.224944+00 | | 2024-04-11 17:37:14.566172+00 |
| public | b_seat_reserve_hour | 12809164 | 374267 | 0.00 | 2.00 | | 2024-04-12 12:37:05.344144+00 | | 2024-04-08 17:39:56.568386+00 |
| public | b_usage | 753124 | 20812 | 0.00 | 2.00 | | 2024-04-12 12:37:12.509326+00 | | 2024-04-09 17:34:29.538469+00 |
| public | b_usage_hour | 13971193 | 330870 | 0.00 | 2.00 | | 2024-04-12 23:30:34.165624+00 | | 2024-04-24 18:38:14.541357+00 |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-12 12:41:10.720639+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-12 12:41:10.709597+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-12 12:41:10.698594+00 | | |
| public | m_area | 97 | 1 | 0.00 | 1.00 | | 2024-04-13 01:20:55.10611+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-04-12 23:33:13.947029+00 | | |
| public | m_category | 455 | 30 | 0.00 | 6.00 | | 2024-04-12 12:37:13.478455+00 | | 2024-03-26 01:55:07.081821+00 |
| public | m_exb | 3790 | 115 | 0.00 | 2.00 | | 2024-04-13 01:20:55.214251+00 | | 2024-04-15 06:32:05.179075+00 |
| public | m_favorite | 35437 | 536 | 0.00 | 1.00 | | 2024-04-12 23:35:53.470286+00 | | 2024-04-02 07:41:52.488072+00 |
| public | m_feature | 156 | 10 | 0.00 | 6.00 | | 2024-04-13 01:21:04.950628+00 | | |
| public | m_group | 2572 | 1 | 0.00 | 0.00 | | 2024-04-22 01:00:31.441631+00 | | 2024-04-15 04:37:44.665462+00 |
| public | m_holiday | 5865 | 0 | 0.00 | 0.00 | | 2024-04-12 12:41:10.79183+00 | | 2024-04-05 08:45:08.676261+00 |
| public | m_lob | 2272 | 8 | 0.00 | 0.00 | | 2024-04-12 23:40:10.102259+00 | | 2024-03-31 15:01:05.267697+00 |
| public | m_location | 5357 | 147 | 0.00 | 2.00 | | 2024-04-12 12:37:09.647849+00 | | 2024-04-15 06:32:05.150261+00 |
| public | m_notify_template | 119 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:13.241948+00 | | |
| public | m_outside | 57 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:09.742148+00 | | |
| public | m_pot | 23638 | 4762 | 0.00 | 16.00 | | 2024-04-25 00:01:45.709616+00 | | 2024-04-25 00:10:48.17297+00 |
| public | m_pot_profile | 661 | 36 | 0.00 | 5.00 | | 2024-04-12 23:32:57.143354+00 | | 2024-03-20 09:37:46.4079+00 |
| public | m_provider_user | 58 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:09.44644+00 | | 2024-03-26 10:29:29.496795+00 |
| public | m_region | 15 | 0 | 0.00 | 0.00 | | 2024-04-13 01:21:01.157851+00 | | |
| public | m_role | 76 | 0 | 0.00 | 0.00 | | 2024-04-13 01:21:01.120141+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-04-13 01:12:54.79758+00 | | |
| public | m_setting | 3163 | 216 | 0.00 | 6.00 | | 2024-04-24 04:32:47.162692+00 | | 2024-04-23 21:52:14.418503+00 |
| public | m_setting_log | 4242 | 504 | 0.00 | 10.00 | | 2024-04-22 12:30:24.124977+00 | | 2024-04-24 12:30:09.491034+00 |
| public | m_site | 22 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:13.222976+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:09.402405+00 | | |
| public | m_tx | 25995 | 2150 | 0.00 | 7.00 | | 2024-04-17 03:41:44.493363+00 | | 2024-04-17 03:40:44.382777+00 |
| public | m_user | 971 | 11 | 0.00 | 1.00 | | 2024-04-15 05:46:23.786741+00 | | 2024-04-15 05:46:23.803489+00 |
| public | m_zone | 742 | 55 | 0.00 | 6.00 | | 2024-04-12 12:37:13.526822+00 | | 2024-04-15 06:12:23.833442+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-04-13 00:11:22.372561+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-04-13 01:12:54.777658+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:13.319827+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-04-13 00:11:19.604863+00 | | |
| public | r_location_zone | 3365 | 343 | 0.00 | 9.00 | | 2024-04-12 10:42:25.413011+00 | | 2024-04-16 09:14:27.203105+00 |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-04-12 23:33:13.975702+00 | | |
| public | r_pot_category | 969 | 3 | 0.00 | 0.00 | | 2024-04-12 23:40:10.167142+00 | | 2024-03-21 05:48:39.460847+00 |
| public | r_pot_group | 11352 | 842 | 0.00 | 6.00 | | 2024-04-24 23:12:57.247166+00 | | 2024-04-24 23:33:15.66804+00 |
| public | r_pot_tx | 8160 | 689 | 0.00 | 7.00 | | 2024-04-12 12:37:13.433468+00 | | 2024-04-15 05:28:22.935499+00 |
| public | r_pot_user | 695 | 11 | 0.00 | 1.00 | | 2024-04-15 05:46:23.417366+00 | | 2024-04-15 05:46:23.425715+00 |
| public | r_provider_tenant | 189 | 0 | 0.00 | 0.00 | | 2024-04-24 11:01:24.59261+00 | | 2024-04-09 04:52:52.521831+00 |
| public | r_role_feature | 692 | 29 | 0.00 | 4.00 | | 2024-04-13 01:21:01.102175+00 | | |
| public | r_tenant_feature | 537 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:09.422594+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:13.452129+00 | | |
| public | r_user_region | 843 | 11 | 0.00 | 1.00 | | 2024-04-15 05:46:23.460029+00 | | 2024-04-15 05:46:23.462043+00 |
| public | r_user_site | 736 | 11 | 0.00 | 1.00 | | 2024-04-15 05:46:23.440557+00 | | 2024-04-15 05:46:23.444819+00 |
| public | r_zone_category | 665 | 47 | 0.00 | 6.00 | | 2024-04-12 12:37:09.474506+00 | | 2024-04-15 06:12:23.803248+00 |
| public | t_ai_history | 0 | 0 | 0 | 0 | | 2024-04-15 04:05:05.941793+00 | | |
| public | t_attendance | 295581 | 18156 | 0.00 | 5.00 | | 2024-04-13 01:21:01.085619+00 | | 2024-04-22 02:34:38.225151+00 |
| public | t_general | 29 | 0 | 0.00 | 0.00 | | 2024-04-13 01:21:01.14175+00 | | |
| public | t_mobile_device_history | 74180 | 0 | 0.00 | 0.00 | | 2024-04-12 13:38:20.967099+00 | | 2024-03-27 13:27:04.092288+00 |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-04-12 12:37:13.331809+00 | | |
| public | t_notify_history | 391470 | 12553 | 0.00 | 3.00 | | 2024-04-13 01:21:04.93242+00 | | 2024-04-23 05:25:18.650635+00 |
| public | t_operation_log | 1607634 | 42442 | 0.00 | 2.00 | | 2024-04-12 13:21:12.291889+00 | | 2024-04-16 08:57:35.718262+00 |
| public | t_plan | 3051614 | 388403 | 0.00 | 11.00 | | 2024-04-12 23:38:09.112117+00 | | 2024-04-24 23:33:18.008292+00 |
| public | t_plan_detail | 3592963 | 391918 | 0.00 | 9.00 | | 2024-04-13 01:21:50.380062+00 | | 2024-04-24 01:45:20.509864+00 |
| public | t_plan_sync | 16410 | 2198 | 0.00 | 11.00 | | 2024-04-24 23:32:12.654577+00 | | 2024-04-25 00:49:35.910629+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-04-12 12:37:09.386802+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-04-12 23:30:00.762495+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-04-12 23:40:10.120962+00 | | |
| public | t_recv_position_history | 6887 | 3101 | 0.00 | 31.00 | | 2024-04-25 01:51:22.173861+00 | 2024-04-24 12:42:00.87979+00 | 2024-04-25 01:51:22.205432+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-04-12 23:31:00.824479+00 | | |
| public | t_terminal | 13652 | 1414 | 0.00 | 9.00 | | 2024-04-23 22:46:26.194962+00 | | 2024-04-24 22:12:31.371254+00 |
| public | t_terminal_log | 3633421 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:21.969117+00 | | 2024-03-27 07:38:48.597545+00 |
| public | w_arrival_notify | 2 | 9 | 4.00 | 81.00 | | 2024-04-12 12:43:27.015418+00 | | 2024-03-18 00:19:34.961652+00 |
| public | w_latest_position | 10757 | 2563 | 0.00 | 19.00 | | 2024-04-25 01:51:21.9181+00 | | 2024-04-25 01:51:21.949727+00 |
| public | w_latest_presence | 17125 | 24981 | 1.00 | 59.00 | 2024-01-18 12:42:01.037741+00 | 2024-04-25 01:51:22.386728+00 | 2024-01-18 12:42:01.07062+00 | 2024-04-25 01:51:22.633823+00 |
| public | w_latest_sensor | 160 | 59 | 0.00 | 26.00 | | 2024-04-25 01:50:21.028093+00 | | 2024-04-25 01:49:21.150085+00 |
| public | w_lock | 987 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:08.821855+00 | | |
| public | w_master_update | 15 | 34 | 2.00 | 69.00 | | 2024-04-24 06:11:06.934078+00 | | 2024-04-23 22:32:16.653504+00 |
| public | w_plan_with_detail | 3077642 | 401409 | 0.00 | 11.00 | | 2024-04-12 13:23:33.49257+00 | | 2024-04-24 23:58:29.592806+00 |