| 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 | 17079645 | 0 | 0.00 | 0.00 | | 2024-03-14 01:39:34.831416+00 | | 2024-03-14 01:41:57.399547+00 |
| e202401 | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-16 02:06:31.154823+00 | | |
| e202401 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-16 02:06:31.183207+00 | | |
| e202401 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-16 02:06:31.171882+00 | | |
| e202401 | t_position_history | 340031882 | 0 | 0.00 | 0.00 | | 2024-03-12 10:12:24.102119+00 | | 2024-01-30 10:26:24.358574+00 |
| e202401 | t_presence_history | 36638518 | 0 | 0.00 | 0.00 | | 2024-03-22 07:25:04.11408+00 | | 2024-01-31 15:07:30.056064+00 |
| e202401 | t_sensor_history | 14217394 | 0 | 0.00 | 0.00 | | 2024-03-24 10:01:09.116726+00 | | 2024-01-30 12:58:27.389928+00 |
| e202402 | a_proximity_sum | 30539386 | 0 | 0.00 | 0.00 | | 2024-03-12 01:20:19.663884+00 | | 2024-02-28 18:03:25.795511+00 |
| e202402 | a_stay_time | 17180766 | 45194 | 0.00 | 0.00 | | 2024-03-12 01:17:24.713538+00 | | 2024-02-28 16:55:43.897188+00 |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-19 20:59:54.608094+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-19 20:59:54.619117+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-19 20:59:54.434445+00 | | |
| e202402 | t_position_history | 354664073 | 2 | 0.00 | 0.00 | | 2024-03-13 06:17:36.738143+00 | | 2024-02-28 06:24:03.251416+00 |
| e202402 | t_presence_history | 38421495 | 0 | 0.00 | 0.00 | | 2024-03-21 04:27:30.041016+00 | | 2024-03-11 14:49:28.789296+00 |
| e202402 | t_sensor_history | 15047940 | 0 | 0.00 | 0.00 | | 2024-03-12 03:59:58.647487+00 | | 2024-02-28 11:55:22.157867+00 |
| e202403 | a_proximity_sum | 31634475 | 0 | 0.00 | 0.00 | | 2024-03-22 15:35:21.102924+00 | | 2024-03-25 18:10:23.83675+00 |
| e202403 | a_stay_time | 15756357 | 0 | 0.00 | 0.00 | | 2024-03-21 18:31:48.422447+00 | | 2024-03-25 15:30:15.529128+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 | 322002088 | 0 | 0.00 | 0.00 | | 2024-03-26 01:54:15.45918+00 | | 2024-03-25 10:58:40.221841+00 |
| e202403 | t_presence_history | 56803574 | 616727 | 0.00 | 1.00 | | 2024-03-25 17:43:12.616768+00 | | 2024-03-25 16:50:28.000002+00 |
| e202403 | t_sensor_history | 13548601 | 0 | 0.00 | 0.00 | | 2024-03-24 17:40:25.421364+00 | | 2024-03-26 03:21:38.911099+00 |
| public | __digdag_status | 31 | 36 | 1.00 | 53.00 | | 2024-03-23 12:30:42.587182+00 | | 2024-03-25 12:30:48.680445+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-17 23:58:22.168522+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:33.285588+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:18.012776+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:33.426251+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:33.575014+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:18.055946+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:17.706633+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:30.388655+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:18.078423+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:18.104636+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 | 37 | 0.00 | 5.00 | | 2024-03-14 03:21:00.70595+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 | 1573 | 0 | 0.00 | 0.00 | | 2024-03-14 03:21:00.803336+00 | | |
| public | m_exb | 18082 | 1412 | 0.00 | 7.00 | | 2024-03-19 04:32:14.976828+00 | | 2024-03-26 00:36:16.396918+00 |
| public | m_favorite | 150870 | 3797 | 0.00 | 2.00 | | 2024-03-12 03:24:56.196298+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 | 13459 | 24 | 0.00 | 0.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 | 15752 | 36 | 0.00 | 0.00 | | 2024-03-22 10:03:48.073732+00 | | 2024-03-13 08:59:39.977714+00 |
| public | m_location | 32429 | 3423 | 0.00 | 9.00 | | 2024-03-12 08:32:44.032165+00 | | 2024-03-14 07:34:32.414511+00 |
| public | m_notify_template | 720 | 0 | 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 | 184048 | 33053 | 0.00 | 15.00 | | 2024-03-22 00:07:25.200598+00 | | 2024-03-26 02:06:28.940884+00 |
| public | m_pot_profile | 32576 | 152 | 0.00 | 0.00 | | 2024-03-12 03:01:54.037137+00 | | 2024-02-21 06:28:02.787527+00 |
| public | m_provider_user | 65 | 37 | 0.00 | 36.00 | | 2024-03-12 05:44:28.375723+00 | | 2024-03-26 04:46:38.162939+00 |
| public | m_region | 99 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.478152+00 | | |
| public | m_role | 521 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.452205+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.293842+00 | | |
| public | m_setting | 20395 | 1548 | 0.00 | 7.00 | | 2024-03-25 16:08:34.595922+00 | | 2024-03-25 15:46:03.556506+00 |
| public | m_setting_log | 16069 | 0 | 0.00 | 0.00 | 2024-02-16 03:34:50.060418+00 | 2024-03-25 13:14:18.162824+00 | | 2024-03-25 12:30:54.462141+00 |
| public | m_site | 169 | 2 | 0.00 | 1.00 | | 2024-03-25 13:40:49.322758+00 | | |
| public | m_tenant | 98 | 3 | 0.00 | 2.00 | | 2024-03-25 13:40:49.610812+00 | | |
| public | m_tx | 103461 | 10407 | 0.00 | 9.00 | | 2024-03-26 08:19:50.048898+00 | | 2024-03-26 08:14:49.721267+00 |
| public | m_user | 29191 | 417 | 0.00 | 1.00 | | 2024-03-14 03:21:00.64057+00 | | 2024-02-21 08:40:30.943311+00 |
| public | m_zone | 3976 | 558 | 0.00 | 12.00 | | 2024-03-12 14:52:29.01301+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 | 445 | 0 | 0.00 | 0.00 | | 2024-03-26 01:54:59.165763+00 | | |
| public | r_location_zone | 30906 | 4 | 0.00 | 0.00 | | 2024-03-26 08:40:20.872444+00 | | 2024-03-22 06:57:20.663247+00 |
| public | r_pot_auth | 736 | 21 | 0.00 | 2.00 | | 2024-03-19 07:49:19.870442+00 | | 2024-03-22 09:00:42.270868+00 |
| public | r_pot_category | 24494 | 4838 | 0.00 | 16.00 | | 2024-03-26 06:08:38.55084+00 | | 2024-03-26 06:02:38.563904+00 |
| public | r_pot_group | 92054 | 7460 | 0.00 | 7.00 | | 2024-03-26 03:32:38.050065+00 | | 2024-03-26 08:08:49.689107+00 |
| public | r_pot_tx | 45646 | 283 | 0.00 | 0.00 | | 2024-03-23 05:20:45.184972+00 | | 2024-03-14 07:08:47.394561+00 |
| public | r_pot_user | 18927 | 276 | 0.00 | 1.00 | | 2024-03-18 07:59:58.589614+00 | | 2024-02-21 08:40:30.997445+00 |
| public | r_provider_tenant | 2657 | 0 | 0.00 | 0.00 | | 2024-03-26 05:15:38.269355+00 | | 2024-03-26 04:46:38.148513+00 |
| public | r_role_feature | 5210 | 13 | 0.00 | 0.00 | | 2024-03-18 07:59:58.683711+00 | | 2024-01-18 08:22:54.488926+00 |
| public | r_tenant_feature | 3414 | 0 | 0.00 | 0.00 | | 2024-03-15 22:04:10.814964+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 | 19473 | 273 | 0.00 | 1.00 | | 2024-03-18 07:59:58.252187+00 | | 2024-02-21 08:40:30.42447+00 |
| public | r_user_site | 5274 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.273411+00 | | 2024-03-21 06:04:00.125378+00 |
| public | r_zone_category | 2677 | 26 | 0.00 | 0.00 | | 2024-03-21 01:53:48.778769+00 | | 2024-03-19 07:11:26.414081+00 |
| public | t_attendance | 813050 | 52578 | 0.00 | 6.00 | | 2024-03-15 22:04:36.450789+00 | | 2024-03-15 14:48:00.547674+00 |
| public | t_general | 1549 | 1 | 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 | 414968 | 0 | 0.00 | 0.00 | | 2024-03-13 16:17:25.885227+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 | 2061843 | 56171 | 0.00 | 2.00 | | 2024-03-12 08:33:03.348168+00 | | 2024-03-26 08:36:50.766128+00 |
| public | t_operation_log | 8092109 | 54461 | 0.00 | 0.00 | | 2024-03-21 04:05:06.820866+00 | | 2024-03-17 19:43:32.241009+00 |
| public | t_plan | 9594717 | 1278814 | 0.00 | 11.00 | | 2024-03-22 11:58:48.485839+00 | | 2024-03-26 04:36:41.119596+00 |
| public | t_plan_detail | 15023138 | 2244533 | 0.00 | 12.00 | | 2024-03-25 00:26:54.725669+00 | | 2024-03-26 00:53:17.489569+00 |
| public | t_plan_sync | 25525 | 4929 | 0.00 | 16.00 | | 2024-03-26 03:33:37.985662+00 | | 2024-03-26 04:20:38.273081+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 | 113482 | 1052423 | 9.00 | 90.00 | | 2024-03-26 08:39:50.579464+00 | 2024-03-25 13:30:03.645106+00 | 2024-03-26 08:39:51.142269+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:48.22591+00 | | |
| public | t_terminal | 32682 | 3318 | 0.00 | 9.00 | | 2024-03-24 22:46:15.956068+00 | | 2024-03-26 06:36:03.069346+00 |
| public | t_terminal_log | 5672969 | 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 | 29 | 0.00 | 31.00 | | 2024-03-13 00:30:49.331531+00 | | 2024-03-18 11:28:14.688607+00 |
| public | w_latest_position | 45367 | 323279 | 7.00 | 87.00 | | 2024-03-26 08:39:51.336904+00 | | 2024-03-26 08:39:51.595202+00 |
| public | w_latest_presence | 242365 | 0 | 0.00 | 0.00 | 2024-01-18 12:30:06.016796+00 | 2024-03-25 18:17:37.899519+00 | 2024-01-18 12:30:06.178604+00 | 2024-03-25 18:00:22.247921+00 |
| public | w_latest_sensor | 443 | 3786 | 8.00 | 89.00 | | 2024-03-26 08:40:20.888916+00 | | 2024-03-26 08:40:21.004169+00 |
| public | w_lock | 12061 | 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 | 313 | 7 | 0.00 | 2.00 | | 2024-03-26 08:33:50.038857+00 | | 2024-03-26 08:13:49.554036+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.690522+00 | | |
| public | w_plan_with_detail | 9592325 | 1289360 | 0.00 | 11.00 | | 2024-03-22 11:51:17.769941+00 | | 2024-03-26 03:53:42.846278+00 |