| 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 | 1611387 | 0 | 0.00 | 0.00 | | 2025-02-17 17:26:48.841245+00 | | 2025-02-17 15:43:46.220783+00 |
| e202502 | a_stay_time | 3611752 | 0 | 0.00 | 0.00 | | 2025-02-17 17:01:22.216965+00 | | 2025-02-17 17:01:22.802612+00 |
| e202502 | t_position_history | 21966274 | 0 | 0.00 | 0.00 | | 2025-02-15 00:43:20.776163+00 | | 2025-02-17 10:44:11.677914+00 |
| e202502 | t_presence_history | 2288517 | 444248 | 0.00 | 16.00 | | 2025-02-18 01:29:12.942484+00 | | 2025-02-18 01:45:07.926527+00 |
| e202502 | t_sensor_history | 720351 | 0 | 0.00 | 0.00 | | 2025-02-15 23:11:06.835709+00 | | 2025-02-17 17:13:46.674081+00 |
| public | __digdag_status | 12 | 15 | 1.00 | 55.00 | | 2025-02-16 21:20:13.928781+00 | | 2025-02-14 21:50:45.591191+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2025-02-15 04:10:54.332714+00 | | |
| public | a_plan_actual | 3362 | 0 | 0.00 | 0.00 | | 2025-02-14 16:00:55.671334+00 | | 2025-02-17 17:15:46.412178+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 | 614803 | 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 | 9687039 | 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 | 536154 | 25536 | 0.00 | 4.00 | | 2025-02-09 20:27:19.934866+00 | | 2025-02-11 18:35:55.944299+00 |
| public | b_attendance_pot_hour | 8352002 | 383342 | 0.00 | 4.00 | | 2025-02-08 00:27:45.151334+00 | | 2025-02-10 18:37:00.65421+00 |
| public | b_check_in | 4669379 | 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 | 72292645 | 0 | 0.00 | 0.00 | | 2025-02-13 07:37:33.62882+00 | | 2024-12-13 17:31:51.541713+00 |
| public | b_check_in_pot | 207376 | 0 | 0.00 | 0.00 | | 2025-02-10 09:03:44.936171+00 | | 2025-02-10 05:56:17.869751+00 |
| public | b_check_in_pot_hour | 4788881 | 579336 | 0.00 | 10.00 | | 2025-02-09 01:51:22.657277+00 | | 2025-02-10 05:58:40.115839+00 |
| public | b_proximity_group | 42927494 | 0 | 0.00 | 0.00 | | 2025-02-13 07:57:36.85639+00 | | 2024-12-20 17:42:57.939951+00 |
| public | b_proximity_info | 41788907 | 0 | 0.00 | 0.00 | | 2025-02-10 08:54:42.431487+00 | | 2025-01-28 18:02:47.325698+00 |
| public | b_seat_reserve | 1159119 | 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 | 22019742 | 0 | 0.00 | 0.00 | | 2025-02-13 05:11:16.074024+00 | | 2025-02-12 17:46:04.081408+00 |
| public | b_usage | 1313179 | 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 | 24598606 | 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 | 3363 | 229 | 0.00 | 6.00 | | 2025-02-07 21:45:33.903727+00 | | 2025-02-10 05:41:11.048945+00 |
| public | m_favorite | 36129 | 133 | 0.00 | 0.00 | | 2025-02-12 07:02:18.486855+00 | | 2025-02-12 00:12:59.77606+00 |
| public | m_favorite_group | 8239 | 0 | 0.00 | 0.00 | | 2025-02-14 23:41:15.317519+00 | | 2024-12-09 00:27:50.393044+00 |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-02-13 08:17:00.757701+00 | | |
| public | m_group | 2320 | 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 | 3 | 0.00 | 0.00 | | 2025-02-12 09:39:02.126271+00 | | 2025-02-12 07:14:27.67477+00 |
| public | m_lob_log | 48 | 0 | 0.00 | 0.00 | | 2025-02-17 10:46:26.128045+00 | | |
| public | m_location | 5095 | 5 | 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 | 30411 | 698 | 0.00 | 2.00 | | 2025-02-18 01:10:23.223759+00 | | 2025-02-18 00:10:13.276126+00 |
| public | m_pot_profile | 705 | 4 | 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 | 3418 | 252 | 0.00 | 6.00 | | 2025-02-16 16:03:45.528633+00 | | 2025-02-16 13:12:51.052375+00 |
| public | m_setting_log | 4764 | 178 | 0.00 | 3.00 | | 2025-02-16 12:30:55.085477+00 | | 2025-02-16 12:30:55.200339+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 | 16221 | 1 | 0.00 | 0.00 | | 2025-02-14 06:13:10.290356+00 | | 2025-02-14 06:13:10.403632+00 |
| public | m_user | 5282 | 0 | 0.00 | 0.00 | | 2025-02-16 06:47:51.420575+00 | | 2024-12-17 09:55:38.578628+00 |
| public | m_zone | 804 | 0 | 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 | 0 | 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 | 1 | 0.00 | 0.00 | | 2025-02-13 07:37:34.209059+00 | | 2025-02-13 07:38:34.182171+00 |
| public | r_pot_group | 12392 | 1343 | 0.00 | 9.00 | | 2025-02-17 21:05:20.772014+00 | | 2025-02-17 23:34:50.87739+00 |
| public | r_pot_tx | 9775 | 1 | 0.00 | 0.00 | | 2025-02-17 02:45:56.926531+00 | | 2025-01-31 07:06:47.51958+00 |
| public | r_pot_user | 2785 | 0 | 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 | 2843 | 0 | 0.00 | 0.00 | | 2025-02-13 12:50:25.174406+00 | | 2025-01-31 07:07:47.5742+00 |
| public | r_user_site | 241 | 0 | 0.00 | 0.00 | | 2025-02-17 18:32:55.091784+00 | | 2025-02-07 06:52:14.341587+00 |
| public | r_zone_category | 686 | 0 | 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 | 514640 | 3905 | 0.00 | 0.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 | 132909 | 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 | 675461 | 1737 | 0.00 | 0.00 | | 2025-02-13 08:05:55.598775+00 | | 2025-02-12 10:17:29.60914+00 |
| public | t_operation_log | 2826160 | 5 | 0.00 | 0.00 | | 2025-02-13 05:26:54.027692+00 | | 2025-01-15 04:03:36.94788+00 |
| public | t_plan | 5387462 | 219982 | 0.00 | 3.00 | | 2025-02-12 18:53:59.905729+00 | | 2025-02-17 00:36:58.706186+00 |
| public | t_plan_cancel_history | 68272 | 7 | 0.00 | 0.00 | | 2025-02-12 09:53:51.703583+00 | | 2025-02-12 09:52:51.318793+00 |
| public | t_plan_detail | 6365555 | 106943 | 0.00 | 1.00 | | 2025-02-16 06:44:50.567174+00 | | 2025-02-14 01:59:44.428432+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2025-02-15 00:17:51.110753+00 | | |
| public | t_plan_sync | 233887 | 27259 | 0.00 | 10.00 | | 2025-02-09 22:57:24.113256+00 | | 2025-02-17 09:44:17.47367+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 | 7624 | 1921 | 0.00 | 20.00 | | 2025-02-18 01:45:08.006162+00 | 2025-02-17 12:42:01.207306+00 | 2025-02-18 01:45:08.050167+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-02-13 07:30:27.746092+00 | | |
| public | t_terminal | 32409 | 701 | 0.00 | 2.00 | | 2025-02-17 12:39:49.194773+00 | | 2025-02-17 18:30:37.698192+00 |
| public | t_terminal_log | 5924072 | 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 | 1 | 1.00 | 50.00 | | 2025-02-13 05:18:31.740775+00 | | 2025-01-16 04:14:53.962613+00 |
| public | w_latest_position | 11729 | 1044 | 0.00 | 8.00 | | 2025-02-18 01:45:06.36048+00 | | 2025-02-18 01:45:06.398219+00 |
| public | w_latest_presence | 17798 | 17694 | 0.00 | 49.00 | | 2025-02-18 01:45:08.185264+00 | | 2025-02-18 01:45:08.288884+00 |
| public | w_latest_sensor | 113 | 16 | 0.00 | 12.00 | | 2025-02-18 01:45:06.09403+00 | | 2025-02-18 01:45:06.334098+00 |
| public | w_lock | 1126 | 0 | 0.00 | 0.00 | | 2025-02-13 05:17:18.966733+00 | | |
| public | w_master_update | 16 | 39 | 2.00 | 70.00 | | 2025-02-16 09:05:43.910558+00 | | 2025-02-16 12:31:58.377547+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-02-10 08:52:16.722628+00 | | |
| public | w_plan_with_detail | 5390547 | 243771 | 0.00 | 4.00 | | 2025-02-12 07:41:23.28075+00 | | 2025-02-17 00:03:53.44442+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2025-02-15 00:11:51.11059+00 | | |