| 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 |
|---|
| e202402 | a_proximity_sum | 30539341 | 0 | 0.00 | 0.00 | | 2024-04-10 01:28:52.248958+00 | | 2024-02-28 18:03:25.795511+00 |
| e202402 | a_stay_time | 17176554 | 0 | 0.00 | 0.00 | | 2024-04-10 01:28:52.181332+00 | | 2024-02-28 16:55:43.897188+00 |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-03 09:44:37.226311+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-03 09:44:37.237502+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-03 09:44:37.215061+00 | | |
| e202402 | t_position_history | 355399420 | 0 | 0.00 | 0.00 | | 2024-04-11 07:25:46.544671+00 | | 2024-02-28 06:24:03.251416+00 |
| e202402 | t_presence_history | 40155397 | 14 | 0.00 | 0.00 | | 2024-04-04 11:00:06.764742+00 | | 2024-03-11 14:49:28.789296+00 |
| e202402 | t_sensor_history | 15047880 | 0 | 0.00 | 0.00 | | 2024-04-10 03:59:00.061825+00 | | 2024-02-28 11:55:22.157867+00 |
| e202403 | a_proximity_sum | 41119908 | 0 | 0.00 | 0.00 | | 2024-04-06 10:48:59.929252+00 | | 2024-03-30 16:19:49.867598+00 |
| e202403 | a_stay_time | 19568077 | 0 | 0.00 | 0.00 | | 2024-04-10 18:30:24.131815+00 | | 2024-03-29 15:10:19.442279+00 |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-09 03:20:52.531975+00 | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-09 03:20:52.542919+00 | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-09 03:20:52.520997+00 | | |
| e202403 | t_position_history | 389453455 | 0 | 0.00 | 0.00 | | 2024-04-09 11:01:19.466708+00 | | 2024-03-29 13:58:09.948045+00 |
| e202403 | t_presence_history | 38526400 | 5111363 | 0.00 | 11.00 | | 2024-03-31 14:02:47.830715+00 | | 2024-03-31 14:59:48.915433+00 |
| e202403 | t_sensor_history | 15240023 | 0 | 0.00 | 0.00 | | 2024-04-08 06:07:02.135974+00 | | 2024-03-30 16:18:49.861644+00 |
| e202404 | a_proximity_sum | 20310402 | 0 | 0.00 | 0.00 | | 2024-04-11 16:57:22.759218+00 | | 2024-04-13 16:17:00.099783+00 |
| e202404 | a_stay_time | 9934602 | 0 | 0.00 | 0.00 | | 2024-04-12 15:11:16.995092+00 | | 2024-04-12 16:12:48.443383+00 |
| e202404 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-02 22:45:41.454753+00 | | |
| e202404 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-02 22:45:41.432424+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-02 22:45:41.443467+00 | | |
| e202404 | t_position_history | 200513284 | 0 | 0.00 | 0.00 | | 2024-04-12 20:21:40.535552+00 | | 2024-04-13 04:23:53.288598+00 |
| e202404 | t_presence_history | 18858659 | 1700569 | 0.00 | 8.00 | | 2024-04-15 00:33:40.416331+00 | | 2024-04-15 00:33:53.517254+00 |
| e202404 | t_sensor_history | 4269048 | 0 | 0.00 | 0.00 | | 2024-04-12 18:31:26.583222+00 | | 2024-04-14 02:50:58.529951+00 |
| public | __digdag_status | 31 | 48 | 1.00 | 60.00 | | 2024-04-11 03:30:38.431623+00 | | 2024-04-13 03:30:40.174824+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.142519+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.130564+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-04-12 12:23:07.811079+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-04-12 12:23:08.931416+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-04-12 12:22:46.431756+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-04-12 12:23:08.946782+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-04-12 12:23:08.965655+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-04-12 12:22:46.449592+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-04-12 12:22:46.416347+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-04-12 12:23:07.882149+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-04-12 12:22:46.471334+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-04-12 12:22:46.492484+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.944734+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.933308+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.921818+00 | | |
| public | m_area | 644 | 5 | 0.00 | 0.00 | | 2024-04-12 04:40:21.968008+00 | | 2024-04-09 02:54:59.648083+00 |
| public | m_auth | 115 | 20 | 0.00 | 14.00 | | 2024-04-09 06:15:04.163842+00 | | 2024-04-11 07:50:05.160199+00 |
| public | m_category | 1692 | 0 | 0.00 | 0.00 | | 2024-04-12 04:40:22.036846+00 | | 2024-03-26 09:54:33.731031+00 |
| public | m_exb | 20203 | 1233 | 0.00 | 5.00 | | 2024-04-14 11:07:30.845914+00 | | 2024-04-14 23:51:45.627603+00 |
| public | m_favorite | 148825 | 603 | 0.00 | 0.00 | | 2024-04-10 03:58:59.93128+00 | | 2024-04-01 01:56:54.725127+00 |
| public | m_feature | 154 | 0 | 0.00 | 0.00 | | 2024-04-10 01:28:43.126195+00 | | |
| public | m_group | 14488 | 477 | 0.00 | 3.00 | | 2024-04-02 01:38:08.309514+00 | | 2024-04-12 05:03:22.848128+00 |
| public | m_holiday | 25618 | 0 | 0.00 | 0.00 | | 2024-04-05 09:30:10.243789+00 | | 2024-04-05 09:50:14.889678+00 |
| public | m_lob | 15073 | 48 | 0.00 | 0.00 | | 2024-04-06 04:23:13.702292+00 | | 2024-04-01 12:34:27.798233+00 |
| public | m_location | 34861 | 5152 | 0.00 | 12.00 | | 2024-04-03 02:18:17.403694+00 | | 2024-04-14 12:02:40.239187+00 |
| public | m_notify_template | 733 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.361766+00 | | 2024-03-13 07:21:28.594642+00 |
| public | m_outside | 290 | 14 | 0.00 | 4.00 | | 2024-04-03 21:26:57.452703+00 | | |
| public | m_pot | 187572 | 30254 | 0.00 | 13.00 | | 2024-04-10 09:00:38.992681+00 | | 2024-04-15 00:39:30.517519+00 |
| public | m_pot_profile | 35468 | 49 | 0.00 | 0.00 | | 2024-04-10 03:58:58.188534+00 | | 2024-04-11 07:45:26.966164+00 |
| public | m_provider_user | 68 | 0 | 0.00 | 0.00 | | 2024-04-10 03:11:23.861584+00 | | 2024-03-28 09:27:17.588147+00 |
| public | m_region | 101 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.439114+00 | | |
| public | m_role | 536 | 4 | 0.00 | 0.00 | | 2024-04-09 06:15:04.422069+00 | | 2024-03-28 02:18:51.575265+00 |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.291489+00 | | |
| public | m_setting | 11218 | 1227 | 0.00 | 9.00 | | 2024-04-13 17:57:29.179415+00 | | 2024-04-14 07:50:20.034192+00 |
| public | m_setting_log | 25848 | 1902 | 0.00 | 6.00 | 2024-02-16 03:34:50.060418+00 | 2024-04-10 12:51:07.250045+00 | | 2024-04-13 12:30:39.173027+00 |
| public | m_site | 172 | 1 | 0.00 | 0.00 | | 2024-04-09 06:15:04.3252+00 | | |
| public | m_tenant | 100 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.589666+00 | | |
| public | m_tx | 85201 | 13390 | 0.00 | 13.00 | | 2024-04-13 01:38:53.344278+00 | | 2024-04-13 08:45:33.946787+00 |
| public | m_user | 29840 | 57 | 0.00 | 0.00 | | 2024-04-12 04:40:21.940349+00 | | 2024-03-31 23:57:54.486297+00 |
| public | m_zone | 4063 | 152 | 0.00 | 3.00 | | 2024-04-10 18:03:54.994245+00 | | 2024-04-11 06:49:28.039164+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:03.130511+00 | | |
| public | r_auth_zone | 212 | 23 | 0.00 | 9.00 | | 2024-04-11 08:26:06.282061+00 | | 2024-04-11 08:26:06.287685+00 |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.384885+00 | | |
| public | r_group_auth | 492 | 12 | 0.00 | 2.00 | | 2024-04-09 11:33:39.288664+00 | | 2024-04-06 08:42:23.362461+00 |
| public | r_location_zone | 31103 | 2733 | 0.00 | 8.00 | | 2024-04-11 07:26:56.179779+00 | | 2024-04-12 09:03:15.285086+00 |
| public | r_pot_auth | 729 | 59 | 0.00 | 7.00 | | 2024-04-03 02:23:34.402244+00 | | 2024-04-03 01:46:35.460601+00 |
| public | r_pot_category | 6612 | 0 | 0.00 | 0.00 | | 2024-04-14 20:28:56.789406+00 | | 2024-04-14 20:01:10.573264+00 |
| public | r_pot_group | 86715 | 9834 | 0.00 | 10.00 | | 2024-04-14 23:33:45.376626+00 | | 2024-04-15 00:33:52.673673+00 |
| public | r_pot_tx | 45162 | 1341 | 0.00 | 2.00 | | 2024-04-07 01:35:25.475693+00 | | 2024-04-10 06:34:16.125557+00 |
| public | r_pot_user | 19137 | 425 | 0.00 | 2.00 | | 2024-04-02 01:38:08.058024+00 | | 2024-03-31 23:55:53.935899+00 |
| public | r_provider_tenant | 1654 | 0 | 0.00 | 0.00 | | 2024-04-13 07:50:48.300068+00 | | 2024-04-09 04:50:02.671565+00 |
| public | r_role_feature | 5188 | 128 | 0.00 | 2.00 | | 2024-04-02 01:38:08.096262+00 | | 2024-03-28 04:53:44.604731+00 |
| public | r_tenant_feature | 3373 | 0 | 0.00 | 0.00 | | 2024-04-12 12:22:46.383656+00 | | 2024-03-22 05:38:31.850763+00 |
| public | r_tx_sensor | 451 | 0 | 0.00 | 0.00 | | 2024-04-03 08:14:02.763498+00 | | 2024-01-27 01:38:23.792244+00 |
| public | r_user_region | 19691 | 439 | 0.00 | 2.00 | | 2024-04-02 01:38:07.768083+00 | | 2024-04-11 09:40:20.304336+00 |
| public | r_user_site | 5269 | 158 | 0.00 | 2.00 | | 2024-04-09 06:15:04.269837+00 | | 2024-04-01 03:15:59.165625+00 |
| public | r_zone_category | 2731 | 53 | 0.00 | 1.00 | | 2024-04-04 08:21:25.91829+00 | | 2024-04-12 09:41:20.888376+00 |
| public | t_ai_history | 7 | 0 | 0.00 | 0.00 | | | | |
| public | t_attendance | 863498 | 4433 | 0.00 | 0.00 | | 2024-04-12 12:23:07.799607+00 | | 2024-04-11 23:40:48.24496+00 |
| public | t_general | 1649 | 2 | 0.00 | 0.00 | | 2024-04-09 06:15:04.552323+00 | | 2024-04-04 01:01:17.018014+00 |
| public | t_mobile_device_history | 442694 | 0 | 0.00 | 0.00 | | 2024-04-11 12:01:27.468229+00 | | 2024-04-09 07:47:57.383332+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.405839+00 | | |
| public | t_notify_history | 2221008 | 29698 | 0.00 | 1.00 | | 2024-04-10 08:19:58.199137+00 | | 2024-04-08 01:15:37.299082+00 |
| public | t_operation_log | 8487938 | 158759 | 0.00 | 1.00 | | 2024-04-04 10:49:21.50286+00 | | 2024-04-03 07:46:33.237938+00 |
| public | t_plan | 9974863 | 871879 | 0.00 | 8.00 | | 2024-04-11 12:19:29.131662+00 | | 2024-04-14 14:25:37.873592+00 |
| public | t_plan_detail | 15767310 | 819393 | 0.00 | 4.00 | | 2024-04-14 05:46:06.624326+00 | | 2024-04-15 00:43:28.16883+00 |
| public | t_plan_sync | 45287 | 4604 | 0.00 | 9.00 | | 2024-04-15 00:47:42.75525+00 | | 2024-04-15 00:33:52.930923+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.613302+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:03.142748+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.465109+00 | | |
| public | t_recv_position_history | 117638 | 1200927 | 10.00 | 91.00 | | 2024-04-15 00:48:43.036267+00 | 2024-04-14 13:30:02.524833+00 | 2024-04-15 00:48:43.465851+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:03.170371+00 | | |
| public | t_terminal | 38824 | 2746 | 0.00 | 6.00 | | 2024-04-10 23:19:49.664302+00 | | 2024-04-14 22:46:39.100778+00 |
| public | t_terminal_log | 6132487 | 0 | 0.00 | 0.00 | | 2024-04-04 03:16:57.140766+00 | | 2024-03-23 15:22:08.14262+00 |
| public | w_arrival_notify | 66 | 9 | 0.00 | 12.00 | | 2024-04-11 00:52:04.743404+00 | | 2024-04-12 00:44:08.105276+00 |
| public | w_latest_position | 47258 | 385020 | 8.00 | 89.00 | | 2024-04-15 00:48:44.64088+00 | | 2024-04-15 00:48:44.791405+00 |
| public | w_latest_presence | 177193 | 1788176 | 10.00 | 90.00 | 2024-01-18 12:30:06.016796+00 | 2024-04-15 00:48:44.042561+00 | 2024-01-18 12:30:06.178604+00 | 2024-04-15 00:48:44.455093+00 |
| public | w_latest_sensor | 443 | 3931 | 8.00 | 89.00 | | 2024-04-15 00:48:42.38385+00 | | 2024-04-15 00:48:42.499775+00 |
| public | w_lock | 12207 | 0 | 0.00 | 0.00 | | 2024-04-01 17:38:05.101794+00 | | 2024-04-05 09:40:14.085919+00 |
| public | w_master_update | 95 | 59 | 0.00 | 38.00 | | 2024-04-15 00:12:54.833068+00 | | 2024-04-15 00:33:52.690662+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.964568+00 | | |
| public | w_plan_with_detail | 9954457 | 637291 | 0.00 | 6.00 | | 2024-04-11 17:24:08.197332+00 | | 2024-04-14 06:11:23.750934+00 |