| 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 |
|---|
| e202405 | a_proximity_sum | 37034643 | 315831 | 0.00 | 0.00 | | 2024-07-11 08:20:24.611175+00 | | 2024-05-31 16:20:09.382218+00 |
| e202405 | a_stay_time | 19320558 | 0 | 0.00 | 0.00 | | 2024-07-13 01:43:25.232795+00 | | 2024-07-12 05:50:10.90622+00 |
| e202405 | l_position_history | 0 | 0 | 0 | 0 | | 2024-07-13 08:50:41.359738+00 | | |
| e202405 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-07-13 08:50:41.3708+00 | | |
| e202405 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-07-13 08:50:41.34861+00 | | |
| e202405 | t_position_history | 370176930 | 0 | 0.00 | 0.00 | | 2024-07-12 02:21:21.196639+00 | | 2024-07-03 05:25:08.986314+00 |
| e202405 | t_presence_history | 40364790 | 0 | 0.00 | 0.00 | | 2024-07-17 03:09:45.930626+00 | | 2024-05-31 15:00:00.098672+00 |
| e202405 | t_sensor_history | 9066957 | 0 | 0.00 | 0.00 | | 2024-07-21 10:21:44.44214+00 | | 2024-05-31 03:04:14.324231+00 |
| e202406 | a_proximity_sum | 41143300 | 0 | 0.00 | 0.00 | | 2024-07-15 09:04:30.419787+00 | | 2024-06-27 16:22:48.543823+00 |
| e202406 | a_stay_time | 19467361 | 0 | 0.00 | 0.00 | | 2024-07-15 08:50:58.939423+00 | | 2024-07-03 08:36:45.069485+00 |
| e202406 | l_position_history | 0 | 0 | 0 | 0 | | 2024-07-19 22:30:42.965382+00 | | |
| e202406 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-07-19 22:30:42.987651+00 | | |
| e202406 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-07-19 22:30:42.976316+00 | | |
| e202406 | t_position_history | 395762239 | 0 | 0.00 | 0.00 | | 2024-07-16 01:38:24.057326+00 | | 2024-07-03 01:38:50.026966+00 |
| e202406 | t_presence_history | 37228569 | 0 | 0.00 | 0.00 | | 2024-07-19 02:30:23.445953+00 | | 2024-06-30 14:30:32.622624+00 |
| e202406 | t_sensor_history | 9119677 | 0 | 0.00 | 0.00 | | 2024-07-20 10:25:26.976127+00 | | 2024-06-28 09:34:35.396683+00 |
| e202407 | a_proximity_sum | 33100227 | 0 | 0.00 | 0.00 | | 2024-07-21 17:32:27.516222+00 | | 2024-07-21 17:32:28.034718+00 |
| e202407 | a_stay_time | 14092102 | 0 | 0.00 | 0.00 | | 2024-07-21 05:01:05.999236+00 | | 2024-07-19 16:15:24.530532+00 |
| e202407 | l_position_history | 0 | 0 | 0 | 0 | | 2024-07-19 03:10:47.849347+00 | | |
| e202407 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-07-19 03:35:59.087469+00 | | |
| e202407 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-07-19 03:35:59.076418+00 | | |
| e202407 | t_position_history | 324828710 | 0 | 0.00 | 0.00 | | 2024-07-19 07:30:42.306571+00 | | 2024-07-19 11:21:31.183985+00 |
| e202407 | t_presence_history | 31419723 | 3914136 | 0.00 | 11.00 | | 2024-07-22 00:17:01.275367+00 | | 2024-07-22 00:33:19.093382+00 |
| e202407 | t_sensor_history | 6552613 | 0 | 0.00 | 0.00 | | 2024-07-18 22:12:38.701054+00 | | 2024-07-21 05:52:14.071528+00 |
| public | __digdag_status | 31 | 40 | 1.00 | 56.00 | | 2024-07-18 12:30:57.354361+00 | | 2024-07-19 12:30:41.042856+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-07-11 22:46:12.857676+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-07-11 22:46:12.720416+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-07-15 02:53:46.214538+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-07-15 02:53:47.170358+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-07-15 02:52:46.128609+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-07-15 02:53:47.192232+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-07-15 02:53:47.211884+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-07-15 02:52:46.148819+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-07-15 02:52:46.106851+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-07-15 02:53:46.235838+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-07-15 02:52:46.169698+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-07-15 02:52:46.189707+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-07-11 23:00:30.481666+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-07-11 23:00:30.470724+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-07-11 23:00:30.459765+00 | | |
| public | m_area | 625 | 10 | 0.00 | 1.00 | | 2024-07-14 13:02:35.657173+00 | | 2024-06-28 07:24:18.756496+00 |
| public | m_auth | 109 | 1 | 0.00 | 0.00 | | 2024-07-11 22:46:12.87253+00 | | |
| public | m_category | 1707 | 0 | 0.00 | 0.00 | | 2024-07-14 13:02:35.756078+00 | | 2024-06-25 09:59:15.889653+00 |
| public | m_exb | 20064 | 2658 | 0.00 | 11.00 | | 2024-07-14 10:02:02.339284+00 | | 2024-07-17 05:53:33.048095+00 |
| public | m_favorite | 161315 | 844 | 0.00 | 0.00 | | 2024-07-12 07:37:00.57346+00 | | 2024-06-27 06:46:30.093849+00 |
| public | m_feature | 160 | 0 | 0.00 | 0.00 | | 2024-07-12 06:03:09.781252+00 | | |
| public | m_group | 16745 | 63 | 0.00 | 0.00 | | 2024-07-17 09:22:11.873717+00 | | 2024-07-10 09:58:42.085372+00 |
| public | m_holiday | 25296 | 0 | 0.00 | 0.00 | | 2024-07-19 13:16:49.928062+00 | | 2024-07-08 03:20:43.009936+00 |
| public | m_lob | 20711 | 13 | 0.00 | 0.00 | | 2024-07-20 05:31:38.167434+00 | | 2024-06-21 09:19:55.785923+00 |
| public | m_location | 36261 | 1398 | 0.00 | 3.00 | | 2024-07-18 04:18:44.095301+00 | | 2024-07-18 08:50:21.560138+00 |
| public | m_notify_template | 715 | 0 | 0.00 | 0.00 | | 2024-07-11 22:46:13.038617+00 | | 2024-06-17 00:59:30.67119+00 |
| public | m_outside | 286 | 0 | 0.00 | 0.00 | | 2024-07-18 11:02:07.440633+00 | | 2024-07-03 01:58:21.092861+00 |
| public | m_pot | 170746 | 6248 | 0.00 | 3.00 | | 2024-07-22 00:02:48.530372+00 | | 2024-07-21 23:34:42.259894+00 |
| public | m_pot_profile | 39725 | 0 | 0.00 | 0.00 | | 2024-07-21 05:21:55.602713+00 | | 2024-07-04 07:47:22.166289+00 |
| public | m_provider_user | 70 | 1 | 0.00 | 1.00 | | 2024-07-12 06:33:05.191581+00 | | 2024-05-15 01:36:37.001504+00 |
| public | m_region | 94 | 0 | 0.00 | 0.00 | | 2024-07-11 22:46:13.113341+00 | | |
| public | m_role | 536 | 1 | 0.00 | 0.00 | | 2024-07-11 22:46:13.097672+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-07-11 22:46:12.989365+00 | | |
| public | m_setting | 11166 | 1748 | 0.00 | 13.00 | | 2024-07-20 12:30:28.053982+00 | | 2024-07-21 07:53:38.542453+00 |
| public | m_setting_log | 26566 | 1168 | 0.00 | 4.00 | | 2024-07-19 17:30:41.009936+00 | | 2024-07-21 01:07:17.049091+00 |
| public | m_site | 168 | 0 | 0.00 | 0.00 | | 2024-07-11 22:46:13.010947+00 | | |
| public | m_tenant | 93 | 0 | 0.00 | 0.00 | | 2024-07-11 22:46:13.253087+00 | | |
| public | m_tx | 92827 | 3406 | 0.00 | 3.00 | | 2024-07-21 13:40:41.230108+00 | | 2024-07-22 00:23:12.138335+00 |
| public | m_user | 29410 | 110 | 0.00 | 0.00 | | 2024-07-14 13:02:34.373327+00 | | 2024-06-03 00:18:59.127095+00 |
| public | m_zone | 5538 | 75 | 0.00 | 1.00 | | 2024-07-12 18:01:06.905201+00 | | 2024-07-09 13:10:57.585276+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-07-11 22:46:05.630658+00 | | |
| public | r_auth_zone | 210 | 1 | 0.00 | 0.00 | | 2024-07-13 15:44:52.832953+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-07-11 22:46:13.062416+00 | | |
| public | r_group_auth | 457 | 0 | 0.00 | 0.00 | | 2024-07-16 03:51:53.501207+00 | | 2024-07-04 08:10:27.0311+00 |
| public | r_location_zone | 38256 | 2843 | 0.00 | 6.00 | | 2024-07-20 03:14:59.514+00 | | 2024-07-21 07:44:37.666167+00 |
| public | r_pot_auth | 766 | 21 | 0.00 | 2.00 | | 2024-07-18 04:18:37.632622+00 | | 2024-07-16 09:52:45.336191+00 |
| public | r_pot_category | 6745 | 0 | 0.00 | 0.00 | | 2024-07-21 20:32:15.987441+00 | | 2024-07-21 20:01:11.759319+00 |
| public | r_pot_group | 93084 | 15053 | 0.00 | 13.00 | | 2024-07-21 23:01:28.829576+00 | | 2024-07-22 00:35:18.668596+00 |
| public | r_pot_tx | 52714 | 365 | 0.00 | 0.00 | | 2024-07-21 01:43:07.273268+00 | | 2024-07-18 07:06:58.101079+00 |
| public | r_pot_user | 18346 | 32 | 0.00 | 0.00 | | 2024-07-17 09:22:11.638446+00 | | 2024-05-23 08:08:14.876959+00 |
| public | r_provider_tenant | 2662 | 0 | 0.00 | 0.00 | | 2024-07-21 02:20:36.487344+00 | | 2024-06-28 05:12:42.819951+00 |
| public | r_role_feature | 5042 | 13 | 0.00 | 0.00 | | 2024-07-17 09:22:11.67533+00 | | 2024-07-17 09:12:16.595823+00 |
| public | r_tenant_feature | 3402 | 0 | 0.00 | 0.00 | | 2024-07-15 02:52:39.40628+00 | | 2024-07-03 07:47:27.286426+00 |
| public | r_tx_sensor | 327 | 0 | 0.00 | 0.00 | | 2024-07-17 04:09:33.02673+00 | | 2024-05-08 03:36:41.526083+00 |
| public | r_user_region | 18851 | 26 | 0.00 | 0.00 | | 2024-07-17 09:22:05.548703+00 | | 2024-05-23 09:03:11.7525+00 |
| public | r_user_site | 5104 | 21 | 0.00 | 0.00 | | 2024-07-11 22:46:12.962574+00 | | 2024-06-28 09:33:34.486007+00 |
| public | r_zone_category | 3246 | 5 | 0.00 | 0.00 | | 2024-07-19 02:03:34.222135+00 | | 2024-07-09 00:28:44.475424+00 |
| public | t_ai_history | 7 | 0 | 0.00 | 0.00 | | 2024-07-16 11:22:17.462857+00 | | |
| public | t_attendance | 1140759 | 37987 | 0.00 | 3.00 | | 2024-07-15 02:53:08.070775+00 | | 2024-07-17 18:39:01.138318+00 |
| public | t_general | 2148 | 0 | 0.00 | 0.00 | | 2024-07-11 22:46:13.236955+00 | | 2024-06-09 01:00:58.565026+00 |
| public | t_mobile_device_history | 544101 | 0 | 0.00 | 0.00 | | 2024-07-13 23:02:57.181393+00 | | 2024-07-10 00:23:27.222842+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-07-11 22:46:13.082805+00 | | |
| public | t_notify_history | 2637458 | 79080 | 0.00 | 2.00 | | 2024-07-12 10:03:20.097237+00 | | 2024-07-16 04:58:36.301234+00 |
| public | t_operation_log | 10177800 | 55275 | 0.00 | 0.00 | | 2024-07-19 03:02:40.238329+00 | | 2024-07-07 23:47:37.746087+00 |
| public | t_plan | 11279548 | 830735 | 0.00 | 6.00 | | 2024-07-17 01:13:11.136487+00 | | 2024-07-20 12:11:30.517114+00 |
| public | t_plan_detail | 19339467 | 307206 | 0.00 | 1.00 | | 2024-07-19 22:30:36.581135+00 | | 2024-07-21 05:30:56.185765+00 |
| public | t_plan_sync | 38968 | 5191 | 0.00 | 11.00 | | 2024-07-22 00:19:14.030328+00 | | 2024-07-22 00:35:18.947538+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-07-11 22:46:13.279263+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-07-11 22:46:05.642199+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-07-11 22:46:13.13223+00 | | |
| public | t_recv_position_history | 119816 | 50143 | 0.00 | 29.00 | | 2024-07-22 00:50:59.868507+00 | 2024-07-21 13:30:07.604675+00 | 2024-07-22 00:51:00.357262+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-07-11 22:46:05.671819+00 | | |
| public | t_terminal | 68212 | 1348 | 0.00 | 1.00 | | 2024-07-21 01:43:08.422683+00 | | 2024-07-21 21:51:43.939187+00 |
| public | t_terminal_log | 8644769 | 0 | 0.00 | 0.00 | | 2024-07-18 22:21:34.455678+00 | | 2024-07-21 21:40:48.353849+00 |
| public | w_arrival_notify | 73 | 42 | 0.00 | 36.00 | | 2024-07-16 15:00:31.364137+00 | | 2024-07-22 00:24:19.36544+00 |
| public | w_latest_position | 55691 | 10099 | 0.00 | 15.00 | | 2024-07-22 00:51:00.684326+00 | | 2024-07-22 00:51:00.823743+00 |
| public | w_latest_presence | 198726 | 50969 | 0.00 | 20.00 | | 2024-07-22 00:51:01.914207+00 | | 2024-07-22 00:51:02.295169+00 |
| public | w_latest_sensor | 344 | 173 | 0.00 | 33.00 | | 2024-07-22 00:51:00.838636+00 | | 2024-07-22 00:51:00.948446+00 |
| public | w_lock | 12977 | 0 | 0.00 | 0.00 | | 2024-07-17 06:25:51.062913+00 | | |
| public | w_master_update | 162 | 10 | 0.00 | 5.00 | | 2024-07-22 00:35:18.686289+00 | | 2024-07-22 00:34:18.459555+00 |
| public | w_migration | 824 | 0 | 0.00 | 0.00 | | 2024-07-11 23:00:30.50239+00 | | |
| public | w_plan_with_detail | 11298382 | 1486372 | 0.00 | 11.00 | | 2024-07-12 07:05:47.22345+00 | | 2024-07-20 08:31:30.393168+00 |