| 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 |
|---|
| e202404 | a_proximity_sum | 817619 | 0 | 0.00 | 0.00 | | 2024-06-15 09:59:10.351463+00 | | 2024-06-15 09:59:10.799881+00 |
| e202404 | a_stay_time | 2118464 | 0 | 0.00 | 0.00 | | 2024-06-15 09:58:28.879251+00 | | 2024-06-15 09:57:43.972963+00 |
| e202404 | l_position_history | 0 | 0 | 0 | 0 | | 2024-06-08 01:04:17.32463+00 | | |
| e202404 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-09 19:15:19.169502+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-06-09 19:15:19.158712+00 | | |
| e202404 | t_position_history | 32754173 | 282821 | 0.00 | 0.00 | | 2024-06-18 07:32:55.507257+00 | | 2024-06-15 09:49:18.943738+00 |
| e202404 | t_presence_history | 5635849 | 1067554 | 0.00 | 15.00 | | 2024-06-10 06:43:06.890788+00 | | 2024-06-19 06:33:54.343665+00 |
| e202404 | t_sensor_history | 1154936 | 0 | 0.00 | 0.00 | | 2024-06-19 19:20:26.836611+00 | | 2024-04-28 22:43:41.720491+00 |
| e202405 | a_proximity_sum | 628486 | 0 | 0.00 | 0.00 | | 2024-06-15 09:59:36.792704+00 | | 2024-06-15 09:59:37.238812+00 |
| e202405 | a_stay_time | 2269497 | 0 | 0.00 | 0.00 | | 2024-06-15 09:57:30.75126+00 | | 2024-06-15 09:57:31.266383+00 |
| e202405 | l_position_history | 0 | 0 | 0 | 0 | | 2024-06-08 01:04:17.335676+00 | | |
| e202405 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-09 19:15:19.191328+00 | | |
| e202405 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-06-09 19:15:19.180628+00 | | |
| e202405 | t_position_history | 31235709 | 822069 | 0.00 | 2.00 | | 2024-06-15 09:57:01.172341+00 | | 2024-06-15 09:52:22.418055+00 |
| e202405 | t_presence_history | 5521747 | 992178 | 0.00 | 15.00 | | 2024-06-10 21:59:07.79402+00 | | 2024-06-19 06:22:21.645044+00 |
| e202405 | t_sensor_history | 1209989 | 0 | 0.00 | 0.00 | | 2024-06-18 17:51:38.319935+00 | | 2024-05-28 18:57:43.773123+00 |
| e202406 | a_proximity_sum | 831133 | 0 | 0.00 | 0.00 | | 2024-06-19 17:02:05.959463+00 | | 2024-06-19 15:31:04.891055+00 |
| e202406 | a_stay_time | 1494797 | 0 | 0.00 | 0.00 | | 2024-06-19 15:31:01.563935+00 | | 2024-06-19 16:45:12.644564+00 |
| e202406 | l_position_history | 0 | 0 | 0 | 0 | | 2024-06-14 13:10:44.997664+00 | | |
| e202406 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-14 13:10:45.053359+00 | | |
| e202406 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-06-14 13:10:45.008441+00 | | |
| e202406 | t_position_history | 19945873 | 0 | 0.00 | 0.00 | | 2024-06-19 03:41:34.997034+00 | | 2024-06-19 07:47:43.985033+00 |
| e202406 | t_presence_history | 3637998 | 111194 | 0.00 | 2.00 | | 2024-06-20 01:41:35.684625+00 | | 2024-06-20 01:42:59.312836+00 |
| e202406 | t_sensor_history | 782382 | 0 | 0.00 | 0.00 | | 2024-06-16 15:02:30.749208+00 | | 2024-06-18 22:28:39.837739+00 |
| public | __digdag_status | 3867 | 7 | 0.00 | 0.00 | | 2024-06-19 12:30:27.181864+00 | | 2024-06-19 12:30:27.189906+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-08 00:55:09.189602+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-06-08 00:55:09.15581+00 | | |
| public | b_attendance_group | 414673 | 16996 | 0.00 | 3.00 | | 2024-06-08 00:55:08.064853+00 | | 2024-06-17 02:40:20.918271+00 |
| public | b_attendance_hour | 6397611 | 295285 | 0.00 | 4.00 | | 2024-06-08 07:34:26.689384+00 | | 2024-06-16 17:41:08.271717+00 |
| public | b_attendance_pot | 9361 | 113 | 0.00 | 1.00 | | 2024-06-19 01:40:43.050075+00 | | 2024-06-17 19:03:42.199336+00 |
| public | b_attendance_pot_hour | 153690 | 10140 | 0.00 | 6.00 | | 2024-06-14 17:36:48.238823+00 | | 2024-06-16 16:51:08.287027+00 |
| public | b_check_in | 3408133 | 105140 | 0.00 | 2.00 | | 2024-06-08 09:04:57.675329+00 | | 2024-06-17 18:35:52.126439+00 |
| public | b_check_in_hour | 50866167 | 1499363 | 0.00 | 2.00 | | 2024-06-08 07:36:40.770101+00 | | 2024-06-17 18:28:49.736132+00 |
| public | b_check_in_pot | 12042 | 0 | 0.00 | 0.00 | | 2024-06-09 17:54:11.40201+00 | | 2024-06-13 16:51:03.937264+00 |
| public | b_check_in_pot_hour | 180652 | 0 | 0.00 | 0.00 | | 2024-06-11 12:22:57.805623+00 | | 2024-06-19 16:51:13.735083+00 |
| public | b_proximity_group | 37337032 | 1644999 | 0.00 | 4.00 | | 2024-06-08 08:32:18.10928+00 | | 2024-06-06 18:34:40.455357+00 |
| public | b_proximity_info | 27875774 | 230610 | 0.00 | 0.00 | | 2024-06-17 02:11:05.540698+00 | | 2024-06-17 02:09:10.193656+00 |
| public | b_seat_reserve | 745903 | 25985 | 0.00 | 3.00 | | 2024-06-08 08:11:05.083097+00 | | 2024-06-16 17:38:05.151784+00 |
| public | b_seat_reserve_hour | 13809405 | 481681 | 0.00 | 3.00 | | 2024-06-08 00:53:50.272952+00 | | 2024-06-17 02:41:23.54052+00 |
| public | b_usage | 818449 | 25985 | 0.00 | 3.00 | | 2024-06-08 00:55:11.241981+00 | | 2024-06-17 17:34:14.943833+00 |
| public | b_usage_hour | 14888131 | 480396 | 0.00 | 3.00 | | 2024-06-08 07:31:11.628217+00 | | 2024-06-17 17:36:15.222492+00 |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-06-08 01:01:34.67547+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-08 01:01:34.664735+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-06-08 01:01:34.654008+00 | | |
| public | m_area | 81 | 18 | 0.00 | 18.00 | | 2024-06-08 09:18:36.43247+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-06-08 07:35:12.117065+00 | | |
| public | m_category | 396 | 60 | 0.00 | 13.00 | | 2024-06-08 00:55:11.420951+00 | | |
| public | m_exb | 2977 | 0 | 0.00 | 0.00 | | 2024-06-19 10:25:58.516664+00 | | 2024-06-19 10:25:58.533177+00 |
| public | m_favorite | 34836 | 2387 | 0.00 | 6.00 | | 2024-06-08 07:40:41.759717+00 | | 2024-06-06 23:39:16.64971+00 |
| public | m_feature | 162 | 0 | 0.00 | 0.00 | | 2024-06-08 09:20:43.187054+00 | | |
| public | m_group | 1982 | 0 | 0.00 | 0.00 | | 2024-06-19 10:25:57.764009+00 | | 2024-06-19 10:25:57.800838+00 |
| public | m_holiday | 5240 | 540 | 0.00 | 9.00 | | 2024-06-08 01:01:34.691922+00 | | |
| public | m_lob | 1131 | 0 | 0.00 | 0.00 | | 2024-06-19 10:25:58.605544+00 | | 2024-06-19 10:25:58.613357+00 |
| public | m_location | 4565 | 0 | 0.00 | 0.00 | | 2024-06-19 10:26:57.9461+00 | | 2024-06-19 10:25:57.888617+00 |
| public | m_notify_template | 108 | 11 | 0.00 | 9.00 | | 2024-06-08 00:55:11.284288+00 | | |
| public | m_outside | 54 | 3 | 0.00 | 5.00 | | 2024-06-08 00:55:09.409264+00 | | |
| public | m_pot | 22255 | 938 | 0.00 | 4.00 | | 2024-06-20 00:10:41.552363+00 | | 2024-06-20 00:10:42.24376+00 |
| public | m_pot_profile | 632 | 91 | 0.00 | 12.00 | | 2024-06-08 07:34:12.291862+00 | | 2024-06-12 08:53:48.893895+00 |
| public | m_provider_user | 58 | 1 | 0.00 | 1.00 | | 2024-06-08 00:55:09.145061+00 | | |
| public | m_region | 14 | 1 | 0.00 | 6.00 | | 2024-06-08 09:18:43.140514+00 | | |
| public | m_role | 65 | 12 | 0.00 | 15.00 | | 2024-06-08 09:18:43.106694+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-06-08 09:04:50.784823+00 | | |
| public | m_setting | 2895 | 40 | 0.00 | 1.00 | | 2024-06-19 20:37:47.697415+00 | | 2024-06-19 14:11:22.48019+00 |
| public | m_setting_log | 4390 | 216 | 0.00 | 4.00 | | 2024-06-18 12:30:41.149412+00 | | 2024-06-19 10:25:59.405464+00 |
| public | m_site | 21 | 2 | 0.00 | 8.00 | | 2024-06-08 00:55:11.262193+00 | | |
| public | m_tenant | 14 | 2 | 0.00 | 12.00 | | 2024-06-08 00:55:09.098385+00 | | |
| public | m_tx | 12530 | 1 | 0.00 | 0.00 | | 2024-06-19 10:25:58.257291+00 | | 2024-06-19 10:25:58.381217+00 |
| public | m_user | 646 | 92 | 0.00 | 12.00 | | 2024-06-17 03:18:23.049529+00 | | 2024-06-17 03:21:48.586852+00 |
| public | m_zone | 661 | 105 | 0.00 | 13.00 | | 2024-06-08 00:55:11.444613+00 | | 2024-06-17 02:50:20.468637+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-06-08 08:11:05.094075+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-06-08 09:04:50.762909+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.308308+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-06-08 08:11:03.349098+00 | | |
| public | r_location_zone | 3280 | 371 | 0.00 | 10.00 | | 2024-06-07 23:11:16.162823+00 | | 2024-06-17 01:14:18.684134+00 |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-06-08 07:35:12.137308+00 | | |
| public | r_pot_category | 977 | 4 | 0.00 | 0.00 | | 2024-06-08 07:41:41.440731+00 | | |
| public | r_pot_group | 9654 | 1166 | 0.00 | 10.00 | | 2024-06-19 23:13:09.64852+00 | | 2024-06-19 23:34:43.391872+00 |
| public | r_pot_tx | 7161 | 1116 | 0.00 | 13.00 | | 2024-06-08 00:55:11.384385+00 | | 2024-06-19 08:12:26.192321+00 |
| public | r_pot_user | 380 | 5 | 0.00 | 1.00 | | 2024-06-17 01:16:18.640561+00 | | 2024-06-17 01:16:18.648896+00 |
| public | r_provider_tenant | 160 | 14 | 0.00 | 8.00 | | 2024-06-18 07:34:07.298698+00 | | |
| public | r_role_feature | 522 | 0 | 0.00 | 0.00 | | 2024-06-19 08:15:26.255409+00 | | 2024-06-19 08:14:26.200809+00 |
| public | r_tenant_feature | 505 | 49 | 0.00 | 8.00 | | 2024-06-08 00:55:09.124569+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.402061+00 | | |
| public | r_user_region | 523 | 5 | 0.00 | 0.00 | | 2024-06-17 01:16:18.829716+00 | | 2024-06-17 01:16:18.833974+00 |
| public | r_user_site | 405 | 15 | 0.00 | 3.00 | | 2024-06-17 01:16:18.804545+00 | | 2024-06-17 01:16:18.809704+00 |
| public | r_zone_category | 623 | 60 | 0.00 | 8.00 | | 2024-06-08 00:55:09.178597+00 | | 2024-05-15 11:06:59.505804+00 |
| public | t_ai_history | 0 | 0 | 0 | 0 | | 2024-06-10 04:25:39.12104+00 | | |
| public | t_attendance | 312608 | 20473 | 0.00 | 6.00 | | 2024-06-08 09:18:42.794046+00 | | 2024-06-17 09:01:05.377501+00 |
| public | t_general | 32 | 0 | 0.00 | 0.00 | | 2024-06-08 09:18:43.124832+00 | | |
| public | t_mobile_device_history | 80606 | 6567 | 0.00 | 7.00 | | 2024-06-08 02:36:02.0763+00 | | 2024-06-16 03:55:20.798728+00 |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-06-08 00:55:11.319072+00 | | |
| public | t_notify_history | 426677 | 15878 | 0.00 | 3.00 | | 2024-06-08 09:18:46.60335+00 | | 2024-06-19 18:32:48.021939+00 |
| public | t_operation_log | 1698593 | 80328 | 0.00 | 4.00 | | 2024-06-08 01:41:01.387692+00 | | 2024-06-12 08:03:31.409471+00 |
| public | t_plan | 3300778 | 489291 | 0.00 | 12.00 | | 2024-06-13 09:13:43.014184+00 | | 2024-06-19 10:13:59.676549+00 |
| public | t_plan_detail | 3716616 | 350571 | 0.00 | 8.00 | | 2024-06-11 22:32:22.664025+00 | | 2024-06-19 23:26:40.333364+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-06-10 21:48:13.06266+00 | | |
| public | t_plan_sync | 16612 | 1999 | 0.00 | 10.00 | | 2024-06-19 23:32:40.384674+00 | | 2024-06-20 00:52:19.425389+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-06-08 00:55:09.075553+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-06-08 07:30:44.673235+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-06-08 07:41:41.396317+00 | | |
| public | t_recv_position_history | 5508 | 916 | 0.00 | 14.00 | | 2024-06-20 01:44:58.695898+00 | 2024-06-19 12:42:00.581469+00 | 2024-06-20 01:44:58.726547+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-06-08 07:32:12.023339+00 | | |
| public | t_terminal | 16322 | 933 | 0.00 | 5.00 | | 2024-06-13 09:17:40.744264+00 | | 2024-06-19 23:38:40.767475+00 |
| public | t_terminal_log | 3794047 | 374350 | 0.00 | 8.00 | | 2024-06-08 00:55:16.438009+00 | | 2024-06-19 07:38:40.364846+00 |
| public | w_arrival_notify | 2 | 11 | 5.00 | 84.00 | | 2024-06-08 01:04:17.390642+00 | | |
| public | w_latest_position | 9627 | 1818 | 0.00 | 15.00 | | 2024-06-20 01:43:58.877825+00 | | 2024-06-20 01:44:58.648906+00 |
| public | w_latest_presence | 16192 | 11741 | 0.00 | 42.00 | | 2024-06-20 01:44:58.851153+00 | | 2024-06-20 01:44:58.931433+00 |
| public | w_latest_sensor | 113 | 32 | 0.00 | 22.00 | | 2024-06-20 01:43:58.624674+00 | | 2024-06-20 01:43:58.855023+00 |
| public | w_lock | 997 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:08.513222+00 | | |
| public | w_master_update | 13 | 15 | 1.00 | 53.00 | | 2024-06-19 10:25:58.401984+00 | | 2024-06-19 12:33:30.18957+00 |
| public | w_plan_with_detail | 3316304 | 487063 | 0.00 | 12.00 | | 2024-06-13 09:15:23.553511+00 | | 2024-06-18 08:11:44.750824+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-06-10 21:22:33.881849+00 | | |