| 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 | 32697353 | 5950740 | 0.00 | 15.00 | | 2024-06-15 09:49:12.29621+00 | | 2024-06-15 09:49:18.943738+00 |
| e202404 | t_presence_history | 6867055 | 0 | 0.00 | 0.00 | | 2024-06-10 06:43:06.890788+00 | | 2024-04-30 14:47:32.149293+00 |
| e202404 | t_sensor_history | 1154956 | 0 | 0.00 | 0.00 | | 2024-06-07 04:00:10.00414+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 | 32057778 | 0 | 0.00 | 0.00 | | 2024-06-15 09:57:01.172341+00 | | 2024-06-15 09:52:22.418055+00 |
| e202405 | t_presence_history | 6933942 | 0 | 0.00 | 0.00 | | 2024-06-10 21:59:07.79402+00 | | 2024-05-31 14:52:09.269041+00 |
| e202405 | t_sensor_history | 1209985 | 0 | 0.00 | 0.00 | | 2024-06-06 04:12:21.013676+00 | | 2024-05-28 18:57:43.773123+00 |
| e202406 | a_proximity_sum | 181421 | 0 | 0.00 | 0.00 | | 2024-06-15 10:05:04.276243+00 | | 2024-06-15 10:03:19.236596+00 |
| e202406 | a_stay_time | 1166872 | 0 | 0.00 | 0.00 | | 2024-06-15 09:57:42.763783+00 | | 2024-06-15 09:57:43.186131+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 | 16116897 | 896679 | 0.00 | 5.00 | | 2024-06-14 10:47:57.013474+00 | | 2024-06-14 10:47:57.512062+00 |
| e202406 | t_presence_history | 2866780 | 60943 | 0.00 | 2.00 | | 2024-06-17 01:43:01.968083+00 | | 2024-06-17 01:43:02.569196+00 |
| e202406 | t_sensor_history | 648494 | 0 | 0.00 | 0.00 | | 2024-06-16 15:02:30.749208+00 | | 2024-06-15 17:17:05.90857+00 |
| public | __digdag_status | 176 | 16 | 0.00 | 8.00 | | 2024-06-17 01:43:10.921304+00 | | 2024-06-17 01:43:10.924377+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 | 410616 | 8602 | 0.00 | 2.00 | | 2024-06-08 00:55:08.064853+00 | | 2024-05-31 17:35:56.591531+00 |
| public | b_attendance_hour | 6501092 | 132905 | 0.00 | 2.00 | | 2024-06-08 07:34:26.689384+00 | | 2024-06-16 17:41:08.271717+00 |
| public | b_attendance_pot | 10130 | 1234 | 0.00 | 10.00 | | 2024-06-06 08:04:34.549807+00 | | 2024-06-12 19:03:23.719685+00 |
| public | b_attendance_pot_hour | 153645 | 5055 | 0.00 | 3.00 | | 2024-06-14 17:36:48.238823+00 | | 2024-06-16 16:51:08.287027+00 |
| public | b_check_in | 3306291 | 72346 | 0.00 | 2.00 | | 2024-06-08 09:04:57.675329+00 | | 2024-05-30 18:34:48.755322+00 |
| public | b_check_in_hour | 49446739 | 1057596 | 0.00 | 2.00 | | 2024-06-08 07:36:40.770101+00 | | 2024-05-30 18:34:52.439949+00 |
| public | b_check_in_pot | 11700 | 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 | 175485 | 0 | 0.00 | 0.00 | | 2024-06-11 12:22:57.805623+00 | | 2024-06-09 16:51:11.010125+00 |
| public | b_proximity_group | 37750462 | 1037735 | 0.00 | 2.00 | | 2024-06-08 08:32:18.10928+00 | | 2024-06-06 18:34:40.455357+00 |
| public | b_proximity_info | 47468406 | 5915891 | 0.00 | 11.00 | | 2024-06-17 01:42:35.370451+00 | | 2024-06-17 01:43:10.865676+00 |
| public | b_seat_reserve | 748910 | 15397 | 0.00 | 2.00 | | 2024-06-08 08:11:05.083097+00 | | 2024-06-16 17:38:05.151784+00 |
| public | b_seat_reserve_hour | 13569286 | 273854 | 0.00 | 1.00 | | 2024-06-08 00:53:50.272952+00 | | 2024-05-30 18:33:16.564907+00 |
| public | b_usage | 805993 | 15397 | 0.00 | 1.00 | | 2024-06-08 00:55:11.241981+00 | | 2024-05-31 17:46:02.633534+00 |
| public | b_usage_hour | 14688751 | 273854 | 0.00 | 1.00 | | 2024-06-08 07:31:11.628217+00 | | 2024-05-31 18:33:03.379243+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 | 99 | 0 | 0.00 | 0.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 | 456 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.420951+00 | | |
| public | m_exb | 3876 | 275 | 0.00 | 6.00 | | 2024-06-08 09:18:36.556055+00 | | 2024-06-17 01:45:09.867244+00 |
| public | m_favorite | 36795 | 236 | 0.00 | 0.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 | 2632 | 0 | 0.00 | 0.00 | | 2024-06-15 22:55:09.415266+00 | | |
| public | m_holiday | 5780 | 0 | 0.00 | 0.00 | | 2024-06-08 01:01:34.691922+00 | | |
| public | m_lob | 2278 | 5 | 0.00 | 0.00 | | 2024-06-08 07:41:41.37835+00 | | |
| public | m_location | 5425 | 160 | 0.00 | 2.00 | | 2024-06-08 00:55:09.392276+00 | | 2024-06-12 07:25:10.066889+00 |
| public | m_notify_template | 119 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.284288+00 | | |
| public | m_outside | 57 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:09.409264+00 | | |
| public | m_pot | 24076 | 1076 | 0.00 | 4.00 | | 2024-06-17 00:10:43.630473+00 | | 2024-06-17 00:10:45.984074+00 |
| public | m_pot_profile | 679 | 28 | 0.00 | 3.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 | 15 | 0 | 0.00 | 0.00 | | 2024-06-08 09:18:43.140514+00 | | |
| public | m_role | 77 | 0 | 0.00 | 0.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 | 3158 | 178 | 0.00 | 5.00 | | 2024-06-16 06:25:03.474011+00 | | 2024-06-15 15:22:30.053626+00 |
| public | m_setting_log | 4262 | 644 | 0.00 | 13.00 | | 2024-06-13 12:30:46.928334+00 | | 2024-06-16 19:52:42.767717+00 |
| public | m_site | 23 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.262193+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:09.098385+00 | | |
| public | m_tx | 15014 | 1799 | 0.00 | 10.00 | | 2024-06-14 12:12:42.445129+00 | | 2024-06-17 01:45:09.842924+00 |
| public | m_user | 979 | 2 | 0.00 | 0.00 | | 2024-06-10 05:51:20.781669+00 | | |
| public | m_zone | 761 | 5 | 0.00 | 0.00 | | 2024-06-08 00:55:11.444613+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 | 3284 | 318 | 0.00 | 8.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 | 10596 | 1483 | 0.00 | 12.00 | | 2024-06-16 23:12:50.366528+00 | | 2024-06-16 23:32:54.256453+00 |
| public | r_pot_tx | 7940 | 334 | 0.00 | 4.00 | | 2024-06-08 00:55:11.384385+00 | | |
| public | r_pot_user | 385 | 0 | 0.00 | 0.00 | | 2024-06-17 01:16:18.640561+00 | | 2024-06-17 01:16:18.648896+00 |
| public | r_provider_tenant | 174 | 28 | 0.00 | 13.00 | | 2024-06-05 20:12:22.52431+00 | | |
| public | r_role_feature | 681 | 18 | 0.00 | 2.00 | | 2024-06-08 09:18:43.090682+00 | | |
| public | r_tenant_feature | 531 | 23 | 0.00 | 4.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 | 528 | 0 | 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 | 396228 | 12489 | 0.00 | 3.00 | | 2024-06-08 09:18:42.794046+00 | | 2024-06-01 18:34:38.210707+00 |
| public | t_general | 32 | 0 | 0.00 | 0.00 | | 2024-06-08 09:18:43.124832+00 | | |
| public | t_mobile_device_history | 86654 | 4 | 0.00 | 0.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 | 452174 | 10014 | 0.00 | 2.00 | | 2024-06-08 09:18:46.60335+00 | | 2024-06-06 18:32:39.176352+00 |
| public | t_operation_log | 1722949 | 30462 | 0.00 | 1.00 | | 2024-06-08 01:41:01.387692+00 | | 2024-06-12 08:03:31.409471+00 |
| public | t_plan | 3292467 | 233990 | 0.00 | 6.00 | | 2024-06-13 09:13:43.014184+00 | | 2024-06-15 11:20:02.104742+00 |
| public | t_plan_detail | 3696745 | 221961 | 0.00 | 5.00 | | 2024-06-11 22:32:22.664025+00 | | 2024-06-14 12:55:45.516402+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-06-10 21:48:13.06266+00 | | |
| public | t_plan_sync | 16597 | 2279 | 0.00 | 12.00 | | 2024-06-16 23:10:49.871106+00 | | 2024-06-17 00:47:57.6717+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 | 5787 | 1347 | 0.00 | 18.00 | | 2024-06-17 01:45:10.043616+00 | 2024-06-16 12:42:00.739595+00 | 2024-06-17 01:45:10.069475+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-06-08 07:32:12.023339+00 | | |
| public | t_terminal | 16202 | 563 | 0.00 | 3.00 | | 2024-06-13 09:17:40.744264+00 | | 2024-06-16 21:50:06.794633+00 |
| public | t_terminal_log | 4113546 | 411 | 0.00 | 0.00 | | 2024-06-08 00:55:16.438009+00 | | 2024-06-07 13:05:57.570082+00 |
| public | w_arrival_notify | 1 | 9 | 9.00 | 90.00 | | 2024-06-08 01:04:17.390642+00 | | |
| public | w_latest_position | 10555 | 1538 | 0.00 | 12.00 | | 2024-06-17 01:42:35.647949+00 | | 2024-06-17 01:45:09.902429+00 |
| public | w_latest_presence | 17550 | 9016 | 0.00 | 33.00 | | 2024-06-17 01:45:10.146832+00 | | 2024-06-17 01:45:10.244642+00 |
| public | w_latest_sensor | 113 | 72 | 0.00 | 38.00 | | 2024-06-17 01:42:35.388971+00 | | 2024-06-17 01:42:35.621512+00 |
| public | w_lock | 991 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:08.513222+00 | | |
| public | w_master_update | 14 | 38 | 2.00 | 73.00 | | 2024-06-15 12:33:00.567278+00 | | 2024-06-15 21:53:30.456309+00 |
| public | w_plan_with_detail | 3301518 | 239725 | 0.00 | 6.00 | | 2024-06-13 09:15:23.553511+00 | | 2024-06-16 22:47:50.436329+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-06-10 21:22:33.881849+00 | | |