| 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-04-27 04:34:48.989022+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 | 47382771 | 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 | 693411 | 0 | 0.00 | 0.00 | | 2024-05-10 15:31:45.621192+00 | | 2024-05-12 15:31:03.116763+00 |
| e202405 | a_stay_time | 830993 | 0 | 0.00 | 0.00 | | 2024-05-10 15:30:46.003769+00 | | 2024-05-12 15:31:02.199011+00 |
| e202405 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-27 04:34:48.9995+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 | 15812263 | 0 | 0.00 | 0.00 | | 2024-05-10 08:29:18.249146+00 | | 2024-05-12 09:21:13.386979+00 |
| e202405 | t_presence_history | 1839922 | 353272 | 0.00 | 16.00 | | 2024-05-13 01:36:57.322952+00 | | 2024-05-13 01:41:44.254714+00 |
| e202405 | t_sensor_history | 517719 | 0 | 0.00 | 0.00 | | 2024-05-10 21:50:31.609321+00 | | 2024-05-12 04:36:35.638936+00 |
| public | __digdag_status | 10 | 24 | 2.00 | 70.00 | | 2024-05-10 21:20:32.998073+00 | | 2024-05-10 13:10:13.780381+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-27 04:21:48.124104+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-04-27 04:21:48.093268+00 | | |
| public | b_attendance_group | 399315 | 14048 | 0.00 | 3.00 | | 2024-04-27 04:21:46.855858+00 | | |
| public | b_attendance_hour | 6234764 | 214769 | 0.00 | 3.00 | | 2024-04-27 12:54:23.1972+00 | | 2024-05-12 18:30:45.192135+00 |
| public | b_attendance_pot | 9805 | 0 | 0.00 | 0.00 | | 2024-05-11 03:20:19.884276+00 | | 2024-05-04 16:51:10.756998+00 |
| public | b_attendance_pot_hour | 147283 | 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 | 3118769 | 127436 | 0.00 | 3.00 | | 2024-04-27 16:05:34.07516+00 | | |
| public | b_check_in_hour | 46938850 | 1864434 | 0.00 | 3.00 | | 2024-04-27 12:56:12.806505+00 | | |
| public | b_check_in_pot | 7710 | 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 | 115702 | 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 | 39435931 | 1846196 | 0.00 | 4.00 | | 2024-04-27 14:17:33.231406+00 | | |
| public | b_proximity_info | 32759829 | 81208 | 0.00 | 0.00 | | 2024-04-27 12:53:02.28603+00 | | |
| public | b_seat_reserve | 722537 | 26144 | 0.00 | 3.00 | | 2024-04-27 13:40:34.045315+00 | | 2024-05-12 18:34:43.576137+00 |
| public | b_seat_reserve_hour | 13012071 | 470886 | 0.00 | 3.00 | | 2024-04-27 04:21:35.072132+00 | | |
| public | b_usage | 755142 | 26144 | 0.00 | 3.00 | | 2024-04-27 04:21:50.591384+00 | | |
| public | b_usage_hour | 13987249 | 470886 | 0.00 | 3.00 | | 2024-04-27 12:50:25.050434+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-27 04:29:03.365758+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-27 04:29:02.959444+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-27 04:29:03.355288+00 | | |
| public | m_area | 97 | 0 | 0.00 | 0.00 | | 2024-04-27 16:19:34.564157+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-04-27 12:54:23.426303+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:50.960543+00 | | |
| public | m_exb | 3790 | 0 | 0.00 | 0.00 | | 2024-04-27 16:19:34.607517+00 | | |
| public | m_favorite | 35867 | 375 | 0.00 | 1.00 | | 2024-04-27 12:59:13.478363+00 | | |
| public | m_feature | 156 | 0 | 0.00 | 0.00 | | 2024-04-27 16:20:56.956253+00 | | |
| public | m_group | 2602 | 6 | 0.00 | 0.00 | | 2024-05-07 20:47:03.410089+00 | | |
| public | m_holiday | 5843 | 0 | 0.00 | 0.00 | | 2024-04-27 04:29:06.076724+00 | | |
| public | m_lob | 2268 | 7 | 0.00 | 0.00 | | 2024-04-27 13:01:32.791772+00 | | |
| public | m_location | 5357 | 12 | 0.00 | 0.00 | | 2024-04-27 04:21:48.267369+00 | | |
| public | m_notify_template | 119 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:50.783768+00 | | |
| public | m_outside | 57 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:48.283371+00 | | |
| public | m_pot | 23763 | 1136 | 0.00 | 4.00 | | 2024-05-13 00:10:33.754432+00 | | 2024-05-13 00:10:34.519425+00 |
| public | m_pot_profile | 661 | 8 | 0.00 | 1.00 | | 2024-04-27 12:54:04.853263+00 | | |
| public | m_provider_user | 58 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:48.082503+00 | | |
| public | m_region | 15 | 0 | 0.00 | 0.00 | | 2024-04-27 16:19:34.684008+00 | | |
| public | m_role | 76 | 0 | 0.00 | 0.00 | | 2024-04-27 16:19:34.644294+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-04-27 16:05:24.02556+00 | | |
| public | m_setting | 2122 | 422 | 0.00 | 16.00 | | 2024-05-11 09:27:36.296442+00 | | 2024-05-12 23:27:51.26444+00 |
| public | m_setting_log | 4252 | 254 | 0.00 | 5.00 | | 2024-05-11 12:30:46.248512+00 | | 2024-05-12 12:30:36.991684+00 |
| public | m_site | 22 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:50.756745+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:48.041341+00 | | |
| public | m_tx | 14906 | 2 | 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 | 15 | 0.00 | 1.00 | | 2024-04-27 04:21:51.002699+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-04-27 13:40:34.124404+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-04-27 16:05:24.007345+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:50.805478+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-04-27 13:40:31.711147+00 | | |
| public | r_location_zone | 3365 | 13 | 0.00 | 0.00 | | 2024-04-27 02:02:19.79073+00 | | |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-04-27 12:54:23.448789+00 | | |
| public | r_pot_category | 972 | 13 | 0.00 | 1.00 | | 2024-04-27 13:01:32.850493+00 | | |
| public | r_pot_group | 10527 | 679 | 0.00 | 6.00 | | 2024-05-12 23:13:50.094915+00 | | 2024-05-12 23:33:54.571331+00 |
| public | r_pot_tx | 8218 | 34 | 0.00 | 0.00 | | 2024-04-27 04:21:50.913478+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-04-27 16:19:34.628209+00 | | |
| public | r_tenant_feature | 537 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:48.062665+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:50.930547+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 | 15 | 0.00 | 2.00 | | 2024-04-27 04:21:48.11318+00 | | |
| public | t_ai_history | 0 | 0 | 0 | 0 | | 2024-04-30 01:21:03.297853+00 | | |
| public | t_attendance | 373017 | 15035 | 0.00 | 3.00 | | 2024-04-27 16:18:45.457772+00 | | |
| public | t_general | 30 | 4 | 0.00 | 11.00 | | 2024-04-27 16:19:34.668406+00 | | |
| public | t_mobile_device_history | 75602 | 0 | 0.00 | 0.00 | | 2024-04-27 05:41:01.086457+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-04-27 04:21:50.815989+00 | | |
| public | t_notify_history | 446691 | 14225 | 0.00 | 3.00 | | 2024-04-27 16:19:38.609136+00 | | |
| public | t_operation_log | 1797138 | 38182 | 0.00 | 2.00 | | 2024-04-27 05:18:08.194548+00 | | |
| public | t_plan | 3131399 | 357238 | 0.00 | 10.00 | | 2024-04-27 13:01:31.309676+00 | | 2024-05-10 04:28:03.672168+00 |
| public | t_plan_detail | 3609658 | 334958 | 0.00 | 8.00 | | 2024-04-27 16:21:34.221521+00 | | 2024-05-12 23:53:01.206417+00 |
| public | t_plan_sync | 16501 | 2135 | 0.00 | 11.00 | | 2024-05-12 23:31:51.633944+00 | | 2024-05-13 00:51:19.687392+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-04-27 04:21:48.024881+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-04-27 12:49:49.511545+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-04-27 13:01:32.809222+00 | | |
| public | t_recv_position_history | 6771 | 2129 | 0.00 | 23.00 | | 2024-05-13 01:44:43.658819+00 | 2024-05-12 12:42:00.859642+00 | 2024-05-13 01:44:43.684971+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-04-27 12:51:25.4282+00 | | |
| public | t_terminal | 14516 | 974 | 0.00 | 6.00 | | 2024-05-09 12:35:32.490719+00 | | 2024-05-13 01:30:33.192356+00 |
| public | t_terminal_log | 3761543 | 0 | 0.00 | 0.00 | | 2024-04-27 04:22:00.269807+00 | | |
| public | w_arrival_notify | 1 | 3 | 3.00 | 75.00 | | 2024-04-27 04:34:49.021205+00 | | |
| public | w_latest_position | 10813 | 1914 | 0.00 | 15.00 | | 2024-05-13 01:44:43.590565+00 | | 2024-05-13 01:44:43.613157+00 |
| public | w_latest_presence | 17249 | 34524 | 2.00 | 66.00 | | 2024-05-13 01:44:43.77297+00 | | 2024-05-13 01:44:43.857669+00 |
| public | w_latest_sensor | 113 | 13 | 0.00 | 10.00 | | 2024-05-13 01:44:43.343359+00 | | 2024-05-13 01:44:43.571881+00 |
| public | w_lock | 988 | 1 | 0.00 | 0.00 | | 2024-04-27 04:21:47.519344+00 | | |
| public | w_master_update | 15 | 16 | 1.00 | 51.00 | | 2024-05-12 23:13:53.322012+00 | | 2024-05-12 06:11:44.359009+00 |
| public | w_plan_with_detail | 3136442 | 352959 | 0.00 | 10.00 | | 2024-04-27 05:40:52.62014+00 | | 2024-05-09 05:56:08.930435+00 |