| 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 |
|---|
| e202312 | a_proximity_sum | 29521865 | 0 | 0.00 | 0.00 | | 2024-01-31 17:10:08.547786+00 | | 2023-12-29 12:50:02.455693+00 |
| e202312 | a_stay_time | 17019683 | 0 | 0.00 | 0.00 | | 2024-01-22 01:44:52.307376+00 | | 2023-12-29 15:07:06.176602+00 |
| e202312 | l_position_history | 0 | 0 | 0 | 0 | | 2024-01-27 22:32:29.513253+00 | | |
| e202312 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-27 22:32:29.502436+00 | | |
| e202312 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-01-27 22:32:29.491556+00 | | |
| e202312 | t_position_history | 322267522 | 0 | 0.00 | 0.00 | | 2024-01-30 02:06:19.225522+00 | | 2023-12-30 17:24:31.17066+00 |
| e202312 | t_presence_history | 54449810 | 0 | 0.00 | 0.00 | | 2024-01-29 00:44:49.31426+00 | | 2023-12-31 14:43:53.221525+00 |
| e202312 | t_sensor_history | 11898437 | 4043 | 0.00 | 0.00 | | 2024-01-20 10:26:38.021132+00 | | 2023-12-29 13:16:55.682719+00 |
| e202401 | a_proximity_sum | 27175641 | 86838 | 0.00 | 0.00 | | 2024-01-31 16:20:59.837737+00 | | 2024-01-30 15:14:06.375164+00 |
| e202401 | a_stay_time | 17178510 | 160826 | 0.00 | 0.00 | | 2024-01-29 17:15:20.16429+00 | | 2024-01-30 15:11:06.159905+00 |
| e202401 | l_position_history | 0 | 0 | 0 | 0 | | 2024-01-31 17:45:32.534218+00 | | |
| e202401 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-31 17:45:32.556084+00 | | |
| e202401 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-01-31 17:45:32.54524+00 | | |
| e202401 | t_position_history | 338630571 | 1570816 | 0.00 | 0.00 | | 2024-01-27 22:24:30.122039+00 | | 2024-01-30 10:26:24.358574+00 |
| e202401 | t_presence_history | 38115824 | 5085737 | 0.00 | 11.00 | | 2024-01-31 14:30:04.060397+00 | | 2024-01-31 15:07:30.056064+00 |
| e202401 | t_sensor_history | 14056711 | 452 | 0.00 | 0.00 | | 2024-01-30 02:08:27.967697+00 | | 2024-01-30 12:58:27.389928+00 |
| e202402 | a_proximity_sum | 996257 | 0 | 0.00 | 0.00 | | 2024-02-01 16:21:31.708563+00 | | 2024-02-01 17:58:38.672552+00 |
| e202402 | a_stay_time | 835705 | 0 | 0.00 | 0.00 | | 2024-02-01 17:10:39.060066+00 | | 2024-02-01 18:01:38.457768+00 |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-01-20 13:52:26.936119+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-20 13:52:27.002551+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-01-20 13:52:26.980578+00 | | |
| e202402 | t_position_history | 25648236 | 0 | 0.00 | 0.00 | | 2024-02-02 04:18:21.283458+00 | | 2024-02-02 07:35:50.071147+00 |
| e202402 | t_presence_history | 2906128 | 130475 | 0.00 | 4.00 | | 2024-02-02 07:37:59.190792+00 | | 2024-02-02 07:38:50.088102+00 |
| e202402 | t_sensor_history | 824045 | 0 | 0.00 | 0.00 | | 2024-02-02 04:00:48.123424+00 | | 2024-02-02 04:47:53.58501+00 |
| public | __digdag_status | 9 | 8 | 0.00 | 47.00 | | 2024-02-01 12:30:13.986576+00 | | 2024-02-01 12:30:13.987059+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:18.831309+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:18.819354+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.614273+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:55.551944+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.527472+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:55.576229+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:55.597084+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.548568+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.505634+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.6382+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.569612+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.59112+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:19.469496+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:19.45835+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:19.447248+00 | | |
| public | m_area | 622 | 8 | 0.00 | 1.00 | | 2024-01-30 00:23:30.956475+00 | | 2024-01-18 08:43:32.882494+00 |
| public | m_auth | 84 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:18.849777+00 | | |
| public | m_category | 1577 | 0 | 0.00 | 0.00 | | 2024-01-30 00:23:31.030972+00 | | |
| public | m_exb | 18556 | 290 | 0.00 | 1.00 | | 2024-01-24 08:20:27.009168+00 | | 2024-01-31 23:41:48.109481+00 |
| public | m_favorite | 145701 | 1145 | 0.00 | 0.00 | | 2024-01-27 02:50:24.98761+00 | | 2024-01-18 07:33:40.519402+00 |
| public | m_feature | 150 | 0 | 0.00 | 0.00 | | 2024-01-26 23:33:07.371313+00 | | |
| public | m_group | 13413 | 593 | 0.00 | 4.00 | | 2024-01-18 17:40:08.645201+00 | | 2024-01-01 03:10:40.774873+00 |
| public | m_holiday | 15697 | 0 | 0.00 | 0.00 | | 2024-01-26 02:30:50.318248+00 | | 2024-02-01 01:01:41.977654+00 |
| public | m_lob | 17908 | 101 | 0.00 | 0.00 | | 2024-01-23 14:35:24.314694+00 | | 2024-01-26 12:24:11.753833+00 |
| public | m_location | 33008 | 875 | 0.00 | 2.00 | | 2024-01-27 17:20:22.386337+00 | | 2024-01-18 01:18:56.165985+00 |
| public | m_notify_template | 716 | 5 | 0.00 | 0.00 | | 2024-01-26 04:46:18.963043+00 | | 2023-12-25 06:37:18.875076+00 |
| public | m_outside | 267 | 2 | 0.00 | 0.00 | | 2024-01-21 04:00:18.87303+00 | | |
| public | m_pot | 263235 | 18449 | 0.00 | 6.00 | | 2024-01-31 13:22:30.527119+00 | | 2024-02-01 23:48:39.089673+00 |
| public | m_pot_profile | 30597 | 91 | 0.00 | 0.00 | | 2024-01-26 23:50:08.210301+00 | | 2024-01-17 00:25:12.254289+00 |
| public | m_provider_user | 24 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.018706+00 | | |
| public | m_region | 97 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.077118+00 | | |
| public | m_role | 511 | 2 | 0.00 | 0.00 | | 2024-01-26 04:46:19.060964+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:18.888729+00 | | |
| public | m_setting | 10647 | 1978 | 0.00 | 15.00 | | 2024-02-02 04:29:53.07026+00 | | 2024-02-02 06:07:00.668798+00 |
| public | m_setting_log | 76486 | 0 | 0.00 | 0.00 | | 2024-02-02 00:48:56.41229+00 | | 2024-02-02 00:47:55.202099+00 |
| public | m_site | 164 | 1 | 0.00 | 0.00 | | 2024-01-26 04:46:18.914137+00 | | |
| public | m_tenant | 96 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.200989+00 | | |
| public | m_tx | 80583 | 14540 | 0.00 | 15.00 | | 2024-02-01 09:13:12.688507+00 | | 2024-02-01 09:56:12.59535+00 |
| public | m_user | 28521 | 318 | 0.00 | 1.00 | | 2024-01-29 22:25:54.409086+00 | | 2024-01-21 00:05:10.573968+00 |
| public | m_zone | 5793 | 12 | 0.00 | 0.00 | | 2024-01-28 04:25:04.123964+00 | | 2024-01-23 03:36:19.668472+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:18.784599+00 | | |
| public | r_auth_zone | 184 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:18.86803+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:18.995069+00 | | |
| public | r_group_auth | 431 | 0 | 0.00 | 0.00 | | 2024-01-26 08:30:47.979591+00 | | |
| public | r_location_zone | 31541 | 4426 | 0.00 | 12.00 | | 2024-01-23 03:48:20.164491+00 | | 2024-01-26 02:44:41.849652+00 |
| public | r_pot_auth | 687 | 3 | 0.00 | 0.00 | | 2024-01-19 23:20:21.985998+00 | | |
| public | r_pot_category | 5884 | 0 | 0.00 | 0.00 | | 2024-02-02 06:08:00.587084+00 | | 2024-02-02 06:02:00.680036+00 |
| public | r_pot_group | 92336 | 6838 | 0.00 | 6.00 | | 2024-02-02 03:10:43.838899+00 | | 2024-02-02 06:02:00.645926+00 |
| public | r_pot_tx | 44625 | 1852 | 0.00 | 3.00 | | 2024-01-24 03:20:57.089596+00 | | 2024-02-02 05:46:00.55509+00 |
| public | r_pot_user | 18588 | 329 | 0.00 | 1.00 | | 2024-01-18 22:28:38.567983+00 | | 2024-01-11 06:16:34.031162+00 |
| public | r_role_feature | 5320 | 6 | 0.00 | 0.00 | | 2024-01-18 17:40:08.437341+00 | | 2024-01-18 08:22:54.488926+00 |
| public | r_tenant_feature | 3275 | 0 | 0.00 | 0.00 | | 2024-01-31 13:22:22.062717+00 | | |
| public | r_tx_sensor | 455 | 91 | 0.00 | 16.00 | | 2024-01-20 10:25:11.836697+00 | | 2024-01-27 01:38:23.792244+00 |
| public | r_user_region | 19119 | 331 | 0.00 | 1.00 | | 2024-01-18 22:28:38.377932+00 | | 2024-01-11 06:16:33.903871+00 |
| public | r_user_site | 5217 | 99 | 0.00 | 1.00 | | 2024-01-26 04:18:33.478269+00 | | 2024-01-11 06:16:33.979684+00 |
| public | r_zone_category | 2826 | 324 | 0.00 | 10.00 | | 2024-01-22 01:43:51.497834+00 | | 2024-01-23 05:12:39.85601+00 |
| public | t_attendance | 686998 | 10563 | 0.00 | 1.00 | | 2024-01-31 13:22:46.058086+00 | | 2024-02-01 18:38:38.896522+00 |
| public | t_general | 1279 | 5 | 0.00 | 0.00 | | 2024-01-26 04:46:19.184577+00 | | 2024-01-29 01:00:49.959426+00 |
| public | t_mobile_device_history | 371356 | 0 | 0.00 | 0.00 | | 2024-01-29 09:35:08.449742+00 | | 2024-01-05 09:31:07.694373+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.039732+00 | | |
| public | t_notify_history | 1812033 | 31649 | 0.00 | 1.00 | | 2024-01-27 17:50:51.673848+00 | | 2024-01-25 22:05:12.19766+00 |
| public | t_operation_log | 7328778 | 149214 | 0.00 | 1.00 | | 2024-01-22 04:54:40.973434+00 | | 2024-01-30 04:47:46.888304+00 |
| public | t_plan | 8617802 | 828137 | 0.00 | 8.00 | | 2024-01-28 22:53:07.879863+00 | | 2024-02-01 01:40:45.449067+00 |
| public | t_plan_detail | 13575624 | 323408 | 0.00 | 2.00 | | 2024-02-01 05:51:30.210964+00 | | 2024-02-02 01:36:00.62873+00 |
| public | t_plan_sync | 24886 | 4223 | 0.00 | 14.00 | | 2024-02-02 03:33:46.74422+00 | | 2024-02-02 03:33:46.931793+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.226001+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:18.796329+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:19.098026+00 | | |
| public | t_recv_position_history | 112515 | 20384 | 0.00 | 15.00 | | 2024-02-02 07:38:51.609752+00 | 2024-02-01 12:30:04.012873+00 | 2024-02-02 07:38:51.921467+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:18.807623+00 | | |
| public | t_terminal | 18115 | 2168 | 0.00 | 10.00 | | 2024-01-30 03:34:15.818288+00 | | 2024-02-02 06:35:54.102684+00 |
| public | t_terminal_log | 4391561 | 0 | 0.00 | 0.00 | | 2024-01-21 17:23:20.847235+00 | | 2024-01-23 00:05:24.194059+00 |
| public | w_arrival_notify | 64 | 29 | 0.00 | 31.00 | | 2024-01-28 13:19:14.955948+00 | | 2024-02-02 01:09:58.955174+00 |
| public | w_latest_position | 42266 | 7115 | 0.00 | 14.00 | | 2024-02-02 07:38:50.171681+00 | | 2024-02-02 07:38:50.267461+00 |
| public | w_latest_presence | 184266 | 38612 | 0.00 | 17.00 | 2024-01-18 12:30:06.016796+00 | 2024-02-02 07:38:50.56896+00 | 2024-01-18 12:30:06.178604+00 | 2024-02-02 07:38:50.94139+00 |
| public | w_latest_sensor | 393 | 281 | 0.00 | 41.00 | | 2024-02-02 07:38:50.998155+00 | | 2024-02-02 07:38:51.111057+00 |
| public | w_lock | 10965 | 0 | 0.00 | 0.00 | | 2024-02-02 02:31:46.868393+00 | | 2024-01-31 02:02:19.791893+00 |
| public | w_master_update | 96 | 49 | 0.00 | 33.00 | | 2024-02-02 05:25:00.276627+00 | | 2024-02-02 07:05:49.02252+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.487935+00 | | |
| public | w_plan_with_detail | 8639508 | 1121089 | 0.00 | 11.00 | | 2024-01-24 07:59:32.637322+00 | | 2024-02-01 01:55:51.351257+00 |