| 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 | 338286174 | 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-03-05 22:11:27.640288+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-05 22:11:27.651287+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-05 22:11:25.900213+00 | | |
| e202402 | t_position_history | 354035523 | 8 | 0.00 | 0.00 | | 2024-02-28 02:33:22.17918+00 | | 2024-02-28 06:24:03.251416+00 |
| e202402 | t_presence_history | 38854397 | 0 | 0.00 | 0.00 | | 2024-03-07 00:37:34.814248+00 | | 2024-02-29 14:33:56.738379+00 |
| e202402 | t_sensor_history | 15152015 | 1115 | 0.00 | 0.00 | | 2024-02-27 00:55:23.610288+00 | | 2024-02-28 11:55:22.157867+00 |
| e202403 | a_proximity_sum | 7648039 | 0 | 0.00 | 0.00 | | 2024-03-06 16:11:19.996025+00 | | 2024-03-06 16:11:20.550001+00 |
| e202403 | a_stay_time | 4034334 | 33136 | 0.00 | 0.00 | | 2024-03-06 17:46:07.475154+00 | | 2024-03-06 16:10:12.511843+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 | 93465424 | 0 | 0.00 | 0.00 | | 2024-03-07 08:10:20.407572+00 | | 2024-03-07 02:38:18.524891+00 |
| e202403 | t_presence_history | 26459088 | 6765123 | 0.00 | 20.00 | | 2024-03-07 09:02:42.721017+00 | | 2024-03-07 08:51:41.489163+00 |
| e202403 | t_sensor_history | 3701901 | 0 | 0.00 | 0.00 | | 2024-03-06 05:53:56.884696+00 | | 2024-03-06 21:20:55.246391+00 |
| public | __digdag_status | 58 | 40 | 0.00 | 40.00 | | 2024-03-07 06:24:47.570194+00 | | 2024-03-07 07:55:10.675095+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 | 15 | 0.00 | 2.00 | | 2024-02-29 01:09:35.939618+00 | | 2024-01-18 08:43:32.882494+00 |
| public | m_auth | 109 | 34 | 0.00 | 23.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 | 1941 | 0.00 | 9.00 | | 2024-02-23 11:06:43.705454+00 | | 2024-03-07 02:42:16.42393+00 |
| public | m_favorite | 151041 | 1382 | 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 | 13598 | 198 | 0.00 | 1.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 | 17977 | 257 | 0.00 | 1.00 | | 2024-02-22 09:20:23.856942+00 | | 2024-01-26 12:24:11.753833+00 |
| public | m_location | 33452 | 2242 | 0.00 | 6.00 | | 2024-02-27 05:21:46.398039+00 | | 2024-03-07 02:42:16.987907+00 |
| public | m_notify_template | 724 | 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 | 0 | 0.00 | 0.00 | | 2024-03-06 03:41:21.658342+00 | | |
| public | m_pot | 209168 | 8985 | 0.00 | 4.00 | | 2024-03-07 04:17:18.302313+00 | | 2024-03-07 03:01:42.756909+00 |
| public | m_pot_profile | 31934 | 271 | 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 | 47 | 0.00 | 41.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 | 523 | 11 | 0.00 | 2.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 | 18599 | 2497 | 0.00 | 11.00 | | 2024-03-07 05:59:45.977261+00 | | 2024-03-07 05:58:45.782369+00 |
| public | m_setting_log | 51261 | 0 | 0.00 | 0.00 | 2024-02-16 03:34:50.060418+00 | 2024-03-07 06:16:02.140753+00 | | 2024-03-07 06:17:02.032939+00 |
| public | m_site | 169 | 3 | 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 | 129183 | 4512 | 0.00 | 3.00 | | 2024-03-07 02:42:16.298417+00 | | 2024-03-07 01:16:12.00449+00 |
| public | m_user | 28779 | 170 | 0.00 | 0.00 | | 2024-02-29 00:09:48.624224+00 | | 2024-02-21 08:40:30.943311+00 |
| public | m_zone | 4150 | 334 | 0.00 | 7.00 | | 2024-02-27 09:30:47.826673+00 | | 2024-03-07 04:37:13.60577+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:25.42284+00 | | |
| public | r_auth_zone | 210 | 40 | 0.00 | 16.00 | | 2024-02-23 12:24:31.477986+00 | | 2024-03-07 02:43:16.034776+00 |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:25.648517+00 | | |
| public | r_group_auth | 439 | 1 | 0.00 | 0.00 | | 2024-02-26 07:10:34.118255+00 | | |
| public | r_location_zone | 31978 | 5473 | 0.00 | 14.00 | | 2024-03-06 01:38:51.629909+00 | | 2024-03-07 02:42:16.513152+00 |
| public | r_pot_auth | 715 | 3 | 0.00 | 0.00 | | 2024-03-05 09:10:13.710061+00 | | 2024-02-26 06:33:33.188922+00 |
| public | r_pot_category | 6204 | 0 | 0.00 | 0.00 | | 2024-03-07 06:24:47.514928+00 | | 2024-03-07 06:02:46.611043+00 |
| public | r_pot_group | 96501 | 12564 | 0.00 | 11.00 | | 2024-03-07 06:02:46.450938+00 | | 2024-03-07 09:02:32.821747+00 |
| public | r_pot_tx | 46429 | 2446 | 0.00 | 5.00 | | 2024-02-23 01:16:30.930137+00 | | 2024-03-06 00:25:53.987522+00 |
| public | r_pot_user | 18628 | 28 | 0.00 | 0.00 | | 2024-03-04 09:01:28.357524+00 | | 2024-02-21 08:40:30.997445+00 |
| public | r_provider_tenant | 2655 | 572 | 0.00 | 17.00 | | 2024-02-28 07:51:30.427785+00 | | 2024-03-06 04:58:03.30961+00 |
| public | r_role_feature | 5346 | 75 | 0.00 | 1.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-03-05 17:38:47.09676+00 | | 2024-01-27 01:38:23.792244+00 |
| public | r_user_region | 19180 | 36 | 0.00 | 0.00 | | 2024-03-04 09:01:28.19864+00 | | 2024-02-21 08:40:30.42447+00 |
| public | r_user_site | 5231 | 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 | 32 | 0.00 | 1.00 | | 2024-03-06 17:31:53.164394+00 | | 2024-02-29 06:57:30.578107+00 |
| public | t_attendance | 765091 | 28614 | 0.00 | 3.00 | | 2024-03-01 17:41:58.40272+00 | | 2024-02-28 22:47:09.64929+00 |
| public | t_general | 1452 | 14 | 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 | 404423 | 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 | 1950094 | 51369 | 0.00 | 2.00 | | 2024-02-27 05:22:58.257941+00 | | 2024-03-01 01:34:14.276609+00 |
| public | t_operation_log | 7809419 | 0 | 0.00 | 0.00 | | 2024-03-06 23:21:57.646403+00 | | 2024-03-05 00:50:28.509838+00 |
| public | t_plan | 9191717 | 226571 | 0.00 | 2.00 | | 2024-03-07 04:01:48.856216+00 | | 2024-03-06 20:21:20.99311+00 |
| public | t_plan_detail | 14377930 | 1195998 | 0.00 | 7.00 | | 2024-03-06 23:58:45.503623+00 | | 2024-03-07 03:11:41.379214+00 |
| public | t_plan_sync | 25271 | 3355 | 0.00 | 11.00 | | 2024-03-07 09:01:32.946151+00 | | 2024-03-07 09:01:33.135828+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 | 112668 | 3686853 | 32.00 | 97.00 | | 2024-03-07 09:02:35.332889+00 | 2024-03-06 12:30:03.108947+00 | 2024-03-07 09:02:35.873233+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-02-26 03:54:25.49702+00 | | |
| public | t_terminal | 28061 | 2494 | 0.00 | 8.00 | | 2024-03-07 06:04:47.584354+00 | | 2024-03-07 08:03:26.509435+00 |
| public | t_terminal_log | 5165306 | 0 | 0.00 | 0.00 | | 2024-03-06 08:40:51.801674+00 | | 2024-03-01 09:43:44.604781+00 |
| public | w_arrival_notify | 63 | 29 | 0.00 | 31.00 | | 2024-02-27 15:32:02.462165+00 | | 2024-03-05 23:34:33.525821+00 |
| public | w_latest_position | 44367 | 1107031 | 24.00 | 96.00 | | 2024-03-07 09:02:33.297751+00 | | 2024-03-07 09:02:33.612995+00 |
| public | w_latest_presence | 196972 | 6864785 | 34.00 | 97.00 | 2024-01-18 12:30:06.016796+00 | 2024-03-07 09:02:44.848351+00 | 2024-01-18 12:30:06.178604+00 | 2024-03-07 09:02:45.289651+00 |
| public | w_latest_sensor | 443 | 24140 | 54.00 | 98.00 | | 2024-03-07 09:02:33.64196+00 | | 2024-03-07 09:02:33.757501+00 |
| public | w_lock | 11885 | 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 | 97 | 47 | 0.00 | 32.00 | | 2024-03-07 06:57:07.893415+00 | | 2024-03-07 07:18:08.799939+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-02-26 03:54:26.189706+00 | | |
| public | w_plan_with_detail | 9179200 | 713840 | 0.00 | 7.00 | | 2024-03-06 06:55:22.436843+00 | | 2024-03-06 22:11:10.411564+00 |