| 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 |
|---|
| e202503 | a_proximity_sum | 30294796 | 0 | 0.00 | 0.00 | | 2025-05-28 01:09:35.275088+00 | | |
| e202503 | a_stay_time | 37339215 | 0 | 0.00 | 0.00 | | 2025-05-26 08:36:13.541033+00 | | |
| e202503 | t_position_history | 458909847 | 0 | 0.00 | 0.00 | | 2025-05-26 05:41:23.788652+00 | | |
| e202503 | t_presence_history | 47512303 | 0 | 0.00 | 0.00 | | 2025-05-27 11:57:13.991345+00 | | |
| e202503 | t_sensor_history | 13280502 | 0 | 0.00 | 0.00 | | 2025-05-27 04:02:57.295094+00 | | |
| e202504 | a_proximity_sum | 30878862 | 0 | 0.00 | 0.00 | | 2025-05-28 19:34:32.705747+00 | | |
| e202504 | a_stay_time | 39029265 | 0 | 0.00 | 0.00 | | 2025-05-27 12:54:06.526509+00 | | |
| e202504 | t_position_history | 474345258 | 105342 | 0.00 | 0.00 | | 2025-05-21 01:04:32.290583+00 | | |
| e202504 | t_presence_history | 55949935 | 0 | 0.00 | 0.00 | | 2025-05-27 03:13:41.032342+00 | | |
| e202504 | t_sensor_history | 12827583 | 0 | 0.00 | 0.00 | | 2025-05-25 22:21:03.589633+00 | | |
| e202505 | a_proximity_sum | 24519218 | 0 | 0.00 | 0.00 | | 2025-05-26 17:56:23.690847+00 | | 2025-05-27 17:40:38.47981+00 |
| e202505 | a_stay_time | 34229569 | 0 | 0.00 | 0.00 | | 2025-05-26 18:06:11.143826+00 | | 2025-05-27 17:25:37.265798+00 |
| e202505 | t_position_history | 481738286 | 0 | 0.00 | 0.00 | | 2025-05-28 04:58:55.750785+00 | | 2025-05-27 07:42:06.96181+00 |
| e202505 | t_presence_history | 47640216 | 8736286 | 0.00 | 15.00 | | 2025-05-29 00:16:26.175973+00 | | 2025-05-29 00:55:07.946195+00 |
| e202505 | t_sensor_history | 11543881 | 0 | 0.00 | 0.00 | | 2025-05-28 05:11:36.349708+00 | | 2025-05-27 01:17:51.429445+00 |
| public | __digdag_status | 32 | 5 | 0.00 | 13.00 | | 2025-05-28 09:38:39.781808+00 | | 2025-05-28 12:35:51.665267+00 |
| public | a_attendance_sum | 114191 | 21847 | 0.00 | 16.00 | | 2025-05-29 00:34:28.329909+00 | | 2025-05-29 00:48:26.460394+00 |
| public | a_plan_actual | 505979 | 0 | 0.00 | 0.00 | | 2025-05-20 19:30:07.013532+00 | | 2025-05-28 16:40:47.032705+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-05-22 10:26:01.943639+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-05-22 10:22:23.735882+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-05-22 10:14:59.605906+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-05-25 06:33:37.86406+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:50.508171+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:51.55819+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.667563+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:51.577661+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:51.597435+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.686497+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.645265+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:50.528949+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.707344+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.72768+00 | | |
| public | l_area | 1322 | 1 | 0.00 | 0.00 | | 2025-05-27 11:11:25.765295+00 | | 2025-05-27 11:11:25.775817+00 |
| public | l_auth | 152 | 0 | 0.00 | 0.00 | | | | 2025-05-27 11:12:25.457228+00 |
| public | l_category | 2314 | 1 | 0.00 | 0.00 | | 2025-05-27 11:11:26.39329+00 | | 2025-05-27 11:11:26.410357+00 |
| public | l_group | 31485 | 26 | 0.00 | 0.00 | | 2025-05-27 11:11:26.683893+00 | | 2025-05-27 11:11:27.996149+00 |
| public | l_location | 84687 | 68 | 0.00 | 0.00 | | 2025-05-27 11:11:25.960033+00 | | 2025-05-27 11:11:26.378793+00 |
| public | l_location_zone | 67190 | 192 | 0.00 | 0.00 | | 2025-05-27 11:12:25.509799+00 | | 2025-05-27 11:12:25.615825+00 |
| public | l_outside | 399 | 1 | 0.00 | 0.00 | | | | 2025-05-27 11:12:25.473139+00 |
| public | l_pot | 344290 | 215 | 0.00 | 0.00 | | 2025-05-27 11:11:28.531419+00 | | 2025-05-27 11:11:29.437553+00 |
| public | l_pot_category | 9971 | 3 | 0.00 | 0.00 | | 2025-05-27 11:12:25.632047+00 | | 2025-05-27 11:12:25.6537+00 |
| public | l_pot_group | 203791 | 61 | 0.00 | 0.00 | | 2025-05-27 11:12:25.900684+00 | | 2025-05-27 11:12:26.045879+00 |
| public | l_pot_tx | 82804 | 87 | 0.00 | 0.00 | | 2025-05-27 11:12:25.698626+00 | | 2025-05-27 11:12:25.810722+00 |
| public | l_role | 646 | 1 | 0.00 | 0.00 | | | | 2025-05-27 11:12:22.546994+00 |
| public | l_role_feature | 6024 | 1 | 0.00 | 0.00 | | 2025-05-27 11:15:22.632488+00 | | 2025-05-27 11:15:22.647362+00 |
| public | l_site | 225 | 3 | 0.00 | 1.00 | | | | 2025-05-27 11:11:25.791401+00 |
| public | l_tx | 124480 | 10292 | 0.00 | 7.00 | | 2025-05-27 11:11:26.478849+00 | | 2025-05-27 11:11:26.638826+00 |
| public | l_user | 53824 | 233 | 0.00 | 0.00 | | 2025-05-27 11:11:22.362279+00 | | 2025-05-27 11:11:22.891703+00 |
| public | l_zone | 8723 | 8 | 0.00 | 0.00 | | 2025-05-27 11:11:25.812029+00 | | 2025-05-27 11:11:25.89755+00 |
| public | l_zone_category | 4473 | 6 | 0.00 | 0.00 | | 2025-05-27 11:12:22.373918+00 | | 2025-05-27 11:12:22.386434+00 |
| public | m_area | 703 | 2 | 0.00 | 0.00 | | 2025-05-24 09:16:50.429727+00 | | |
| public | m_auth | 128 | 1 | 0.00 | 0.00 | | 2025-05-22 10:51:33.902365+00 | | |
| public | m_category | 2120 | 1 | 0.00 | 0.00 | | 2025-05-24 09:16:50.389205+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-05-26 01:49:36.63992+00 | | |
| public | m_exb | 22428 | 156 | 0.00 | 0.00 | | 2025-05-22 06:08:29.663558+00 | | |
| public | m_favorite | 224225 | 1147 | 0.00 | 0.00 | | 2025-05-23 09:50:54.237969+00 | | |
| public | m_favorite_group | 99253 | 41 | 0.00 | 0.00 | | 2025-05-27 00:53:40.214436+00 | | |
| public | m_feature | 167 | 0 | 0.00 | 0.00 | | 2025-05-22 23:18:16.010146+00 | | |
| public | m_group | 25707 | 3778 | 0.00 | 12.00 | | 2025-05-27 10:19:49.51152+00 | | 2025-05-28 14:40:49.391098+00 |
| public | m_holiday | 34730 | 0 | 0.00 | 0.00 | | 2025-05-20 13:40:35.886395+00 | | |
| public | m_lob | 23007 | 50 | 0.00 | 0.00 | | 2025-05-21 01:12:58.92568+00 | | |
| public | m_lob_log | 1397 | 0 | 0.00 | 0.00 | | 2025-05-28 08:01:18.601693+00 | | |
| public | m_location | 38980 | 500 | 0.00 | 1.00 | | 2025-05-24 02:12:18.464624+00 | | 2025-05-23 10:14:57.815674+00 |
| public | m_notify_template | 821 | 1 | 0.00 | 0.00 | | 2025-05-22 10:51:34.056568+00 | | |
| public | m_outside | 340 | 0 | 0.00 | 0.00 | | 2025-05-28 01:09:34.950703+00 | | |
| public | m_personal_setting | 121685 | 2160 | 0.00 | 1.00 | | 2025-05-29 00:55:12.822778+00 | | 2025-05-29 00:24:34.407624+00 |
| public | m_pot | 178384 | 16796 | 0.00 | 8.00 | | 2025-05-26 08:03:52.452517+00 | | 2025-05-29 00:20:46.85485+00 |
| public | m_pot_profile | 58688 | 39 | 0.00 | 0.00 | | 2025-05-21 07:53:13.747378+00 | | |
| public | m_provider_user | 77 | 18 | 0.00 | 18.00 | | 2025-05-23 00:57:46.827296+00 | | |
| public | m_region | 107 | 0 | 0.00 | 0.00 | | 2025-05-22 10:51:58.071253+00 | | |
| public | m_role | 649 | 1 | 0.00 | 0.00 | | 2025-05-22 10:51:34.254744+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-05-22 10:51:34.000525+00 | | |
| public | m_setting | 14511 | 2131 | 0.00 | 12.00 | | 2025-05-27 15:33:54.174952+00 | | 2025-05-29 00:16:40.903495+00 |
| public | m_setting_log | 33125 | 1502 | 0.00 | 4.00 | | 2025-05-24 16:13:47.165242+00 | | 2025-05-28 09:55:09.264258+00 |
| public | m_site | 174 | 5 | 0.00 | 2.00 | | 2025-05-22 10:51:33.880466+00 | | |
| public | m_tenant | 106 | 2 | 0.00 | 1.00 | | 2025-05-22 10:51:59.02169+00 | | |
| public | m_tx | 159676 | 0 | 0.00 | 0.00 | | 2025-05-29 00:57:21.626334+00 | | 2025-05-29 00:56:20.557029+00 |
| public | m_user | 32297 | 182 | 0.00 | 0.00 | | 2025-05-27 07:25:28.832952+00 | | 2025-05-26 02:24:57.849514+00 |
| public | m_zone | 6278 | 113 | 0.00 | 1.00 | | 2025-05-23 05:13:22.356128+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-05-22 10:14:59.582079+00 | | |
| public | r_auth_zone | 203 | 0 | 0.00 | 0.00 | | 2025-05-23 12:14:19.090635+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-05-22 10:51:34.081412+00 | | |
| public | r_group_auth | 528 | 0 | 0.00 | 0.00 | | 2025-05-25 23:40:57.04958+00 | | |
| public | r_location_zone | 52013 | 704 | 0.00 | 1.00 | | 2025-05-24 09:16:50.284214+00 | | 2025-05-22 10:51:34.225911+00 |
| public | r_pot_auth | 5712 | 3 | 0.00 | 0.00 | | 2025-05-22 10:14:59.552769+00 | | 2025-05-22 10:14:59.569465+00 |
| public | r_pot_category | 13740 | 15 | 0.00 | 0.00 | | 2025-05-28 06:52:03.244902+00 | | |
| public | r_pot_group | 318683 | 106 | 0.00 | 0.00 | | 2025-05-26 01:07:37.176419+00 | | |
| public | r_pot_tx | 62857 | 59 | 0.00 | 0.00 | | 2025-05-29 00:02:58.212009+00 | | |
| public | r_pot_user | 19636 | 36 | 0.00 | 0.00 | | 2025-05-21 02:26:45.809107+00 | | 2025-05-26 02:24:57.152566+00 |
| public | r_provider_tenant | 1169 | 0 | 0.00 | 0.00 | | 2025-05-26 04:20:05.832872+00 | | 2025-05-26 04:16:58.715888+00 |
| public | r_role_feature | 5673 | 2 | 0.00 | 0.00 | | 2025-05-27 01:45:39.52967+00 | | |
| public | r_tenant_feature | 4172 | 0 | 0.00 | 0.00 | | 2025-05-24 17:50:05.433606+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-05-26 13:50:53.168236+00 | | |
| public | r_user_region | 21945 | 34 | 0.00 | 0.00 | | 2025-05-21 02:43:58.063368+00 | | |
| public | r_user_site | 5529 | 26 | 0.00 | 0.00 | | 2025-05-22 10:51:33.977226+00 | | |
| public | r_zone_category | 4230 | 0 | 0.00 | 0.00 | | 2025-05-28 08:01:18.561223+00 | | |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2025-05-26 05:41:23.370326+00 | | |
| public | t_attendance | 2616556 | 28127 | 0.00 | 1.00 | | 2025-05-24 17:55:02.313335+00 | | |
| public | t_general | 3763 | 6 | 0.00 | 0.00 | | 2025-05-22 10:51:58.234272+00 | | |
| public | t_mobile_device_history | 1213176 | 0 | 0.00 | 0.00 | | 2025-05-23 01:31:22.51233+00 | | |
| public | t_mobile_status_history | 759949 | 0 | 0.00 | 0.00 | | 2025-05-20 23:18:27.571062+00 | | 2025-05-28 01:51:31.590592+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-05-22 10:51:34.102627+00 | | |
| public | t_notify_history | 5428171 | 15883 | 0.00 | 0.00 | | 2025-05-23 01:59:31.353117+00 | | |
| public | t_operation_log | 19769805 | 9 | 0.00 | 0.00 | | 2025-05-28 09:38:38.934476+00 | | |
| public | t_plan | 22716545 | 823590 | 0.00 | 3.00 | | 2025-05-26 10:46:58.08304+00 | | 2025-05-27 00:25:23.918524+00 |
| public | t_plan_cancel_history | 376094 | 8066 | 0.00 | 2.00 | | 2025-05-28 07:19:54.247181+00 | | |
| public | t_plan_detail | 39037142 | 3145699 | 0.00 | 7.00 | | 2025-05-20 23:18:14.273014+00 | | 2025-05-28 10:39:50.984652+00 |
| public | t_plan_sync | 49247 | 6503 | 0.00 | 11.00 | | 2025-05-29 00:37:25.686237+00 | | 2025-05-29 00:37:26.031136+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-05-22 10:51:59.046068+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-05-22 10:14:59.663586+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-05-22 10:51:58.094496+00 | | |
| public | t_recv_position_history | 138368 | 222610 | 1.00 | 61.00 | | 2025-05-29 01:02:25.753542+00 | 2025-05-28 13:30:15.166104+00 | 2025-05-29 01:02:26.351182+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-05-22 10:15:02.420048+00 | | |
| public | t_terminal | 13408 | 2312 | 0.00 | 14.00 | | 2025-05-28 22:19:57.229653+00 | | 2025-05-29 00:53:29.086308+00 |
| public | t_terminal_log | 21108914 | 0 | 0.00 | 0.00 | | 2025-05-28 05:43:47.323415+00 | | |
| public | temp_pivot_table | 241107 | 0 | 0.00 | 0.00 | | 2025-05-21 07:53:24.223165+00 | | |
| public | w_arrival_notify | 100 | 34 | 0.00 | 25.00 | | 2025-05-27 05:04:14.00739+00 | | 2025-05-28 10:15:55.432065+00 |
| public | w_latest_mobile_device | 51678 | 2444 | 0.00 | 4.00 | | 2025-05-26 07:20:53.109502+00 | | 2025-05-29 00:26:28.563749+00 |
| public | w_latest_mobile_status | 50604 | 6407 | 0.00 | 11.00 | | 2025-05-29 00:03:58.373019+00 | | 2025-05-29 00:57:31.690667+00 |
| public | w_latest_position | 71273 | 75936 | 1.00 | 51.00 | | 2025-05-29 01:02:26.521654+00 | | 2025-05-29 01:02:26.709067+00 |
| public | w_latest_presence | 215450 | 399112 | 1.00 | 64.00 | | 2025-05-29 01:02:27.060307+00 | | 2025-05-29 01:02:29.248884+00 |
| public | w_latest_sensor | 386 | 864 | 2.00 | 69.00 | | 2025-05-29 01:02:26.724188+00 | | 2025-05-29 01:02:26.850275+00 |
| public | w_lock | 16868 | 0 | 0.00 | 0.00 | | 2025-05-26 23:49:50.845851+00 | | |
| public | w_master_update | 187 | 61 | 0.00 | 24.00 | | 2025-05-28 23:33:37.656244+00 | | 2025-05-28 23:32:37.539074+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-05-22 13:35:40.342833+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-05-22 10:08:42.858149+00 | | |
| public | w_plan_with_detail | 22736231 | 1321796 | 0.00 | 5.00 | | 2025-05-23 00:48:34.444086+00 | | 2025-05-27 00:12:53.357921+00 |