| 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 | 37034642 | 0 | 0.00 | 0.00 | | 2024-07-11 08:20:24.611175+00 | | 2024-05-31 16:20:09.382218+00 |
| e202405 | a_stay_time | 21017380 | 2373239 | 0.00 | 10.00 | | 2024-07-02 01:05:58.907908+00 | | 2024-07-03 08:24:46.650063+00 |
| e202405 | l_position_history | 0 | 0 | 0 | 0 | | 2024-07-02 05:01:47.427995+00 | | |
| e202405 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-07-02 05:01:47.439145+00 | | |
| e202405 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-07-02 05:01:38.827167+00 | | |
| e202405 | t_position_history | 398526336 | 54904379 | 0.00 | 12.00 | | 2024-06-30 15:36:22.643899+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 | 41138025 | 0 | 0.00 | 0.00 | | 2024-07-03 12:11:31.999797+00 | | 2024-06-27 16:22:48.543823+00 |
| e202406 | a_stay_time | 19815504 | 0 | 0.00 | 0.00 | | 2024-07-03 11:59:37.07747+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 | 396466563 | 0 | 0.00 | 0.00 | | 2024-07-04 05:39:13.759025+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 | 15312195 | 21853 | 0.00 | 0.00 | | 2024-07-10 16:22:24.56449+00 | | 2024-07-11 19:06:40.51353+00 |
| e202407 | a_stay_time | 9181544 | 44361 | 0.00 | 0.00 | | 2024-07-10 15:46:45.164422+00 | | 2024-07-11 15:11:07.402059+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 | 191624381 | 0 | 0.00 | 0.00 | | 2024-07-10 06:12:37.722411+00 | | 2024-07-11 08:00:15.165463+00 |
| e202407 | t_presence_history | 17569984 | 136280 | 0.00 | 0.00 | | 2024-07-12 00:51:51.237934+00 | | 2024-07-12 00:40:30.288268+00 |
| e202407 | t_sensor_history | 3494702 | 0 | 0.00 | 0.00 | | 2024-07-10 11:16:41.168985+00 | | 2024-07-11 01:02:45.429539+00 |
| public | __digdag_status | 32 | 31 | 0.00 | 49.00 | | 2024-07-09 08:31:01.521104+00 | | 2024-07-10 12:31:05.503123+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-03 07:47:30.094463+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-07-03 07:47:31.047245+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-07-03 07:47:04.535673+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-07-03 07:47:31.0702+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-07-03 07:47:31.092791+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-07-03 07:47:04.557051+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-07-03 07:47:04.514159+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-07-03 07:47:30.116047+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-07-03 07:47:04.578624+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-07-03 07:47:04.60472+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-03 02:06:57.082537+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 | 1706 | 32 | 0.00 | 1.00 | | 2024-07-03 02:06:57.167306+00 | | 2024-06-25 09:59:15.889653+00 |
| public | m_exb | 19953 | 3049 | 0.00 | 13.00 | | 2024-07-03 00:26:16.793031+00 | | 2024-07-10 07:02:31.044912+00 |
| public | m_favorite | 160403 | 1956 | 0.00 | 1.00 | | 2024-07-01 06:31:26.180174+00 | | 2024-06-27 06:46:30.093849+00 |
| public | m_feature | 160 | 1 | 0.00 | 0.00 | | 2024-07-01 03:46:27.672459+00 | | |
| public | m_group | 16726 | 653 | 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 | 20446 | 8 | 0.00 | 0.00 | | 2024-07-10 04:46:24.525681+00 | | 2024-06-21 09:19:55.785923+00 |
| public | m_location | 35931 | 2363 | 0.00 | 6.00 | | 2024-07-08 00:00:37.921917+00 | | 2024-07-10 02:36:13.438623+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 | 153195 | 12323 | 0.00 | 7.00 | | 2024-07-11 07:07:09.413955+00 | | 2024-07-12 00:47:33.671644+00 |
| public | m_pot_profile | 40225 | 14 | 0.00 | 0.00 | | 2024-07-10 16:40:50.938387+00 | | 2024-07-04 07:47:22.166289+00 |
| public | m_provider_user | 69 | 4 | 0.00 | 5.00 | | 2024-07-01 04:46:40.612378+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 | 531 | 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 | 17423 | 886 | 0.00 | 4.00 | | 2024-07-11 07:43:07.901816+00 | | 2024-07-11 07:07:09.584237+00 |
| public | m_setting_log | 26728 | 1336 | 0.00 | 4.00 | | 2024-07-10 00:51:45.075149+00 | | 2024-07-11 05:00:51.76081+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 | 92087 | 13474 | 0.00 | 12.00 | | 2024-07-11 06:55:36.437684+00 | | 2024-07-11 07:52:01.245253+00 |
| public | m_user | 29357 | 216 | 0.00 | 0.00 | | 2024-07-03 02:06:55.206129+00 | | 2024-06-03 00:18:59.127095+00 |
| public | m_zone | 4602 | 253 | 0.00 | 5.00 | | 2024-07-01 19:52:08.076297+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 | 1 | 0.00 | 0.00 | | 2024-07-02 08:12:04.395793+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-07-11 22:46:13.062416+00 | | |
| public | r_group_auth | 457 | 21 | 0.00 | 4.00 | | 2024-07-04 08:10:27.027059+00 | | 2024-07-04 08:10:27.0311+00 |
| public | r_location_zone | 37060 | 233 | 0.00 | 0.00 | | 2024-07-11 06:21:00.007401+00 | | 2024-07-11 06:21:00.082981+00 |
| public | r_pot_auth | 746 | 69 | 0.00 | 8.00 | | 2024-07-08 00:00:31.29981+00 | | 2024-06-28 08:46:48.42878+00 |
| public | r_pot_category | 6721 | 0 | 0.00 | 0.00 | | 2024-07-11 20:18:37.305855+00 | | 2024-07-11 20:01:11.493443+00 |
| public | r_pot_group | 92876 | 14363 | 0.00 | 13.00 | | 2024-07-11 23:01:30.465649+00 | | 2024-07-12 00:05:21.31451+00 |
| public | r_pot_tx | 52260 | 135 | 0.00 | 0.00 | | 2024-07-10 11:59:04.378538+00 | | 2024-07-09 01:41:17.917619+00 |
| public | r_pot_user | 18198 | 96 | 0.00 | 0.00 | | 2024-07-06 14:15:57.010651+00 | | 2024-05-23 08:08:14.876959+00 |
| public | r_provider_tenant | 2221 | 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 | 4967 | 7 | 0.00 | 0.00 | | 2024-07-06 14:15:57.031799+00 | | |
| public | r_tenant_feature | 3400 | 2 | 0.00 | 0.00 | | 2024-07-03 07:46:58.191566+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 | 18826 | 88 | 0.00 | 0.00 | | 2024-07-06 14:15:56.147359+00 | | 2024-05-23 09:03:11.7525+00 |
| public | r_user_site | 5093 | 2 | 0.00 | 0.00 | | 2024-07-11 22:46:12.962574+00 | | 2024-06-28 09:33:34.486007+00 |
| public | r_zone_category | 3214 | 104 | 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-05 03:05:14.317217+00 | | |
| public | t_attendance | 1119187 | 61596 | 0.00 | 5.00 | | 2024-07-03 07:47:25.502999+00 | | 2024-07-06 19:11:30.144729+00 |
| public | t_general | 2098 | 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 | 533518 | 3 | 0.00 | 0.00 | | 2024-07-02 10:56:52.586514+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 | 2626963 | 87684 | 0.00 | 3.00 | | 2024-07-01 10:11:44.241294+00 | | 2024-07-02 23:38:47.339082+00 |
| public | t_operation_log | 10214999 | 85293 | 0.00 | 0.00 | | 2024-07-09 03:43:42.012687+00 | | 2024-07-07 23:47:37.746087+00 |
| public | t_plan | 11214995 | 1245372 | 0.00 | 9.00 | | 2024-07-05 11:16:25.729441+00 | | 2024-07-11 03:50:22.428927+00 |
| public | t_plan_detail | 19164447 | 1066564 | 0.00 | 5.00 | | 2024-07-10 01:37:41.796348+00 | | 2024-07-11 23:23:25.506176+00 |
| public | t_plan_sync | 68228 | 491 | 0.00 | 0.00 | | 2024-07-12 00:35:29.579616+00 | | 2024-07-12 00:34:29.496231+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 | 117713 | 99999 | 0.00 | 45.00 | | 2024-07-12 00:51:59.392019+00 | 2024-07-11 13:30:08.012635+00 | 2024-07-12 00:51:59.731588+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-07-11 22:46:05.671819+00 | | |
| public | t_terminal | 66253 | 1190 | 0.00 | 1.00 | | 2024-07-10 11:59:05.514296+00 | | 2024-07-12 00:04:22.044389+00 |
| public | t_terminal_log | 8239203 | 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 | 38 | 0.00 | 33.00 | | 2024-07-10 03:14:27.417591+00 | | 2024-07-11 02:46:58.9223+00 |
| public | w_latest_position | 54982 | 25039 | 0.00 | 31.00 | | 2024-07-12 00:51:59.844519+00 | | 2024-07-12 00:51:59.944157+00 |
| public | w_latest_presence | 271746 | 179985 | 0.00 | 39.00 | | 2024-07-12 00:52:00.419435+00 | | 2024-07-12 00:51:53.541996+00 |
| public | w_latest_sensor | 344 | 186 | 0.00 | 35.00 | | 2024-07-12 00:52:00.049807+00 | | 2024-07-12 00:52:00.160487+00 |
| public | w_lock | 12884 | 0 | 0.00 | 0.00 | | 2024-07-06 06:03:02.542674+00 | | |
| public | w_master_update | 163 | 39 | 0.00 | 19.00 | | 2024-07-11 23:20:30.85239+00 | | 2024-07-11 23:17:31.468261+00 |
| public | w_migration | 824 | 0 | 0.00 | 0.00 | | 2024-07-11 23:00:30.50239+00 | | |
| public | w_plan_with_detail | 11255414 | 2141313 | 0.00 | 15.00 | | 2024-07-01 05:28:19.990758+00 | | 2024-07-11 03:09:35.98697+00 |