| 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 |
|---|
| e202312 | a_proximity_sum | 29521841 | 0 | 0.00 | 0.00 | | 2024-02-15 22:03:37.522655+00 | | 2023-12-29 12:50:02.455693+00 |
| e202312 | a_stay_time | 17019612 | 0 | 0.00 | 0.00 | | 2024-02-20 17:34:25.080978+00 | | 2023-12-29 15:07:06.176602+00 |
| e202312 | l_position_history | 0 | 0 | 0 | 0 | | 2024-02-27 07:18:03.017158+00 | | |
| e202312 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-27 07:18:02.998115+00 | | |
| e202312 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-02-27 07:18:02.987043+00 | | |
| e202312 | t_position_history | 322261987 | 0 | 0.00 | 0.00 | | 2024-02-14 03:34:35.506232+00 | | 2023-12-30 17:24:31.17066+00 |
| e202312 | t_presence_history | 54449798 | 0 | 0.00 | 0.00 | | 2024-02-13 01:14:45.66407+00 | | 2023-12-31 14:43:53.221525+00 |
| e202312 | t_sensor_history | 11901023 | 0 | 0.00 | 0.00 | | 2024-02-19 17:55:54.93575+00 | | 2023-12-29 13:16:55.682719+00 |
| e202401 | a_proximity_sum | 27162792 | 0 | 0.00 | 0.00 | | 2024-02-26 12:53:40.522805+00 | | 2024-01-30 15:14:06.375164+00 |
| e202401 | a_stay_time | 17146869 | 4586 | 0.00 | 0.00 | | 2024-02-13 20:31:19.266219+00 | | 2024-01-30 15:11:06.159905+00 |
| e202401 | l_position_history | 0 | 0 | 0 | 0 | | 2024-02-15 22:24:38.073172+00 | | |
| e202401 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-15 22:24:38.095061+00 | | |
| e202401 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-02-15 22:24:38.084163+00 | | |
| e202401 | t_position_history | 338284491 | 0 | 0.00 | 0.00 | | 2024-02-27 07:10:23.425092+00 | | 2024-01-30 10:26:24.358574+00 |
| e202401 | t_presence_history | 36846669 | 0 | 0.00 | 0.00 | | 2024-02-22 04:31:29.436329+00 | | 2024-01-31 15:07:30.056064+00 |
| e202401 | t_sensor_history | 14218302 | 663 | 0.00 | 0.00 | | 2024-02-24 06:52:02.626817+00 | | 2024-01-30 12:58:27.389928+00 |
| e202402 | a_proximity_sum | 26470956 | 0 | 0.00 | 0.00 | | 2024-02-26 16:03:17.71205+00 | | 2024-02-26 18:09:55.905889+00 |
| e202402 | a_stay_time | 14527371 | 0 | 0.00 | 0.00 | | 2024-02-26 16:16:51.890474+00 | | 2024-02-22 18:00:57.631037+00 |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-02-19 21:38:26.548583+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-19 21:38:26.570626+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-02-19 21:38:26.55985+00 | | |
| e202402 | t_position_history | 319141408 | 0 | 0.00 | 0.00 | | 2024-02-22 10:06:50.095775+00 | | 2024-02-26 06:23:21.986719+00 |
| e202402 | t_presence_history | 34035614 | 9401484 | 0.00 | 21.00 | | 2024-02-27 09:56:54.076681+00 | | 2024-02-27 09:28:48.753382+00 |
| e202402 | t_sensor_history | 13860501 | 0 | 0.00 | 0.00 | | 2024-02-27 00:55:23.610288+00 | | 2024-02-26 01:06:30.30322+00 |
| public | __digdag_status | 57 | 12 | 0.00 | 17.00 | | 2024-02-27 08:29:55.124667+00 | | 2024-02-27 02:30:24.224969+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:25.520244+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:25.508763+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.762266+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:46.721109+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.679821+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:46.74147+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:46.761994+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.699948+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.658804+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.782862+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.721845+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.742002+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:26.17135+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:26.160232+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:26.148901+00 | | |
| public | m_area | 631 | 9 | 0.00 | 1.00 | | 2024-02-14 01:24:18.309229+00 | | 2024-01-18 08:43:32.882494+00 |
| public | m_auth | 103 | 2 | 0.00 | 1.00 | | 2024-02-26 03:54:25.532316+00 | | |
| public | m_category | 1592 | 0 | 0.00 | 0.00 | | 2024-02-14 01:24:18.339671+00 | | |
| public | m_exb | 18741 | 27 | 0.00 | 0.00 | | 2024-02-23 11:06:43.705454+00 | | 2024-01-31 23:41:48.109481+00 |
| public | m_favorite | 149610 | 107 | 0.00 | 0.00 | | 2024-02-26 23:55:02.830885+00 | | 2024-02-26 11:15:18.008043+00 |
| public | m_feature | 151 | 0 | 0.00 | 0.00 | | 2024-02-26 19:20:39.868555+00 | | |
| public | m_group | 13494 | 26 | 0.00 | 0.00 | | 2024-02-18 02:30:02.227237+00 | | 2024-02-27 00:05:38.156077+00 |
| public | m_holiday | 15216 | 0 | 0.00 | 0.00 | | 2024-02-26 01:10:50.25426+00 | | 2024-02-01 01:01:41.977654+00 |
| public | m_lob | 18026 | 9 | 0.00 | 0.00 | | 2024-02-22 09:20:23.856942+00 | | 2024-01-26 12:24:11.753833+00 |
| public | m_location | 33128 | 0 | 0.00 | 0.00 | | 2024-02-27 05:21:46.398039+00 | | 2024-02-02 10:56:18.136784+00 |
| public | m_notify_template | 721 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:25.624137+00 | | 2023-12-25 06:37:18.875076+00 |
| public | m_outside | 278 | 2 | 0.00 | 0.00 | | 2024-02-20 04:10:40.596641+00 | | |
| public | m_pot | 208863 | 40223 | 0.00 | 16.00 | | 2024-02-22 23:52:41.704494+00 | | 2024-02-27 03:07:14.3029+00 |
| public | m_pot_profile | 31796 | 41 | 0.00 | 0.00 | | 2024-02-26 21:42:39.895478+00 | | 2024-02-21 06:28:02.787527+00 |
| public | m_provider_user | 65 | 4 | 0.00 | 5.00 | | 2024-02-27 01:36:21.873777+00 | | 2024-02-14 09:08:37.831676+00 |
| public | m_region | 98 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:25.708848+00 | | |
| public | m_role | 515 | 3 | 0.00 | 0.00 | | 2024-02-26 03:54:25.690667+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:25.552056+00 | | |
| public | m_setting | 18907 | 897 | 0.00 | 4.00 | | 2024-02-27 09:06:20.282652+00 | | 2024-02-27 09:04:20.103894+00 |
| public | m_setting_log | 51847 | 0 | 0.00 | 0.00 | 2024-02-16 03:34:50.060418+00 | 2024-02-27 06:00:17.39913+00 | | 2024-02-27 06:03:29.439831+00 |
| public | m_site | 168 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:25.581824+00 | | |
| public | m_tenant | 97 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:25.859685+00 | | |
| public | m_tx | 89548 | 6547 | 0.00 | 6.00 | | 2024-02-26 07:30:35.247771+00 | | 2024-02-26 06:48:15.686528+00 |
| public | m_user | 29084 | 2566 | 0.00 | 8.00 | | 2024-02-14 00:10:47.398573+00 | | 2024-02-21 08:40:30.943311+00 |
| public | m_zone | 6617 | 0 | 0.00 | 0.00 | | 2024-02-27 09:30:47.826673+00 | | 2024-02-08 08:37:07.646051+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:25.42284+00 | | |
| public | r_auth_zone | 209 | 0 | 0.00 | 0.00 | | 2024-02-23 12:24:31.477986+00 | | 2024-02-26 05:08:04.242146+00 |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:25.648517+00 | | |
| public | r_group_auth | 436 | 0 | 0.00 | 0.00 | | 2024-02-26 07:10:34.118255+00 | | |
| public | r_location_zone | 31897 | 1145 | 0.00 | 3.00 | | 2024-02-20 01:43:30.343249+00 | | 2024-02-16 10:26:41.730391+00 |
| public | r_pot_auth | 717 | 14 | 0.00 | 1.00 | | 2024-02-19 08:34:45.165072+00 | | 2024-02-26 06:33:33.188922+00 |
| public | r_pot_category | 5990 | 0 | 0.00 | 0.00 | | 2024-02-27 07:18:02.966786+00 | | 2024-02-27 06:02:16.741547+00 |
| public | r_pot_group | 139716 | 23807 | 0.00 | 14.00 | | 2024-02-27 09:11:46.926202+00 | | 2024-02-27 09:10:20.476174+00 |
| public | r_pot_tx | 45838 | 409 | 0.00 | 0.00 | | 2024-02-23 01:16:30.930137+00 | | 2024-02-26 03:59:25.763269+00 |
| public | r_pot_user | 18649 | 2559 | 0.00 | 12.00 | | 2024-02-18 06:20:47.088313+00 | | 2024-02-21 08:40:30.997445+00 |
| public | r_provider_tenant | 2675 | 469 | 0.00 | 14.00 | | 2024-02-14 06:55:09.773332+00 | | 2024-02-27 09:11:47.735336+00 |
| public | r_role_feature | 5350 | 3 | 0.00 | 0.00 | | 2024-02-18 02:30:02.031091+00 | | 2024-01-18 08:22:54.488926+00 |
| public | r_tenant_feature | 3332 | 1 | 0.00 | 0.00 | | 2024-02-15 17:51:14.411088+00 | | |
| public | r_tx_sensor | 455 | 0 | 0.00 | 0.00 | | 2024-02-19 17:55:27.447717+00 | | 2024-01-27 01:38:23.792244+00 |
| public | r_user_region | 19195 | 2596 | 0.00 | 11.00 | | 2024-02-18 06:20:46.955737+00 | | 2024-02-21 08:40:30.42447+00 |
| public | r_user_site | 5227 | 5 | 0.00 | 0.00 | | 2024-02-26 03:09:04.27992+00 | | 2024-01-11 06:16:33.979684+00 |
| public | r_zone_category | 2857 | 7 | 0.00 | 0.00 | | 2024-02-20 17:34:25.026497+00 | | 2024-01-23 05:12:39.85601+00 |
| public | t_attendance | 738448 | 55343 | 0.00 | 6.00 | | 2024-02-15 17:51:31.660381+00 | | 2024-02-20 03:35:28.166416+00 |
| public | t_general | 1405 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:25.841243+00 | | 2024-01-29 01:00:49.959426+00 |
| public | t_mobile_device_history | 393083 | 0 | 0.00 | 0.00 | | 2024-02-13 10:37:59.86692+00 | | 2024-02-09 04:49:46.654181+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:25.669948+00 | | |
| public | t_notify_history | 1927998 | 977 | 0.00 | 0.00 | | 2024-02-27 05:22:58.257941+00 | | 2024-02-19 00:20:06.667528+00 |
| public | t_operation_log | 7462371 | 58167 | 0.00 | 0.00 | | 2024-02-21 00:37:13.680176+00 | | 2024-02-15 19:06:28.324191+00 |
| public | t_plan | 9082834 | 1663219 | 0.00 | 15.00 | | 2024-02-13 00:36:42.000271+00 | | 2024-02-27 04:28:10.950579+00 |
| public | t_plan_detail | 14241109 | 1375381 | 0.00 | 8.00 | | 2024-02-16 07:36:26.792864+00 | | 2024-02-27 08:01:31.433451+00 |
| public | t_plan_sync | 41168 | 15336 | 0.00 | 27.00 | | 2024-02-27 09:56:35.315822+00 | | 2024-02-27 09:33:48.060037+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:25.884338+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:25.434736+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:25.727519+00 | | |
| public | t_recv_position_history | 109922 | 4659390 | 42.00 | 97.00 | | 2024-02-27 09:57:00.467307+00 | 2024-02-26 12:30:03.061345+00 | 2024-02-27 09:57:01.024201+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:25.49702+00 | | |
| public | t_terminal | 24732 | 2306 | 0.00 | 8.00 | | 2024-02-27 08:23:56.131091+00 | | 2024-02-27 09:53:55.404422+00 |
| public | t_terminal_log | 4974788 | 0 | 0.00 | 0.00 | | 2024-02-20 09:05:52.58847+00 | | 2024-02-10 06:01:59.826383+00 |
| public | w_arrival_notify | 64 | 30 | 0.00 | 31.00 | | 2024-02-12 18:14:45.694847+00 | | 2024-02-21 00:34:37.660717+00 |
| public | w_latest_position | 43225 | 1378652 | 31.00 | 96.00 | | 2024-02-27 09:56:54.657681+00 | | 2024-02-27 09:56:55.043185+00 |
| public | w_latest_presence | 188671 | 9533813 | 50.00 | 98.00 | 2024-01-18 12:30:06.016796+00 | 2024-02-27 09:56:57.860297+00 | 2024-01-18 12:30:06.178604+00 | 2024-02-27 09:56:58.300534+00 |
| public | w_latest_sensor | 443 | 34426 | 77.00 | 98.00 | | 2024-02-27 09:56:58.334777+00 | | 2024-02-27 09:56:58.451253+00 |
| public | w_lock | 11618 | 0 | 0.00 | 0.00 | | 2024-02-17 10:15:45.414956+00 | | 2024-01-31 02:02:19.791893+00 |
| public | w_master_update | 97 | 53 | 0.00 | 35.00 | | 2024-02-27 08:07:30.880662+00 | | 2024-02-27 09:32:47.790719+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:26.189706+00 | | |
| public | w_plan_with_detail | 9038308 | 508742 | 0.00 | 5.00 | | 2024-02-23 09:51:49.547951+00 | | 2024-02-27 04:45:57.855226+00 |