| 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 |
|---|
| e202410 | a_proximity_sum | 1081198 | 0 | 0.00 | 0.00 | | 2024-12-14 18:25:35.337564+00 | | 2024-11-07 04:46:59.819351+00 |
| e202410 | a_stay_time | 3183991 | 0 | 0.00 | 0.00 | | 2024-12-13 18:38:35.645031+00 | | 2024-11-07 06:02:52.540901+00 |
| e202410 | t_position_history | 37554973 | 0 | 0.00 | 0.00 | | 2024-12-18 03:10:08.454969+00 | | 2024-10-29 23:37:01.175338+00 |
| e202410 | t_presence_history | 7871276 | 0 | 0.00 | 0.00 | | 2024-12-17 23:43:02.798809+00 | | 2024-10-31 14:52:46.384793+00 |
| e202410 | t_sensor_history | 1232953 | 0 | 0.00 | 0.00 | | 2024-12-17 05:16:48.555795+00 | | 2024-10-29 03:22:14.031407+00 |
| e202411 | a_proximity_sum | 1445166 | 0 | 0.00 | 0.00 | | 2024-12-22 00:08:58.825181+00 | | 2024-11-28 15:35:25.582184+00 |
| e202411 | a_stay_time | 4808444 | 0 | 0.00 | 0.00 | | 2024-12-17 01:23:06.233518+00 | | 2024-11-29 15:31:20.632353+00 |
| e202411 | t_position_history | 35494936 | 0 | 0.00 | 0.00 | | 2024-12-13 18:41:20.416526+00 | | 2024-11-29 08:22:26.529491+00 |
| e202411 | t_presence_history | 8650509 | 0 | 0.00 | 0.00 | | 2024-12-15 23:10:38.749773+00 | | 2024-11-30 14:49:12.174674+00 |
| e202411 | t_sensor_history | 1213954 | 0 | 0.00 | 0.00 | | 2024-12-23 20:58:23.758469+00 | | 2024-11-28 16:35:17.67372+00 |
| e202412 | a_proximity_sum | 1348576 | 0 | 0.00 | 0.00 | | 2024-12-23 17:17:31.329983+00 | | 2024-12-21 15:16:06.786991+00 |
| e202412 | a_stay_time | 3954649 | 0 | 0.00 | 0.00 | | 2024-12-23 15:38:36.704401+00 | | 2024-12-23 17:00:40.65443+00 |
| e202412 | t_position_history | 29812636 | 0 | 0.00 | 0.00 | | 2024-12-20 23:14:49.427433+00 | | 2024-12-24 01:25:03.595215+00 |
| e202412 | t_presence_history | 4874367 | 308702 | 0.00 | 5.00 | | 2024-12-24 01:38:06.605199+00 | | 2024-12-24 01:40:20.005227+00 |
| e202412 | t_sensor_history | 968337 | 0 | 0.00 | 0.00 | | 2024-12-19 19:04:58.70547+00 | | 2024-12-22 20:10:53.639566+00 |
| public | __digdag_status | 12 | 18 | 1.00 | 60.00 | | 2024-12-22 13:10:03.938095+00 | | 2024-12-20 21:20:07.197098+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2024-12-17 00:33:56.135471+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-12-14 13:08:53.151624+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-12-14 12:52:16.980027+00 | | |
| public | b_attendance_group | 569166 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:49.800713+00 | | 2024-12-07 17:45:04.626746+00 |
| public | b_attendance_hour | 8882603 | 0 | 0.00 | 0.00 | | 2024-12-14 23:24:11.065489+00 | | 2024-12-06 17:40:29.428151+00 |
| public | b_attendance_pot | 427072 | 0 | 0.00 | 0.00 | | 2024-12-20 08:24:50.572701+00 | | 2024-12-17 18:36:08.862871+00 |
| public | b_attendance_pot_hour | 6635853 | 0 | 0.00 | 0.00 | | 2024-12-19 07:48:36.854332+00 | | 2024-12-12 18:20:48.299836+00 |
| public | b_check_in | 4467532 | 0 | 0.00 | 0.00 | | 2024-12-15 00:42:50.665961+00 | | 2024-12-10 17:42:39.967486+00 |
| public | b_check_in_hour | 68054113 | 0 | 0.00 | 0.00 | | 2024-12-14 23:25:59.573933+00 | | 2024-12-13 17:31:51.541713+00 |
| public | b_check_in_pot | 198228 | 0 | 0.00 | 0.00 | | 2024-12-21 10:30:22.779613+00 | | 2024-12-14 18:26:36.74616+00 |
| public | b_check_in_pot_hour | 4095812 | 0 | 0.00 | 0.00 | | 2024-12-20 01:57:54.83856+00 | | 2024-12-22 16:51:20.392897+00 |
| public | b_proximity_group | 39438501 | 0 | 0.00 | 0.00 | | 2024-12-15 00:23:42.715452+00 | | 2024-12-20 17:42:57.939951+00 |
| public | b_proximity_info | 34173351 | 0 | 0.00 | 0.00 | | 2024-12-21 10:21:21.233029+00 | | 2024-11-27 17:51:03.911928+00 |
| public | b_seat_reserve | 1025657 | 0 | 0.00 | 0.00 | | 2024-12-14 23:48:19.151677+00 | | 2024-11-22 17:46:01.568763+00 |
| public | b_seat_reserve_hour | 19431057 | 0 | 0.00 | 0.00 | | 2024-12-14 12:51:48.954448+00 | | 2024-11-24 17:48:14.117716+00 |
| public | b_usage | 1143926 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.00419+00 | | 2024-11-19 12:16:20.249407+00 |
| public | b_usage_hour | 21175038 | 0 | 0.00 | 0.00 | | 2024-12-14 23:13:17.343413+00 | | 2024-11-20 17:36:08.827222+00 |
| public | m_area | 97 | 0 | 0.00 | 0.00 | | 2024-12-15 01:11:17.690965+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-12-14 23:32:00.095173+00 | | |
| public | m_category | 488 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.120266+00 | | |
| public | m_exb | 3804 | 0 | 0.00 | 0.00 | | 2024-12-19 06:46:23.303567+00 | | 2024-11-20 14:17:58.996858+00 |
| public | m_favorite | 35507 | 24 | 0.00 | 0.00 | | 2024-12-23 10:16:56.950186+00 | | 2024-12-03 06:11:37.005424+00 |
| public | m_favorite_group | 8257 | 14 | 0.00 | 0.00 | | 2024-12-16 18:33:55.401759+00 | | 2024-12-09 00:27:50.393044+00 |
| public | m_feature | 165 | 0 | 0.00 | 0.00 | | 2024-12-15 01:11:17.673733+00 | | |
| public | m_group | 2333 | 0 | 0.00 | 0.00 | | 2024-12-23 18:35:51.784621+00 | | |
| public | m_holiday | 5566 | 0 | 0.00 | 0.00 | | 2024-12-14 13:09:31.340822+00 | | |
| public | m_lob | 1180 | 1 | 0.00 | 0.00 | | 2024-12-23 17:57:45.171864+00 | | |
| public | m_lob_log | 11 | 0 | 0.00 | 0.00 | | 2024-12-18 15:30:46.54005+00 | | |
| public | m_location | 5487 | 0 | 0.00 | 0.00 | | 2024-12-23 18:35:51.846164+00 | | 2024-11-25 04:16:30.357563+00 |
| public | m_notify_template | 132 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.046948+00 | | |
| public | m_outside | 67 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:50.487801+00 | | |
| public | m_pot | 26477 | 2014 | 0.00 | 7.00 | | 2024-12-24 00:10:21.536903+00 | | 2024-12-24 01:37:09.442972+00 |
| public | m_pot_profile | 701 | 25 | 0.00 | 3.00 | | 2024-12-14 23:23:45.104404+00 | | 2024-12-20 07:31:42.338095+00 |
| public | m_provider_user | 59 | 12 | 0.00 | 16.00 | | 2024-12-14 13:08:50.452272+00 | | |
| public | m_region | 18 | 0 | 0.00 | 0.00 | | 2024-12-15 00:51:44.097319+00 | | |
| public | m_role | 83 | 0 | 0.00 | 0.00 | | 2024-12-15 01:10:49.055077+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-12-15 00:42:43.872885+00 | | |
| public | m_setting | 2427 | 415 | 0.00 | 14.00 | | 2024-12-22 03:43:37.433322+00 | | 2024-12-23 05:31:15.479607+00 |
| public | m_setting_log | 5055 | 212 | 0.00 | 4.00 | | 2024-12-22 12:36:25.853619+00 | | 2024-12-23 12:30:05.616993+00 |
| public | m_site | 27 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.023944+00 | | |
| public | m_tenant | 18 | 1 | 0.00 | 5.00 | | 2024-12-14 13:08:50.415256+00 | | |
| public | m_tx | 42960 | 1 | 0.00 | 0.00 | | 2024-12-20 12:12:16.059474+00 | | 2024-12-03 01:44:45.328615+00 |
| public | m_user | 3419 | 1 | 0.00 | 0.00 | | 2024-12-17 09:55:38.530318+00 | | 2024-12-17 09:55:38.578628+00 |
| public | m_zone | 892 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.139885+00 | | 2024-11-19 15:09:07.905763+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-12-14 23:52:18.903257+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-12-15 00:42:43.85157+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.068478+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-12-14 23:48:18.772744+00 | | |
| public | r_location_zone | 5596 | 0 | 0.00 | 0.00 | | 2024-12-18 19:31:37.47618+00 | | 2024-11-27 05:28:47.354369+00 |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-12-14 23:32:00.115728+00 | | |
| public | r_pot_category | 991 | 6 | 0.00 | 0.00 | | 2024-12-14 23:32:00.168292+00 | | |
| public | r_pot_group | 10804 | 1479 | 0.00 | 12.00 | | 2024-12-23 21:05:24.587498+00 | | 2024-12-23 23:33:13.666431+00 |
| public | r_pot_tx | 10285 | 13 | 0.00 | 0.00 | | 2024-12-18 03:58:08.266209+00 | | |
| public | r_pot_user | 3046 | 1 | 0.00 | 0.00 | | 2024-12-15 09:39:21.900222+00 | | |
| public | r_provider_tenant | 165 | 0 | 0.00 | 0.00 | | 2024-12-23 11:02:13.365218+00 | | 2024-12-23 11:02:13.369756+00 |
| public | r_role_feature | 602 | 0 | 0.00 | 0.00 | | 2024-12-23 13:17:17.01454+00 | | |
| public | r_tenant_feature | 682 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:50.43313+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.10145+00 | | |
| public | r_user_region | 3104 | 1 | 0.00 | 0.00 | | 2024-12-15 09:39:21.928453+00 | | |
| public | r_user_site | 355 | 0 | 0.00 | 0.00 | | 2024-12-21 10:21:24.234939+00 | | |
| public | r_zone_category | 775 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:50.470895+00 | | 2024-11-19 15:09:07.863079+00 |
| public | t_ai_history | 35 | 0 | 0.00 | 0.00 | | 2024-12-16 07:07:10.914555+00 | | |
| public | t_attendance | 428711 | 9291 | 0.00 | 2.00 | | 2024-12-15 01:10:49.037504+00 | | 2024-12-15 01:11:17.652309+00 |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2024-12-15 00:51:44.079403+00 | | |
| public | t_mobile_device_history | 120364 | 0 | 0.00 | 0.00 | | 2024-12-14 14:50:57.190184+00 | | 2024-11-13 08:18:57.025024+00 |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-12-14 13:08:53.07957+00 | | |
| public | t_notify_history | 610713 | 5234 | 0.00 | 0.00 | | 2024-12-15 00:51:48.596696+00 | | 2024-12-20 01:11:29.422244+00 |
| public | t_operation_log | 2290440 | 2 | 0.00 | 0.00 | | 2024-12-14 13:32:41.3255+00 | | 2024-11-25 02:59:20.632326+00 |
| public | t_plan | 4724750 | 370806 | 0.00 | 7.00 | | 2024-12-13 17:10:07.643767+00 | | 2024-12-21 06:45:01.285154+00 |
| public | t_plan_detail | 5845608 | 355396 | 0.00 | 5.00 | | 2024-12-17 10:22:13.278963+00 | | 2024-12-22 07:19:48.508316+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-12-16 22:07:23.613692+00 | | |
| public | t_plan_sync | 233591 | 22063 | 0.00 | 8.00 | | 2024-12-20 09:12:08.7192+00 | | 2024-12-23 09:18:30.268162+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-12-14 13:08:50.395991+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-12-14 23:12:43.777033+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-12-14 23:32:00.134644+00 | | |
| public | t_recv_position_history | 8137 | 2971 | 0.00 | 26.00 | | 2024-12-24 01:44:42.477938+00 | 2024-12-23 12:42:01.633073+00 | 2024-12-24 01:44:42.532396+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-12-14 23:13:17.389328+00 | | |
| public | t_terminal | 25216 | 1801 | 0.00 | 6.00 | | 2024-12-18 19:54:06.876178+00 | | 2024-12-24 01:19:02.879232+00 |
| public | t_terminal_log | 5390740 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:59.781963+00 | | 2024-12-04 20:05:43.670536+00 |
| public | w_arrival_notify | 1 | 5 | 5.00 | 83.00 | | 2024-12-14 13:10:39.326698+00 | | 2024-11-19 00:27:39.742116+00 |
| public | w_latest_position | 11489 | 1609 | 0.00 | 12.00 | | 2024-12-24 01:44:42.342094+00 | | 2024-12-24 01:44:42.374092+00 |
| public | w_latest_presence | 17541 | 31127 | 1.00 | 63.00 | | 2024-12-24 01:44:42.645808+00 | | 2024-12-24 01:44:42.757913+00 |
| public | w_latest_sensor | 161 | 72 | 0.00 | 30.00 | | 2024-12-24 01:43:20.074405+00 | | 2024-12-24 01:42:19.668379+00 |
| public | w_lock | 1115 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:50.060558+00 | | |
| public | w_master_update | 18 | 23 | 1.00 | 56.00 | | 2024-12-23 06:00:35.175462+00 | | 2024-12-23 03:56:33.251641+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2024-12-21 10:19:49.109325+00 | | |
| public | w_plan_with_detail | 4719001 | 33936 | 0.00 | 0.00 | | 2024-12-23 11:19:52.032112+00 | | 2024-12-21 06:09:58.242126+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-12-16 20:56:58.424241+00 | | |