| 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 |
|---|
| e202407 | a_proximity_sum | 57513523 | 0 | 0.00 | 0.00 | | 2024-09-24 09:51:23.293879+00 | | 2024-07-31 16:14:46.361131+00 |
| e202407 | a_stay_time | 22349429 | 0 | 0.00 | 0.00 | | 2024-09-17 12:42:37.274851+00 | | 2024-07-30 16:11:02.317159+00 |
| e202407 | l_position_history | 0 | 0 | 0 | 0 | | 2024-09-25 09:01:43.588449+00 | | |
| e202407 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-09-25 09:39:13.711487+00 | | |
| e202407 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-09-25 09:39:13.70056+00 | | |
| e202407 | t_position_history | 487838333 | 0 | 0.00 | 0.00 | | 2024-09-25 19:17:08.12394+00 | | 2024-07-31 10:21:16.05463+00 |
| e202407 | t_presence_history | 45607062 | 0 | 0.00 | 0.00 | | 2024-09-25 09:28:51.282964+00 | | 2024-07-31 14:45:34.349214+00 |
| e202407 | t_sensor_history | 9292506 | 0 | 0.00 | 0.00 | | 2024-09-19 02:26:24.682611+00 | | 2024-07-31 04:22:01.085006+00 |
| e202408 | a_proximity_sum | 37770870 | 0 | 0.00 | 0.00 | | 2024-09-17 17:07:32.610152+00 | | 2024-08-30 18:04:15.752996+00 |
| e202408 | a_stay_time | 23715448 | 0 | 0.00 | 0.00 | | 2024-09-26 00:22:22.294226+00 | | 2024-08-29 16:01:01.429933+00 |
| e202408 | l_position_history | 0 | 0 | 0 | 0 | | 2024-09-25 01:21:46.410911+00 | | |
| e202408 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-09-25 01:21:46.433277+00 | | |
| e202408 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-09-25 01:21:46.422294+00 | | |
| e202408 | t_position_history | 443790052 | 0 | 0.00 | 0.00 | | 2024-09-25 01:31:44.00429+00 | | 2024-08-30 04:23:42.833544+00 |
| e202408 | t_presence_history | 45854744 | 0 | 0.00 | 0.00 | | 2024-09-25 08:19:50.628561+00 | | 2024-08-31 14:39:59.767121+00 |
| e202408 | t_sensor_history | 8983483 | 0 | 0.00 | 0.00 | | 2024-09-24 20:50:58.915027+00 | | 2024-08-31 12:53:22.897625+00 |
| e202409 | a_proximity_sum | 37951763 | 0 | 0.00 | 0.00 | | 2024-09-23 16:12:55.619997+00 | | 2024-09-24 17:34:36.114083+00 |
| e202409 | a_stay_time | 18839345 | 0 | 0.00 | 0.00 | | 2024-09-25 16:27:28.529927+00 | | 2024-09-25 17:25:36.159465+00 |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-09-25 22:51:46.453552+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-09-25 22:51:46.475627+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-09-25 22:51:46.464711+00 | | |
| e202409 | t_position_history | 382692462 | 0 | 0.00 | 0.00 | | 2024-09-23 23:22:08.115889+00 | | 2024-09-25 13:08:40.778493+00 |
| e202409 | t_presence_history | 39907634 | 6281045 | 0.00 | 13.00 | | 2024-09-26 00:13:09.133303+00 | | 2024-09-26 00:44:30.211107+00 |
| e202409 | t_sensor_history | 7768591 | 0 | 0.00 | 0.00 | | 2024-09-21 21:23:31.153004+00 | | 2024-09-25 21:41:53.410789+00 |
| public | __digdag_status | 31 | 8 | 0.00 | 20.00 | | 2024-09-25 08:30:51.807504+00 | | 2024-09-23 12:30:34.710699+00 |
| public | a_attendance_sum | 25828 | 4092 | 0.00 | 13.00 | | 2024-09-26 00:43:32.283718+00 | | 2024-09-26 00:47:29.960033+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-09-18 12:22:30.838062+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-09-18 12:22:24.752879+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-09-20 10:04:16.043793+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-09-20 10:04:17.048206+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-09-20 10:03:42.895056+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-09-20 10:04:17.070104+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-09-20 10:04:17.090141+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-09-20 10:03:42.916408+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-09-20 10:03:42.872102+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-09-20 10:04:16.06646+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-09-20 10:03:42.937589+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-09-20 10:03:42.959822+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-09-18 12:22:31.29625+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-09-18 12:22:31.285286+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-09-18 12:22:31.274281+00 | | |
| public | m_area | 658 | 13 | 0.00 | 1.00 | | 2024-09-20 06:54:50.139649+00 | | 2024-09-22 07:28:40.141859+00 |
| public | m_auth | 118 | 2 | 0.00 | 1.00 | | 2024-09-18 12:22:30.861986+00 | | |
| public | m_category | 1724 | 18 | 0.00 | 1.00 | | 2024-09-20 06:54:50.101344+00 | | 2024-06-25 09:59:15.889653+00 |
| public | m_exb | 20869 | 899 | 0.00 | 4.00 | | 2024-09-18 07:58:25.297815+00 | | 2024-09-24 09:02:43.621131+00 |
| public | m_favorite | 175126 | 662 | 0.00 | 0.00 | | 2024-09-19 04:10:00.823565+00 | | 2024-09-17 01:02:37.332475+00 |
| public | m_feature | 163 | 1 | 0.00 | 0.00 | | 2024-09-19 02:49:30.893134+00 | | |
| public | m_group | 17299 | 26 | 0.00 | 0.00 | | 2024-09-24 02:52:16.481531+00 | | 2024-07-10 09:58:42.085372+00 |
| public | m_holiday | 26385 | 0 | 0.00 | 0.00 | | 2024-09-17 00:40:14.13159+00 | | 2024-07-08 03:20:43.009936+00 |
| public | m_lob | 21471 | 55 | 0.00 | 0.00 | | 2024-09-17 04:43:18.63752+00 | | 2024-08-10 12:19:11.748312+00 |
| public | m_location | 37566 | 60 | 0.00 | 0.00 | | 2024-09-24 12:47:27.307979+00 | | 2024-09-24 09:18:23.731916+00 |
| public | m_notify_template | 731 | 9 | 0.00 | 1.00 | | 2024-09-18 12:22:31.02157+00 | | 2024-08-29 07:15:16.864762+00 |
| public | m_outside | 315 | 0 | 0.00 | 0.00 | | 2024-09-25 02:51:26.430895+00 | | 2024-07-03 01:58:21.092861+00 |
| public | m_pot | 158538 | 27015 | 0.00 | 14.00 | | 2024-09-24 23:52:38.812641+00 | | 2024-09-25 23:55:40.056682+00 |
| public | m_pot_profile | 43639 | 81 | 0.00 | 0.00 | | 2024-09-17 12:42:31.029834+00 | | 2024-08-23 08:02:32.125598+00 |
| public | m_provider_user | 71 | 0 | 0.00 | 0.00 | | 2024-09-19 03:21:52.588486+00 | | 2024-09-06 06:53:59.132463+00 |
| public | m_region | 97 | 0 | 0.00 | 0.00 | | 2024-09-18 12:22:31.104007+00 | | |
| public | m_role | 553 | 2 | 0.00 | 0.00 | | 2024-09-18 12:22:31.087406+00 | | 2024-09-24 06:40:14.717909+00 |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-09-18 12:22:30.960548+00 | | |
| public | m_setting | 19810 | 268 | 0.00 | 1.00 | | 2024-09-25 19:57:08.573984+00 | | 2024-09-24 22:18:48.390575+00 |
| public | m_setting_log | 27722 | 0 | 0.00 | 0.00 | | 2024-09-22 15:20:11.096397+00 | | 2024-09-25 16:55:23.173063+00 |
| public | m_site | 175 | 2 | 0.00 | 1.00 | | 2024-09-18 12:22:30.980354+00 | | |
| public | m_tenant | 96 | 0 | 0.00 | 0.00 | | 2024-09-18 12:22:31.237075+00 | | |
| public | m_tx | 98609 | 8118 | 0.00 | 7.00 | | 2024-09-25 00:56:38.092244+00 | | 2024-09-25 16:35:35.75488+00 |
| public | m_user | 30245 | 322 | 0.00 | 1.00 | | 2024-09-20 06:54:20.103492+00 | | 2024-07-29 08:16:48.223752+00 |
| public | m_zone | 5437 | 32 | 0.00 | 0.00 | | 2024-09-19 08:34:26.195133+00 | | 2024-09-10 09:55:19.944808+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-09-18 12:22:23.856752+00 | | |
| public | r_auth_zone | 219 | 2 | 0.00 | 0.00 | | 2024-09-20 00:18:57.935981+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-09-18 12:22:31.043821+00 | | |
| public | r_group_auth | 477 | 0 | 0.00 | 0.00 | | 2024-09-21 20:25:10.258028+00 | | 2024-07-04 08:10:27.0311+00 |
| public | r_location_zone | 42143 | 56 | 0.00 | 0.00 | | 2024-09-25 08:03:09.048954+00 | | 2024-09-01 06:57:06.227452+00 |
| public | r_pot_auth | 6586 | 146 | 0.00 | 2.00 | | 2024-09-18 18:01:18.030825+00 | | 2024-09-13 09:05:03.972169+00 |
| public | r_pot_category | 6989 | 1 | 0.00 | 0.00 | | 2024-09-25 20:09:59.508565+00 | | 2024-09-25 20:01:08.137333+00 |
| public | r_pot_group | 147195 | 3365 | 0.00 | 2.00 | | 2024-09-26 00:37:29.618562+00 | | 2024-09-26 00:20:25.183887+00 |
| public | r_pot_tx | 56432 | 1708 | 0.00 | 2.00 | | 2024-09-17 10:24:46.623225+00 | | 2024-09-24 08:17:18.823526+00 |
| public | r_pot_user | 18605 | 306 | 0.00 | 1.00 | | 2024-09-24 02:52:16.267035+00 | | 2024-07-29 08:16:54.122769+00 |
| public | r_provider_tenant | 2886 | 0 | 0.00 | 0.00 | | 2024-09-19 23:20:48.177636+00 | | 2024-09-10 06:55:03.549051+00 |
| public | r_role_feature | 5139 | 13 | 0.00 | 0.00 | | 2024-09-24 02:52:16.29128+00 | | 2024-07-17 09:12:16.595823+00 |
| public | r_tenant_feature | 3499 | 0 | 0.00 | 0.00 | | 2024-09-20 10:03:36.843423+00 | | 2024-07-03 07:47:27.286426+00 |
| public | r_tx_sensor | 327 | 0 | 0.00 | 0.00 | | 2024-09-23 18:27:51.321753+00 | | 2024-05-08 03:36:41.526083+00 |
| public | r_user_region | 19578 | 303 | 0.00 | 1.00 | | 2024-09-24 02:52:09.292573+00 | | 2024-07-26 08:18:26.23685+00 |
| public | r_user_site | 5106 | 8 | 0.00 | 0.00 | | 2024-09-18 12:22:30.939058+00 | | 2024-06-28 09:33:34.486007+00 |
| public | r_zone_category | 3320 | 0 | 0.00 | 0.00 | | 2024-09-25 07:51:52.085345+00 | | 2024-09-10 09:55:19.881206+00 |
| public | t_ai_history | 7 | 0 | 0.00 | 0.00 | | 2024-09-22 18:38:46.663815+00 | | |
| public | t_attendance | 1370307 | 27270 | 0.00 | 1.00 | | 2024-09-20 10:04:08.915445+00 | | 2024-09-21 19:11:06.477953+00 |
| public | t_general | 2506 | 16 | 0.00 | 0.00 | | 2024-09-18 12:22:31.223711+00 | | 2024-09-11 10:45:57.392285+00 |
| public | t_mobile_device_history | 646862 | 0 | 0.00 | 0.00 | | 2024-09-20 02:00:26.190265+00 | | 2024-09-25 00:00:31.986407+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-09-18 12:22:31.065141+00 | | |
| public | t_notify_history | 2984389 | 35977 | 0.00 | 1.00 | | 2024-09-19 06:17:42.145175+00 | | 2024-09-19 22:05:29.508494+00 |
| public | t_operation_log | 11053106 | 1 | 0.00 | 0.00 | | 2024-09-25 09:01:43.574878+00 | | 2024-09-05 20:45:16.520916+00 |
| public | t_plan | 12298343 | 775529 | 0.00 | 5.00 | | 2024-09-23 08:04:20.884743+00 | | 2024-09-25 03:40:43.975472+00 |
| public | t_plan_detail | 21413730 | 2671366 | 0.00 | 11.00 | | 2024-09-17 02:24:19.063429+00 | | 2024-09-26 00:49:24.807834+00 |
| public | t_plan_sync | 71860 | 4153 | 0.00 | 5.00 | | 2024-09-26 00:38:29.107412+00 | | 2024-09-26 00:36:28.765098+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-09-18 12:22:31.263126+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-09-18 12:22:23.868321+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-09-18 12:22:31.12262+00 | | |
| public | t_recv_position_history | 127093 | 108731 | 0.00 | 46.00 | | 2024-09-26 00:49:30.709512+00 | 2024-09-25 13:30:06.795743+00 | 2024-09-26 00:49:31.210083+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-09-18 12:22:23.894714+00 | | |
| public | t_terminal | 92210 | 4345 | 0.00 | 4.00 | | 2024-09-17 10:24:47.954911+00 | | 2024-09-26 00:18:25.321245+00 |
| public | t_terminal_log | 10842758 | 0 | 0.00 | 0.00 | | 2024-09-25 05:15:39.759022+00 | | 2024-09-19 08:24:31.396176+00 |
| public | w_arrival_notify | 89 | 60 | 0.00 | 40.00 | | 2024-09-22 15:01:13.088793+00 | | 2024-09-25 22:50:46.440155+00 |
| public | w_latest_position | 60797 | 24807 | 0.00 | 28.00 | | 2024-09-26 00:49:31.351458+00 | | 2024-09-26 00:49:31.479528+00 |
| public | w_latest_presence | 229059 | 180029 | 0.00 | 44.00 | | 2024-09-26 00:49:34.48914+00 | | 2024-09-26 00:49:35.101503+00 |
| public | w_latest_sensor | 344 | 233 | 0.00 | 40.00 | | 2024-09-26 00:49:31.496161+00 | | 2024-09-26 00:49:31.607045+00 |
| public | w_lock | 14353 | 0 | 0.00 | 0.00 | | 2024-09-24 00:17:50.519449+00 | | 2024-08-21 00:53:41.629677+00 |
| public | w_master_update | 96 | 62 | 0.00 | 39.00 | | 2024-09-26 00:05:35.49598+00 | | 2024-09-26 00:37:29.632237+00 |
| public | w_migration | 824 | 0 | 0.00 | 0.00 | | 2024-09-18 12:22:31.319565+00 | | |
| public | w_plan_with_detail | 12323659 | 1264212 | 0.00 | 9.00 | | 2024-09-19 03:52:22.571351+00 | | 2024-09-24 23:58:26.964018+00 |