| 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 |
|---|
| e202404 | a_proximity_sum | 3117477 | 0 | 0.00 | 0.00 | | 2024-06-06 18:55:03.591626+00 | | |
| e202404 | a_stay_time | 2915963 | 0 | 0.00 | 0.00 | | 2024-06-04 03:28:01.648496+00 | | |
| e202404 | l_position_history | 0 | 0 | 0 | 0 | | 2024-06-08 01:04:17.32463+00 | | |
| e202404 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-28 01:50:20.216005+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-28 01:50:20.205161+00 | | |
| e202404 | t_position_history | 47382493 | 0 | 0.00 | 0.00 | | 2024-06-05 05:50:31.528146+00 | | |
| e202404 | t_presence_history | 6867099 | 0 | 0.00 | 0.00 | | 2024-05-28 11:23:46.911052+00 | | 2024-04-30 14:47:32.149293+00 |
| e202404 | t_sensor_history | 1154956 | 0 | 0.00 | 0.00 | | 2024-06-07 04:00:10.00414+00 | | 2024-04-28 22:43:41.720491+00 |
| e202405 | a_proximity_sum | 2095422 | 0 | 0.00 | 0.00 | | 2024-06-04 09:33:09.131746+00 | | 2024-05-31 15:32:14.495666+00 |
| e202405 | a_stay_time | 2856084 | 0 | 0.00 | 0.00 | | 2024-06-07 22:21:01.633148+00 | | 2024-05-31 15:45:55.077198+00 |
| e202405 | l_position_history | 0 | 0 | 0 | 0 | | 2024-06-08 01:04:17.335676+00 | | |
| e202405 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-28 01:50:20.534855+00 | | |
| e202405 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-28 01:50:20.524006+00 | | |
| e202405 | t_position_history | 47022730 | 0 | 0.00 | 0.00 | | 2024-06-08 01:01:34.149383+00 | | 2024-05-29 23:09:42.660572+00 |
| e202405 | t_presence_history | 6548327 | 1151823 | 0.00 | 14.00 | | 2024-05-31 13:45:54.847347+00 | | 2024-05-31 14:52:09.269041+00 |
| e202405 | t_sensor_history | 1209985 | 0 | 0.00 | 0.00 | | 2024-06-06 04:12:21.013676+00 | | 2024-05-28 18:57:43.773123+00 |
| e202406 | a_proximity_sum | 5583557 | 0 | 0.00 | 0.00 | | 2024-06-07 15:40:01.069124+00 | | 2024-06-07 15:40:01.5851+00 |
| e202406 | a_stay_time | 783765 | 0 | 0.00 | 0.00 | | 2024-06-07 15:31:24.101224+00 | | 2024-06-07 15:31:24.357042+00 |
| e202406 | l_position_history | 0 | 0 | 0 | 0 | | 2024-06-02 10:51:04.345078+00 | | |
| e202406 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-02 10:51:04.367+00 | | |
| e202406 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-06-02 10:51:04.355965+00 | | |
| e202406 | t_position_history | 13012217 | 0 | 0.00 | 0.00 | | 2024-06-07 10:53:31.035994+00 | | 2024-06-07 12:47:21.754126+00 |
| e202406 | t_presence_history | 1417549 | 114535 | 0.00 | 7.00 | | 2024-06-08 01:38:05.464306+00 | | 2024-06-08 01:41:57.631292+00 |
| e202406 | t_sensor_history | 298846 | 0 | 0.00 | 0.00 | | 2024-06-07 11:50:19.985724+00 | | 2024-06-07 15:00:22.574604+00 |
| public | __digdag_status | 7 | 23 | 3.00 | 76.00 | | 2024-06-05 21:50:26.951052+00 | | 2024-06-07 21:20:13.358579+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-08 00:55:09.189602+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-06-08 00:55:09.15581+00 | | |
| public | b_attendance_group | 407220 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:08.064853+00 | | 2024-05-31 17:35:56.591531+00 |
| public | b_attendance_hour | 6453829 | 172540 | 0.00 | 2.00 | | 2024-05-27 01:53:32.506463+00 | | 2024-05-29 18:33:40.06548+00 |
| public | b_attendance_pot | 10114 | 224 | 0.00 | 2.00 | | 2024-06-06 08:04:34.549807+00 | | 2024-06-07 19:03:44.045525+00 |
| public | b_attendance_pot_hour | 153390 | 10080 | 0.00 | 6.00 | | 2024-06-02 13:24:18.358428+00 | | 2024-06-06 19:03:05.415349+00 |
| public | b_check_in | 3381146 | 97650 | 0.00 | 2.00 | | 2024-05-27 02:42:39.167386+00 | | 2024-05-30 18:34:48.755322+00 |
| public | b_check_in_hour | 50457066 | 1384827 | 0.00 | 2.00 | | 2024-05-27 01:55:06.863707+00 | | 2024-05-30 18:34:52.439949+00 |
| public | b_check_in_pot | 10674 | 0 | 0.00 | 0.00 | | 2024-05-28 01:27:35.49262+00 | | 2024-06-03 16:50:48.770603+00 |
| public | b_check_in_pot_hour | 160160 | 0 | 0.00 | 0.00 | | 2024-05-29 23:58:06.635638+00 | | 2024-05-31 16:50:56.01414+00 |
| public | b_proximity_group | 39535674 | 1435845 | 0.00 | 3.00 | | 2024-05-27 02:23:28.202388+00 | | 2024-06-06 18:34:40.455357+00 |
| public | b_proximity_info | 45415958 | 32008 | 0.00 | 0.00 | | 2024-06-06 16:09:31.294878+00 | | 2024-06-06 16:09:34.547938+00 |
| public | b_seat_reserve | 741654 | 20400 | 0.00 | 2.00 | | 2024-05-27 02:12:10.117048+00 | | 2024-05-29 19:03:15.655762+00 |
| public | b_seat_reserve_hour | 13417476 | 0 | 0.00 | 0.00 | | 2024-06-08 00:53:50.272952+00 | | 2024-05-30 18:33:16.564907+00 |
| public | b_usage | 796546 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.241981+00 | | 2024-05-31 17:46:02.633534+00 |
| public | b_usage_hour | 14796327 | 359260 | 0.00 | 2.00 | | 2024-05-27 01:51:06.132274+00 | | 2024-05-31 18:33:03.379243+00 |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-06-08 01:01:34.67547+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-06-08 01:01:34.664735+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-06-08 01:01:34.654008+00 | | |
| public | m_area | 98 | 0 | 0.00 | 0.00 | | 2024-05-27 02:50:05.51117+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-05-27 01:53:32.524864+00 | | |
| public | m_category | 456 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.420951+00 | | |
| public | m_exb | 4835 | 87 | 0.00 | 1.00 | | 2024-05-27 02:50:05.629079+00 | | |
| public | m_favorite | 36561 | 417 | 0.00 | 1.00 | | 2024-05-27 01:55:07.948582+00 | | 2024-06-06 23:39:16.64971+00 |
| public | m_feature | 162 | 0 | 0.00 | 0.00 | | 2024-05-27 02:50:15.561486+00 | | |
| public | m_group | 2630 | 33 | 0.00 | 1.00 | | 2024-06-03 08:59:47.590259+00 | | |
| public | m_holiday | 5780 | 0 | 0.00 | 0.00 | | 2024-06-08 01:01:34.691922+00 | | |
| public | m_lob | 2271 | 3 | 0.00 | 0.00 | | 2024-05-27 01:56:07.607556+00 | | |
| public | m_location | 5393 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:09.392276+00 | | |
| public | m_notify_template | 119 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.284288+00 | | |
| public | m_outside | 57 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:09.409264+00 | | |
| public | m_pot | 24047 | 3573 | 0.00 | 12.00 | | 2024-06-07 13:10:54.605264+00 | | 2024-06-08 00:10:06.541883+00 |
| public | m_pot_profile | 671 | 19 | 0.00 | 2.00 | | 2024-05-27 01:53:18.318294+00 | | 2024-05-24 01:20:33.798494+00 |
| public | m_provider_user | 58 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:09.145061+00 | | |
| public | m_region | 15 | 0 | 0.00 | 0.00 | | 2024-05-27 02:50:11.805974+00 | | |
| public | m_role | 77 | 1 | 0.00 | 1.00 | | 2024-05-27 02:50:11.767384+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-05-27 02:42:32.161115+00 | | |
| public | m_setting | 2952 | 112 | 0.00 | 3.00 | | 2024-06-07 13:01:21.850746+00 | | 2024-06-06 15:41:47.731598+00 |
| public | m_setting_log | 4230 | 878 | 0.00 | 17.00 | | 2024-06-03 12:30:04.142568+00 | | 2024-06-08 01:41:57.076302+00 |
| public | m_site | 22 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.262193+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:09.098385+00 | | |
| public | m_tx | 15003 | 6 | 0.00 | 0.00 | | 2024-05-31 13:29:44.336403+00 | | 2024-05-31 13:29:44.435988+00 |
| public | m_user | 979 | 7 | 0.00 | 0.00 | | 2024-05-28 10:10:41.646512+00 | | |
| public | m_zone | 751 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.444613+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-05-27 02:12:10.128179+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-05-27 02:42:32.133523+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.308308+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-05-27 02:12:08.357201+00 | | |
| public | r_location_zone | 3361 | 0 | 0.00 | 0.00 | | 2024-06-07 23:11:16.162823+00 | | 2024-05-27 07:45:23.854768+00 |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-05-27 01:53:32.547685+00 | | |
| public | r_pot_category | 979 | 8 | 0.00 | 0.00 | | 2024-05-27 01:56:07.667051+00 | | |
| public | r_pot_group | 10210 | 705 | 0.00 | 6.00 | | 2024-06-07 23:13:16.247457+00 | | 2024-06-07 23:33:16.325451+00 |
| public | r_pot_tx | 8259 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.384385+00 | | |
| public | r_pot_user | 694 | 8 | 0.00 | 1.00 | | 2024-05-28 10:10:41.511178+00 | | |
| public | r_provider_tenant | 189 | 0 | 0.00 | 0.00 | | 2024-06-05 20:12:22.52431+00 | | |
| public | r_role_feature | 699 | 4 | 0.00 | 0.00 | | 2024-05-27 02:50:11.751039+00 | | |
| public | r_tenant_feature | 554 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:09.124569+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.402061+00 | | |
| public | r_user_region | 843 | 8 | 0.00 | 0.00 | | 2024-05-28 10:10:41.559015+00 | | |
| public | r_user_site | 735 | 2 | 0.00 | 0.00 | | 2024-05-28 10:10:41.536588+00 | | |
| public | r_zone_category | 671 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:09.178597+00 | | 2024-05-15 11:06:59.505804+00 |
| public | t_ai_history | 0 | 0 | 0 | 0 | | 2024-05-28 08:33:39.114921+00 | | |
| public | t_attendance | 310519 | 22073 | 0.00 | 6.00 | | 2024-05-27 02:50:11.727443+00 | | 2024-06-01 18:34:38.210707+00 |
| public | t_general | 32 | 3 | 0.00 | 8.00 | | 2024-05-27 02:50:11.790043+00 | | |
| public | t_mobile_device_history | 80519 | 0 | 0.00 | 0.00 | | 2024-05-26 23:02:09.794125+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-06-08 00:55:11.319072+00 | | |
| public | t_notify_history | 419137 | 18172 | 0.00 | 4.00 | | 2024-05-27 02:50:15.541056+00 | | 2024-06-06 18:32:39.176352+00 |
| public | t_operation_log | 2173186 | 0 | 0.00 | 0.00 | | 2024-06-08 01:41:01.387692+00 | | 2024-05-22 05:27:44.476293+00 |
| public | t_plan | 3276563 | 591094 | 0.00 | 15.00 | | 2024-05-31 18:35:22.42175+00 | | 2024-06-06 23:46:21.936522+00 |
| public | t_plan_detail | 3679960 | 553924 | 0.00 | 13.00 | | 2024-05-13 13:10:07.054646+00 | | 2024-06-07 01:46:00.75379+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | | | |
| public | t_plan_sync | 16588 | 2234 | 0.00 | 11.00 | | 2024-06-07 23:11:15.819542+00 | | 2024-06-08 00:47:13.915616+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-06-08 00:55:09.075553+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-05-27 01:50:34.147919+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-05-27 01:56:07.626525+00 | | |
| public | t_recv_position_history | 7654 | 2046 | 0.00 | 21.00 | | 2024-06-08 01:44:57.151309+00 | 2024-06-07 12:42:00.551281+00 | 2024-06-08 01:44:57.177056+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-05-27 01:52:07.207854+00 | | |
| public | t_terminal | 15772 | 1078 | 0.00 | 6.00 | | 2024-05-31 18:48:08.159664+00 | | 2024-06-08 01:38:57.403248+00 |
| public | t_terminal_log | 4032362 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:16.438009+00 | | 2024-06-07 13:05:57.570082+00 |
| public | w_arrival_notify | 1 | 0 | 0.00 | 0.00 | | 2024-06-08 01:04:17.390642+00 | | |
| public | w_latest_position | 10864 | 1839 | 0.00 | 14.00 | | 2024-06-08 01:35:56.682427+00 | | 2024-06-08 01:44:57.088673+00 |
| public | w_latest_presence | 17527 | 7052 | 0.00 | 28.00 | | 2024-06-08 01:44:57.250831+00 | | 2024-06-08 01:44:57.335833+00 |
| public | w_latest_sensor | 164 | 54 | 0.00 | 24.00 | | 2024-06-08 01:43:57.039079+00 | | 2024-06-08 01:42:57.225679+00 |
| public | w_lock | 991 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:08.513222+00 | | |
| public | w_master_update | 15 | 9 | 0.00 | 37.00 | | 2024-06-07 15:01:22.408055+00 | | 2024-06-06 06:01:01.652416+00 |
| public | w_plan_with_detail | 3260807 | 615272 | 0.00 | 15.00 | | 2024-05-31 18:37:52.579332+00 | | 2024-06-07 12:25:22.237056+00 |
| public | w_plan_with_detail_new | 33 | 1 | 0.00 | 2.00 | | | | |