| 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 | 37034666 | 0 | 0.00 | 0.00 | | 2024-06-29 15:26:30.68004+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 | 398526331 | 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 | 40364887 | 0 | 0.00 | 0.00 | | 2024-06-23 09:30:50.933557+00 | | 2024-05-31 15:00:00.098672+00 |
| e202405 | t_sensor_history | 9067041 | 0 | 0.00 | 0.00 | | 2024-06-28 10:04:31.539319+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-06-27 07:25:08.779314+00 | | |
| e202406 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-27 07:25:08.801527+00 | | |
| e202406 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-06-27 07:25:08.79059+00 | | |
| e202406 | t_position_history | 410383380 | 54845987 | 0.00 | 11.00 | | 2024-06-26 09:47:31.735645+00 | | 2024-07-03 01:38:50.026966+00 |
| e202406 | t_presence_history | 37865919 | 172116 | 0.00 | 0.00 | | 2024-06-30 14:51:12.807685+00 | | 2024-06-30 14:30:32.622624+00 |
| e202406 | t_sensor_history | 9190953 | 0 | 0.00 | 0.00 | | 2024-06-27 20:50:33.190987+00 | | 2024-06-28 09:34:35.396683+00 |
| e202407 | a_proximity_sum | 4867167 | 0 | 0.00 | 0.00 | | 2024-07-03 16:09:37.102798+00 | | 2024-07-03 18:36:02.045113+00 |
| e202407 | a_stay_time | 3486569 | 0 | 0.00 | 0.00 | | 2024-07-03 17:56:05.375527+00 | | 2024-07-03 18:31:00.437877+00 |
| e202407 | l_position_history | 0 | 0 | 0 | 0 | | 2024-06-26 07:11:21.600472+00 | | |
| e202407 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-26 07:57:44.987578+00 | | |
| e202407 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-06-26 07:57:44.965695+00 | | |
| e202407 | t_position_history | 62539779 | 0 | 0.00 | 0.00 | | 2024-07-03 10:06:38.676746+00 | | 2024-07-03 23:49:01.780493+00 |
| e202407 | t_presence_history | 5288902 | 522237 | 0.00 | 8.00 | | 2024-07-04 00:42:37.762365+00 | | 2024-07-04 00:47:24.362549+00 |
| e202407 | t_sensor_history | 1048366 | 0 | 0.00 | 0.00 | | 2024-07-03 10:41:45.233278+00 | | 2024-07-03 19:36:40.206955+00 |
| public | __digdag_status | 3111 | 504 | 0.00 | 13.00 | | 2024-07-03 12:30:58.040424+00 | | 2024-07-03 12:30:58.046566+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-30 09:32:17.829915+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-06-30 09:32:17.667891+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-06-30 09:41:23.415713+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-30 09:41:23.404855+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-06-30 09:41:23.393966+00 | | |
| public | m_area | 624 | 8 | 0.00 | 1.00 | | 2024-07-03 02:06:57.082537+00 | | 2024-06-28 07:24:18.756496+00 |
| public | m_auth | 105 | 0 | 0.00 | 0.00 | | 2024-06-30 09:32:17.852347+00 | | |
| public | m_category | 1697 | 17 | 0.00 | 0.00 | | 2024-07-03 02:06:57.167306+00 | | 2024-06-25 09:59:15.889653+00 |
| public | m_exb | 19817 | 762 | 0.00 | 3.00 | | 2024-07-03 00:26:16.793031+00 | | 2024-07-03 08:01:32.104422+00 |
| public | m_favorite | 159144 | 1144 | 0.00 | 0.00 | | 2024-07-01 06:31:26.180174+00 | | 2024-06-27 06:46:30.093849+00 |
| public | m_feature | 161 | 0 | 0.00 | 0.00 | | 2024-07-01 03:46:27.672459+00 | | |
| public | m_group | 16499 | 1236 | 0.00 | 6.00 | | 2024-06-24 03:26:26.129329+00 | | 2024-07-03 02:43:57.182805+00 |
| public | m_holiday | 25083 | 0 | 0.00 | 0.00 | | 2024-06-27 04:22:18.559945+00 | | |
| public | m_lob | 20209 | 319 | 0.00 | 1.00 | | 2024-06-27 12:31:28.513461+00 | | 2024-06-21 09:19:55.785923+00 |
| public | m_location | 34824 | 2762 | 0.00 | 7.00 | | 2024-06-25 01:48:13.445849+00 | | 2024-07-03 05:54:20.51451+00 |
| public | m_notify_template | 698 | 1 | 0.00 | 0.00 | | 2024-06-30 09:32:18.035198+00 | | 2024-06-17 00:59:30.67119+00 |
| public | m_outside | 286 | 7 | 0.00 | 2.00 | | 2024-06-25 12:56:21.474172+00 | | 2024-07-03 01:58:21.092861+00 |
| public | m_pot | 151647 | 26186 | 0.00 | 14.00 | | 2024-07-01 23:01:50.927278+00 | | 2024-07-03 23:09:03.489117+00 |
| public | m_pot_profile | 34223 | 26 | 0.00 | 0.00 | | 2024-06-28 06:59:12.164137+00 | | |
| public | m_provider_user | 68 | 0 | 0.00 | 0.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-06-30 09:32:18.141131+00 | | |
| public | m_role | 525 | 0 | 0.00 | 0.00 | | 2024-06-30 09:32:18.112115+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-06-30 09:32:17.959481+00 | | |
| public | m_setting | 10997 | 1962 | 0.00 | 15.00 | | 2024-07-02 10:50:37.013511+00 | | 2024-07-04 00:21:23.515546+00 |
| public | m_setting_log | 26296 | 1272 | 0.00 | 4.00 | | 2024-06-30 05:29:19.092869+00 | | 2024-07-03 12:30:57.73651+00 |
| public | m_site | 168 | 0 | 0.00 | 0.00 | | 2024-06-30 09:32:17.988988+00 | | |
| public | m_tenant | 93 | 0 | 0.00 | 0.00 | | 2024-06-30 09:32:18.280897+00 | | |
| public | m_tx | 91277 | 16151 | 0.00 | 15.00 | | 2024-07-03 01:42:16.100108+00 | | 2024-07-03 08:15:38.568931+00 |
| public | m_user | 29284 | 23 | 0.00 | 0.00 | | 2024-07-03 02:06:55.206129+00 | | 2024-06-03 00:18:59.127095+00 |
| public | m_zone | 5349 | 10 | 0.00 | 0.00 | | 2024-07-01 19:52:08.076297+00 | | 2024-06-30 05:02:57.280533+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-06-30 09:32:16.339368+00 | | |
| public | r_auth_zone | 207 | 0 | 0.00 | 0.00 | | 2024-07-02 08:12:04.395793+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-06-30 09:32:18.057291+00 | | |
| public | r_group_auth | 466 | 2 | 0.00 | 0.00 | | 2024-06-30 15:19:35.357363+00 | | 2024-06-16 02:59:23.422947+00 |
| public | r_location_zone | 35115 | 41 | 0.00 | 0.00 | | 2024-07-03 08:14:39.718633+00 | | 2024-06-30 10:34:39.28543+00 |
| public | r_pot_auth | 780 | 4 | 0.00 | 0.00 | | 2024-06-25 01:48:11.35614+00 | | 2024-06-28 08:46:48.42878+00 |
| public | r_pot_category | 6633 | 0 | 0.00 | 0.00 | | 2024-07-03 21:23:41.617459+00 | | 2024-07-03 20:01:27.605291+00 |
| public | r_pot_group | 91714 | 17492 | 0.00 | 16.00 | | 2024-07-03 21:23:41.381975+00 | | 2024-07-04 00:20:26.876893+00 |
| public | r_pot_tx | 50851 | 1321 | 0.00 | 2.00 | | 2024-06-28 04:52:42.887643+00 | | 2024-06-20 08:53:42.44731+00 |
| public | r_pot_user | 18183 | 162 | 0.00 | 0.00 | | 2024-06-24 03:26:25.855632+00 | | 2024-05-23 08:08:14.876959+00 |
| public | r_provider_tenant | 1484 | 0 | 0.00 | 0.00 | | 2024-06-28 05:12:42.815199+00 | | 2024-06-28 05:12:42.819951+00 |
| public | r_role_feature | 4962 | 16 | 0.00 | 0.00 | | 2024-06-24 03:26:25.883714+00 | | |
| public | r_tenant_feature | 3399 | 0 | 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-06-23 12:11:08.910077+00 | | 2024-05-08 03:36:41.526083+00 |
| public | r_user_region | 18801 | 165 | 0.00 | 0.00 | | 2024-06-24 03:26:24.148153+00 | | 2024-05-23 09:03:11.7525+00 |
| public | r_user_site | 5093 | 28 | 0.00 | 0.00 | | 2024-06-30 09:32:17.937076+00 | | 2024-06-28 09:33:34.486007+00 |
| public | r_zone_category | 3102 | 44 | 0.00 | 1.00 | | 2024-06-26 05:23:19.172166+00 | | 2024-06-27 10:40:53.016456+00 |
| public | t_ai_history | 7 | 0 | 0.00 | 0.00 | | 2024-06-22 09:40:51.516385+00 | | |
| public | t_attendance | 1070214 | 6935 | 0.00 | 0.00 | | 2024-07-03 07:47:25.502999+00 | | 2024-06-27 02:06:44.545198+00 |
| public | t_general | 2057 | 2 | 0.00 | 0.00 | | 2024-06-30 09:32:18.257288+00 | | 2024-06-09 01:00:58.565026+00 |
| public | t_mobile_device_history | 493772 | 0 | 0.00 | 0.00 | | 2024-07-02 10:56:52.586514+00 | | 2024-06-06 23:58:18.65069+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-06-30 09:32:18.078996+00 | | |
| public | t_notify_history | 2587488 | 28043 | 0.00 | 1.00 | | 2024-07-01 10:11:44.241294+00 | | 2024-07-02 23:38:47.339082+00 |
| public | t_operation_log | 9995168 | 145959 | 0.00 | 1.00 | | 2024-06-26 07:11:21.588612+00 | | 2024-06-20 13:11:21.981761+00 |
| public | t_plan | 11104042 | 1899941 | 0.00 | 14.00 | | 2024-06-26 00:33:45.722116+00 | | 2024-07-03 09:40:18.04066+00 |
| public | t_plan_detail | 18741479 | 2453907 | 0.00 | 11.00 | | 2024-06-27 07:41:27.722273+00 | | 2024-07-03 11:41:43.294512+00 |
| public | t_plan_sync | 68389 | 5722 | 0.00 | 7.00 | | 2024-07-04 00:35:22.601154+00 | | 2024-07-04 00:34:22.48465+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-06-30 09:32:18.305617+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-06-30 09:32:16.350945+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-06-30 09:32:18.160251+00 | | |
| public | t_recv_position_history | 120259 | 52698 | 0.00 | 30.00 | | 2024-07-04 00:51:23.946773+00 | 2024-07-03 13:30:03.424842+00 | 2024-07-04 00:51:24.151055+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-06-30 09:32:16.379153+00 | | |
| public | t_terminal | 63449 | 2408 | 0.00 | 3.00 | | 2024-06-28 04:52:44.107553+00 | | 2024-07-03 22:55:58.046723+00 |
| public | t_terminal_log | 8052752 | 0 | 0.00 | 0.00 | | 2024-06-26 00:46:33.184036+00 | | 2024-06-23 12:28:13.988737+00 |
| public | w_arrival_notify | 76 | 8 | 0.00 | 9.00 | | 2024-07-03 15:00:11.227283+00 | | 2024-07-03 05:18:13.113958+00 |
| public | w_latest_position | 54125 | 11117 | 0.00 | 17.00 | | 2024-07-04 00:51:24.241955+00 | | 2024-07-04 00:51:24.339986+00 |
| public | w_latest_presence | 210580 | 47413 | 0.00 | 18.00 | | 2024-07-04 00:51:26.674709+00 | | 2024-07-04 00:51:27.45427+00 |
| public | w_latest_sensor | 344 | 215 | 0.00 | 38.00 | | 2024-07-04 00:51:24.359343+00 | | 2024-07-04 00:51:24.468712+00 |
| public | w_lock | 12854 | 1 | 0.00 | 0.00 | | 2024-06-23 23:01:01.593631+00 | | |
| public | w_master_update | 161 | 39 | 0.00 | 19.00 | | 2024-07-04 00:05:22.105917+00 | | 2024-07-03 23:56:05.810405+00 |
| public | w_migration | 824 | 0 | 0.00 | 0.00 | | 2024-06-30 09:41:23.435866+00 | | |
| public | w_plan_with_detail | 11095735 | 795200 | 0.00 | 6.00 | | 2024-07-01 05:28:19.990758+00 | | 2024-07-03 09:12:07.562139+00 |