| 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 |
|---|
| e202409 | a_proximity_sum | 42141991 | 0 | 0.00 | 0.00 | | 2024-11-18 10:05:42.634616+00 | | 2024-11-09 02:35:11.414101+00 |
| e202409 | a_stay_time | 21852428 | 0 | 0.00 | 0.00 | | 2024-11-19 08:57:11.704091+00 | | 2024-10-31 04:06:41.049298+00 |
| e202409 | t_position_history | 452405322 | 0 | 0.00 | 0.00 | | 2024-11-18 12:11:09.970434+00 | | |
| e202409 | t_presence_history | 45407307 | 0 | 0.00 | 0.00 | | 2024-11-11 10:27:00.859434+00 | | |
| e202409 | t_sensor_history | 9170482 | 0 | 0.00 | 0.00 | | 2024-11-12 18:09:00.93874+00 | | |
| e202410 | a_proximity_sum | 35741934 | 0 | 0.00 | 0.00 | | 2024-11-14 11:36:55.316635+00 | | 2024-11-09 02:35:10.823595+00 |
| e202410 | a_stay_time | 23401626 | 0 | 0.00 | 0.00 | | 2024-11-15 01:46:06.552798+00 | | 2024-11-09 02:26:51.673576+00 |
| e202410 | t_position_history | 488419117 | 0 | 0.00 | 0.00 | | 2024-11-19 08:26:50.085467+00 | | 2024-10-30 02:43:29.948815+00 |
| e202410 | t_presence_history | 53882437 | 0 | 0.00 | 0.00 | | 2024-11-19 07:56:48.447014+00 | | 2024-10-31 14:26:50.9548+00 |
| e202410 | t_sensor_history | 9420648 | 0 | 0.00 | 0.00 | | 2024-11-14 05:49:51.811716+00 | | 2024-10-29 03:17:40.973549+00 |
| e202411 | a_proximity_sum | 20558610 | 1628987 | 0.00 | 7.00 | | 2024-11-17 17:58:11.729096+00 | | 2024-11-19 15:58:15.376885+00 |
| e202411 | a_stay_time | 19570457 | 0 | 0.00 | 0.00 | | 2024-11-19 15:34:42.246097+00 | | 2024-11-19 17:01:34.971366+00 |
| e202411 | t_position_history | 289803509 | 0 | 0.00 | 0.00 | | 2024-11-19 08:11:56.821087+00 | | 2024-11-19 14:26:09.444857+00 |
| e202411 | t_presence_history | 30370077 | 2217852 | 0.00 | 6.00 | | 2024-11-20 00:47:28.937993+00 | | 2024-11-20 00:41:50.439813+00 |
| e202411 | t_sensor_history | 5958074 | 0 | 0.00 | 0.00 | | 2024-11-18 20:06:27.47528+00 | | 2024-11-19 06:55:32.272375+00 |
| public | __digdag_status | 31 | 53 | 1.00 | 63.00 | | 2024-11-15 12:30:47.386453+00 | | 2024-11-17 03:30:16.950402+00 |
| public | a_attendance_sum | 46492 | 2604 | 0.00 | 5.00 | | 2024-11-20 00:47:29.759444+00 | | 2024-11-20 00:47:29.86033+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:48.127203+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:41.947683+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-11-16 01:08:43.867218+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-11-16 01:20:39.782814+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-11-16 01:08:11.752214+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-11-16 01:20:39.803472+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-11-16 01:20:39.824023+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-11-16 01:08:11.773528+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-11-16 01:08:11.731019+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-11-16 01:08:43.888969+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-11-16 01:08:11.795541+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-11-16 01:08:11.817293+00 | | |
| public | m_area | 661 | 0 | 0.00 | 0.00 | | 2024-11-15 13:41:03.777521+00 | | |
| public | m_auth | 121 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.144126+00 | | |
| public | m_category | 1847 | 2 | 0.00 | 0.00 | | 2024-11-15 13:41:03.751659+00 | | |
| public | m_exb | 21061 | 2157 | 0.00 | 9.00 | | 2024-11-13 10:45:45.105168+00 | | 2024-11-19 03:01:20.62119+00 |
| public | m_favorite | 223958 | 564 | 0.00 | 0.00 | | 2024-11-15 02:20:42.427012+00 | | 2024-10-08 10:00:05.802028+00 |
| public | m_favorite_group | 73700 | 13 | 0.00 | 0.00 | | 2024-11-18 18:32:00.152749+00 | | 2024-10-31 02:08:28.243557+00 |
| public | m_feature | 164 | 0 | 0.00 | 0.00 | | 2024-11-14 05:39:35.088053+00 | | |
| public | m_group | 17920 | 17 | 0.00 | 0.00 | | 2024-11-19 00:24:21.24447+00 | | |
| public | m_holiday | 25459 | 0 | 0.00 | 0.00 | | 2024-11-12 00:28:24.302035+00 | | |
| public | m_lob | 22104 | 79 | 0.00 | 0.00 | | 2024-11-12 05:05:06.276836+00 | | |
| public | m_location | 37736 | 2295 | 0.00 | 5.00 | | 2024-11-19 07:54:57.079171+00 | | 2024-11-19 13:03:39.574767+00 |
| public | m_notify_template | 735 | 5 | 0.00 | 0.00 | | 2024-11-13 23:00:48.284114+00 | | |
| public | m_outside | 321 | 0 | 0.00 | 0.00 | | 2024-11-19 16:50:33.506553+00 | | |
| public | m_pot | 161758 | 11318 | 0.00 | 6.00 | | 2024-11-19 11:46:13.685619+00 | | 2024-11-20 00:23:50.995078+00 |
| public | m_pot_profile | 48822 | 65 | 0.00 | 0.00 | | 2024-11-12 16:50:48.014279+00 | | |
| public | m_provider_user | 71 | 2 | 0.00 | 2.00 | | 2024-11-14 06:05:25.546696+00 | | |
| public | m_region | 98 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.366725+00 | | |
| public | m_role | 564 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.352412+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.23576+00 | | |
| public | m_setting | 12040 | 1510 | 0.00 | 11.00 | | 2024-11-18 23:15:42.656349+00 | | 2024-11-20 00:07:46.710345+00 |
| public | m_setting_log | 28876 | 1286 | 0.00 | 4.00 | | 2024-11-18 12:56:40.431739+00 | | 2024-11-19 23:32:51.409128+00 |
| public | m_site | 176 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.252323+00 | | |
| public | m_tenant | 97 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.488374+00 | | |
| public | m_tx | 146365 | 3101 | 0.00 | 2.00 | | 2024-11-19 16:12:45.340459+00 | | 2024-11-19 13:03:37.242773+00 |
| public | m_user | 30793 | 208 | 0.00 | 0.00 | | 2024-11-15 13:41:02.812855+00 | | |
| public | m_zone | 5144 | 211 | 0.00 | 3.00 | | 2024-11-14 14:12:16.515622+00 | | 2024-11-19 11:03:38.900547+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:40.783368+00 | | |
| public | r_auth_zone | 222 | 0 | 0.00 | 0.00 | | 2024-11-15 04:01:00.186236+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.310067+00 | | |
| public | r_group_auth | 588 | 0 | 0.00 | 0.00 | | 2024-11-17 09:11:01.335448+00 | | 2024-10-08 09:38:50.736835+00 |
| public | r_location_zone | 43552 | 2400 | 0.00 | 5.00 | | 2024-11-19 15:10:59.997397+00 | | 2024-11-19 15:11:00.128217+00 |
| public | r_pot_auth | 8383 | 0 | 0.00 | 0.00 | | 2024-11-15 15:30:11.976635+00 | | 2024-11-06 01:49:00.707869+00 |
| public | r_pot_category | 7007 | 0 | 0.00 | 0.00 | | 2024-11-19 20:10:49.515302+00 | | 2024-11-19 20:01:47.701524+00 |
| public | r_pot_group | 96028 | 15989 | 0.00 | 14.00 | | 2024-11-19 22:03:00.34599+00 | | 2024-11-20 00:23:48.400526+00 |
| public | r_pot_tx | 57568 | 1074 | 0.00 | 1.00 | | 2024-11-12 12:06:51.456986+00 | | 2024-11-15 03:06:20.926681+00 |
| public | r_pot_user | 18723 | 24 | 0.00 | 0.00 | | 2024-11-19 00:24:21.033795+00 | | |
| public | r_provider_tenant | 1363 | 84 | 0.00 | 5.00 | | 2024-11-12 05:51:24.323614+00 | | 2024-11-12 05:51:24.327858+00 |
| public | r_role_feature | 5163 | 2 | 0.00 | 0.00 | | 2024-11-19 00:24:21.06221+00 | | |
| public | r_tenant_feature | 3619 | 1 | 0.00 | 0.00 | | 2024-11-16 01:08:05.879257+00 | | |
| public | r_tx_sensor | 313 | 0 | 0.00 | 0.00 | | 2024-11-18 10:50:43.796767+00 | | |
| public | r_user_region | 19452 | 24 | 0.00 | 0.00 | | 2024-11-19 00:24:14.128344+00 | | 2024-11-14 08:21:09.435305+00 |
| public | r_user_site | 5094 | 6 | 0.00 | 0.00 | | 2024-11-13 23:00:48.214018+00 | | |
| public | r_zone_category | 3573 | 62 | 0.00 | 1.00 | | 2024-11-11 05:22:49.857283+00 | | 2024-11-19 14:45:53.443557+00 |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2024-11-18 02:42:10.807671+00 | | |
| public | t_attendance | 1674810 | 16835 | 0.00 | 0.00 | | 2024-11-16 01:08:43.840251+00 | | 2024-11-18 23:31:43.126254+00 |
| public | t_general | 2760 | 5 | 0.00 | 0.00 | | 2024-11-13 23:00:48.473778+00 | | 2024-11-13 03:43:51.184966+00 |
| public | t_mobile_device_history | 714247 | 0 | 0.00 | 0.00 | | 2024-11-15 06:13:35.268877+00 | | 2024-11-14 23:59:17.727218+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.331152+00 | | |
| public | t_notify_history | 3538343 | 10640 | 0.00 | 0.00 | | 2024-11-14 08:57:09.392093+00 | | 2024-11-13 02:26:04.171404+00 |
| public | t_operation_log | 13456648 | 12 | 0.00 | 0.00 | | 2024-11-11 06:32:26.37063+00 | | 2024-11-10 23:44:26.901532+00 |
| public | t_plan | 14593170 | 396219 | 0.00 | 2.00 | | 2024-11-18 07:18:52.060857+00 | | 2024-11-18 00:06:05.687042+00 |
| public | t_plan_detail | 25057682 | 1459499 | 0.00 | 5.00 | | 2024-11-12 02:39:26.755885+00 | | 2024-11-19 07:01:25.905315+00 |
| public | t_plan_sync | 42141 | 6231 | 0.00 | 12.00 | | 2024-11-20 00:19:49.396825+00 | | 2024-11-20 00:35:49.940981+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-11-13 23:00:48.511443+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:40.843385+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:48.38748+00 | | |
| public | t_recv_position_history | 122048 | 61340 | 0.00 | 33.00 | | 2024-11-20 00:50:47.56568+00 | 2024-11-19 13:30:27.621241+00 | 2024-11-20 00:50:48.138208+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-11-13 23:00:40.903751+00 | | |
| public | t_terminal | 108755 | 3612 | 0.00 | 3.00 | | 2024-11-12 12:06:53.337707+00 | | 2024-11-19 20:41:28.344891+00 |
| public | t_terminal_log | 12645397 | 0 | 0.00 | 0.00 | | 2024-11-20 00:31:09.449948+00 | | 2024-11-11 00:59:08.212201+00 |
| public | w_arrival_notify | 85 | 58 | 0.00 | 40.00 | | 2024-11-15 01:34:47.632433+00 | | 2024-11-19 01:35:14.515959+00 |
| public | w_latest_position | 62452 | 15770 | 0.00 | 20.00 | | 2024-11-20 00:50:48.299859+00 | | 2024-11-20 00:50:48.446308+00 |
| public | w_latest_presence | 196016 | 121590 | 0.00 | 38.00 | | 2024-11-20 00:50:52.736292+00 | | 2024-11-20 00:50:53.143906+00 |
| public | w_latest_sensor | 340 | 210 | 0.00 | 38.00 | | 2024-11-20 00:50:48.46254+00 | | 2024-11-20 00:50:48.575144+00 |
| public | w_lock | 14923 | 0 | 0.00 | 0.00 | | 2024-11-18 17:08:42.524879+00 | | |
| public | w_master_update | 172 | 16 | 0.00 | 8.00 | | 2024-11-20 00:31:50.514985+00 | | 2024-11-20 00:22:48.256876+00 |
| public | w_migration | 795 | 0 | 0.00 | 0.00 | | 2024-11-14 00:25:14.51583+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2024-11-13 09:39:14.035575+00 | | |
| public | w_plan_with_detail | 14581593 | 894982 | 0.00 | 5.00 | | 2024-11-14 06:38:03.2329+00 | | 2024-11-18 00:03:58.161183+00 |