| 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 |
|---|
| e202403 | a_proximity_sum | 676367 | 0 | 0.00 | 0.00 | | 2024-05-05 22:13:03.322856+00 | | |
| e202403 | a_stay_time | 2220202 | 0 | 0.00 | 0.00 | | 2024-05-06 03:26:26.61776+00 | | |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-29 08:52:51.846146+00 | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-29 08:52:52.049269+00 | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-29 07:22:07.028421+00 | | |
| e202403 | t_position_history | 31270591 | 0 | 0.00 | 0.00 | | 2024-05-10 02:50:37.680742+00 | | |
| e202403 | t_presence_history | 9346809 | 0 | 0.00 | 0.00 | | 2024-04-28 12:16:01.883415+00 | | |
| e202403 | t_sensor_history | 1264979 | 0 | 0.00 | 0.00 | | 2024-05-08 07:44:35.541521+00 | | |
| e202404 | a_proximity_sum | 3117539 | 0 | 0.00 | 0.00 | | 2024-05-11 17:34:40.934916+00 | | |
| e202404 | a_stay_time | 2916011 | 0 | 0.00 | 0.00 | | 2024-05-08 09:58:10.817347+00 | | |
| e202404 | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-13 06:53:24.641169+00 | | |
| e202404 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-29 08:52:51.867759+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-29 08:52:51.857188+00 | | |
| e202404 | t_position_history | 47382772 | 0 | 0.00 | 0.00 | | 2024-05-09 19:18:51.210079+00 | | |
| e202404 | t_presence_history | 6707847 | 523461 | 0.00 | 7.00 | | 2024-04-30 14:39:14.793769+00 | | 2024-04-30 14:47:32.149293+00 |
| e202404 | t_sensor_history | 1154996 | 0 | 0.00 | 0.00 | | 2024-05-12 08:14:14.116057+00 | | 2024-04-28 22:43:41.720491+00 |
| e202405 | a_proximity_sum | 794294 | 0 | 0.00 | 0.00 | | 2024-05-13 15:32:04.556966+00 | | 2024-05-13 15:32:05.516544+00 |
| e202405 | a_stay_time | 968118 | 0 | 0.00 | 0.00 | | 2024-05-13 15:32:00.143304+00 | | 2024-05-13 15:32:00.440993+00 |
| e202405 | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-13 06:53:24.652146+00 | | |
| e202405 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-29 08:52:51.910502+00 | | |
| e202405 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-29 08:52:51.889318+00 | | |
| e202405 | t_position_history | 17894491 | 0 | 0.00 | 0.00 | | 2024-05-13 06:51:20.629658+00 | | 2024-05-13 06:51:22.123986+00 |
| e202405 | t_presence_history | 2155386 | 426767 | 0.00 | 16.00 | | 2024-05-14 01:34:52.944534+00 | | 2024-05-14 01:44:06.069423+00 |
| e202405 | t_sensor_history | 558639 | 0 | 0.00 | 0.00 | | 2024-05-13 05:33:44.900679+00 | | 2024-05-13 11:13:51.137684+00 |
| public | __digdag_status | 6 | 35 | 5.00 | 85.00 | | 2024-05-10 21:20:32.998073+00 | | 2024-05-14 00:10:28.594912+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-13 06:47:49.562102+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-05-13 06:47:49.534261+00 | | |
| public | b_attendance_group | 404600 | 878 | 0.00 | 0.00 | | 2024-05-13 06:47:48.401169+00 | | 2024-05-13 17:45:28.28103+00 |
| public | b_attendance_hour | 6063825 | 13534 | 0.00 | 0.00 | | 2024-05-13 11:31:42.923437+00 | | 2024-05-12 18:30:45.192135+00 |
| public | b_attendance_pot | 9942 | 0 | 0.00 | 0.00 | | 2024-05-11 03:20:19.884276+00 | | 2024-05-13 16:50:49.140821+00 |
| public | b_attendance_pot_hour | 148993 | 0 | 0.00 | 0.00 | | 2024-05-07 00:54:09.887491+00 | | 2024-05-12 16:50:22.528655+00 |
| public | b_check_in | 3334330 | 7966 | 0.00 | 0.00 | | 2024-05-13 13:01:21.036564+00 | | 2024-05-13 13:02:16.932229+00 |
| public | b_check_in_hour | 49505919 | 116550 | 0.00 | 0.00 | | 2024-05-13 11:33:27.844926+00 | | 2024-05-13 11:33:31.827589+00 |
| public | b_check_in_pot | 7824 | 0 | 0.00 | 0.00 | | 2024-04-29 08:05:59.109945+00 | | 2024-05-09 16:50:38.573436+00 |
| public | b_check_in_pot_hour | 117412 | 0 | 0.00 | 0.00 | | 2024-05-02 09:20:51.235383+00 | | 2024-05-07 16:51:37.862435+00 |
| public | b_proximity_group | 38142292 | 115416 | 0.00 | 0.00 | | 2024-05-13 12:26:12.512154+00 | | |
| public | b_proximity_info | 32945173 | 0 | 0.00 | 0.00 | | 2024-05-13 11:31:26.817385+00 | | |
| public | b_seat_reserve | 699465 | 1634 | 0.00 | 0.00 | | 2024-05-13 12:05:31.739397+00 | | 2024-05-12 18:34:43.576137+00 |
| public | b_seat_reserve_hour | 13362344 | 29430 | 0.00 | 0.00 | | 2024-05-13 06:47:40.944407+00 | | 2024-05-13 17:38:01.276617+00 |
| public | b_usage | 786818 | 1634 | 0.00 | 0.00 | | 2024-05-13 06:47:52.058825+00 | | 2024-05-13 17:34:00.932987+00 |
| public | b_usage_hour | 14318434 | 29430 | 0.00 | 0.00 | | 2024-05-13 11:26:23.300117+00 | | 2024-05-13 17:46:28.118293+00 |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-13 06:51:22.882359+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-13 06:51:22.871534+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-13 06:51:22.86069+00 | | |
| public | m_area | 97 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.764016+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-05-13 11:31:42.94183+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:52.240305+00 | | |
| public | m_exb | 3790 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.811731+00 | | |
| public | m_favorite | 35793 | 156 | 0.00 | 0.00 | | 2024-05-13 11:33:32.274346+00 | | |
| public | m_feature | 156 | 0 | 0.00 | 0.00 | | 2024-05-13 13:09:31.014217+00 | | |
| public | m_group | 2602 | 14 | 0.00 | 0.00 | | 2024-05-07 20:47:03.410089+00 | | |
| public | m_holiday | 5822 | 0 | 0.00 | 0.00 | | 2024-05-13 06:51:22.909806+00 | | |
| public | m_lob | 2267 | 2 | 0.00 | 0.00 | | 2024-05-13 11:36:31.511653+00 | | |
| public | m_location | 5357 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:49.759572+00 | | |
| public | m_notify_template | 119 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:52.094639+00 | | |
| public | m_outside | 57 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:49.932585+00 | | |
| public | m_pot | 24991 | 956 | 0.00 | 3.00 | | 2024-05-14 00:11:27.389481+00 | | 2024-05-14 00:10:27.876183+00 |
| public | m_pot_profile | 661 | 0 | 0.00 | 0.00 | | 2024-05-13 11:31:27.704216+00 | | |
| public | m_provider_user | 58 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:49.522889+00 | | |
| public | m_region | 15 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.880976+00 | | |
| public | m_role | 76 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.842935+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-05-13 13:01:13.579029+00 | | |
| public | m_setting | 3163 | 196 | 0.00 | 5.00 | | 2024-05-13 06:43:08.789897+00 | | 2024-05-12 23:27:51.26444+00 |
| public | m_setting_log | 4252 | 504 | 0.00 | 10.00 | | 2024-05-11 12:30:46.248512+00 | | 2024-05-13 12:30:17.41953+00 |
| public | m_site | 22 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:52.077075+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:49.480738+00 | | |
| public | m_tx | 14907 | 9 | 0.00 | 0.00 | | 2024-05-08 00:42:47.09624+00 | | 2024-05-08 00:42:47.198469+00 |
| public | m_user | 972 | 1 | 0.00 | 0.00 | | 2024-04-30 03:16:22.394433+00 | | |
| public | m_zone | 742 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:52.286374+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-05-13 12:05:47.720658+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-05-13 13:01:13.556501+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:52.116082+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-05-13 12:05:29.8704+00 | | |
| public | r_location_zone | 4142 | 0 | 0.00 | 0.00 | | 2024-05-13 05:40:53.113325+00 | | |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-05-13 11:31:42.965339+00 | | |
| public | r_pot_category | 973 | 0 | 0.00 | 0.00 | | 2024-05-13 11:36:31.590838+00 | | |
| public | r_pot_group | 11047 | 933 | 0.00 | 7.00 | | 2024-05-13 23:13:33.707757+00 | | 2024-05-13 23:33:37.099313+00 |
| public | r_pot_tx | 8213 | 7 | 0.00 | 0.00 | | 2024-05-13 06:47:52.199425+00 | | |
| public | r_pot_user | 696 | 0 | 0.00 | 0.00 | | 2024-04-30 03:16:22.212029+00 | | |
| public | r_provider_tenant | 189 | 0 | 0.00 | 0.00 | | 2024-05-10 06:33:07.536094+00 | | |
| public | r_role_feature | 692 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.826875+00 | | |
| public | r_tenant_feature | 537 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:49.502293+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:52.217277+00 | | |
| public | r_user_region | 844 | 1 | 0.00 | 0.00 | | 2024-04-30 03:16:22.28958+00 | | |
| public | r_user_site | 737 | 1 | 0.00 | 0.00 | | 2024-04-30 03:16:22.250249+00 | | |
| public | r_zone_category | 665 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:49.550814+00 | | |
| public | t_ai_history | 0 | 0 | 0 | 0 | | 2024-04-30 01:21:03.297853+00 | | |
| public | t_attendance | 429584 | 219 | 0.00 | 0.00 | | 2024-05-13 13:07:01.11428+00 | | |
| public | t_general | 30 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.86548+00 | | |
| public | t_mobile_device_history | 76467 | 0 | 0.00 | 0.00 | | 2024-05-13 07:26:27.003484+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-05-13 06:47:52.126999+00 | | |
| public | t_notify_history | 462129 | 665 | 0.00 | 0.00 | | 2024-05-13 13:07:34.298953+00 | | |
| public | t_operation_log | 1973747 | 344 | 0.00 | 0.00 | | 2024-05-13 07:14:14.014771+00 | | |
| public | t_plan | 4348797 | 27707 | 0.00 | 0.00 | | 2024-05-13 11:35:30.301556+00 | | 2024-05-10 04:28:03.672168+00 |
| public | t_plan_detail | 5157593 | 29932 | 0.00 | 0.00 | | 2024-05-13 13:10:07.054646+00 | | 2024-05-12 23:53:01.206417+00 |
| public | t_plan_sync | 16506 | 1241 | 0.00 | 6.00 | | 2024-05-13 23:33:33.883786+00 | | 2024-05-14 00:52:53.016859+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-05-13 06:47:49.464122+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-05-13 11:25:50.228895+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-05-13 11:36:31.530663+00 | | |
| public | t_recv_position_history | 6923 | 1020 | 0.00 | 12.00 | | 2024-05-14 01:45:04.865495+00 | 2024-05-13 12:42:00.746942+00 | 2024-05-14 01:45:04.900847+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-05-13 11:30:24.044351+00 | | |
| public | t_terminal | 14564 | 1067 | 0.00 | 6.00 | | 2024-05-09 12:35:32.490719+00 | | 2024-05-13 22:17:55.777895+00 |
| public | t_terminal_log | 3741383 | 0 | 0.00 | 0.00 | | 2024-05-13 06:48:01.548953+00 | | |
| public | w_arrival_notify | 1 | 1 | 1.00 | 50.00 | | 2024-05-13 06:53:24.784094+00 | | |
| public | w_latest_position | 10814 | 872 | 0.00 | 7.00 | | 2024-05-14 01:45:04.788687+00 | | 2024-05-14 01:45:04.816301+00 |
| public | w_latest_presence | 17256 | 15982 | 0.00 | 48.00 | | 2024-05-14 01:45:04.99151+00 | | 2024-05-14 01:45:05.077254+00 |
| public | w_latest_sensor | 113 | 71 | 0.00 | 38.00 | | 2024-05-14 01:42:03.210712+00 | | 2024-05-14 01:44:05.008916+00 |
| public | w_lock | 988 | 0 | 0.00 | 0.00 | | 2024-05-13 06:47:48.901898+00 | | |
| public | w_master_update | 15 | 33 | 2.00 | 68.00 | | 2024-05-13 02:08:57.09479+00 | | 2024-05-13 01:54:43.739897+00 |
| public | w_plan_with_detail | 3542023 | 45801 | 0.00 | 1.00 | | 2024-05-13 07:26:21.957432+00 | | 2024-05-09 05:56:08.930435+00 |