| 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 | 513156 | 0 | 0.00 | 0.00 | | 2023-12-28 09:00:23.718382+00 | | |
| e202311 | a_stay_time | 2007402 | 0 | 0.00 | 0.00 | | 2023-12-29 04:45:14.895174+00 | | |
| e202311 | l_position_history | 0 | 0 | 0 | 0 | | 2023-12-28 03:05:36.594024+00 | | |
| e202311 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-12-28 09:00:18.454263+00 | | |
| e202311 | l_stay_time | 0 | 0 | 0 | 0 | | 2023-12-28 22:00:21.536523+00 | | |
| e202311 | t_position_history | 34857866 | 0 | 0.00 | 0.00 | | 2023-12-28 03:04:42.732733+00 | | |
| e202311 | t_presence_history | 6297160 | 0 | 0.00 | 0.00 | | 2023-12-28 08:59:53.051454+00 | | |
| e202311 | t_sensor_history | 1717517 | 0 | 0.00 | 0.00 | | 2023-12-28 09:00:18.430336+00 | | |
| e202312 | a_proximity_sum | 599451 | 0 | 0.00 | 0.00 | | 2023-12-29 04:44:47.972782+00 | | 2023-12-29 04:44:49.034219+00 |
| e202312 | a_stay_time | 2081349 | 0 | 0.00 | 0.00 | | 2023-12-29 04:29:46.503391+00 | | 2023-12-29 04:29:50.031049+00 |
| e202312 | l_position_history | 0 | 0 | 0 | 0 | | 2023-12-29 04:29:50.05231+00 | | |
| e202312 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-12-29 04:44:49.066508+00 | | |
| e202312 | l_stay_time | 0 | 0 | 0 | 0 | | 2023-12-29 04:34:27.080166+00 | | |
| e202312 | t_position_history | 30703665 | 0 | 0.00 | 0.00 | | 2023-12-29 04:34:23.540073+00 | | 2023-12-29 04:34:27.05313+00 |
| e202312 | t_presence_history | 6027141 | 53691 | 0.00 | 0.00 | | 2023-12-31 14:58:42.893627+00 | | 2023-12-31 14:47:48.987215+00 |
| e202312 | t_sensor_history | 1487287 | 0 | 0.00 | 0.00 | | 2023-12-28 09:00:49.962495+00 | | 2023-12-31 01:31:24.286278+00 |
| e202401 | a_proximity_sum | 150674 | 0 | 0.00 | 0.00 | | 2024-01-12 15:32:15.783327+00 | | 2024-01-12 17:15:32.976727+00 |
| e202401 | a_stay_time | 571500 | 0 | 0.00 | 0.00 | | 2024-01-12 15:30:42.052946+00 | | 2024-01-12 15:30:42.280884+00 |
| e202401 | l_position_history | 0 | 0 | 0 | 0 | | 2023-12-29 04:34:27.102824+00 | | |
| e202401 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-12-28 22:00:06.585587+00 | | |
| e202401 | l_stay_time | 0 | 0 | 0 | 0 | | 2023-12-28 22:00:06.60973+00 | | |
| e202401 | t_position_history | 9514738 | 0 | 0.00 | 0.00 | | 2024-01-12 04:00:54.931444+00 | | 2024-01-14 04:04:21.834582+00 |
| e202401 | t_presence_history | 2659491 | 93568 | 0.00 | 3.00 | | 2024-01-15 01:43:33.801649+00 | | 2024-01-15 01:39:22.831308+00 |
| e202401 | t_sensor_history | 698429 | 0 | 0.00 | 0.00 | | 2024-01-13 23:45:48.719518+00 | | 2024-01-15 01:15:10.694809+00 |
| public | __digdag_status | 5 | 20 | 4.00 | 80.00 | | 2024-01-13 00:10:40.91514+00 | | 2024-01-14 12:31:30.747304+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2023-12-27 07:59:37.72637+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2023-12-27 07:59:37.529709+00 | | |
| public | b_attendance_group | 353107 | 12371 | 0.00 | 3.00 | | 2023-12-27 07:46:01.382947+00 | | 2024-01-14 18:36:02.493917+00 |
| public | b_attendance_hour | 5497879 | 192228 | 0.00 | 3.00 | | 2023-12-27 08:20:54.837034+00 | | 2024-01-14 18:32:44.351252+00 |
| public | b_attendance_pot | 0 | 0 | 0 | 0 | | 2023-12-27 08:19:38.662951+00 | | |
| public | b_attendance_pot_hour | 0 | 0 | 0 | 0 | | 2023-12-27 08:19:39.130906+00 | | |
| public | b_check_in | 3042061 | 120741 | 0.00 | 3.00 | | 2023-12-27 08:21:38.989671+00 | | 2024-01-14 18:36:06.276823+00 |
| public | b_check_in_hour | 45049328 | 1755915 | 0.00 | 3.00 | | 2023-12-27 08:28:00.372718+00 | | 2024-01-14 18:36:10.142607+00 |
| public | b_proximity_group | 42312276 | 1500989 | 0.00 | 3.00 | | 2023-12-27 07:59:16.560393+00 | | 2023-12-27 07:59:20.50446+00 |
| public | b_proximity_info | 23564382 | 103878 | 0.00 | 0.00 | | 2023-12-27 07:52:12.370708+00 | | 2023-12-27 07:52:16.165265+00 |
| public | b_seat_reserve | 633573 | 20850 | 0.00 | 3.00 | | 2023-12-27 07:41:45.406293+00 | | 2023-12-27 07:41:47.317287+00 |
| public | b_seat_reserve_hour | 11655164 | 444088 | 0.00 | 3.00 | | 2023-12-27 07:43:34.894664+00 | | 2024-01-14 18:32:40.519099+00 |
| public | b_usage | 672766 | 27001 | 0.00 | 3.00 | | 2023-12-27 08:37:14.591015+00 | | 2024-01-13 18:32:32.253551+00 |
| public | b_usage_hour | 12195655 | 525559 | 0.00 | 4.00 | | 2023-12-27 07:45:51.566389+00 | | 2024-01-13 18:28:21.332237+00 |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2023-12-27 08:44:56.93965+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-12-27 08:44:56.919393+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2023-12-27 08:44:56.902131+00 | | |
| public | m_area | 98 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:17.129846+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2023-12-27 08:20:58.62552+00 | | |
| public | m_category | 344 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:17.615687+00 | | |
| public | m_exb | 3730 | 118 | 0.00 | 3.00 | | 2023-12-27 08:37:17.301361+00 | | 2023-12-27 08:37:17.315449+00 |
| public | m_favorite | 33206 | 275 | 0.00 | 0.00 | | 2023-12-27 08:28:21.976206+00 | | 2024-01-15 00:47:39.708196+00 |
| public | m_feature | 149 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:57.601239+00 | | |
| public | m_group | 2039 | 169 | 0.00 | 7.00 | | 2023-12-27 08:19:32.885726+00 | | 2024-01-10 00:53:27.246761+00 |
| public | m_holiday | 3990 | 0 | 0.00 | 0.00 | | 2023-12-27 08:45:30.27035+00 | | |
| public | m_lob | 2364 | 15 | 0.00 | 0.00 | | 2023-12-27 08:37:17.690153+00 | | |
| public | m_location | 5505 | 54 | 0.00 | 0.00 | | 2023-12-27 08:19:35.475868+00 | | 2023-12-27 08:19:35.566764+00 |
| public | m_notify_template | 104 | 2 | 0.00 | 1.00 | | 2023-12-27 08:37:16.705302+00 | | |
| public | m_outside | 62 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:06.408+00 | | |
| public | m_pot | 22445 | 1168 | 0.00 | 4.00 | | 2024-01-15 00:10:22.467257+00 | | 2024-01-15 00:10:23.293173+00 |
| public | m_pot_profile | 627 | 10 | 0.00 | 1.00 | | 2023-12-27 08:19:39.096971+00 | | 2023-12-27 08:19:39.104822+00 |
| public | m_provider_user | 15 | 1 | 0.00 | 6.00 | | 2023-12-27 07:59:37.679338+00 | | |
| public | m_region | 15 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:45.795988+00 | | |
| public | m_role | 76 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:45.73667+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2023-12-27 08:21:12.42995+00 | | |
| public | m_setting | 2092 | 405 | 0.00 | 16.00 | | 2024-01-13 11:30:05.729794+00 | | 2024-01-14 10:26:01.425163+00 |
| public | m_setting_log | 4174 | 750 | 0.00 | 15.00 | | 2024-01-11 12:31:16.760215+00 | | 2024-01-14 12:31:27.147973+00 |
| public | m_site | 21 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:16.682461+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2023-12-27 07:59:25.756216+00 | | |
| public | m_tx | 13991 | 1236 | 0.00 | 8.00 | | 2024-01-11 23:47:11.143816+00 | | 2024-01-11 23:47:11.741038+00 |
| public | m_user | 744 | 82 | 0.00 | 9.00 | | 2023-12-27 08:44:56.990449+00 | | 2024-01-12 09:20:54.006822+00 |
| public | m_zone | 596 | 2 | 0.00 | 0.00 | | 2023-12-27 08:38:01.498412+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2023-12-27 07:43:38.749284+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2023-12-27 08:20:58.664021+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:16.751678+00 | | |
| public | r_group_auth | 288 | 0 | 0.00 | 0.00 | | 2023-12-27 07:41:33.692632+00 | | |
| public | r_location_zone | 3630 | 195 | 0.00 | 5.00 | | 2023-12-27 08:37:17.088275+00 | | 2023-12-27 08:37:17.099129+00 |
| public | r_pot_auth | 21 | 3 | 0.00 | 12.00 | | 2023-12-27 08:20:58.642506+00 | | |
| public | r_pot_category | 405 | 12 | 0.00 | 2.00 | | 2023-12-27 08:37:45.876577+00 | | |
| public | r_pot_group | 9076 | 836 | 0.00 | 8.00 | | 2024-01-14 23:12:43.883787+00 | | 2024-01-14 23:33:08.238007+00 |
| public | r_pot_tx | 7383 | 64 | 0.00 | 0.00 | | 2023-12-27 08:37:17.537417+00 | | |
| public | r_pot_user | 453 | 97 | 0.00 | 17.00 | | 2023-12-27 07:45:55.64578+00 | | 2024-01-12 09:20:48.366499+00 |
| public | r_role_feature | 734 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:45.708391+00 | | |
| public | r_tenant_feature | 550 | 0 | 0.00 | 0.00 | | 2023-12-27 07:59:25.949143+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:17.569578+00 | | |
| public | r_user_region | 521 | 97 | 0.00 | 15.00 | | 2023-12-27 08:37:16.730946+00 | | 2024-01-12 09:20:48.39476+00 |
| public | r_user_site | 302 | 97 | 0.00 | 24.00 | | 2023-12-27 08:20:58.687033+00 | | 2024-01-12 09:20:48.380356+00 |
| public | r_zone_category | 564 | 5 | 0.00 | 0.00 | | 2023-12-27 07:59:37.645018+00 | | |
| public | t_attendance | 242954 | 15032 | 0.00 | 5.00 | | 2023-12-27 08:37:45.372854+00 | | 2024-01-15 01:05:57.460736+00 |
| public | t_general | 20 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:45.757591+00 | | |
| public | t_mobile_device_history | 56578 | 0 | 0.00 | 0.00 | | 2023-12-28 22:00:20.174075+00 | | 2023-12-28 22:00:20.613569+00 |
| public | t_news | 0 | 0 | 0 | 0 | | 2023-12-27 08:37:16.762329+00 | | |
| public | t_notify_history | 303106 | 8725 | 0.00 | 2.00 | | 2023-12-27 08:37:56.933396+00 | | 2024-01-12 09:03:38.953396+00 |
| public | t_operation_log | 1394467 | 34029 | 0.00 | 2.00 | | 2023-12-28 03:05:32.995978+00 | | 2023-12-28 03:05:36.555324+00 |
| public | t_plan | 2549241 | 314294 | 0.00 | 10.00 | | 2023-12-27 08:37:04.630568+00 | | 2024-01-10 18:33:25.332879+00 |
| public | t_plan_detail | 3294560 | 446650 | 0.00 | 11.00 | | 2023-12-27 08:40:11.640308+00 | | 2024-01-12 00:39:24.911956+00 |
| public | t_plan_sync | 15720 | 2159 | 0.00 | 12.00 | | 2024-01-14 23:11:43.40998+00 | | 2024-01-15 00:47:39.573459+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2023-12-27 07:59:25.713596+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2023-12-27 07:43:38.797221+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2023-12-27 08:37:45.817378+00 | | |
| public | t_recv_position_history | 6114 | 1258 | 0.00 | 17.00 | | 2024-01-15 01:45:20.120981+00 | 2024-01-14 12:42:00.782116+00 | 2024-01-15 01:45:20.143654+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2023-12-27 07:46:02.51502+00 | | |
| public | t_terminal | 8849 | 627 | 0.00 | 6.00 | | 2024-01-13 02:40:16.399696+00 | | 2024-01-14 23:44:42.687055+00 |
| public | t_terminal_log | 2689658 | 0 | 0.00 | 0.00 | | 2023-12-27 08:44:52.679747+00 | | 2023-12-27 08:44:56.880863+00 |
| public | w_arrival_notify | 1 | 2 | 2.00 | 66.00 | | 2023-12-27 08:45:57.861888+00 | | |
| public | w_latest_position | 11376 | 2887 | 0.00 | 20.00 | | 2024-01-15 01:45:16.818321+00 | | 2024-01-15 01:45:20.081461+00 |
| public | w_latest_presence | 16159 | 31330 | 1.00 | 65.00 | 2024-01-14 12:42:00.865066+00 | 2024-01-15 01:45:20.236945+00 | 2024-01-14 12:42:00.894637+00 | 2024-01-15 01:45:20.31418+00 |
| public | w_latest_sensor | 113 | 60 | 0.00 | 34.00 | | 2024-01-15 01:44:14.933685+00 | | 2024-01-15 01:45:15.405437+00 |
| public | w_lock | 951 | 1 | 0.00 | 0.00 | | 2023-12-27 07:59:24.275038+00 | | |
| public | w_master_update | 15 | 51 | 3.00 | 77.00 | | 2024-01-13 06:11:47.641421+00 | | 2024-01-14 12:31:27.024809+00 |
| public | w_plan_with_detail | 2548167 | 280457 | 0.00 | 9.00 | | 2023-12-28 09:06:07.439695+00 | | 2024-01-12 00:27:53.37974+00 |