| 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 |
|---|
| e202408 | a_proximity_sum | 696351 | 0 | 0.00 | 0.00 | | 2024-10-14 05:21:00.716925+00 | | |
| e202408 | a_stay_time | 2193492 | 0 | 0.00 | 0.00 | | 2024-10-15 09:16:45.364693+00 | | |
| e202408 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-12 17:43:46.156661+00 | | |
| e202408 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-12 17:43:46.138978+00 | | |
| e202408 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-12 17:47:02.36364+00 | | |
| e202408 | t_position_history | 27712963 | 0 | 0.00 | 0.00 | | 2024-10-14 15:56:54.940814+00 | | |
| e202408 | t_presence_history | 5120420 | 0 | 0.00 | 0.00 | | 2024-10-13 22:10:38.921063+00 | | |
| e202408 | t_sensor_history | 1196084 | 0 | 0.00 | 0.00 | | 2024-10-16 08:51:59.038352+00 | | |
| e202409 | a_proximity_sum | 881205 | 0 | 0.00 | 0.00 | | 2024-10-15 09:29:48.222306+00 | | |
| e202409 | a_stay_time | 2549908 | 0 | 0.00 | 0.00 | | 2024-10-14 08:27:14.157404+00 | | |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-14 12:21:29.574268+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-14 12:18:28.790611+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-14 12:18:28.773266+00 | | |
| e202409 | t_position_history | 30788006 | 0 | 0.00 | 0.00 | | 2024-10-10 00:16:09.874667+00 | | |
| e202409 | t_presence_history | 6027295 | 0 | 0.00 | 0.00 | | 2024-10-15 01:46:16.408331+00 | | |
| e202409 | t_sensor_history | 1163444 | 0 | 0.00 | 0.00 | | 2024-10-14 03:21:08.114005+00 | | |
| e202410 | a_proximity_sum | 565191 | 0 | 0.00 | 0.00 | | 2024-10-15 17:00:40.69728+00 | | 2024-10-17 17:25:36.967647+00 |
| e202410 | a_stay_time | 1726860 | 0 | 0.00 | 0.00 | | 2024-10-15 17:00:43.084872+00 | | 2024-10-17 16:35:39.605283+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-15 00:30:52.602042+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-15 00:30:52.569237+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-15 00:30:52.580656+00 | | |
| e202410 | t_position_history | 20805763 | 0 | 0.00 | 0.00 | | 2024-10-17 13:53:38.939956+00 | | 2024-10-17 00:19:13.889872+00 |
| e202410 | t_presence_history | 3624873 | 681453 | 0.00 | 15.00 | | 2024-10-18 01:25:00.345072+00 | | 2024-10-18 01:41:24.006405+00 |
| e202410 | t_sensor_history | 729727 | 0 | 0.00 | 0.00 | | 2024-10-17 14:41:16.614034+00 | | 2024-10-17 23:25:28.835011+00 |
| public | __digdag_status | 10 | 18 | 1.00 | 64.00 | | 2024-10-16 12:30:56.22921+00 | | 2024-10-14 21:20:02.60867+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2024-10-11 01:42:22.156194+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-09 07:14:43.449001+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-10-09 07:13:27.029831+00 | | |
| public | b_attendance_group | 468452 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:42.769996+00 | | |
| public | b_attendance_hour | 7021134 | 0 | 0.00 | 0.00 | | 2024-10-09 09:40:36.564569+00 | | |
| public | b_attendance_pot | 236929 | 0 | 0.00 | 0.00 | | 2024-10-16 00:32:11.092097+00 | | 2024-10-15 18:36:01.888064+00 |
| public | b_attendance_pot_hour | 3667883 | 0 | 0.00 | 0.00 | | 2024-10-15 08:05:56.634411+00 | | 2024-10-16 16:50:43.992377+00 |
| public | b_check_in | 3805931 | 0 | 0.00 | 0.00 | | 2024-10-09 10:21:24.702644+00 | | |
| public | b_check_in_hour | 57050976 | 0 | 0.00 | 0.00 | | 2024-10-09 09:42:02.180083+00 | | |
| public | b_check_in_pot | 135201 | 0 | 0.00 | 0.00 | | 2024-10-16 04:56:38.279612+00 | | |
| public | b_check_in_pot_hour | 2546422 | 0 | 0.00 | 0.00 | | 2024-10-15 10:11:48.621699+00 | | |
| public | b_proximity_group | 33462387 | 0 | 0.00 | 0.00 | | 2024-10-09 10:12:17.361729+00 | | |
| public | b_proximity_info | 28771036 | 0 | 0.00 | 0.00 | | 2024-10-16 04:54:37.573088+00 | | |
| public | b_seat_reserve | 855124 | 0 | 0.00 | 0.00 | | 2024-10-09 09:52:58.312448+00 | | |
| public | b_seat_reserve_hour | 16046327 | 0 | 0.00 | 0.00 | | 2024-10-09 07:13:26.760924+00 | | |
| public | b_usage | 958549 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.572422+00 | | |
| public | b_usage_hour | 17543862 | 0 | 0.00 | 0.00 | | 2024-10-09 09:35:09.518929+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-09 07:19:41.620747+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-09 07:19:41.609929+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-09 07:19:41.599105+00 | | |
| public | m_area | 93 | 7 | 0.00 | 7.00 | | 2024-10-09 10:26:25.212598+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-10-09 09:42:02.88044+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.680384+00 | | |
| public | m_exb | 4638 | 116 | 0.00 | 2.00 | | 2024-10-08 23:30:28.216494+00 | | |
| public | m_favorite | 33610 | 12 | 0.00 | 0.00 | | 2024-10-17 17:47:36.438331+00 | | 2024-10-08 09:37:31.834203+00 |
| public | m_favorite_group | 7132 | 17 | 0.00 | 0.00 | | 2024-10-08 09:38:33.212195+00 | | 2024-10-14 22:44:14.507633+00 |
| public | m_feature | 164 | 0 | 0.00 | 0.00 | | 2024-10-09 10:30:42.582653+00 | | |
| public | m_group | 2319 | 0 | 0.00 | 0.00 | | 2024-10-18 00:41:01.832322+00 | | |
| public | m_holiday | 5624 | 0 | 0.00 | 0.00 | | 2024-10-09 07:19:41.637455+00 | | |
| public | m_lob | 1171 | 0 | 0.00 | 0.00 | | 2024-10-18 00:41:04.288799+00 | | |
| public | m_location | 5434 | 0 | 0.00 | 0.00 | | 2024-10-18 00:41:02.036053+00 | | |
| public | m_notify_template | 124 | 2 | 0.00 | 1.00 | | 2024-10-09 07:14:45.604965+00 | | |
| public | m_outside | 63 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.465532+00 | | |
| public | m_pot | 28423 | 157 | 0.00 | 0.00 | | 2024-10-18 01:29:24.85681+00 | | 2024-10-18 00:10:16.762813+00 |
| public | m_pot_profile | 675 | 29 | 0.00 | 4.00 | | 2024-10-09 09:36:10.03224+00 | | |
| public | m_provider_user | 59 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.420363+00 | | |
| public | m_region | 17 | 0 | 0.00 | 0.00 | | 2024-10-09 10:26:26.701981+00 | | |
| public | m_role | 79 | 0 | 0.00 | 0.00 | | 2024-10-09 10:26:26.664682+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-10-09 10:21:18.50321+00 | | |
| public | m_setting | 2270 | 388 | 0.00 | 14.00 | | 2024-10-16 06:34:06.608828+00 | | 2024-10-17 22:10:33.616101+00 |
| public | m_setting_log | 4717 | 428 | 0.00 | 8.00 | | 2024-10-15 12:31:57.197536+00 | | 2024-10-17 21:07:11.513033+00 |
| public | m_site | 26 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.590239+00 | | |
| public | m_tenant | 17 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.386887+00 | | |
| public | m_tx | 26269 | 0 | 0.00 | 0.00 | | 2024-10-17 11:06:09.4209+00 | | 2024-10-17 11:05:09.379783+00 |
| public | m_user | 3288 | 2 | 0.00 | 0.00 | | 2024-10-09 21:49:57.370023+00 | | |
| public | m_zone | 751 | 3 | 0.00 | 0.00 | | 2024-10-09 07:14:45.704303+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-10-09 09:52:58.323569+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-10-09 10:21:18.483407+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.628252+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-10-09 09:52:56.572914+00 | | |
| public | r_location_zone | 5490 | 74 | 0.00 | 1.00 | | 2024-10-13 18:26:24.084228+00 | | |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-10-09 09:42:02.904055+00 | | |
| public | r_pot_category | 988 | 2 | 0.00 | 0.00 | | 2024-10-09 09:42:04.145778+00 | | |
| public | r_pot_group | 11940 | 1155 | 0.00 | 8.00 | | 2024-10-17 23:14:28.550501+00 | | 2024-10-17 23:36:31.105168+00 |
| public | r_pot_tx | 8129 | 25 | 0.00 | 0.00 | | 2024-10-12 12:51:10.996826+00 | | |
| public | r_pot_user | 3023 | 0 | 0.00 | 0.00 | | 2024-10-09 21:49:57.308533+00 | | |
| public | r_provider_tenant | 161 | 0 | 0.00 | 0.00 | | 2024-10-15 23:59:10.404471+00 | | |
| public | r_role_feature | 598 | 0 | 0.00 | 0.00 | | 2024-10-17 23:25:28.069746+00 | | |
| public | r_tenant_feature | 645 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.402833+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:45.66127+00 | | |
| public | r_user_region | 3081 | 0 | 0.00 | 0.00 | | 2024-10-09 21:49:57.334509+00 | | |
| public | r_user_site | 356 | 0 | 0.00 | 0.00 | | 2024-10-16 04:41:44.813899+00 | | |
| public | r_zone_category | 684 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.437588+00 | | |
| public | t_ai_history | 28 | 0 | 0.00 | 0.00 | | 2024-10-10 09:13:18.412496+00 | | |
| public | t_attendance | 568822 | 7994 | 0.00 | 1.00 | | 2024-10-09 10:27:31.080331+00 | | |
| public | t_general | 34 | 1 | 0.00 | 2.00 | | 2024-10-09 10:26:26.685653+00 | | |
| public | t_mobile_device_history | 96835 | 0 | 0.00 | 0.00 | | 2024-10-09 07:42:10.963281+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-10-09 07:14:45.639166+00 | | |
| public | t_notify_history | 513424 | 5725 | 0.00 | 1.00 | | 2024-10-09 10:26:29.959895+00 | | |
| public | t_operation_log | 2297110 | 5 | 0.00 | 0.00 | | 2024-10-09 07:29:53.60034+00 | | |
| public | t_plan | 3897173 | 320409 | 0.00 | 7.00 | | 2024-10-09 00:50:12.430957+00 | | 2024-10-16 06:41:24.282386+00 |
| public | t_plan_detail | 4632431 | 171780 | 0.00 | 3.00 | | 2024-10-11 11:59:29.337827+00 | | 2024-10-17 06:37:49.191105+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-10-11 00:25:59.901208+00 | | |
| public | t_plan_sync | 223394 | 25283 | 0.00 | 10.00 | | 2024-10-15 21:06:01.510556+00 | | 2024-10-17 21:30:08.524576+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-10-09 07:14:43.37047+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-10-09 09:34:38.046241+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-10-09 09:42:02.924486+00 | | |
| public | t_recv_position_history | 6329 | 62 | 0.00 | 0.00 | | 2024-10-18 01:45:23.818165+00 | 2024-10-17 12:42:00.94405+00 | 2024-10-18 01:45:23.84814+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-10-09 09:35:38.063282+00 | | |
| public | t_terminal | 21994 | 1149 | 0.00 | 4.00 | | 2024-10-13 18:31:15.698992+00 | | 2024-10-17 19:49:11.755696+00 |
| public | t_terminal_log | 4837708 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:49.174752+00 | | |
| public | w_arrival_notify | 1 | 4 | 4.00 | 80.00 | | 2024-10-09 07:19:57.728771+00 | | |
| public | w_latest_position | 10652 | 44 | 0.00 | 0.00 | | 2024-10-18 01:45:23.638075+00 | | 2024-10-18 01:45:23.661596+00 |
| public | w_latest_presence | 17100 | 1068 | 0.00 | 5.00 | | 2024-10-18 01:45:23.957149+00 | | 2024-10-18 01:45:24.061482+00 |
| public | w_latest_sensor | 113 | 16 | 0.00 | 12.00 | | 2024-10-18 01:45:23.38172+00 | | 2024-10-18 01:45:23.616094+00 |
| public | w_lock | 1023 | 0 | 0.00 | 0.00 | | 2024-10-09 07:14:43.064582+00 | | |
| public | w_master_update | 17 | 0 | 0.00 | 0.00 | | 2024-10-18 00:10:16.779966+00 | | 2024-10-17 12:33:34.844162+00 |
| public | w_plan_with_detail | 3894802 | 25172 | 0.00 | 0.00 | | 2024-10-17 21:35:24.210588+00 | | 2024-10-16 06:42:23.758129+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-10-11 00:12:03.97027+00 | | |