| 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 | 44162570 | 173575 | 0.00 | 0.00 | | 2023-10-10 09:43:50.290756+00 | | 2023-09-29 16:16:31.126327+00 |
| e202309 | a_stay_time | 14707334 | 140524 | 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 | 276037779 | 1711685 | 0.00 | 0.00 | | 2023-10-10 15:45:15.062908+00 | | 2023-09-30 00:38:09.107617+00 |
| e202309 | t_presence_history | 45335080 | 8288 | 0.00 | 0.00 | | 2023-10-20 04:04:54.164138+00 | | 2023-09-30 14:40:56.529237+00 |
| e202309 | t_sensor_history | 3698613 | 77930 | 0.00 | 2.00 | | 2023-10-26 19:47:23.027163+00 | | 2023-10-22 19:45:54.45375+00 |
| e202310 | a_proximity_sum | 27791089 | 0 | 0.00 | 0.00 | | 2023-10-26 22:02:19.317186+00 | | 2023-10-26 22:02:19.873156+00 |
| e202310 | a_stay_time | 14891901 | 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 | 273043987 | 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 | 38779499 | 7963386 | 0.00 | 17.00 | | 2023-10-28 01:36:38.945368+00 | | 2023-10-28 02:16:18.959295+00 |
| e202310 | t_sensor_history | 3316194 | 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 | 51 | 4.00 | 82.00 | | 2023-10-25 12:32:11.032489+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 | 453 | 0.00 | 2.00 | | 2023-10-27 12:54:51.767853+00 | | 2023-10-27 16:05:55.64415+00 |
| public | m_favorite | 122444 | 878 | 0.00 | 0.00 | | 2023-10-09 09:49:54.57237+00 | | 2023-10-25 05:25:38.508268+00 |
| public | m_feature | 146 | 5 | 0.00 | 3.00 | | 2023-10-09 03:36:33.917132+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 | 16655 | 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 | 160 | 0.00 | 0.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 | 129017 | 13418 | 0.00 | 9.00 | | 2023-10-26 00:21:51.386331+00 | | 2023-10-27 09:30:42.755762+00 |
| public | m_pot_profile | 27702 | 173 | 0.00 | 0.00 | | 2023-10-09 05:02:30.753941+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 | 15717 | 858 | 0.00 | 5.00 | | 2023-10-28 01:08:01.32704+00 | | 2023-10-27 23:47:10.601902+00 |
| public | m_setting_log | 481818 | 43320 | 0.00 | 8.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 | 13284 | 0.00 | 16.00 | | 2023-10-27 07:56:22.06012+00 | | 2023-10-27 16:03:19.982005+00 |
| public | m_user | 26172 | 1203 | 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 | 24400 | 1604 | 0.00 | 6.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 | 84575 | 12907 | 0.00 | 13.00 | | 2023-10-27 22:02:42.546598+00 | | 2023-10-28 00:31:45.416679+00 |
| public | r_pot_tx | 36980 | 755 | 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 | 468098 | 35188 | 0.00 | 6.00 | | 2023-10-15 00:45:34.874453+00 | | 2023-10-27 09:11:08.930661+00 |
| public | t_general | 788 | 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 | 275414 | 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 | 1523754 | 75308 | 0.00 | 4.00 | | 2023-10-10 00:52:11.199329+00 | | 2023-10-20 07:01:25.129331+00 |
| public | t_operation_log | 5764327 | 55600 | 0.00 | 0.00 | | 2023-10-21 21:32:29.917526+00 | | 2023-10-17 18:39:15.466485+00 |
| public | t_plan | 7443660 | 1132006 | 0.00 | 13.00 | | 2023-10-15 23:26:04.680073+00 | | 2023-10-27 04:48:19.087458+00 |
| public | t_plan_detail | 10874148 | 885261 | 0.00 | 7.00 | | 2023-10-19 13:57:53.147195+00 | | 2023-10-27 04:54:29.571377+00 |
| public | t_plan_sync | 31889 | 1184 | 0.00 | 3.00 | | 2023-10-28 00:49:49.164557+00 | | 2023-10-28 00:31:45.580356+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 | 81624 | 856458 | 10.00 | 91.00 | | 2023-10-28 02:22:00.005922+00 | 2023-10-27 12:30:08.82753+00 | 2023-10-28 02:22:00.357015+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2023-10-27 14:47:58.586789+00 | | |
| public | t_terminal | 3018 | 539 | 0.00 | 15.00 | | 2023-10-27 23:26:12.913305+00 | | 2023-10-28 02:01:47.539632+00 |
| public | t_terminal_log | 2250804 | 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 | 44271 | 63856 | 1.00 | 59.00 | | 2023-10-28 02:21:56.441043+00 | | 2023-10-28 02:21:59.627798+00 |
| public | w_latest_presence | 48557 | 2594955 | 53.00 | 98.00 | | 2023-10-28 02:21:52.73752+00 | | 2023-10-28 02:21:56.151055+00 |
| public | w_latest_sensor | 201 | 776 | 3.00 | 79.00 | | 2023-10-28 02:21:56.167147+00 | | 2023-10-28 02:21:56.338708+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 | 87 | 37 | 0.00 | 29.00 | | 2023-10-27 18:01:59.006825+00 | | 2023-10-27 21:32:54.629433+00 |
| public | w_migration | 824 | 0 | 0.00 | 0.00 | | 2023-10-27 17:43:59.17854+00 | | |
| public | w_plan_with_detail | 7434226 | 333697 | 0.00 | 4.00 | | 2023-10-25 10:00:36.333242+00 | | 2023-10-27 00:07:25.730654+00 |