| 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 |
|---|
| e202310 | a_proximity_sum | 51728445 | 0 | 0.00 | 0.00 | | 2023-12-07 05:57:32.075609+00 | | |
| e202310 | a_stay_time | 17059859 | 0 | 0.00 | 0.00 | | 2023-12-08 02:26:16.916407+00 | | |
| e202310 | l_position_history | 0 | 0 | 0 | 0 | | | | |
| e202310 | l_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202310 | l_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202310 | t_position_history | 313936740 | 0 | 0.00 | 0.00 | | 2023-12-07 13:55:22.547763+00 | | |
| e202310 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| e202310 | t_sensor_history | 0 | 10 | 0 | 100.00 | | | | |
| e202311 | a_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202311 | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202311 | l_position_history | 0 | 0 | 0 | 0 | | | | |
| e202311 | l_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202311 | l_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202311 | t_position_history | 1259 | 4 | 0.00 | 0.00 | | | | |
| e202311 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| e202311 | t_sensor_history | 0 | 1905 | 0 | 100.00 | | | | |
| e202312 | a_proximity_sum | 9493594 | 0 | 0.00 | 0.00 | | 2023-12-09 16:28:32.42241+00 | | 2023-12-09 16:28:32.970976+00 |
| e202312 | a_stay_time | 5303506 | 0 | 0.00 | 0.00 | | 2023-12-08 16:13:37.181816+00 | | 2023-12-09 16:52:14.300683+00 |
| e202312 | l_position_history | 0 | 0 | 0 | 0 | | 2023-12-06 03:23:09.404928+00 | | |
| e202312 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-12-06 03:23:09.393719+00 | | |
| e202312 | l_stay_time | 0 | 0 | 0 | 0 | | 2023-12-06 03:23:09.382432+00 | | |
| e202312 | t_position_history | 104605117 | 0 | 0.00 | 0.00 | | 2023-12-10 05:17:48.287638+00 | | 2023-12-09 01:54:11.521774+00 |
| e202312 | t_presence_history | 12918665 | 1606857 | 0.00 | 11.00 | | 2023-12-10 05:36:26.204048+00 | | 2023-12-10 05:36:26.701492+00 |
| e202312 | t_sensor_history | 3566395 | 0 | 0.00 | 0.00 | | 2023-12-08 10:33:34.605693+00 | | 2023-12-09 16:00:56.695364+00 |
| public | __digdag_status | 12 | 10 | 0.00 | 45.00 | | 2023-12-09 23:42:03.074456+00 | | 2023-12-09 03:31:41.444367+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | | | |
| public | m_area | 609 | 1 | 0.00 | 0.00 | | 2023-12-08 07:01:20.693085+00 | | |
| public | m_auth | 0 | 0 | 0 | 0 | | | | |
| public | m_category | 1526 | 0 | 0.00 | 0.00 | | 2023-12-08 07:01:20.785324+00 | | |
| public | m_exb | 16642 | 798 | 0.00 | 4.00 | | 2023-12-08 06:38:01.833091+00 | | 2023-12-08 06:35:04.162002+00 |
| public | m_favorite | 718 | 335 | 0.00 | 31.00 | | | | |
| public | m_feature | 0 | 0 | 0 | 0 | | | | |
| public | m_group | 26 | 7 | 0.00 | 21.00 | | | | |
| public | m_holiday | 0 | 0 | 0 | 0 | | | | |
| public | m_lob | 38 | 18 | 0.00 | 32.00 | | | | |
| public | m_location | 30795 | 4804 | 0.00 | 13.00 | | | | 2023-12-10 05:17:48.919623+00 |
| public | m_notify_template | 2 | 5 | 2.00 | 71.00 | | | | |
| public | m_outside | 7 | 3 | 0.00 | 30.00 | | | | |
| public | m_pot | 258550 | 19141 | 0.00 | 6.00 | | 2023-12-07 00:22:37.778797+00 | | 2023-12-08 03:06:00.732672+00 |
| public | m_pot_profile | 213 | 6 | 0.00 | 2.00 | | | | |
| public | m_provider_user | 0 | 0 | 0 | 0 | | | | |
| public | m_region | 0 | 0 | 0 | 0 | | | | |
| public | m_role | 23 | 3 | 0.00 | 11.00 | | | | |
| public | m_sensor | 0 | 0 | 0 | 0 | | | | |
| public | m_setting | 18144 | 568 | 0.00 | 3.00 | | 2023-12-10 04:50:40.093348+00 | | 2023-12-10 03:22:41.271306+00 |
| public | m_setting_log | 68278 | 0 | 0.00 | 0.00 | | 2023-12-10 02:18:17.473556+00 | | 2023-12-10 02:14:00.717543+00 |
| public | m_site | 1 | 1 | 1.00 | 50.00 | | | | |
| public | m_tenant | 0 | 0 | 0 | 0 | | | | |
| public | m_tx | 72898 | 10465 | 0.00 | 12.00 | | 2023-12-08 06:35:03.964766+00 | | 2023-12-08 06:35:04.095761+00 |
| public | m_user | 28156 | 22 | 0.00 | 0.00 | | 2023-12-08 04:37:21.95516+00 | | |
| public | m_zone | 5501 | 1 | 0.00 | 0.00 | | 2023-12-06 07:08:10.620384+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | | | |
| public | r_auth_zone | 0 | 0 | 0 | 0 | | | | |
| public | r_exb_sensor | 0 | 0 | 0 | 0 | | | | |
| public | r_group_auth | 0 | 0 | 0 | 0 | | | | |
| public | r_location_zone | 29297 | 2246 | 0.00 | 7.00 | | 2023-12-07 08:26:58.021065+00 | | 2023-12-08 06:35:04.241503+00 |
| public | r_pot_auth | 2 | 0 | 0.00 | 0.00 | | | | |
| public | r_pot_category | 4 | 0 | 0.00 | 0.00 | | | | |
| public | r_pot_group | 87834 | 17547 | 0.00 | 16.00 | | 2023-12-10 03:04:29.783813+00 | | 2023-12-10 03:11:29.884182+00 |
| public | r_pot_tx | 139 | 261 | 1.00 | 65.00 | | | | |
| public | r_pot_user | 18570 | 2097 | 0.00 | 10.00 | | | | 2023-12-06 05:30:07.118191+00 |
| public | r_role_feature | 336 | 39 | 0.00 | 10.00 | | | | |
| public | r_tenant_feature | 24 | 4 | 0.00 | 14.00 | | | | |
| public | r_tx_sensor | 0 | 0 | 0 | 0 | | | | |
| public | r_user_region | 19093 | 2118 | 0.00 | 9.00 | | | | 2023-12-06 05:30:07.021334+00 |
| public | r_user_site | 5304 | 2 | 0.00 | 0.00 | | 2023-12-06 05:30:07.054674+00 | | 2023-12-06 05:30:07.067158+00 |
| public | r_zone_category | 4 | 83 | 20.00 | 95.00 | | | | |
| public | t_attendance | 10999 | 12395 | 1.00 | 52.00 | | | | |
| public | t_general | 24 | 6 | 0.00 | 20.00 | | | | |
| public | t_mobile_device_history | 281209 | 0 | 0.00 | 0.00 | | 2023-12-07 16:46:57.393019+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | | | |
| public | t_notify_history | 1571425 | 23747 | 0.00 | 1.00 | | 2023-12-06 01:25:39.267873+00 | | |
| public | t_operation_log | 44554 | 78409 | 1.00 | 63.00 | | | | |
| public | t_plan | 8183314 | 510634 | 0.00 | 5.00 | | 2023-12-08 18:45:23.249891+00 | | 2023-12-08 01:26:53.156806+00 |
| public | t_plan_detail | 11790874 | 1917100 | 0.00 | 13.00 | | | | 2023-12-08 18:38:59.172414+00 |
| public | t_plan_sync | 39617 | 3554 | 0.00 | 8.00 | | 2023-12-10 03:37:22.248971+00 | | 2023-12-10 03:33:18.075458+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | | | |
| public | t_recv_position_history | 88043 | 569805 | 6.00 | 86.00 | | 2023-12-10 05:42:21.973001+00 | 2023-12-09 12:30:02.811867+00 | 2023-12-10 05:42:22.32452+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| public | t_terminal | 3286 | 421 | 0.00 | 11.00 | | 2023-12-09 02:37:01.282979+00 | | 2023-12-10 05:36:26.855982+00 |
| public | t_terminal_log | 98853 | 0 | 0.00 | 0.00 | | | | |
| public | w_arrival_notify | 49 | 11 | 0.00 | 18.00 | | 2023-12-06 14:22:00.673012+00 | | |
| public | w_latest_position | 38128 | 54309 | 1.00 | 58.00 | | 2023-12-10 05:42:29.079502+00 | | 2023-12-10 05:42:32.259239+00 |
| public | w_latest_presence | 263271 | 1657430 | 6.00 | 86.00 | | 2023-12-10 05:42:24.430345+00 | | 2023-12-10 05:42:27.832357+00 |
| public | w_latest_sensor | 305 | 2813 | 9.00 | 90.00 | | 2023-12-10 05:42:27.868859+00 | | 2023-12-10 05:42:28.946029+00 |
| public | w_lock | 47 | 0 | 0.00 | 0.00 | | | | |
| public | w_master_update | 161 | 33 | 0.00 | 17.00 | | 2023-12-10 03:08:33.084026+00 | | 2023-12-10 03:04:29.904695+00 |
| public | w_migration | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_with_detail | 8181719 | 1170339 | 0.00 | 12.00 | | | | 2023-12-08 01:20:33.510888+00 |