| 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 | 696334 | 0 | 0.00 | 0.00 | | 2024-10-23 05:05:14.726333+00 | | |
| e202408 | a_stay_time | 2193491 | 0 | 0.00 | 0.00 | | 2024-10-24 06:16:41.971728+00 | | |
| e202408 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-22 09:00:43.977145+00 | | |
| e202408 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-22 09:00:43.910163+00 | | |
| e202408 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-22 09:04:32.088993+00 | | |
| e202408 | t_position_history | 27712893 | 0 | 0.00 | 0.00 | | 2024-10-23 08:29:42.311325+00 | | |
| e202408 | t_presence_history | 5120369 | 0 | 0.00 | 0.00 | | 2024-10-23 02:22:09.056223+00 | | |
| e202408 | t_sensor_history | 1196033 | 0 | 0.00 | 0.00 | | 2024-10-25 08:55:40.607438+00 | | |
| e202409 | a_proximity_sum | 881183 | 0 | 0.00 | 0.00 | | 2024-10-24 06:28:40.754451+00 | | |
| e202409 | a_stay_time | 2549850 | 0 | 0.00 | 0.00 | | 2024-10-23 06:13:12.199913+00 | | |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-23 07:39:13.00901+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-23 07:39:12.668384+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-23 07:39:12.65064+00 | | |
| e202409 | t_position_history | 30787971 | 0 | 0.00 | 0.00 | | 2024-10-19 11:39:42.131949+00 | | |
| e202409 | t_presence_history | 6027245 | 0 | 0.00 | 0.00 | | 2024-10-23 19:40:41.836733+00 | | |
| e202409 | t_sensor_history | 1163403 | 0 | 0.00 | 0.00 | | 2024-10-23 04:19:21.634993+00 | | |
| e202410 | a_proximity_sum | 834239 | 0 | 0.00 | 0.00 | | 2024-10-23 15:31:30.599655+00 | | 2024-10-24 16:45:39.816931+00 |
| e202410 | a_stay_time | 2558935 | 0 | 0.00 | 0.00 | | 2024-10-23 15:31:33.923102+00 | | 2024-10-24 15:30:22.142813+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-23 13:25:55.121278+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-23 13:25:55.091311+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-23 13:25:55.102664+00 | | |
| e202410 | t_position_history | 31255910 | 0 | 0.00 | 0.00 | | 2024-10-26 21:39:52.653923+00 | | 2024-10-24 05:32:59.714122+00 |
| e202410 | t_presence_history | 5467093 | 977690 | 0.00 | 15.00 | | 2024-10-28 01:19:24.012667+00 | | 2024-10-28 01:42:11.135005+00 |
| e202410 | t_sensor_history | 1144132 | 0 | 0.00 | 0.00 | | 2024-10-26 04:54:00.361152+00 | | 2024-10-26 11:51:25.733128+00 |
| public | __digdag_status | 11 | 16 | 1.00 | 59.00 | | 2024-10-26 13:10:33.422244+00 | | 2024-10-25 13:15:51.029834+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2024-10-21 05:49:05.680757+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-18 11:41:47.427459+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-10-18 11:34:58.913253+00 | | |
| public | b_attendance_group | 484437 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:46.702357+00 | | |
| public | b_attendance_hour | 7255278 | 0 | 0.00 | 0.00 | | 2024-10-18 20:50:59.585913+00 | | |
| public | b_attendance_pot | 265019 | 0 | 0.00 | 0.00 | | 2024-10-24 16:17:19.106803+00 | | 2024-10-24 18:41:00.274672+00 |
| public | b_attendance_pot_hour | 4105058 | 0 | 0.00 | 0.00 | | 2024-10-24 05:08:57.742587+00 | | 2024-10-24 18:41:04.314104+00 |
| public | b_check_in | 3911071 | 0 | 0.00 | 0.00 | | 2024-10-18 22:56:20.634781+00 | | |
| public | b_check_in_hour | 58664712 | 0 | 0.00 | 0.00 | | 2024-10-18 20:55:57.32376+00 | | |
| public | b_check_in_pot | 145314 | 0 | 0.00 | 0.00 | | 2024-10-25 02:17:18.464078+00 | | 2024-10-22 18:20:35.817639+00 |
| public | b_check_in_pot_hour | 2775514 | 0 | 0.00 | 0.00 | | 2024-10-24 07:00:42.188658+00 | | 2024-10-19 18:26:52.270677+00 |
| public | b_proximity_group | 33453758 | 0 | 0.00 | 0.00 | | 2024-10-18 22:37:42.211505+00 | | |
| public | b_proximity_info | 29218861 | 0 | 0.00 | 0.00 | | 2024-10-25 02:16:16.54021+00 | | |
| public | b_seat_reserve | 881617 | 0 | 0.00 | 0.00 | | 2024-10-18 22:01:00.123058+00 | | |
| public | b_seat_reserve_hour | 16547472 | 0 | 0.00 | 0.00 | | 2024-10-18 11:34:23.671424+00 | | |
| public | b_usage | 989898 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.830698+00 | | |
| public | b_usage_hour | 18112795 | 0 | 0.00 | 0.00 | | 2024-10-18 20:22:02.756621+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-18 11:48:46.403754+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-18 11:48:46.38682+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-18 11:48:46.369373+00 | | |
| public | m_area | 93 | 0 | 0.00 | 0.00 | | 2024-10-18 23:05:02.700026+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-10-18 21:08:34.886653+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.946068+00 | | |
| public | m_exb | 4297 | 0 | 0.00 | 0.00 | | 2024-10-28 00:31:57.781913+00 | | |
| public | m_favorite | 35343 | 16 | 0.00 | 0.00 | | 2024-10-27 09:43:20.750605+00 | | 2024-10-08 09:37:31.834203+00 |
| public | m_favorite_group | 7435 | 17 | 0.00 | 0.00 | | 2024-10-21 04:04:25.885158+00 | | 2024-10-25 08:55:40.648705+00 |
| public | m_feature | 165 | 0 | 0.00 | 0.00 | | 2024-10-18 23:11:08.207042+00 | | |
| public | m_group | 2320 | 0 | 0.00 | 0.00 | | 2024-10-27 18:33:14.838391+00 | | |
| public | m_holiday | 5606 | 0 | 0.00 | 0.00 | | 2024-10-18 11:48:46.422316+00 | | |
| public | m_lob | 1173 | 0 | 0.00 | 0.00 | | 2024-10-27 18:33:15.040979+00 | | |
| public | m_location | 5434 | 0 | 0.00 | 0.00 | | 2024-10-27 18:33:14.965317+00 | | |
| public | m_notify_template | 124 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.871604+00 | | |
| public | m_outside | 63 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.444876+00 | | |
| public | m_pot | 28452 | 1039 | 0.00 | 3.00 | | 2024-10-28 00:37:59.565058+00 | | 2024-10-28 00:10:51.380357+00 |
| public | m_pot_profile | 671 | 19 | 0.00 | 2.00 | | 2024-10-18 20:31:03.714661+00 | | |
| public | m_provider_user | 59 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.396612+00 | | |
| public | m_region | 17 | 0 | 0.00 | 0.00 | | 2024-10-18 23:04:02.678976+00 | | |
| public | m_role | 79 | 0 | 0.00 | 0.00 | | 2024-10-18 23:05:02.685343+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-10-18 22:56:19.520896+00 | | |
| public | m_setting | 3526 | 68 | 0.00 | 1.00 | | 2024-10-27 19:22:22.248284+00 | | 2024-10-27 13:04:50.263761+00 |
| public | m_setting_log | 4793 | 430 | 0.00 | 8.00 | | 2024-10-25 12:30:21.440925+00 | | 2024-10-26 20:52:03.232116+00 |
| public | m_site | 26 | 1 | 0.00 | 3.00 | | 2024-10-18 11:41:47.847214+00 | | |
| public | m_tenant | 17 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.361075+00 | | |
| public | m_tx | 38503 | 0 | 0.00 | 0.00 | | 2024-10-27 03:50:28.181989+00 | | 2024-10-17 11:05:09.379783+00 |
| public | m_user | 3268 | 1 | 0.00 | 0.00 | | 2024-10-19 07:50:39.929351+00 | | |
| public | m_zone | 751 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.96724+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-10-18 22:01:44.657563+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-10-18 22:56:19.500945+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.893544+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-10-18 22:00:59.796889+00 | | |
| public | r_location_zone | 6026 | 0 | 0.00 | 0.00 | | 2024-10-23 01:46:03.830481+00 | | |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-10-18 21:08:34.912746+00 | | |
| public | r_pot_category | 991 | 1 | 0.00 | 0.00 | | 2024-10-18 21:07:34.865057+00 | | |
| public | r_pot_group | 11759 | 1043 | 0.00 | 8.00 | | 2024-10-27 23:12:29.868376+00 | | 2024-10-27 23:33:44.316378+00 |
| public | r_pot_tx | 9621 | 8 | 0.00 | 0.00 | | 2024-10-22 07:55:20.160319+00 | | |
| public | r_pot_user | 3023 | 1 | 0.00 | 0.00 | | 2024-10-19 07:50:39.868916+00 | | |
| public | r_provider_tenant | 161 | 0 | 0.00 | 0.00 | | 2024-10-24 13:27:47.373242+00 | | |
| public | r_role_feature | 598 | 0 | 0.00 | 0.00 | | 2024-10-27 13:31:54.74472+00 | | |
| public | r_tenant_feature | 645 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.377025+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.926178+00 | | |
| public | r_user_region | 3081 | 1 | 0.00 | 0.00 | | 2024-10-19 07:50:39.889441+00 | | |
| public | r_user_site | 356 | 0 | 0.00 | 0.00 | | 2024-10-25 01:57:04.488697+00 | | |
| public | r_zone_category | 684 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.416062+00 | | |
| public | t_ai_history | 33 | 0 | 0.00 | 0.00 | | 2024-10-20 20:42:01.970975+00 | | |
| public | t_attendance | 553382 | 7850 | 0.00 | 1.00 | | 2024-10-18 23:06:07.866429+00 | | |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2024-10-18 23:04:02.662027+00 | | |
| public | t_mobile_device_history | 97150 | 0 | 0.00 | 0.00 | | 2024-10-18 12:41:05.542495+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-10-18 11:41:47.904546+00 | | |
| public | t_notify_history | 523253 | 3450 | 0.00 | 0.00 | | 2024-10-18 23:04:05.006716+00 | | 2024-10-24 15:03:15.635118+00 |
| public | t_operation_log | 2391891 | 2 | 0.00 | 0.00 | | 2024-10-18 12:10:43.282728+00 | | |
| public | t_plan | 4015691 | 826 | 0.00 | 0.00 | | 2024-10-28 01:39:53.550293+00 | | 2024-10-24 23:52:45.99256+00 |
| public | t_plan_detail | 4873995 | 259330 | 0.00 | 5.00 | | 2024-10-22 00:17:42.365363+00 | | 2024-10-25 08:55:40.536146+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-10-21 04:31:29.420299+00 | | |
| public | t_plan_sync | 233285 | 25936 | 0.00 | 10.00 | | 2024-10-24 10:49:15.456696+00 | | 2024-10-27 23:11:29.566501+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-10-18 11:41:47.344337+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-10-18 20:21:37.941096+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-10-18 21:07:34.832323+00 | | |
| public | t_recv_position_history | 6853 | 1404 | 0.00 | 17.00 | | 2024-10-28 01:45:18.729435+00 | 2024-10-27 12:42:01.284441+00 | 2024-10-28 01:45:18.757416+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-10-18 20:27:03.518657+00 | | |
| public | t_terminal | 22476 | 1447 | 0.00 | 6.00 | | 2024-10-23 01:49:04.40845+00 | | 2024-10-28 01:43:19.389225+00 |
| public | t_terminal_log | 4910748 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:52.917379+00 | | |
| public | w_arrival_notify | 1 | 5 | 5.00 | 83.00 | | 2024-10-18 11:49:46.395962+00 | | |
| public | w_latest_position | 10678 | 671 | 0.00 | 5.00 | | 2024-10-28 01:45:18.53888+00 | | 2024-10-28 01:45:18.565044+00 |
| public | w_latest_presence | 17138 | 13282 | 0.00 | 43.00 | | 2024-10-28 01:45:18.865192+00 | | 2024-10-28 01:45:18.966082+00 |
| public | w_latest_sensor | 113 | 51 | 0.00 | 31.00 | | 2024-10-28 01:43:18.338782+00 | | 2024-10-28 01:43:18.57061+00 |
| public | w_lock | 1052 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.022601+00 | | |
| public | w_master_update | 17 | 16 | 0.00 | 48.00 | | 2024-10-27 12:32:28.07476+00 | | 2024-10-26 12:13:16.209058+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_with_detail | 4011996 | 28402 | 0.00 | 0.00 | | 2024-10-27 11:32:59.532396+00 | | 2024-10-24 23:51:44.591601+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-10-21 04:18:12.159276+00 | | |