| 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 | 370176926 | 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 | 40364838 | 0 | 0.00 | 0.00 | | 2024-07-05 18:53:19.206745+00 | | 2024-05-31 15:00:00.098672+00 |
| e202405 | t_sensor_history | 9066999 | 0 | 0.00 | 0.00 | | 2024-07-10 23:30:47.239723+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-10 01:31:13.353052+00 | | |
| e202406 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-07-10 01:31:13.374966+00 | | |
| e202406 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-07-10 01:31:13.364043+00 | | |
| e202406 | t_position_history | 395761374 | 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 | 37228614 | 0 | 0.00 | 0.00 | | 2024-07-09 02:58:28.048812+00 | | 2024-06-30 14:30:32.622624+00 |
| e202406 | t_sensor_history | 9119711 | 0 | 0.00 | 0.00 | | 2024-07-10 06:43:35.785024+00 | | 2024-06-28 09:34:35.396683+00 |
| e202407 | a_proximity_sum | 20100253 | 0 | 0.00 | 0.00 | | 2024-07-12 17:31:45.285128+00 | | 2024-07-15 16:09:04.395112+00 |
| e202407 | a_stay_time | 11231616 | 0 | 0.00 | 0.00 | | 2024-07-12 15:31:39.038991+00 | | 2024-07-16 17:35:51.194345+00 |
| e202407 | l_position_history | 0 | 0 | 0 | 0 | | 2024-07-09 03:53:49.901191+00 | | |
| e202407 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-07-09 04:35:30.96265+00 | | |
| e202407 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-07-09 04:35:30.951709+00 | | |
| e202407 | t_position_history | 251555612 | 0 | 0.00 | 0.00 | | 2024-07-16 08:10:32.32214+00 | | 2024-07-16 14:35:21.898586+00 |
| e202407 | t_presence_history | 24230671 | 4679808 | 0.00 | 16.00 | | 2024-07-17 00:04:33.050031+00 | | 2024-07-17 00:33:17.558239+00 |
| e202407 | t_sensor_history | 5032775 | 0 | 0.00 | 0.00 | | 2024-07-15 12:48:27.023324+00 | | 2024-07-16 00:26:10.830761+00 |
| public | __digdag_status | 31 | 36 | 1.00 | 53.00 | | 2024-07-14 03:30:43.497576+00 | | 2024-07-16 12:31:11.338497+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 | 2 | 0.00 | 0.00 | | 2024-07-14 13:02:35.657173+00 | | 2024-06-28 07:24:18.756496+00 |
| public | m_auth | 108 | 0 | 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 | 19967 | 254 | 0.00 | 1.00 | | 2024-07-14 10:02:02.339284+00 | | 2024-07-16 00:08:07.586803+00 |
| public | m_favorite | 160804 | 370 | 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 | 16734 | 654 | 0.00 | 3.00 | | 2024-07-06 14:15:57.262935+00 | | 2024-07-10 09:58:42.085372+00 |
| public | m_holiday | 25421 | 0 | 0.00 | 0.00 | | 2024-07-09 22:43:49.47097+00 | | 2024-07-08 03:20:43.009936+00 |
| public | m_lob | 20517 | 22 | 0.00 | 0.00 | | 2024-07-10 04:46:24.525681+00 | | 2024-06-21 09:19:55.785923+00 |
| public | m_location | 36064 | 3014 | 0.00 | 7.00 | | 2024-07-08 00:00:37.921917+00 | | 2024-07-12 04:29:48.196511+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-08 09:28:12.436897+00 | | 2024-07-03 01:58:21.092861+00 |
| public | m_pot | 153346 | 6843 | 0.00 | 4.00 | | 2024-07-16 23:34:26.692962+00 | | 2024-07-17 00:25:18.500899+00 |
| public | m_pot_profile | 40284 | 71 | 0.00 | 0.00 | | 2024-07-10 16:40:50.938387+00 | | 2024-07-04 07:47:22.166289+00 |
| public | m_provider_user | 70 | 0 | 0.00 | 0.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 | 534 | 0 | 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 | 18815 | 141 | 0.00 | 0.00 | | 2024-07-16 22:36:24.388805+00 | | 2024-07-16 19:40:24.825702+00 |
| public | m_setting_log | 26724 | 0 | 0.00 | 0.00 | | 2024-07-14 21:02:45.346913+00 | | 2024-07-16 15:33:05.016955+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 | 92335 | 8797 | 0.00 | 8.00 | | 2024-07-16 01:07:16.679055+00 | | 2024-07-16 01:07:16.821968+00 |
| public | m_user | 29388 | 30 | 0.00 | 0.00 | | 2024-07-14 13:02:34.373327+00 | | 2024-06-03 00:18:59.127095+00 |
| public | m_zone | 5511 | 30 | 0.00 | 0.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 | 209 | 0 | 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 | 37247 | 3149 | 0.00 | 7.00 | | 2024-07-11 06:21:00.007401+00 | | 2024-07-15 08:16:39.689116+00 |
| public | r_pot_auth | 748 | 70 | 0.00 | 8.00 | | 2024-07-08 00:00:31.29981+00 | | 2024-07-16 09:52:45.336191+00 |
| public | r_pot_category | 6743 | 0 | 0.00 | 0.00 | | 2024-07-16 20:08:26.519839+00 | | 2024-07-16 20:01:25.044722+00 |
| public | r_pot_group | 92918 | 14390 | 0.00 | 13.00 | | 2024-07-16 23:01:45.298638+00 | | 2024-07-17 00:24:16.871465+00 |
| public | r_pot_tx | 52431 | 427 | 0.00 | 0.00 | | 2024-07-10 11:59:04.378538+00 | | 2024-07-09 01:41:17.917619+00 |
| public | r_pot_user | 18208 | 120 | 0.00 | 0.00 | | 2024-07-06 14:15:57.010651+00 | | 2024-05-23 08:08:14.876959+00 |
| public | r_provider_tenant | 2222 | 0 | 0.00 | 0.00 | | 2024-07-10 12:27:04.560614+00 | | 2024-06-28 05:12:42.819951+00 |
| public | r_role_feature | 5030 | 11 | 0.00 | 0.00 | | 2024-07-06 14:15:57.031799+00 | | |
| public | r_tenant_feature | 3400 | 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-05 23:31:08.0313+00 | | 2024-05-08 03:36:41.526083+00 |
| public | r_user_region | 18835 | 114 | 0.00 | 0.00 | | 2024-07-06 14:15:56.147359+00 | | 2024-05-23 09:03:11.7525+00 |
| public | r_user_site | 5099 | 19 | 0.00 | 0.00 | | 2024-07-11 22:46:12.962574+00 | | 2024-06-28 09:33:34.486007+00 |
| public | r_zone_category | 3221 | 113 | 0.00 | 3.00 | | 2024-07-09 02:16:03.526653+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 | 1116903 | 7779 | 0.00 | 0.00 | | 2024-07-15 02:53:08.070775+00 | | 2024-07-06 19:11:30.144729+00 |
| public | t_general | 2123 | 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 | 540907 | 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 | 2628068 | 38182 | 0.00 | 1.00 | | 2024-07-12 10:03:20.097237+00 | | 2024-07-16 04:58:36.301234+00 |
| public | t_operation_log | 10274618 | 144083 | 0.00 | 1.00 | | 2024-07-09 03:43:42.012687+00 | | 2024-07-07 23:47:37.746087+00 |
| public | t_plan | 11288070 | 1933176 | 0.00 | 14.00 | | 2024-07-05 11:16:25.729441+00 | | 2024-07-16 06:22:23.074542+00 |
| public | t_plan_detail | 19275161 | 2103646 | 0.00 | 9.00 | | 2024-07-10 01:37:41.796348+00 | | 2024-07-16 21:33:25.855576+00 |
| public | t_plan_sync | 38761 | 5221 | 0.00 | 11.00 | | 2024-07-17 00:28:17.225806+00 | | 2024-07-17 00:36:18.047498+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 | 117017 | 70948 | 0.00 | 37.00 | | 2024-07-17 00:48:18.158416+00 | 2024-07-16 13:30:07.782885+00 | 2024-07-17 00:48:18.507159+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-07-11 22:46:05.671819+00 | | |
| public | t_terminal | 66968 | 2408 | 0.00 | 3.00 | | 2024-07-10 11:59:05.514296+00 | | 2024-07-17 00:39:21.588677+00 |
| public | t_terminal_log | 8385930 | 0 | 0.00 | 0.00 | | 2024-07-08 18:50:08.258192+00 | | 2024-06-23 12:28:13.988737+00 |
| public | w_arrival_notify | 74 | 4 | 0.00 | 5.00 | | 2024-07-16 15:00:31.364137+00 | | 2024-07-12 15:01:03.864005+00 |
| public | w_latest_position | 55309 | 11453 | 0.00 | 17.00 | | 2024-07-17 00:48:18.605662+00 | | 2024-07-17 00:48:18.70866+00 |
| public | w_latest_presence | 212450 | 57933 | 0.00 | 21.00 | | 2024-07-17 00:48:19.932091+00 | | 2024-07-17 00:48:20.320179+00 |
| public | w_latest_sensor | 344 | 193 | 0.00 | 35.00 | | 2024-07-17 00:48:18.847939+00 | | 2024-07-17 00:48:18.958768+00 |
| public | w_lock | 12913 | 2 | 0.00 | 0.00 | | 2024-07-06 06:03:02.542674+00 | | |
| public | w_master_update | 160 | 45 | 0.00 | 21.00 | | 2024-07-17 00:10:17.077166+00 | | 2024-07-17 00:05:14.976632+00 |
| public | w_migration | 824 | 0 | 0.00 | 0.00 | | 2024-07-11 23:00:30.50239+00 | | |
| public | w_plan_with_detail | 11250476 | 824794 | 0.00 | 6.00 | | 2024-07-12 07:05:47.22345+00 | | 2024-07-16 05:41:12.383716+00 |