| 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 |
|---|
| 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 | 17136673 | 18 | 0.00 | 0.00 | | 2024-02-28 20:41:40.501489+00 | | 2024-01-30 15:11:06.159905+00 |
| e202401 | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-01 23:04:55.951387+00 | | |
| e202401 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-01 23:04:55.973445+00 | | |
| e202401 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-01 23:04:55.962272+00 | | |
| e202401 | t_position_history | 338285997 | 706 | 0.00 | 0.00 | | 2024-02-27 07:10:23.425092+00 | | 2024-01-30 10:26:24.358574+00 |
| e202401 | t_presence_history | 36782036 | 64633 | 0.00 | 0.00 | | 2024-02-22 04:31:29.436329+00 | | 2024-01-31 15:07:30.056064+00 |
| e202401 | t_sensor_history | 14216472 | 2493 | 0.00 | 0.00 | | 2024-02-24 06:52:02.626817+00 | | 2024-01-30 12:58:27.389928+00 |
| e202402 | a_proximity_sum | 30543268 | 0 | 0.00 | 0.00 | | 2024-02-26 16:03:17.71205+00 | | 2024-02-28 18:03:25.795511+00 |
| e202402 | a_stay_time | 17238064 | 47 | 0.00 | 0.00 | | 2024-02-26 16:16:51.890474+00 | | 2024-02-28 16:55:43.897188+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 | 354035465 | 4 | 0.00 | 0.00 | | 2024-02-28 02:33:22.17918+00 | | 2024-02-28 06:24:03.251416+00 |
| e202402 | t_presence_history | 39184478 | 2395698 | 0.00 | 5.00 | | 2024-02-29 14:49:07.795523+00 | | 2024-02-29 14:33:56.738379+00 |
| e202402 | t_sensor_history | 15152470 | 660 | 0.00 | 0.00 | | 2024-02-27 00:55:23.610288+00 | | 2024-02-28 11:55:22.157867+00 |
| e202403 | a_proximity_sum | 4633058 | 0 | 0.00 | 0.00 | | 2024-03-04 16:21:58.72364+00 | | 2024-03-04 18:03:19.91642+00 |
| e202403 | a_stay_time | 2119711 | 0 | 0.00 | 0.00 | | 2024-03-04 18:00:26.836465+00 | | 2024-03-04 17:06:03.647789+00 |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | 2024-02-26 00:01:11.841339+00 | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-26 00:01:11.863788+00 | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-02-26 00:01:15.179721+00 | | |
| e202403 | t_position_history | 61405133 | 0 | 0.00 | 0.00 | | 2024-03-05 08:52:36.751887+00 | | 2024-03-05 06:54:21.621151+00 |
| e202403 | t_presence_history | 18853932 | 8820481 | 0.00 | 31.00 | | 2024-03-05 09:21:27.115299+00 | | 2024-03-05 09:09:51.601645+00 |
| e202403 | t_sensor_history | 2612221 | 0 | 0.00 | 0.00 | | 2024-03-05 04:57:50.450041+00 | | 2024-03-05 07:07:22.075998+00 |
| public | __digdag_status | 57 | 6 | 0.00 | 9.00 | | 2024-03-05 07:57:34.032239+00 | | 2024-03-05 07:57:34.037491+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-03-03 23:18:23.436231+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.903483+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.348161+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.925687+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.946567+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.369638+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.325325+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.457736+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.391651+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.413472+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 | 636 | 8 | 0.00 | 1.00 | | 2024-02-29 01:09:35.939618+00 | | 2024-01-18 08:43:32.882494+00 |
| public | m_auth | 109 | 8 | 0.00 | 6.00 | | 2024-02-26 03:54:25.532316+00 | | 2024-02-28 05:53:49.738173+00 |
| public | m_category | 1588 | 14 | 0.00 | 0.00 | | 2024-02-29 01:09:35.965439+00 | | |
| public | m_exb | 19081 | 946 | 0.00 | 4.00 | | 2024-02-23 11:06:43.705454+00 | | 2024-02-28 13:18:02.216551+00 |
| public | m_favorite | 150465 | 1184 | 0.00 | 0.00 | | 2024-02-26 23:55:02.830885+00 | | 2024-02-26 11:15:18.008043+00 |
| public | m_feature | 153 | 0 | 0.00 | 0.00 | | 2024-02-26 19:20:39.868555+00 | | |
| public | m_group | 13605 | 81 | 0.00 | 0.00 | | 2024-03-04 07:38:48.46419+00 | | 2024-02-27 00:05:38.156077+00 |
| public | m_holiday | 15668 | 0 | 0.00 | 0.00 | | 2024-02-26 01:10:50.25426+00 | | 2024-02-01 01:01:41.977654+00 |
| public | m_lob | 17975 | 227 | 0.00 | 1.00 | | 2024-02-22 09:20:23.856942+00 | | 2024-01-26 12:24:11.753833+00 |
| public | m_location | 33452 | 1008 | 0.00 | 2.00 | | 2024-02-27 05:21:46.398039+00 | | 2024-02-02 10:56:18.136784+00 |
| public | m_notify_template | 717 | 9 | 0.00 | 1.00 | | 2024-02-26 03:54:25.624137+00 | | 2023-12-25 06:37:18.875076+00 |
| public | m_outside | 277 | 4 | 0.00 | 1.00 | | 2024-02-20 04:10:40.596641+00 | | |
| public | m_pot | 225087 | 20481 | 0.00 | 8.00 | | 2024-03-05 03:50:12.769829+00 | | 2024-03-05 03:24:06.343595+00 |
| public | m_pot_profile | 31883 | 235 | 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 | 45 | 0.00 | 40.00 | | 2024-02-27 01:36:21.873777+00 | | 2024-02-14 09:08:37.831676+00 |
| public | m_region | 98 | 1 | 0.00 | 1.00 | | 2024-02-26 03:54:25.708848+00 | | |
| public | m_role | 516 | 7 | 0.00 | 1.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 | 18487 | 846 | 0.00 | 4.00 | | 2024-03-05 08:19:10.796356+00 | | 2024-03-05 07:30:40.598224+00 |
| public | m_setting_log | 51439 | 379 | 0.00 | 0.00 | 2024-02-16 03:34:50.060418+00 | 2024-03-05 05:39:11.145362+00 | | 2024-03-05 05:40:10.985979+00 |
| public | m_site | 169 | 2 | 0.00 | 1.00 | | 2024-02-26 03:54:25.581824+00 | | |
| public | m_tenant | 97 | 2 | 0.00 | 2.00 | | 2024-02-26 03:54:25.859685+00 | | |
| public | m_tx | 83533 | 8294 | 0.00 | 9.00 | | 2024-03-05 05:07:44.694716+00 | | 2024-03-05 05:07:44.844172+00 |
| public | m_user | 28768 | 140 | 0.00 | 0.00 | | 2024-02-29 00:09:48.624224+00 | | 2024-02-21 08:40:30.943311+00 |
| public | m_zone | 4150 | 288 | 0.00 | 6.00 | | 2024-02-27 09:30:47.826673+00 | | 2024-03-04 04:13:40.640148+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:25.42284+00 | | |
| public | r_auth_zone | 211 | 14 | 0.00 | 6.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 | 437 | 0 | 0.00 | 0.00 | | 2024-02-26 07:10:34.118255+00 | | |
| public | r_location_zone | 32445 | 4624 | 0.00 | 12.00 | | 2024-02-20 01:43:30.343249+00 | | 2024-03-04 04:15:11.918853+00 |
| public | r_pot_auth | 712 | 0 | 0.00 | 0.00 | | 2024-03-05 09:10:13.710061+00 | | 2024-02-26 06:33:33.188922+00 |
| public | r_pot_category | 6205 | 0 | 0.00 | 0.00 | | 2024-03-05 07:57:33.997257+00 | | 2024-03-05 06:02:03.034482+00 |
| public | r_pot_group | 141551 | 23950 | 0.00 | 14.00 | | 2024-03-05 09:10:13.754463+00 | | 2024-03-05 09:09:41.893902+00 |
| public | r_pot_tx | 46207 | 2174 | 0.00 | 4.00 | | 2024-02-23 01:16:30.930137+00 | | 2024-02-26 03:59:25.763269+00 |
| public | r_pot_user | 18627 | 21 | 0.00 | 0.00 | | 2024-03-04 09:01:28.357524+00 | | 2024-02-21 08:40:30.997445+00 |
| public | r_provider_tenant | 2654 | 473 | 0.00 | 15.00 | | 2024-02-28 07:51:30.427785+00 | | 2024-02-28 08:13:38.559679+00 |
| public | r_role_feature | 5340 | 0 | 0.00 | 0.00 | | 2024-03-04 07:38:48.277997+00 | | 2024-01-18 08:22:54.488926+00 |
| public | r_tenant_feature | 3391 | 33 | 0.00 | 0.00 | | 2024-03-01 17:41:37.744445+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 | 19178 | 28 | 0.00 | 0.00 | | 2024-03-04 09:01:28.19864+00 | | 2024-02-21 08:40:30.42447+00 |
| public | r_user_site | 5229 | 15 | 0.00 | 0.00 | | 2024-02-26 03:09:04.27992+00 | | 2024-01-11 06:16:33.979684+00 |
| public | r_zone_category | 2858 | 217 | 0.00 | 7.00 | | 2024-02-20 17:34:25.026497+00 | | 2024-02-29 06:57:30.578107+00 |
| public | t_attendance | 757139 | 14036 | 0.00 | 1.00 | | 2024-03-01 17:41:58.40272+00 | | 2024-02-28 22:47:09.64929+00 |
| public | t_general | 1442 | 13 | 0.00 | 0.00 | | 2024-02-26 03:54:25.841243+00 | | 2024-03-01 01:35:10.979803+00 |
| public | t_mobile_device_history | 401943 | 64 | 0.00 | 0.00 | | 2024-02-28 10:30:42.956582+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 | 1935222 | 40392 | 0.00 | 2.00 | | 2024-02-27 05:22:58.257941+00 | | 2024-03-01 01:34:14.276609+00 |
| public | t_operation_log | 7828764 | 156811 | 0.00 | 1.00 | | 2024-02-21 00:37:13.680176+00 | | 2024-03-05 00:50:28.509838+00 |
| public | t_plan | 9136768 | 1073818 | 0.00 | 10.00 | | 2024-02-27 22:59:44.179095+00 | | 2024-03-03 23:56:39.050246+00 |
| public | t_plan_detail | 14266374 | 635720 | 0.00 | 4.00 | | 2024-03-02 20:16:37.846888+00 | | 2024-03-05 01:18:30.765799+00 |
| public | t_plan_sync | 35634 | 7166 | 0.00 | 16.00 | | 2024-03-05 09:19:13.843165+00 | | 2024-03-05 09:08:42.003843+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 | 107587 | 4837201 | 44.00 | 97.00 | | 2024-03-05 09:21:20.433638+00 | 2024-03-04 12:30:10.206207+00 | 2024-03-05 09:21:20.993572+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:25.49702+00 | | |
| public | t_terminal | 27012 | 4130 | 0.00 | 13.00 | | 2024-03-05 04:47:29.966155+00 | | 2024-03-05 07:44:43.684937+00 |
| public | t_terminal_log | 5159085 | 0 | 0.00 | 0.00 | | 2024-02-20 09:05:52.58847+00 | | 2024-03-01 09:43:44.604781+00 |
| public | w_arrival_notify | 61 | 16 | 0.00 | 20.00 | | 2024-02-27 15:32:02.462165+00 | | 2024-02-21 00:34:37.660717+00 |
| public | w_latest_position | 43397 | 1506656 | 34.00 | 97.00 | | 2024-03-05 09:21:17.838067+00 | | 2024-03-05 09:21:18.240075+00 |
| public | w_latest_presence | 172561 | 9013322 | 52.00 | 98.00 | 2024-01-18 12:30:06.016796+00 | 2024-03-05 09:21:29.784473+00 | 2024-01-18 12:30:06.178604+00 | 2024-03-05 09:21:30.163805+00 |
| public | w_latest_sensor | 443 | 30639 | 69.00 | 98.00 | | 2024-03-05 09:21:18.273114+00 | | 2024-03-05 09:21:18.389157+00 |
| public | w_lock | 11837 | 2 | 0.00 | 0.00 | | 2024-03-04 01:15:10.160408+00 | | 2024-01-31 02:02:19.791893+00 |
| public | w_master_update | 227 | 28 | 0.00 | 10.00 | | 2024-03-05 07:57:33.940205+00 | | 2024-03-05 07:53:38.520957+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:26.189706+00 | | |
| public | w_plan_with_detail | 9127788 | 1416578 | 0.00 | 13.00 | | 2024-02-23 09:51:49.547951+00 | | 2024-03-04 01:44:13.418154+00 |