| 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 |
|---|
| e202409 | a_proximity_sum | 881161 | 0 | 0.00 | 0.00 | | 2024-11-02 20:26:16.444993+00 | | |
| e202409 | a_stay_time | 2549792 | 0 | 0.00 | 0.00 | | 2024-11-01 05:09:51.913601+00 | | |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-01 06:44:26.8741+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-01 06:44:26.855516+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-01 06:44:44.855543+00 | | |
| e202409 | t_position_history | 30787930 | 0 | 0.00 | 0.00 | | 2024-10-29 01:17:53.199012+00 | | |
| e202409 | t_presence_history | 6027195 | 0 | 0.00 | 0.00 | | 2024-11-01 17:42:58.958968+00 | | |
| e202409 | t_sensor_history | 1163362 | 0 | 0.00 | 0.00 | | 2024-11-01 02:55:43.301618+00 | | |
| e202410 | a_proximity_sum | 1036281 | 0 | 0.00 | 0.00 | | 2024-10-31 17:01:33.766561+00 | | 2024-10-30 15:32:18.858546+00 |
| e202410 | a_stay_time | 3104064 | 0 | 0.00 | 0.00 | | 2024-10-28 09:36:46.005156+00 | | 2024-10-30 15:31:17.628148+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-01 12:18:33.260613+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-01 12:18:33.242983+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-01 12:18:21.465801+00 | | |
| e202410 | t_position_history | 37799870 | 0 | 0.00 | 0.00 | | 2024-10-31 05:27:45.93225+00 | | 2024-10-29 23:37:01.175338+00 |
| e202410 | t_presence_history | 6478696 | 534360 | 0.00 | 7.00 | | 2024-10-31 14:43:28.235734+00 | | 2024-10-31 14:52:46.384793+00 |
| e202410 | t_sensor_history | 1268926 | 0 | 0.00 | 0.00 | | 2024-10-30 07:40:04.115722+00 | | 2024-10-29 03:22:14.031407+00 |
| e202411 | a_proximity_sum | 38192 | 0 | 0.00 | 0.00 | | 2024-11-01 17:00:58.289055+00 | | 2024-11-01 17:25:59.6545+00 |
| e202411 | a_stay_time | 127100 | 0 | 0.00 | 0.00 | | 2024-11-01 17:00:58.133032+00 | | 2024-11-02 17:00:23.839063+00 |
| e202411 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-25 11:20:11.891693+00 | | |
| e202411 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-25 11:20:11.946973+00 | | |
| e202411 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-25 11:19:31.058484+00 | | |
| e202411 | t_position_history | 2031846 | 0 | 0.00 | 0.00 | | 2024-11-03 07:42:47.59874+00 | | 2024-11-03 22:54:42.232948+00 |
| e202411 | t_presence_history | 352992 | 12338 | 0.00 | 3.00 | | 2024-11-04 01:45:06.858845+00 | | 2024-11-04 01:45:07.198563+00 |
| e202411 | t_sensor_history | 142221 | 0 | 0.00 | 0.00 | | 2024-11-03 12:58:40.045485+00 | | 2024-11-03 21:35:20.258427+00 |
| public | __digdag_status | 7 | 33 | 4.00 | 82.00 | | 2024-10-31 21:20:08.959718+00 | | 2024-11-01 13:10:36.454379+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2024-10-30 03:27:18.099277+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:55.147438+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-10-28 08:14:35.379014+00 | | |
| public | b_attendance_group | 494473 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.372943+00 | | |
| public | b_attendance_hour | 7421909 | 0 | 0.00 | 0.00 | | 2024-10-28 11:23:46.743681+00 | | |
| public | b_attendance_pot | 284857 | 0 | 0.00 | 0.00 | | 2024-11-03 12:46:40.012239+00 | | 2024-11-03 18:40:54.764031+00 |
| public | b_attendance_pot_hour | 4414886 | 0 | 0.00 | 0.00 | | 2024-11-02 13:34:06.928641+00 | | 2024-11-03 18:38:54.558776+00 |
| public | b_check_in | 3983791 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:31.544344+00 | | |
| public | b_check_in_hour | 59785681 | 0 | 0.00 | 0.00 | | 2024-10-28 11:24:04.27664+00 | | |
| public | b_check_in_pot | 151887 | 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 | 2920326 | 0 | 0.00 | 0.00 | | 2024-11-02 22:52:23.712868+00 | | 2024-11-01 18:26:05.689469+00 |
| public | b_proximity_group | 33308380 | 0 | 0.00 | 0.00 | | 2024-10-28 12:11:21.020351+00 | | |
| public | b_proximity_info | 29697141 | 0 | 0.00 | 0.00 | | 2024-10-25 02:16:16.54021+00 | | |
| public | b_seat_reserve | 900263 | 0 | 0.00 | 0.00 | | 2024-10-28 11:42:26.31841+00 | | |
| public | b_seat_reserve_hour | 16900186 | 0 | 0.00 | 0.00 | | 2024-10-28 08:14:35.244134+00 | | |
| public | b_usage | 1011742 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.850154+00 | | |
| public | b_usage_hour | 18514193 | 0 | 0.00 | 0.00 | | 2024-10-28 11:14:40.66615+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-28 08:20:37.601081+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-28 08:20:37.583442+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-28 08:21:00.98664+00 | | |
| public | m_area | 93 | 0 | 0.00 | 0.00 | | 2024-10-28 12:33:18.585557+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-10-28 11:28:05.307697+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.941145+00 | | |
| public | m_exb | 4297 | 15 | 0.00 | 0.00 | | 2024-10-28 00:31:57.781913+00 | | |
| public | m_favorite | 35319 | 350 | 0.00 | 0.00 | | 2024-10-27 09:43:20.750605+00 | | 2024-10-08 09:37:31.834203+00 |
| public | m_favorite_group | 7569 | 12 | 0.00 | 0.00 | | 2024-10-30 01:37:29.427463+00 | | 2024-10-25 08:55:40.648705+00 |
| public | m_feature | 165 | 0 | 0.00 | 0.00 | | 2024-10-28 12:42:32.844822+00 | | |
| public | m_group | 2320 | 1 | 0.00 | 0.00 | | 2024-10-27 18:33:14.838391+00 | | |
| public | m_holiday | 5588 | 0 | 0.00 | 0.00 | | 2024-10-28 08:20:37.621813+00 | | |
| public | m_lob | 1169 | 11 | 0.00 | 0.00 | | 2024-10-27 18:33:15.040979+00 | | |
| public | m_location | 5434 | 23 | 0.00 | 0.00 | | 2024-10-27 18:33:14.965317+00 | | |
| public | m_notify_template | 124 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.904151+00 | | |
| public | m_outside | 63 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.163872+00 | | |
| public | m_pot | 26123 | 43 | 0.00 | 0.00 | | 2024-11-04 00:10:52.190952+00 | | 2024-11-04 00:10:53.057733+00 |
| public | m_pot_profile | 674 | 26 | 0.00 | 3.00 | | 2024-10-28 11:23:43.470573+00 | | 2024-10-31 01:38:07.653388+00 |
| public | m_provider_user | 59 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.118745+00 | | |
| public | m_region | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 12:32:17.633999+00 | | |
| public | m_role | 79 | 0 | 0.00 | 0.00 | | 2024-10-28 12:33:18.568388+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:30.439106+00 | | |
| public | m_setting | 3537 | 60 | 0.00 | 1.00 | | 2024-11-03 18:39:53.37716+00 | | 2024-11-03 05:48:38.040525+00 |
| public | m_setting_log | 4799 | 866 | 0.00 | 15.00 | | 2024-10-30 12:30:30.821522+00 | | 2024-11-03 07:04:39.466355+00 |
| public | m_site | 26 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.885637+00 | | |
| public | m_tenant | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.082778+00 | | |
| public | m_tx | 27346 | 2131 | 0.00 | 7.00 | | 2024-11-01 08:53:27.27751+00 | | 2024-11-01 08:52:27.085739+00 |
| public | m_user | 3253 | 2 | 0.00 | 0.00 | | 2024-10-28 23:56:22.596594+00 | | |
| public | m_zone | 751 | 3 | 0.00 | 0.00 | | 2024-10-28 08:17:55.23092+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-10-28 11:43:25.973878+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:30.418866+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.187193+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-10-28 11:42:25.984069+00 | | |
| public | r_location_zone | 5983 | 28 | 0.00 | 0.00 | | 2024-11-01 00:12:39.448777+00 | | |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-10-28 11:28:05.330443+00 | | |
| public | r_pot_category | 989 | 9 | 0.00 | 0.00 | | 2024-10-28 11:27:05.306361+00 | | |
| public | r_pot_group | 12701 | 1134 | 0.00 | 8.00 | | 2024-11-03 23:13:39.13748+00 | | 2024-11-03 23:32:39.739793+00 |
| public | r_pot_tx | 10152 | 11 | 0.00 | 0.00 | | 2024-10-31 06:05:20.606701+00 | | |
| public | r_pot_user | 3024 | 1 | 0.00 | 0.00 | | 2024-10-28 23:56:22.497034+00 | | |
| public | r_provider_tenant | 161 | 0 | 0.00 | 0.00 | | 2024-11-03 11:16:09.184287+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-28 08:17:55.101252+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.208593+00 | | |
| public | r_user_region | 3082 | 2 | 0.00 | 0.00 | | 2024-10-28 23:56:22.536161+00 | | |
| public | r_user_site | 356 | 1 | 0.00 | 0.00 | | 2024-10-25 01:57:04.488697+00 | | |
| public | r_zone_category | 684 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.135814+00 | | |
| public | t_ai_history | 33 | 0 | 0.00 | 0.00 | | 2024-10-29 11:21:06.475001+00 | | |
| public | t_attendance | 376130 | 6107 | 0.00 | 1.00 | | 2024-10-28 12:33:25.971598+00 | | 2024-10-31 08:47:16.370632+00 |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2024-10-28 12:32:17.617736+00 | | |
| public | t_mobile_device_history | 96796 | 0 | 0.00 | 0.00 | | 2024-10-28 08:45:04.064105+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:36.915455+00 | | |
| public | t_notify_history | 538711 | 6251 | 0.00 | 1.00 | | 2024-10-28 12:32:19.904995+00 | | 2024-10-24 15:03:15.635118+00 |
| public | t_operation_log | 2456160 | 0 | 0.00 | 0.00 | | 2024-10-28 08:31:04.238095+00 | | |
| public | t_plan | 4113069 | 265923 | 0.00 | 6.00 | | 2024-10-28 01:39:53.550293+00 | | 2024-10-29 21:03:39.044527+00 |
| public | t_plan_detail | 5024691 | 138907 | 0.00 | 2.00 | | 2024-10-30 17:43:19.08068+00 | | 2024-10-31 12:21:34.234277+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-10-30 02:04:11.585106+00 | | |
| public | t_plan_sync | 233321 | 12651 | 0.00 | 5.00 | | 2024-11-03 07:46:14.898937+00 | | 2024-11-03 09:26:32.723875+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:55.066068+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-10-28 11:14:33.256327+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-10-28 11:27:05.267224+00 | | |
| public | t_recv_position_history | 5557 | 1193 | 0.00 | 17.00 | | 2024-11-04 01:45:07.234817+00 | 2024-11-03 12:42:00.720531+00 | 2024-11-04 01:45:07.258522+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-10-28 11:16:33.309088+00 | | |
| public | t_terminal | 22812 | 937 | 0.00 | 3.00 | | 2024-11-01 00:15:46.15212+00 | | 2024-11-04 01:25:06.786068+00 |
| public | t_terminal_log | 4954154 | 0 | 0.00 | 0.00 | | 2024-10-28 08:18:00.652956+00 | | |
| public | w_arrival_notify | 1 | 4 | 4.00 | 80.00 | | 2024-10-28 08:21:01.038349+00 | | |
| public | w_latest_position | 10692 | 1543 | 0.00 | 12.00 | | 2024-11-04 01:35:06.381127+00 | | 2024-11-04 01:43:06.177253+00 |
| public | w_latest_presence | 17229 | 11553 | 0.00 | 40.00 | | 2024-11-04 01:45:07.337514+00 | | 2024-11-04 01:45:07.432556+00 |
| public | w_latest_sensor | 163 | 11 | 0.00 | 6.00 | | 2024-11-04 01:45:06.161678+00 | | 2024-11-04 01:44:06.397963+00 |
| public | w_lock | 1052 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:54.791118+00 | | |
| public | w_master_update | 17 | 18 | 1.00 | 51.00 | | 2024-11-03 06:11:38.737543+00 | | 2024-11-01 23:13:01.37262+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_with_detail | 4103312 | 299810 | 0.00 | 6.00 | | 2024-10-27 11:32:59.532396+00 | | 2024-10-29 16:59:03.742098+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-10-30 01:51:29.897995+00 | | |