| 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 | 272439168 | 307973 | 0.00 | 0.00 | | 2023-10-21 23:06:54.341224+00 | | 2023-09-07 00:23:56.057706+00 |
| e202308 | t_presence_history | 31115701 | 8908 | 0.00 | 0.00 | | 2023-10-20 06:13:22.939294+00 | | 2023-09-30 00:53:09.308717+00 |
| e202308 | t_sensor_history | 3653880 | 11783 | 0.00 | 0.00 | | 2023-10-19 04:36:28.605182+00 | | 2023-10-29 20:54:39.074786+00 |
| e202309 | a_proximity_sum | 44156732 | 0 | 0.00 | 0.00 | | 2023-10-30 01:37:42.682763+00 | | 2023-09-29 16:16:31.126327+00 |
| e202309 | a_stay_time | 14706856 | 141002 | 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 | 275993514 | 1755951 | 0.00 | 0.00 | | 2023-10-10 15:45:15.062908+00 | | 2023-09-30 00:38:09.107617+00 |
| e202309 | t_presence_history | 45332488 | 10880 | 0.00 | 0.00 | | 2023-10-20 04:04:54.164138+00 | | 2023-09-30 14:40:56.529237+00 |
| e202309 | t_sensor_history | 3395139 | 199677 | 0.00 | 5.00 | | 2023-10-26 19:47:23.027163+00 | | 2023-10-28 19:46:17.049881+00 |
| e202310 | a_proximity_sum | 42459551 | 0 | 0.00 | 0.00 | | 2023-10-28 23:31:39.449166+00 | | 2023-10-29 22:04:15.257574+00 |
| e202310 | a_stay_time | 15194784 | 0 | 0.00 | 0.00 | | 2023-10-25 15:48:58.589994+00 | | 2023-10-29 15:13:55.035124+00 |
| e202310 | l_position_history | 0 | 0 | 0 | 0 | | 2023-10-29 02:31:09.422072+00 | | |
| e202310 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-10-29 02:31:09.444104+00 | | |
| e202310 | l_stay_time | 0 | 0 | 0 | 0 | | 2023-10-29 02:31:09.433077+00 | | |
| e202310 | t_position_history | 286016852 | 10 | 0.00 | 0.00 | | 2023-10-25 06:11:15.105229+00 | | 2023-10-27 07:29:29.409671+00 |
| e202310 | t_presence_history | 40586079 | 3629721 | 0.00 | 8.00 | | 2023-10-30 02:30:47.822148+00 | | 2023-10-30 02:30:48.433356+00 |
| e202310 | t_sensor_history | 3460909 | 0 | 0.00 | 0.00 | | 2023-10-25 06:45:09.027167+00 | | 2023-10-29 12:34:58.705039+00 |
| public | __digdag_status | 11 | 40 | 3.00 | 78.00 | | 2023-10-28 03:34:06.208003+00 | | 2023-10-29 12:32:08.282982+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 | 22 | 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 | 1390 | 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 | 122600 | 50 | 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 | 16654 | 28 | 0.00 | 0.00 | | 2023-10-24 04:13:01.643456+00 | | 2023-10-23 04:19:49.20493+00 |
| public | m_location | 26648 | 394 | 0.00 | 1.00 | | 2023-10-27 15:57:51.681111+00 | | 2023-10-23 01:53:51.290928+00 |
| public | m_notify_template | 541 | 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 | 129042 | 15900 | 0.00 | 10.00 | | 2023-10-26 00:21:51.386331+00 | | 2023-10-29 23:59:04.813065+00 |
| public | m_pot_profile | 23382 | 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 | 89 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.776615+00 | | |
| public | m_role | 443 | 1 | 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 | 15532 | 354 | 0.00 | 2.00 | | 2023-10-30 02:03:37.131723+00 | | 2023-10-30 01:23:28.966229+00 |
| public | m_setting_log | 477125 | 79042 | 0.00 | 14.00 | | 2023-10-25 12:32:09.850171+00 | | 2023-10-29 12:32:07.757548+00 |
| public | m_site | 149 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.668678+00 | | |
| public | m_tenant | 88 | 0 | 0.00 | 0.00 | | 2023-10-27 14:47:58.83453+00 | | |
| public | m_tx | 66851 | 4562 | 0.00 | 6.00 | | 2023-10-28 08:50:31.730346+00 | | 2023-10-28 10:05:59.611838+00 |
| public | m_user | 26195 | 1220 | 0.00 | 4.00 | | 2023-10-12 06:50:42.574194+00 | | 2023-10-24 14:29:18.246643+00 |
| public | m_zone | 5345 | 0 | 0.00 | 0.00 | | 2023-10-29 23:41:31.592595+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 | 2 | 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 | 84590 | 16224 | 0.00 | 16.00 | | 2023-10-29 22:04:15.635738+00 | | 2023-10-30 00:32:18.21257+00 |
| public | r_pot_tx | 37035 | 806 | 0.00 | 2.00 | | 2023-10-24 16:56:41.984436+00 | | 2023-10-27 09:19:14.017145+00 |
| public | r_pot_user | 17076 | 343 | 0.00 | 1.00 | | 2023-10-25 07:02:38.906029+00 | | 2023-10-26 07:26:12.639045+00 |
| public | r_role_feature | 4753 | 17 | 0.00 | 0.00 | | 2023-10-18 00:01:34.0861+00 | | 2023-10-17 10:56:07.752636+00 |
| public | r_tenant_feature | 2932 | 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 | 17506 | 345 | 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 | 280 | 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 | 470283 | 35645 | 0.00 | 7.00 | | 2023-10-15 00:45:34.874453+00 | | 2023-10-27 09:11:08.930661+00 |
| public | t_general | 797 | 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 | 275833 | 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 | 1468043 | 4969 | 0.00 | 0.00 | | 2023-10-29 12:23:05.910497+00 | | 2023-10-20 07:01:25.129331+00 |
| public | t_operation_log | 5770901 | 70514 | 0.00 | 1.00 | | 2023-10-21 21:32:29.917526+00 | | 2023-10-17 18:39:15.466485+00 |
| public | t_plan | 7467008 | 1209192 | 0.00 | 13.00 | | 2023-10-15 23:26:04.680073+00 | | 2023-10-27 04:48:19.087458+00 |
| public | t_plan_detail | 10899828 | 944584 | 0.00 | 7.00 | | 2023-10-19 13:57:53.147195+00 | | 2023-10-27 04:54:29.571377+00 |
| public | t_plan_sync | 32154 | 1143 | 0.00 | 3.00 | | 2023-10-30 00:50:04.999098+00 | | 2023-10-30 00:32:18.37481+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 | 102647 | 1714387 | 16.00 | 94.00 | | 2023-10-30 02:24:05.5484+00 | 2023-10-29 12:30:08.932999+00 | 2023-10-30 02:24:05.982627+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2023-10-27 14:47:58.586789+00 | | |
| public | t_terminal | 3025 | 675 | 0.00 | 18.00 | | 2023-10-30 01:35:39.497832+00 | | 2023-10-30 02:06:23.311093+00 |
| public | t_terminal_log | 2283314 | 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 | 45 | 54 | 1.00 | 54.00 | | 2023-10-10 15:47:01.885193+00 | | 2023-10-13 15:00:41.417042+00 |
| public | w_latest_position | 46767 | 534228 | 11.00 | 91.00 | | 2023-10-30 02:24:01.889273+00 | | 2023-10-30 02:24:04.987803+00 |
| public | w_latest_presence | 64774 | 3731560 | 57.00 | 98.00 | | 2023-10-30 02:23:56.48768+00 | | 2023-10-30 02:23:59.713013+00 |
| public | w_latest_sensor | 201 | 2544 | 12.00 | 92.00 | | 2023-10-30 02:23:59.730727+00 | | 2023-10-30 02:23:59.910027+00 |
| public | w_lock | 7860 | 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 | 88 | 44 | 0.00 | 33.00 | | 2023-10-30 01:05:55.245533+00 | | 2023-10-30 01:51:00.726256+00 |
| public | w_migration | 824 | 0 | 0.00 | 0.00 | | 2023-10-27 17:43:59.17854+00 | | |
| public | w_plan_with_detail | 7457574 | 437285 | 0.00 | 5.00 | | 2023-10-25 10:00:36.333242+00 | | 2023-10-27 00:07:25.730654+00 |