| 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 | 1694934 | 0 | 0.00 | 0.00 | | 2025-02-12 09:21:33.926848+00 | | 2024-12-26 15:35:37.647537+00 |
| e202412 | a_stay_time | 4858422 | 0 | 0.00 | 0.00 | | 2025-02-12 09:02:23.677509+00 | | 2024-12-27 17:00:50.351342+00 |
| e202412 | t_position_history | 37421215 | 0 | 0.00 | 0.00 | | 2025-02-14 03:03:35.709713+00 | | 2024-12-29 05:42:10.531261+00 |
| e202412 | t_presence_history | 5540031 | 0 | 0.00 | 0.00 | | 2025-02-17 00:31:55.889435+00 | | 2024-12-31 14:58:46.773602+00 |
| e202412 | t_sensor_history | 1266185 | 0 | 0.00 | 0.00 | | 2025-02-13 01:50:26.045654+00 | | 2024-12-30 10:28:43.508171+00 |
| e202501 | a_proximity_sum | 2201946 | 0 | 0.00 | 0.00 | | 2025-02-13 01:29:18.793892+00 | | 2025-01-31 15:36:25.096641+00 |
| e202501 | a_stay_time | 5300322 | 0 | 0.00 | 0.00 | | 2025-02-13 01:29:39.836252+00 | | 2025-01-31 15:32:23.323967+00 |
| e202501 | t_position_history | 38071562 | 0 | 0.00 | 0.00 | | 2025-02-12 19:24:32.158807+00 | | 2025-01-30 06:08:06.87726+00 |
| e202501 | t_presence_history | 3913187 | 0 | 0.00 | 0.00 | | 2025-02-17 00:22:56.271795+00 | | 2025-01-31 14:59:18.805228+00 |
| e202501 | t_sensor_history | 1259440 | 0 | 0.00 | 0.00 | | 2025-02-18 01:20:50.384184+00 | | 2025-01-30 02:50:22.221246+00 |
| e202502 | a_proximity_sum | 1929282 | 0 | 0.00 | 0.00 | | 2025-02-17 17:26:48.841245+00 | | 2025-02-20 15:15:53.492629+00 |
| e202502 | a_stay_time | 4628399 | 0 | 0.00 | 0.00 | | 2025-02-20 15:31:38.387294+00 | | 2025-02-20 15:31:39.002876+00 |
| e202502 | t_position_history | 27483827 | 0 | 0.00 | 0.00 | | 2025-02-18 10:12:09.617829+00 | | 2025-02-20 04:35:46.362056+00 |
| e202502 | t_presence_history | 2907242 | 369058 | 0.00 | 11.00 | | 2025-02-21 01:32:47.975975+00 | | 2025-02-21 01:35:16.393896+00 |
| e202502 | t_sensor_history | 841952 | 0 | 0.00 | 0.00 | | 2025-02-19 11:06:52.543161+00 | | 2025-02-19 14:54:35.741707+00 |
| public | __digdag_status | 6 | 45 | 7.00 | 88.00 | | 2025-02-16 21:20:13.928781+00 | | 2025-02-18 13:10:47.219598+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2025-02-15 04:10:54.332714+00 | | |
| public | a_plan_actual | 7395 | 0 | 0.00 | 0.00 | | 2025-02-19 17:16:10.54923+00 | | 2025-02-20 16:01:32.445238+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-02-13 05:17:22.920413+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-02-13 05:11:16.576302+00 | | |
| public | b_attendance_group | 617999 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:18.737295+00 | | 2025-01-23 17:35:30.399806+00 |
| public | b_attendance_hour | 9740321 | 0 | 0.00 | 0.00 | | 2025-02-13 07:35:49.848431+00 | | 2025-01-20 17:35:58.724439+00 |
| public | b_attendance_pot | 518218 | 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 | 8069346 | 0 | 0.00 | 0.00 | | 2025-02-18 05:35:16.000007+00 | | 2025-02-10 18:37:00.65421+00 |
| public | b_check_in | 4684337 | 0 | 0.00 | 0.00 | | 2025-02-13 08:02:45.496974+00 | | 2024-12-10 17:42:39.967486+00 |
| public | b_check_in_hour | 73565195 | 0 | 0.00 | 0.00 | | 2025-02-13 07:37:33.62882+00 | | 2025-02-19 17:35:17.734306+00 |
| public | b_check_in_pot | 203260 | 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 | 4321250 | 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 | 43722654 | 0 | 0.00 | 0.00 | | 2025-02-13 07:57:36.85639+00 | | 2025-02-19 17:40:19.116415+00 |
| public | b_proximity_info | 43833288 | 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 | 1166008 | 0 | 0.00 | 0.00 | | 2025-02-13 07:41:37.22773+00 | | 2025-02-12 17:42:03.871821+00 |
| public | b_seat_reserve_hour | 22158239 | 0 | 0.00 | 0.00 | | 2025-02-13 05:11:16.074024+00 | | 2025-02-12 17:46:04.081408+00 |
| public | b_usage | 1321352 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:22.70153+00 | | 2025-02-10 05:56:15.817511+00 |
| public | b_usage_hour | 24756588 | 0 | 0.00 | 0.00 | | 2025-02-13 07:30:26.326558+00 | | 2025-02-09 17:35:31.162682+00 |
| public | m_area | 89 | 0 | 0.00 | 0.00 | | 2025-02-13 08:17:00.789802+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2025-02-13 07:37:34.138967+00 | | |
| public | m_category | 413 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:22.863239+00 | | 2025-02-10 05:48:24.891406+00 |
| public | m_exb | 3875 | 12 | 0.00 | 0.00 | | 2025-02-18 04:35:09.943736+00 | | 2025-02-10 05:41:11.048945+00 |
| public | m_favorite | 36203 | 213 | 0.00 | 0.00 | | 2025-02-12 07:02:18.486855+00 | | 2025-02-12 00:12:59.77606+00 |
| public | m_favorite_group | 8259 | 10 | 0.00 | 0.00 | | 2025-02-14 23:41:15.317519+00 | | 2025-02-18 02:53:28.014744+00 |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-02-13 08:17:00.757701+00 | | |
| public | m_group | 2321 | 0 | 0.00 | 0.00 | | 2025-02-12 09:50:50.873642+00 | | |
| public | m_holiday | 5533 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:31.803601+00 | | 2025-02-10 05:41:11.341818+00 |
| public | m_lob | 1174 | 4 | 0.00 | 0.00 | | 2025-02-12 09:39:02.126271+00 | | 2025-02-12 07:14:27.67477+00 |
| public | m_lob_log | 49 | 0 | 0.00 | 0.00 | | 2025-02-17 10:46:26.128045+00 | | |
| public | m_location | 5096 | 8 | 0.00 | 0.00 | | 2025-02-12 09:50:51.069894+00 | | 2024-11-25 04:16:30.357563+00 |
| public | m_notify_template | 122 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:22.761405+00 | | |
| public | m_outside | 65 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:19.43187+00 | | |
| public | m_pot | 26493 | 5293 | 0.00 | 16.00 | | 2025-02-20 13:11:05.339244+00 | | 2025-02-21 00:10:20.479042+00 |
| public | m_pot_profile | 706 | 7 | 0.00 | 0.00 | | 2025-02-13 07:35:28.168962+00 | | 2025-02-12 00:05:59.139952+00 |
| public | m_provider_user | 59 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:19.389936+00 | | |
| public | m_region | 16 | 0 | 0.00 | 0.00 | | 2025-02-13 08:05:53.500148+00 | | |
| public | m_role | 76 | 0 | 0.00 | 0.00 | | 2025-02-13 08:17:00.746427+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-02-13 08:02:38.141491+00 | | |
| public | m_setting | 2232 | 297 | 0.00 | 11.00 | | 2025-02-19 09:56:54.660105+00 | | 2025-02-20 21:59:41.365016+00 |
| public | m_setting_log | 4766 | 718 | 0.00 | 13.00 | | 2025-02-16 12:30:55.085477+00 | | 2025-02-19 12:30:59.866316+00 |
| public | m_site | 25 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:22.736039+00 | | |
| public | m_tenant | 16 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:19.353058+00 | | |
| public | m_tx | 27572 | 188 | 0.00 | 0.00 | | 2025-02-19 07:22:30.234807+00 | | 2025-02-14 06:13:10.403632+00 |
| public | m_user | 5287 | 10 | 0.00 | 0.00 | | 2025-02-16 06:47:51.420575+00 | | 2024-12-17 09:55:38.578628+00 |
| public | m_zone | 805 | 3 | 0.00 | 0.00 | | 2025-02-13 05:17:22.908828+00 | | 2025-02-10 05:48:24.91203+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-02-13 07:41:37.239209+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2025-02-13 08:02:38.121846+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:22.785072+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2025-02-13 07:41:34.288034+00 | | |
| public | r_location_zone | 3900 | 8 | 0.00 | 0.00 | | 2025-02-17 12:31:48.480652+00 | | 2024-11-27 05:28:47.354369+00 |
| public | r_pot_auth | 24 | 0 | 0.00 | 0.00 | | 2025-02-13 07:37:34.150521+00 | | |
| public | r_pot_category | 881 | 2 | 0.00 | 0.00 | | 2025-02-13 07:37:34.209059+00 | | 2025-02-13 07:38:34.182171+00 |
| public | r_pot_group | 11478 | 1434 | 0.00 | 11.00 | | 2025-02-20 21:05:41.89228+00 | | 2025-02-20 23:34:26.245592+00 |
| public | r_pot_tx | 9777 | 6 | 0.00 | 0.00 | | 2025-02-17 02:45:56.926531+00 | | 2025-01-31 07:06:47.51958+00 |
| public | r_pot_user | 2787 | 4 | 0.00 | 0.00 | | 2025-02-13 12:50:25.147544+00 | | 2025-01-31 07:06:47.486744+00 |
| public | r_provider_tenant | 160 | 0 | 0.00 | 0.00 | | 2025-02-12 07:30:40.193209+00 | | 2024-12-23 11:02:13.369756+00 |
| public | r_role_feature | 576 | 0 | 0.00 | 0.00 | | 2025-02-12 08:30:36.744993+00 | | |
| public | r_tenant_feature | 630 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:19.370123+00 | | 2025-02-14 09:10:53.617841+00 |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:22.816587+00 | | |
| public | r_user_region | 2845 | 5 | 0.00 | 0.00 | | 2025-02-13 12:50:25.174406+00 | | 2025-01-31 07:07:47.5742+00 |
| public | r_user_site | 243 | 1 | 0.00 | 0.00 | | 2025-02-17 18:32:55.091784+00 | | 2025-02-07 06:52:14.341587+00 |
| public | r_zone_category | 687 | 3 | 0.00 | 0.00 | | 2025-02-13 05:17:19.412893+00 | | 2025-02-10 05:38:55.23223+00 |
| public | t_ai_history | 38 | 0 | 0.00 | 0.00 | | 2025-02-14 08:11:06.921402+00 | | |
| public | t_attendance | 519591 | 8883 | 0.00 | 1.00 | | 2025-02-13 08:17:00.723321+00 | | 2025-02-07 05:59:11.968425+00 |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2025-02-13 08:05:53.467435+00 | | |
| public | t_mobile_device_history | 133252 | 0 | 0.00 | 0.00 | | 2025-02-13 05:46:03.879677+00 | | 2025-01-14 23:31:50.015334+00 |
| public | t_news | 0 | 0 | 0 | 0 | | 2025-02-13 05:17:22.796024+00 | | |
| public | t_notify_history | 681720 | 3106 | 0.00 | 0.00 | | 2025-02-13 08:05:55.598775+00 | | 2025-02-12 10:17:29.60914+00 |
| public | t_operation_log | 2845185 | 10 | 0.00 | 0.00 | | 2025-02-13 05:26:54.027692+00 | | 2025-01-15 04:03:36.94788+00 |
| public | t_plan | 5432744 | 337397 | 0.00 | 5.00 | | 2025-02-12 18:53:59.905729+00 | | 2025-02-20 23:56:22.545119+00 |
| public | t_plan_cancel_history | 69081 | 10 | 0.00 | 0.00 | | 2025-02-12 09:53:51.703583+00 | | 2025-02-12 09:52:51.318793+00 |
| public | t_plan_detail | 6416583 | 245584 | 0.00 | 3.00 | | 2025-02-16 06:44:50.567174+00 | | 2025-02-18 08:45:54.908782+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2025-02-15 00:17:51.110753+00 | | |
| public | t_plan_sync | 233903 | 19918 | 0.00 | 7.00 | | 2025-02-19 05:42:53.070483+00 | | 2025-02-20 09:29:43.012853+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2025-02-13 05:17:19.319047+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-02-13 07:29:42.899592+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-02-13 07:37:34.163458+00 | | |
| public | t_recv_position_history | 7544 | 1607 | 0.00 | 17.00 | | 2025-02-21 01:45:15.586875+00 | 2025-02-20 12:42:00.650187+00 | 2025-02-21 01:45:15.620012+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-02-13 07:30:27.746092+00 | | |
| public | t_terminal | 32416 | 1372 | 0.00 | 4.00 | | 2025-02-17 12:39:49.194773+00 | | 2025-02-20 18:08:09.720461+00 |
| public | t_terminal_log | 5943971 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:29.185392+00 | | 2025-02-06 21:53:04.518172+00 |
| public | w_arrival_notify | 1 | 2 | 2.00 | 66.00 | | 2025-02-13 05:18:31.740775+00 | | 2025-01-16 04:14:53.962613+00 |
| public | w_latest_position | 11765 | 1179 | 0.00 | 9.00 | | 2025-02-21 01:45:15.502743+00 | | 2025-02-21 01:45:15.531522+00 |
| public | w_latest_presence | 17814 | 12207 | 0.00 | 40.00 | | 2025-02-21 01:45:15.702888+00 | | 2025-02-21 01:45:15.795382+00 |
| public | w_latest_sensor | 163 | 18 | 0.00 | 9.00 | | 2025-02-21 01:45:15.48078+00 | | 2025-02-21 01:44:15.706152+00 |
| public | w_lock | 1126 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:18.966733+00 | | |
| public | w_master_update | 16 | 33 | 2.00 | 67.00 | | 2025-02-20 00:12:59.536877+00 | | 2025-02-20 00:12:59.539648+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-02-19 23:38:54.90674+00 | | |
| public | w_plan_with_detail | 5438963 | 375270 | 0.00 | 6.00 | | 2025-02-12 07:41:23.28075+00 | | 2025-02-20 21:53:43.123498+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2025-02-15 00:11:51.11059+00 | | |