| 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 |
|---|
| e202412 | a_proximity_sum | 1694920 | 0 | 0.00 | 0.00 | | 2025-02-21 08:30:05.379398+00 | | 2024-12-26 15:35:37.647537+00 |
| e202412 | a_stay_time | 4858369 | 0 | 0.00 | 0.00 | | 2025-02-21 08:17:40.175839+00 | | 2024-12-27 17:00:50.351342+00 |
| e202412 | t_position_history | 37421166 | 0 | 0.00 | 0.00 | | 2025-02-24 04:54:09.539784+00 | | 2024-12-29 05:42:10.531261+00 |
| e202412 | t_presence_history | 5539985 | 0 | 0.00 | 0.00 | | 2025-02-26 05:57:47.846661+00 | | 2024-12-31 14:58:46.773602+00 |
| e202412 | t_sensor_history | 1266139 | 0 | 0.00 | 0.00 | | 2025-02-22 04:21:22.906707+00 | | 2024-12-30 10:28:43.508171+00 |
| e202501 | a_proximity_sum | 2201927 | 0 | 0.00 | 0.00 | | 2025-02-22 03:29:54.665251+00 | | 2025-01-31 15:36:25.096641+00 |
| e202501 | a_stay_time | 5300263 | 0 | 0.00 | 0.00 | | 2025-02-22 03:30:31.825696+00 | | 2025-01-31 15:32:23.323967+00 |
| e202501 | t_position_history | 38104163 | 0 | 0.00 | 0.00 | | 2025-02-21 17:32:55.6743+00 | | 2025-01-30 06:08:06.87726+00 |
| e202501 | t_presence_history | 3913137 | 0 | 0.00 | 0.00 | | 2025-02-26 05:49:03.581422+00 | | 2025-01-31 14:59:18.805228+00 |
| e202501 | t_sensor_history | 1259436 | 0 | 0.00 | 0.00 | | 2025-02-27 06:55:58.234551+00 | | 2025-01-30 02:50:22.221246+00 |
| e202502 | a_proximity_sum | 2395425 | 0 | 0.00 | 0.00 | | 2025-02-21 15:38:22.582332+00 | | 2025-02-26 17:02:53.268407+00 |
| e202502 | a_stay_time | 5994554 | 0 | 0.00 | 0.00 | | 2025-02-26 15:42:08.488022+00 | | 2025-02-27 17:00:28.83521+00 |
| e202502 | t_position_history | 35607967 | 0 | 0.00 | 0.00 | | 2025-02-27 08:37:09.855716+00 | | 2025-02-27 23:03:10.166044+00 |
| e202502 | t_presence_history | 3822604 | 827006 | 0.00 | 17.00 | | 2025-02-28 01:15:16.361523+00 | | 2025-02-28 01:29:43.371544+00 |
| e202502 | t_sensor_history | 1133473 | 0 | 0.00 | 0.00 | | 2025-02-23 23:50:39.614589+00 | | 2025-02-25 19:01:10.850524+00 |
| public | __digdag_status | 12 | 11 | 0.00 | 47.00 | | 2025-02-27 00:10:49.700486+00 | | 2025-02-25 13:11:01.126283+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2025-02-25 06:00:48.58501+00 | | |
| public | a_plan_actual | 12389 | 0 | 0.00 | 0.00 | | 2025-02-27 16:01:30.332562+00 | | 2025-02-27 16:01:30.415664+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-02-22 12:52:28.640853+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-02-22 12:39:00.555483+00 | | |
| public | b_attendance_group | 622109 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:25.795172+00 | | 2025-01-23 17:35:30.399806+00 |
| public | b_attendance_hour | 9678100 | 0 | 0.00 | 0.00 | | 2025-02-22 23:32:12.428383+00 | | 2025-01-20 17:35:58.724439+00 |
| public | b_attendance_pot | 536411 | 0 | 0.00 | 0.00 | | 2025-02-19 05:03:40.994979+00 | | 2025-02-11 18:35:55.944299+00 |
| public | b_attendance_pot_hour | 8115712 | 0 | 0.00 | 0.00 | | 2025-02-27 12:08:29.126167+00 | | 2025-02-10 18:37:00.65421+00 |
| public | b_check_in | 4837827 | 0 | 0.00 | 0.00 | | 2025-02-23 00:40:35.971704+00 | | 2025-02-24 18:00:32.375413+00 |
| public | b_check_in_hour | 74006777 | 0 | 0.00 | 0.00 | | 2025-02-22 23:33:43.740738+00 | | 2025-02-19 17:35:17.734306+00 |
| public | b_check_in_pot | 209700 | 0 | 0.00 | 0.00 | | 2025-02-19 23:50:14.935047+00 | | 2025-02-10 05:56:17.869751+00 |
| public | b_check_in_pot_hour | 4469825 | 0 | 0.00 | 0.00 | | 2025-02-18 22:37:36.505848+00 | | 2025-02-10 05:58:40.115839+00 |
| public | b_proximity_group | 44102585 | 0 | 0.00 | 0.00 | | 2025-02-23 00:21:36.825222+00 | | 2025-02-19 17:40:19.116415+00 |
| public | b_proximity_info | 44726274 | 0 | 0.00 | 0.00 | | 2025-02-19 23:41:30.680795+00 | | 2025-02-19 17:15:11.119187+00 |
| public | b_seat_reserve | 1170212 | 0 | 0.00 | 0.00 | | 2025-02-22 23:42:24.927173+00 | | 2025-02-12 17:42:03.871821+00 |
| public | b_seat_reserve_hour | 22242252 | 0 | 0.00 | 0.00 | | 2025-02-22 12:36:00.036522+00 | | 2025-02-12 17:46:04.081408+00 |
| public | b_usage | 1326573 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:28.498366+00 | | 2025-02-10 05:56:15.817511+00 |
| public | b_usage_hour | 24881798 | 0 | 0.00 | 0.00 | | 2025-02-22 23:11:58.357677+00 | | 2025-02-09 17:35:31.162682+00 |
| public | m_area | 89 | 1 | 0.00 | 1.00 | | 2025-02-23 01:15:14.962622+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2025-02-22 23:34:22.305273+00 | | |
| public | m_category | 413 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:28.60902+00 | | 2025-02-10 05:48:24.891406+00 |
| public | m_exb | 3970 | 0 | 0.00 | 0.00 | | 2025-02-27 10:24:04.369115+00 | | 2025-02-10 05:41:11.048945+00 |
| public | m_favorite | 39529 | 228 | 0.00 | 0.00 | | 2025-02-21 06:16:02.457257+00 | | 2025-02-12 00:12:59.77606+00 |
| public | m_favorite_group | 8269 | 2 | 0.00 | 0.00 | | 2025-02-25 04:15:16.5636+00 | | 2025-02-18 02:53:28.014744+00 |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-02-23 01:15:14.946377+00 | | |
| public | m_group | 2321 | 0 | 0.00 | 0.00 | | 2025-02-21 09:03:05.393165+00 | | |
| public | m_holiday | 5455 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:34.539749+00 | | 2025-02-10 05:41:11.341818+00 |
| public | m_lob | 1176 | 3 | 0.00 | 0.00 | | 2025-02-21 08:51:27.001473+00 | | 2025-02-12 07:14:27.67477+00 |
| public | m_lob_log | 50 | 0 | 0.00 | 0.00 | | 2025-02-27 01:23:47.205631+00 | | |
| public | m_location | 5096 | 0 | 0.00 | 0.00 | | 2025-02-21 09:03:05.564189+00 | | 2024-11-25 04:16:30.357563+00 |
| public | m_notify_template | 122 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:28.534674+00 | | |
| public | m_outside | 65 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:26.440302+00 | | |
| public | m_pot | 30091 | 661 | 0.00 | 2.00 | | 2025-02-28 01:15:31.189645+00 | | 2025-02-28 00:10:52.781439+00 |
| public | m_pot_profile | 709 | 1 | 0.00 | 0.00 | | 2025-02-22 23:31:55.966975+00 | | 2025-02-12 00:05:59.139952+00 |
| public | m_provider_user | 59 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:26.408788+00 | | |
| public | m_region | 16 | 0 | 0.00 | 0.00 | | 2025-02-23 00:47:29.478633+00 | | |
| public | m_role | 76 | 0 | 0.00 | 0.00 | | 2025-02-23 01:15:14.928441+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-02-23 00:40:29.203072+00 | | |
| public | m_setting | 3308 | 70 | 0.00 | 2.00 | | 2025-02-27 16:42:40.572604+00 | | 2025-02-26 20:09:18.712866+00 |
| public | m_setting_log | 4766 | 908 | 0.00 | 16.00 | | 2025-02-22 12:30:52.940026+00 | | 2025-02-27 10:05:57.23794+00 |
| public | m_site | 25 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:28.514448+00 | | |
| public | m_tenant | 16 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:26.36859+00 | | |
| public | m_tx | 27578 | 190 | 0.00 | 0.00 | | 2025-02-19 07:22:30.234807+00 | | 2025-02-14 06:13:10.403632+00 |
| public | m_user | 5248 | 2 | 0.00 | 0.00 | | 2025-02-25 23:57:46.533353+00 | | 2024-12-17 09:55:38.578628+00 |
| public | m_zone | 805 | 9 | 0.00 | 1.00 | | 2025-02-22 12:52:28.62934+00 | | 2025-02-10 05:48:24.91203+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-02-22 23:42:24.938127+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2025-02-23 00:40:29.181935+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:28.557711+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2025-02-22 23:42:22.524728+00 | | |
| public | r_location_zone | 5322 | 0 | 0.00 | 0.00 | | 2025-02-27 02:11:41.641496+00 | | 2025-02-26 08:50:53.534576+00 |
| public | r_pot_auth | 27 | 10 | 0.00 | 27.00 | | 2025-02-22 23:34:22.327244+00 | | |
| public | r_pot_category | 887 | 2 | 0.00 | 0.00 | | 2025-02-22 23:34:25.705529+00 | | 2025-02-13 07:38:34.182171+00 |
| public | r_pot_group | 12574 | 1513 | 0.00 | 10.00 | | 2025-02-27 21:05:59.489199+00 | | 2025-02-27 23:33:56.914162+00 |
| public | r_pot_tx | 9535 | 1 | 0.00 | 0.00 | | 2025-02-26 08:14:11.327358+00 | | 2025-01-31 07:06:47.51958+00 |
| public | r_pot_user | 2787 | 0 | 0.00 | 0.00 | | 2025-02-23 09:20:24.383191+00 | | 2025-01-31 07:06:47.486744+00 |
| public | r_provider_tenant | 160 | 0 | 0.00 | 0.00 | | 2025-02-21 06:45:14.293202+00 | | 2024-12-23 11:02:13.369756+00 |
| public | r_role_feature | 576 | 0 | 0.00 | 0.00 | | 2025-02-21 07:47:12.60966+00 | | |
| public | r_tenant_feature | 630 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:26.388066+00 | | 2025-02-14 09:10:53.617841+00 |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:28.589545+00 | | |
| public | r_user_region | 2845 | 0 | 0.00 | 0.00 | | 2025-02-23 09:20:24.424544+00 | | 2025-01-31 07:07:47.5742+00 |
| public | r_user_site | 243 | 0 | 0.00 | 0.00 | | 2025-02-27 03:53:01.755925+00 | | 2025-02-07 06:52:14.341587+00 |
| public | r_zone_category | 687 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:26.422254+00 | | 2025-02-10 05:38:55.23223+00 |
| public | t_ai_history | 38 | 0 | 0.00 | 0.00 | | 2025-02-24 21:06:49.472542+00 | | |
| public | t_attendance | 552132 | 5526 | 0.00 | 0.00 | | 2025-02-23 01:15:14.912252+00 | | 2025-02-07 05:59:11.968425+00 |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2025-02-23 00:47:29.461704+00 | | |
| public | t_mobile_device_history | 134132 | 0 | 0.00 | 0.00 | | 2025-02-22 14:25:35.909358+00 | | 2025-01-14 23:31:50.015334+00 |
| public | t_news | 0 | 0 | 0 | 0 | | 2025-02-22 12:52:28.568666+00 | | |
| public | t_notify_history | 684034 | 1967 | 0.00 | 0.00 | | 2025-02-23 00:48:32.833269+00 | | 2025-02-12 10:17:29.60914+00 |
| public | t_operation_log | 2976604 | 7 | 0.00 | 0.00 | | 2025-02-22 13:18:51.114145+00 | | 2025-01-15 04:03:36.94788+00 |
| public | t_plan | 5508888 | 228066 | 0.00 | 3.00 | | 2025-02-21 17:06:19.002026+00 | | 2025-02-27 02:24:15.700492+00 |
| public | t_plan_cancel_history | 84398 | 8 | 0.00 | 0.00 | | 2025-02-21 09:05:24.45926+00 | | 2025-02-12 09:52:51.318793+00 |
| public | t_plan_detail | 6473102 | 195250 | 0.00 | 2.00 | | 2025-02-25 23:56:45.769963+00 | | 2025-02-26 01:14:19.27767+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2025-02-25 04:30:30.13701+00 | | |
| public | t_plan_sync | 233948 | 26835 | 0.00 | 10.00 | | 2025-02-19 05:42:53.070483+00 | | 2025-02-27 09:05:59.476373+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2025-02-22 12:52:26.351804+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-02-22 23:11:20.481629+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-02-22 23:34:25.69138+00 | | |
| public | t_recv_position_history | 7462 | 28050 | 3.00 | 78.00 | | 2025-02-28 01:36:53.173517+00 | 2025-02-27 12:42:02.706161+00 | 2025-02-28 01:36:53.207938+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-02-22 23:12:00.456236+00 | | |
| public | t_terminal | 32434 | 1367 | 0.00 | 4.00 | | 2025-02-27 02:15:20.970111+00 | | 2025-02-27 19:57:53.726903+00 |
| public | t_terminal_log | 5973689 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:34.524188+00 | | 2025-02-06 21:53:04.518172+00 |
| public | w_arrival_notify | 1 | 0 | 0.00 | 0.00 | | 2025-02-22 12:55:01.977453+00 | | 2025-01-16 04:14:53.962613+00 |
| public | w_latest_position | 11771 | 1860 | 0.00 | 13.00 | | 2025-02-28 01:44:50.21266+00 | | 2025-02-28 01:44:50.244817+00 |
| public | w_latest_presence | 17859 | 242199 | 13.00 | 93.00 | | 2025-02-28 01:36:53.312273+00 | | 2025-02-28 01:36:53.376926+00 |
| public | w_latest_sensor | 113 | 36 | 0.00 | 24.00 | | 2025-02-28 01:44:49.909971+00 | | 2025-02-28 01:44:50.150682+00 |
| public | w_lock | 1127 | 0 | 0.00 | 0.00 | | 2025-02-22 12:52:26.03734+00 | | |
| public | w_master_update | 16 | 49 | 3.00 | 75.00 | | 2025-02-26 03:27:47.53212+00 | | 2025-02-27 23:10:44.203208+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-02-19 23:38:54.90674+00 | | |
| public | w_plan_with_detail | 5500049 | 255022 | 0.00 | 4.00 | | 2025-02-21 06:55:59.371389+00 | | 2025-02-27 01:24:37.270202+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2025-02-25 04:28:31.893112+00 | | |