| 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 |
|---|
| e202401 | a_proximity_sum | 27157134 | 0 | 0.00 | 0.00 | | 2024-03-26 06:38:48.930158+00 | | 2024-01-30 15:14:06.375164+00 |
| e202401 | a_stay_time | 17079613 | 0 | 0.00 | 0.00 | | 2024-03-28 10:02:16.490215+00 | | 2024-03-14 01:41:57.399547+00 |
| e202401 | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-29 00:46:33.523884+00 | | |
| e202401 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-29 00:46:33.545919+00 | | |
| e202401 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-29 00:46:33.534921+00 | | |
| e202401 | t_position_history | 339668259 | 366656 | 0.00 | 0.00 | | 2024-03-27 01:37:26.422409+00 | | 2024-01-30 10:26:24.358574+00 |
| e202401 | t_presence_history | 36630844 | 7674 | 0.00 | 0.00 | | 2024-03-22 07:25:04.11408+00 | | 2024-01-31 15:07:30.056064+00 |
| e202401 | t_sensor_history | 14119152 | 98242 | 0.00 | 0.00 | | 2024-03-24 10:01:09.116726+00 | | 2024-01-30 12:58:27.389928+00 |
| e202403 | a_proximity_sum | 39952092 | 0 | 0.00 | 0.00 | | 2024-03-26 18:05:36.715203+00 | | 2024-03-30 16:19:49.867598+00 |
| e202403 | a_stay_time | 19465106 | 0 | 0.00 | 0.00 | | 2024-03-27 05:15:16.43779+00 | | 2024-03-29 15:10:19.442279+00 |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-25 10:10:49.192616+00 | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-25 10:10:49.209899+00 | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-25 10:10:49.181192+00 | | |
| e202403 | t_position_history | 385155582 | 5751 | 0.00 | 0.00 | | 2024-03-26 01:54:15.45918+00 | | 2024-03-29 13:58:09.948045+00 |
| e202403 | t_presence_history | 63046126 | 4060838 | 0.00 | 6.00 | | 2024-03-31 00:37:32.941805+00 | | 2024-03-31 00:13:12.895019+00 |
| e202403 | t_sensor_history | 14949578 | 0 | 0.00 | 0.00 | | 2024-03-24 17:40:25.421364+00 | | 2024-03-30 16:18:49.861644+00 |
| public | __digdag_status | 32 | 33 | 1.00 | 50.00 | | 2024-03-28 08:30:14.617013+00 | | 2024-03-28 12:30:33.432394+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.153778+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.14206+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:31.926429+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:33.008567+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:12.385343+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:33.031529+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:33.052666+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:12.406523+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:12.363627+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:31.949184+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:12.427447+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:12.448466+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.669306+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.658032+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.646681+00 | | |
| public | m_area | 625 | 1 | 0.00 | 0.00 | | 2024-03-28 10:45:06.744765+00 | | 2024-03-08 02:07:46.986266+00 |
| public | m_auth | 113 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.174303+00 | | 2024-02-28 05:53:49.738173+00 |
| public | m_category | 1687 | 0 | 0.00 | 0.00 | | 2024-03-28 10:45:06.77351+00 | | 2024-03-26 09:54:33.731031+00 |
| public | m_exb | 18082 | 2977 | 0.00 | 14.00 | | 2024-03-29 06:00:59.833586+00 | | 2024-03-29 06:35:34.303854+00 |
| public | m_favorite | 150538 | 1308 | 0.00 | 0.00 | | 2024-03-26 11:31:13.565858+00 | | 2024-02-26 11:15:18.008043+00 |
| public | m_feature | 153 | 0 | 0.00 | 0.00 | | 2024-03-26 08:40:20.689186+00 | | |
| public | m_group | 13626 | 304 | 0.00 | 2.00 | | 2024-03-18 07:59:59.036778+00 | | 2024-03-13 06:29:07.782652+00 |
| public | m_holiday | 16554 | 0 | 0.00 | 0.00 | | 2024-03-25 10:13:49.440102+00 | | 2024-03-13 04:25:59.969397+00 |
| public | m_lob | 15764 | 105 | 0.00 | 0.00 | | 2024-03-22 10:03:48.073732+00 | | 2024-03-13 08:59:39.977714+00 |
| public | m_location | 32702 | 6224 | 0.00 | 15.00 | | 2024-03-26 22:58:24.573582+00 | | 2024-03-29 04:43:29.808486+00 |
| public | m_notify_template | 728 | 2 | 0.00 | 0.00 | | 2024-03-25 13:40:49.372127+00 | | 2024-03-13 07:21:28.594642+00 |
| public | m_outside | 278 | 0 | 0.00 | 0.00 | | 2024-03-20 06:39:45.830422+00 | | |
| public | m_pot | 185290 | 3756 | 0.00 | 1.00 | | 2024-03-30 12:12:00.258585+00 | | 2024-03-30 12:12:01.344217+00 |
| public | m_pot_profile | 33040 | 21 | 0.00 | 0.00 | | 2024-03-26 11:31:12.040734+00 | | 2024-02-21 06:28:02.787527+00 |
| public | m_provider_user | 67 | 45 | 0.00 | 40.00 | | 2024-03-26 10:29:33.991099+00 | | 2024-03-28 09:27:17.588147+00 |
| public | m_region | 101 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.478152+00 | | |
| public | m_role | 527 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.452205+00 | | 2024-03-28 02:18:51.575265+00 |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.293842+00 | | |
| public | m_setting | 20769 | 1752 | 0.00 | 7.00 | | 2024-03-30 22:48:19.350958+00 | | 2024-03-30 22:47:19.178106+00 |
| public | m_setting_log | 46299 | 0 | 0.00 | 0.00 | 2024-02-16 03:34:50.060418+00 | 2024-03-30 12:51:17.871337+00 | | 2024-03-30 19:01:26.679816+00 |
| public | m_site | 170 | 2 | 0.00 | 1.00 | | 2024-03-25 13:40:49.322758+00 | | |
| public | m_tenant | 100 | 5 | 0.00 | 4.00 | | 2024-03-25 13:40:49.610812+00 | | |
| public | m_tx | 111931 | 20578 | 0.00 | 15.00 | | 2024-03-29 06:27:33.735015+00 | | 2024-03-29 06:22:33.201131+00 |
| public | m_user | 29220 | 83 | 0.00 | 0.00 | | 2024-03-28 10:45:06.705657+00 | | 2024-02-21 08:40:30.943311+00 |
| public | m_zone | 5570 | 135 | 0.00 | 2.00 | | 2024-03-27 04:25:46.606328+00 | | 2024-03-25 01:53:48.454583+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:48.184698+00 | | |
| public | r_auth_zone | 215 | 0 | 0.00 | 0.00 | | 2024-03-23 17:33:57.392926+00 | | 2024-03-07 02:43:16.034776+00 |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.395111+00 | | |
| public | r_group_auth | 450 | 24 | 0.00 | 5.00 | | 2024-03-26 01:54:59.165763+00 | | 2024-03-29 09:54:32.733338+00 |
| public | r_location_zone | 31631 | 3255 | 0.00 | 9.00 | | 2024-03-29 03:09:55.410858+00 | | 2024-03-29 08:31:19.876436+00 |
| public | r_pot_auth | 731 | 56 | 0.00 | 7.00 | | 2024-03-19 07:49:19.870442+00 | | 2024-03-22 09:00:42.270868+00 |
| public | r_pot_category | 24796 | 5009 | 0.00 | 16.00 | | 2024-03-30 20:12:04.190032+00 | | 2024-03-30 20:06:04.193337+00 |
| public | r_pot_group | 89341 | 8975 | 0.00 | 9.00 | | 2024-03-30 22:01:51.246201+00 | | 2024-03-31 00:37:40.634939+00 |
| public | r_pot_tx | 46054 | 2451 | 0.00 | 5.00 | | 2024-03-23 05:20:45.184972+00 | | 2024-03-28 08:33:14.534211+00 |
| public | r_pot_user | 18926 | 382 | 0.00 | 1.00 | | 2024-03-18 07:59:58.589614+00 | | 2024-02-21 08:40:30.997445+00 |
| public | r_provider_tenant | 1698 | 0 | 0.00 | 0.00 | | 2024-03-29 09:52:33.0692+00 | | 2024-03-29 09:11:54.568546+00 |
| public | r_role_feature | 5241 | 46 | 0.00 | 0.00 | | 2024-03-18 07:59:58.683711+00 | | 2024-03-28 04:53:44.604731+00 |
| public | r_tenant_feature | 3461 | 25 | 0.00 | 0.00 | | 2024-03-29 00:39:12.328913+00 | | 2024-03-22 05:38:31.850763+00 |
| public | r_tx_sensor | 455 | 0 | 0.00 | 0.00 | | 2024-03-19 16:18:24.686266+00 | | 2024-01-27 01:38:23.792244+00 |
| public | r_user_region | 19479 | 386 | 0.00 | 1.00 | | 2024-03-18 07:59:58.252187+00 | | 2024-02-21 08:40:30.42447+00 |
| public | r_user_site | 5316 | 13 | 0.00 | 0.00 | | 2024-03-25 13:40:49.273411+00 | | 2024-03-21 06:04:00.125378+00 |
| public | r_zone_category | 2734 | 258 | 0.00 | 8.00 | | 2024-03-21 01:53:48.778769+00 | | 2024-03-28 02:58:53.071812+00 |
| public | t_ai_history | 5 | 0 | 0.00 | 0.00 | | | | |
| public | t_attendance | 818446 | 8504 | 0.00 | 1.00 | | 2024-03-29 00:39:31.903418+00 | | 2024-03-26 14:00:59.319182+00 |
| public | t_general | 1570 | 6 | 0.00 | 0.00 | | 2024-03-25 13:40:49.587016+00 | | 2024-03-01 01:35:10.979803+00 |
| public | t_mobile_device_history | 424775 | 0 | 0.00 | 0.00 | | 2024-03-28 01:26:27.521731+00 | | 2024-03-13 04:08:59.7831+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.41662+00 | | |
| public | t_notify_history | 2125807 | 14152 | 0.00 | 0.00 | | 2024-03-26 22:58:42.878337+00 | | 2024-03-26 08:36:50.766128+00 |
| public | t_operation_log | 8169256 | 141147 | 0.00 | 1.00 | | 2024-03-21 04:05:06.820866+00 | | 2024-03-17 19:43:32.241009+00 |
| public | t_plan | 9634586 | 1244168 | 0.00 | 11.00 | | 2024-03-28 00:29:48.561118+00 | | 2024-03-29 12:52:02.443088+00 |
| public | t_plan_detail | 15332148 | 2010414 | 0.00 | 11.00 | | 2024-03-29 05:35:46.760344+00 | | 2024-03-30 02:02:10.87182+00 |
| public | t_plan_sync | 42451 | 5948 | 0.00 | 12.00 | | 2024-03-31 00:50:18.932724+00 | | 2024-03-31 00:37:41.301453+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.635026+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:48.196542+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.496881+00 | | |
| public | t_recv_position_history | 100354 | 2465215 | 24.00 | 96.00 | | 2024-03-31 00:51:20.23029+00 | 2024-03-30 13:30:13.643324+00 | 2024-03-31 00:51:20.80856+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:48.22591+00 | | |
| public | t_terminal | 34256 | 3554 | 0.00 | 9.00 | | 2024-03-30 02:46:13.1222+00 | | 2024-03-30 23:05:20.347061+00 |
| public | t_terminal_log | 5786808 | 0 | 0.00 | 0.00 | | 2024-03-20 16:57:41.690867+00 | | 2024-03-23 15:22:08.14262+00 |
| public | w_arrival_notify | 64 | 15 | 0.00 | 18.00 | | 2024-03-27 07:59:06.94104+00 | | 2024-03-28 23:51:48.63331+00 |
| public | w_latest_position | 46241 | 260646 | 5.00 | 84.00 | | 2024-03-31 00:51:23.03418+00 | | 2024-03-31 00:51:23.175952+00 |
| public | w_latest_presence | 186089 | 4965907 | 26.00 | 96.00 | 2024-01-18 12:30:06.016796+00 | 2024-03-31 00:51:22.479084+00 | 2024-01-18 12:30:06.178604+00 | 2024-03-31 00:51:22.910926+00 |
| public | w_latest_sensor | 443 | 10702 | 24.00 | 96.00 | | 2024-03-31 00:51:19.016128+00 | | 2024-03-31 00:51:19.136312+00 |
| public | w_lock | 12085 | 0 | 0.00 | 0.00 | | 2024-03-18 03:42:47.55468+00 | | 2024-01-31 02:02:19.791893+00 |
| public | w_master_update | 172 | 15 | 0.00 | 8.00 | | 2024-03-31 00:05:09.266709+00 | | 2024-03-30 23:12:21.549292+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.690522+00 | | |
| public | w_plan_with_detail | 9656449 | 1104530 | 0.00 | 10.00 | | 2024-03-28 03:41:12.341411+00 | | 2024-03-29 10:51:01.204022+00 |