| 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 |
|---|
| e202308 | a_proximity_sum | 30792723 | 0 | 0.00 | 0.00 | | 2023-10-25 03:48:59.869982+00 | | |
| e202308 | a_stay_time | 14145799 | 0 | 0.00 | 0.00 | | 2023-10-24 05:42:43.627357+00 | | 2023-08-31 15:25:02.585425+00 |
| e202308 | l_position_history | 0 | 0 | 0 | 0 | | 2023-10-14 01:39:54.828741+00 | | |
| e202308 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-10-14 01:39:54.354402+00 | | |
| e202308 | l_stay_time | 0 | 0 | 0 | 0 | | 2023-10-14 01:39:54.342574+00 | | |
| e202308 | t_position_history | 272747141 | 0 | 0.00 | 0.00 | | 2023-10-21 23:06:54.341224+00 | | 2023-09-07 00:23:56.057706+00 |
| e202308 | t_presence_history | 31124609 | 0 | 0.00 | 0.00 | | 2023-10-20 06:13:22.939294+00 | | 2023-09-30 00:53:09.308717+00 |
| e202308 | t_sensor_history | 3830724 | 0 | 0.00 | 0.00 | | 2023-10-19 04:36:28.605182+00 | | 2023-09-26 19:44:31.059104+00 |
| e202309 | a_proximity_sum | 44162496 | 173649 | 0.00 | 0.00 | | 2023-10-10 09:43:50.290756+00 | | 2023-09-29 16:16:31.126327+00 |
| e202309 | a_stay_time | 14706996 | 140862 | 0.00 | 0.00 | | 2023-10-11 07:35:03.818548+00 | | 2023-10-12 08:20:49.413988+00 |
| e202309 | l_position_history | 0 | 0 | 0 | 0 | | 2023-10-11 02:52:25.069199+00 | | |
| e202309 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-10-11 02:52:25.058234+00 | | |
| e202309 | l_stay_time | 0 | 0 | 0 | 0 | | 2023-10-11 02:52:25.080078+00 | | |
| e202309 | t_position_history | 276013840 | 1735624 | 0.00 | 0.00 | | 2023-10-10 15:45:15.062908+00 | | 2023-09-30 00:38:09.107617+00 |
| e202309 | t_presence_history | 45333748 | 9620 | 0.00 | 0.00 | | 2023-10-20 04:04:54.164138+00 | | 2023-09-30 14:40:56.529237+00 |
| e202309 | t_sensor_history | 3456413 | 138401 | 0.00 | 3.00 | | 2023-10-26 19:47:23.027163+00 | | 2023-10-28 19:46:17.049881+00 |
| e202310 | a_proximity_sum | 35822094 | 0 | 0.00 | 0.00 | | 2023-10-28 23:31:39.449166+00 | | 2023-10-28 23:31:40.016317+00 |
| e202310 | a_stay_time | 15061342 | 0 | 0.00 | 0.00 | | 2023-10-25 15:48:58.589994+00 | | 2023-10-26 15:13:23.820974+00 |
| e202310 | l_position_history | 0 | 0 | 0 | 0 | | 2023-10-09 14:21:13.572952+00 | | |
| e202310 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-10-09 14:21:13.594963+00 | | |
| e202310 | l_stay_time | 0 | 0 | 0 | 0 | | 2023-10-09 14:21:13.583871+00 | | |
| e202310 | t_position_history | 278350527 | 2 | 0.00 | 0.00 | | 2023-10-25 06:11:15.105229+00 | | 2023-10-27 07:29:29.409671+00 |
| e202310 | t_presence_history | 39404802 | 7641961 | 0.00 | 16.00 | | 2023-10-29 01:22:43.965209+00 | | 2023-10-29 01:46:53.87399+00 |
| e202310 | t_sensor_history | 3365684 | 0 | 0.00 | 0.00 | | 2023-10-25 06:45:09.027167+00 | | 2023-10-25 16:09:59.433811+00 |
| public | __digdag_status | 11 | 20 | 1.00 | 64.00 | | 2023-10-28 03:34:06.208003+00 | | 2023-10-27 12:40:21.792155+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2023-10-27 14:47:58.609405+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2023-10-27 14:47:58.598162+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2023-10-17 03:56:29.894578+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2023-10-17 03:58:43.750085+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2023-10-17 03:56:29.847633+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2023-10-17 03:58:43.762403+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2023-10-17 03:58:43.773779+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2023-10-17 03:56:29.859118+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2023-10-17 03:56:29.835165+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2023-10-17 03:56:29.906881+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2023-10-17 03:56:29.871298+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2023-10-17 03:56:29.883107+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2023-10-27 14:47:58.882746+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-10-27 14:47:58.870874+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2023-10-27 14:47:58.859288+00 | | |
| public | m_area | 542 | 21 | 0.00 | 3.00 | | 2023-10-12 10:10:16.464145+00 | | 2023-10-27 04:39:17.930613+00 |
| public | m_auth | 80 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.628602+00 | | |
| public | m_category | 1382 | 16 | 0.00 | 1.00 | | 2023-10-12 10:10:16.500953+00 | | 2023-10-23 15:32:40.479657+00 |
| public | m_exb | 15618 | 656 | 0.00 | 4.00 | | 2023-10-27 12:54:51.767853+00 | | 2023-10-27 16:05:55.64415+00 |
| public | m_favorite | 122447 | 0 | 0.00 | 0.00 | | 2023-10-28 22:24:17.347499+00 | | 2023-10-25 05:25:38.508268+00 |
| public | m_feature | 146 | 0 | 0.00 | 0.00 | | 2023-10-28 14:03:57.018407+00 | | |
| public | m_group | 11979 | 391 | 0.00 | 3.00 | | 2023-10-18 00:01:34.274167+00 | | 2023-10-21 08:06:37.088529+00 |
| public | m_holiday | 10412 | 0 | 0.00 | 0.00 | | 2023-10-27 06:56:09.227072+00 | | 2023-09-14 03:45:52.783035+00 |
| public | m_lob | 16656 | 23 | 0.00 | 0.00 | | 2023-10-24 04:13:01.643456+00 | | 2023-10-23 04:19:49.20493+00 |
| public | m_location | 26648 | 352 | 0.00 | 1.00 | | 2023-10-27 15:57:51.681111+00 | | 2023-10-23 01:53:51.290928+00 |
| public | m_notify_template | 537 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.695655+00 | | 2023-10-17 15:43:45.022551+00 |
| public | m_outside | 246 | 0 | 0.00 | 0.00 | | 2023-10-20 09:17:36.928712+00 | | 2023-09-08 10:01:28.985066+00 |
| public | m_pot | 129033 | 13663 | 0.00 | 9.00 | | 2023-10-26 00:21:51.386331+00 | | 2023-10-27 09:30:42.755762+00 |
| public | m_pot_profile | 23378 | 0 | 0.00 | 0.00 | | 2023-10-28 16:43:56.028858+00 | | 2023-10-09 05:05:23.00925+00 |
| public | m_provider_user | 28 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.720648+00 | | |
| public | m_region | 88 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.776615+00 | | |
| public | m_role | 440 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.752535+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.652757+00 | | |
| public | m_setting | 15311 | 1476 | 0.00 | 8.00 | | 2023-10-29 00:03:22.950315+00 | | 2023-10-29 00:01:05.061381+00 |
| public | m_setting_log | 481686 | 58192 | 0.00 | 10.00 | | 2023-10-25 12:32:09.850171+00 | | 2023-10-27 12:31:37.01244+00 |
| public | m_site | 149 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.668678+00 | | |
| public | m_tenant | 87 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.83453+00 | | |
| public | m_tx | 66784 | 4018 | 0.00 | 5.00 | | 2023-10-28 08:50:31.730346+00 | | 2023-10-28 10:05:59.611838+00 |
| public | m_user | 26172 | 1211 | 0.00 | 4.00 | | 2023-10-12 06:50:42.574194+00 | | 2023-10-24 14:29:18.246643+00 |
| public | m_zone | 3531 | 299 | 0.00 | 7.00 | | 2023-10-10 06:52:08.502747+00 | | 2023-10-27 13:03:15.559395+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2023-10-27 14:47:58.563458+00 | | |
| public | r_auth_zone | 180 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.641328+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.70764+00 | | |
| public | r_group_auth | 348 | 0 | 0.00 | 0.00 | | 2023-10-27 22:09:15.082532+00 | | 2023-10-24 16:20:41.997934+00 |
| public | r_location_zone | 24399 | 1984 | 0.00 | 7.00 | | 2023-10-25 07:13:05.950744+00 | | 2023-10-27 18:10:06.302064+00 |
| public | r_pot_auth | 673 | 1 | 0.00 | 0.00 | | 2023-10-19 11:17:24.270628+00 | | 2023-09-11 08:31:01.48959+00 |
| public | r_pot_category | 5341 | 510 | 0.00 | 8.00 | | 2023-10-16 17:52:52.578275+00 | | 2023-10-27 09:30:42.778196+00 |
| public | r_pot_group | 84587 | 3347 | 0.00 | 3.00 | | 2023-10-28 23:43:31.10783+00 | | 2023-10-29 00:32:08.61602+00 |
| public | r_pot_tx | 36987 | 758 | 0.00 | 2.00 | | 2023-10-24 16:56:41.984436+00 | | 2023-10-27 09:19:14.017145+00 |
| public | r_pot_user | 17063 | 329 | 0.00 | 1.00 | | 2023-10-25 07:02:38.906029+00 | | 2023-10-26 07:26:12.639045+00 |
| public | r_role_feature | 4731 | 15 | 0.00 | 0.00 | | 2023-10-18 00:01:34.0861+00 | | 2023-10-17 10:56:07.752636+00 |
| public | r_tenant_feature | 2883 | 24 | 0.00 | 0.00 | | 2023-10-14 07:45:12.808088+00 | | 2023-10-25 07:37:45.580813+00 |
| public | r_tx_sensor | 200 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.76451+00 | | |
| public | r_user_region | 17493 | 331 | 0.00 | 1.00 | | 2023-10-25 07:02:38.627078+00 | | 2023-10-27 03:13:06.920722+00 |
| public | r_user_site | 4279 | 274 | 0.00 | 6.00 | | 2023-10-25 06:56:49.877278+00 | | 2023-10-27 03:18:30.458418+00 |
| public | r_zone_category | 2502 | 28 | 0.00 | 1.00 | | 2023-10-21 11:24:44.850241+00 | | 2023-10-19 00:09:01.918721+00 |
| public | t_attendance | 468003 | 35302 | 0.00 | 7.00 | | 2023-10-15 00:45:34.874453+00 | | 2023-10-27 09:11:08.930661+00 |
| public | t_general | 792 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.821454+00 | | 2023-10-19 06:40:08.04425+00 |
| public | t_mobile_device_history | 275473 | 0 | 0.00 | 0.00 | | 2023-10-11 20:12:42.232777+00 | | 2023-10-19 03:32:38.791991+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.731744+00 | | |
| public | t_notify_history | 1520429 | 78745 | 0.00 | 4.00 | | 2023-10-10 00:52:11.199329+00 | | 2023-10-20 07:01:25.129331+00 |
| public | t_operation_log | 5755177 | 68546 | 0.00 | 1.00 | | 2023-10-21 21:32:29.917526+00 | | 2023-10-17 18:39:15.466485+00 |
| public | t_plan | 7446699 | 1136055 | 0.00 | 13.00 | | 2023-10-15 23:26:04.680073+00 | | 2023-10-27 04:48:19.087458+00 |
| public | t_plan_detail | 10877267 | 887159 | 0.00 | 7.00 | | 2023-10-19 13:57:53.147195+00 | | 2023-10-27 04:54:29.571377+00 |
| public | t_plan_sync | 22751 | 4279 | 0.00 | 15.00 | | 2023-10-29 00:32:08.849199+00 | | 2023-10-29 00:52:53.46268+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.847129+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2023-10-27 14:47:58.5752+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2023-10-27 14:47:58.789548+00 | | |
| public | t_recv_position_history | 81872 | 885385 | 10.00 | 91.00 | | 2023-10-29 02:22:36.724355+00 | 2023-10-28 12:30:11.475454+00 | 2023-10-29 02:22:37.072755+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2023-10-27 14:47:58.586789+00 | | |
| public | t_terminal | 3018 | 504 | 0.00 | 14.00 | | 2023-10-29 01:37:04.461843+00 | | 2023-10-29 01:58:57.938707+00 |
| public | t_terminal_log | 2266479 | 0 | 0.00 | 0.00 | | 2023-10-20 23:36:00.892601+00 | | 2023-10-20 20:00:56.280747+00 |
| public | w_arrival_notify | 42 | 54 | 1.00 | 56.00 | | 2023-10-10 15:47:01.885193+00 | | 2023-10-13 15:00:41.417042+00 |
| public | w_latest_position | 41712 | 75684 | 1.00 | 64.00 | | 2023-10-29 02:22:33.209509+00 | | 2023-10-29 02:22:36.33532+00 |
| public | w_latest_presence | 71662 | 2793661 | 38.00 | 97.00 | | 2023-10-29 02:22:29.688243+00 | | 2023-10-29 02:22:32.925704+00 |
| public | w_latest_sensor | 201 | 809 | 4.00 | 80.00 | | 2023-10-29 02:22:32.938835+00 | | 2023-10-29 02:22:33.119749+00 |
| public | w_lock | 7833 | 9 | 0.00 | 0.00 | | 2023-10-17 07:51:45.136342+00 | | 2023-10-03 10:37:27.122177+00 |
| public | w_master_update | 141 | 7 | 0.00 | 4.00 | | 2023-10-28 23:48:45.581895+00 | | 2023-10-28 12:31:41.066698+00 |
| public | w_migration | 824 | 0 | 0.00 | 0.00 | | 2023-10-27 17:43:59.17854+00 | | |
| public | w_plan_with_detail | 7437265 | 339260 | 0.00 | 4.00 | | 2023-10-25 10:00:36.333242+00 | | 2023-10-27 00:07:25.730654+00 |