| 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-06-09 19:15:19.169502+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-06-09 19:15:19.158712+00 | | |
| e202404 | t_position_history | 47382493 | 0 | 0.00 | 0.00 | | 2024-06-05 05:50:31.528146+00 | | |
| e202404 | t_presence_history | 6867055 | 0 | 0.00 | 0.00 | | 2024-06-10 06:43:06.890788+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-06-09 19:15:19.191328+00 | | |
| e202405 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-06-09 19:15:19.180628+00 | | |
| e202405 | t_position_history | 47022735 | 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 | 6933942 | 0 | 0.00 | 0.00 | | 2024-06-10 21:59:07.79402+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 | 12316861 | 0 | 0.00 | 0.00 | | 2024-06-10 16:05:07.43033+00 | | 2024-06-11 15:40:32.230892+00 |
| e202406 | a_stay_time | 1167713 | 0 | 0.00 | 0.00 | | 2024-06-10 15:31:07.591717+00 | | 2024-06-11 15:30:39.871781+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 | 19809070 | 0 | 0.00 | 0.00 | | 2024-06-11 10:13:44.458114+00 | | 2024-06-11 05:20:06.095632+00 |
| e202406 | t_presence_history | 2041627 | 379290 | 0.00 | 15.00 | | 2024-06-12 01:31:35.062276+00 | | 2024-06-12 01:41:17.321592+00 |
| e202406 | t_sensor_history | 460415 | 0 | 0.00 | 0.00 | | 2024-06-11 02:07:53.227183+00 | | 2024-06-11 22:55:46.926283+00 |
| public | __digdag_status | 6 | 12 | 2.00 | 66.00 | | 2024-06-10 21:50:12.806373+00 | | 2024-06-11 12:30:57.406946+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 | 408900 | 3780 | 0.00 | 0.00 | | 2024-06-08 00:55:08.064853+00 | | 2024-05-31 17:35:56.591531+00 |
| public | b_attendance_hour | 6329228 | 58156 | 0.00 | 0.00 | | 2024-06-08 07:34:26.689384+00 | | 2024-05-29 18:33:40.06548+00 |
| public | b_attendance_pot | 10122 | 672 | 0.00 | 6.00 | | 2024-06-06 08:04:34.549807+00 | | 2024-06-07 19:03:44.045525+00 |
| public | b_attendance_pot_hour | 153510 | 16800 | 0.00 | 9.00 | | 2024-06-02 13:24:18.358428+00 | | 2024-06-11 19:04:01.905215+00 |
| public | b_check_in | 3294583 | 32128 | 0.00 | 0.00 | | 2024-06-08 09:04:57.675329+00 | | 2024-05-30 18:34:48.755322+00 |
| public | b_check_in_hour | 49248184 | 470160 | 0.00 | 0.00 | | 2024-06-08 07:36:40.770101+00 | | 2024-05-30 18:34:52.439949+00 |
| public | b_check_in_pot | 11109 | 0 | 0.00 | 0.00 | | 2024-06-09 17:54:11.40201+00 | | 2024-06-03 16:50:48.770603+00 |
| public | b_check_in_pot_hour | 166935 | 0 | 0.00 | 0.00 | | 2024-06-11 12:22:57.805623+00 | | 2024-06-09 16:51:11.010125+00 |
| public | b_proximity_group | 37994951 | 461704 | 0.00 | 1.00 | | 2024-06-08 08:32:18.10928+00 | | 2024-06-06 18:34:40.455357+00 |
| public | b_proximity_info | 57386924 | 15882 | 0.00 | 0.00 | | 2024-06-10 16:10:25.619952+00 | | 2024-06-10 16:10:28.894539+00 |
| public | b_seat_reserve | 726518 | 6800 | 0.00 | 0.00 | | 2024-06-08 08:11:05.083097+00 | | 2024-05-29 19:03:15.655762+00 |
| public | b_seat_reserve_hour | 13480024 | 121680 | 0.00 | 0.00 | | 2024-06-08 00:53:50.272952+00 | | 2024-05-30 18:33:16.564907+00 |
| public | b_usage | 800554 | 6800 | 0.00 | 0.00 | | 2024-06-08 00:55:11.241981+00 | | 2024-05-31 17:46:02.633534+00 |
| public | b_usage_hour | 14581009 | 121680 | 0.00 | 0.00 | | 2024-06-08 07:31:11.628217+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 | 99 | 0 | 0.00 | 0.00 | | 2024-06-08 09:18:36.43247+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-06-08 07:35:12.117065+00 | | |
| public | m_category | 456 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.420951+00 | | |
| public | m_exb | 3835 | 0 | 0.00 | 0.00 | | 2024-06-08 09:18:36.556055+00 | | |
| public | m_favorite | 36576 | 141 | 0.00 | 0.00 | | 2024-06-08 07:40:41.759717+00 | | 2024-06-06 23:39:16.64971+00 |
| public | m_feature | 162 | 0 | 0.00 | 0.00 | | 2024-06-08 09:20:43.187054+00 | | |
| public | m_group | 2632 | 35 | 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 | 2276 | 1 | 0.00 | 0.00 | | 2024-06-08 07:41:41.37835+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 | 24058 | 4493 | 0.00 | 15.00 | | 2024-06-12 00:05:44.890239+00 | | 2024-06-12 00:10:44.046086+00 |
| public | m_pot_profile | 673 | 23 | 0.00 | 3.00 | | 2024-06-08 07:34:12.291862+00 | | 2024-05-24 01:20:33.798494+00 |
| public | m_provider_user | 58 | 1 | 0.00 | 1.00 | | 2024-06-08 00:55:09.145061+00 | | |
| public | m_region | 15 | 0 | 0.00 | 0.00 | | 2024-06-08 09:18:43.140514+00 | | |
| public | m_role | 77 | 0 | 0.00 | 0.00 | | 2024-06-08 09:18:43.106694+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-06-08 09:04:50.784823+00 | | |
| public | m_setting | 3014 | 32 | 0.00 | 1.00 | | 2024-06-11 22:06:35.117973+00 | | 2024-06-11 04:24:51.870773+00 |
| public | m_setting_log | 4233 | 654 | 0.00 | 13.00 | | 2024-06-08 12:30:31.899891+00 | | 2024-06-11 18:55:00.130847+00 |
| public | m_site | 23 | 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 | 27966 | 4 | 0.00 | 0.00 | | 2024-06-09 19:05:19.306898+00 | | 2024-05-31 13:29:44.435988+00 |
| public | m_user | 979 | 0 | 0.00 | 0.00 | | 2024-06-10 05:51:20.781669+00 | | |
| public | m_zone | 752 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:11.444613+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-06-08 08:11:05.094075+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-06-08 09:04:50.762909+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-06-08 08:11:03.349098+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-06-08 07:35:12.137308+00 | | |
| public | r_pot_category | 979 | 2 | 0.00 | 0.00 | | 2024-06-08 07:41:41.440731+00 | | |
| public | r_pot_group | 10036 | 937 | 0.00 | 8.00 | | 2024-06-11 23:13:20.372436+00 | | 2024-06-11 23:33:20.733558+00 |
| public | r_pot_tx | 8257 | 9 | 0.00 | 0.00 | | 2024-06-08 00:55:11.384385+00 | | |
| public | r_pot_user | 694 | 0 | 0.00 | 0.00 | | 2024-06-10 05:51:20.592607+00 | | |
| public | r_provider_tenant | 189 | 13 | 0.00 | 6.00 | | 2024-06-05 20:12:22.52431+00 | | |
| public | r_role_feature | 699 | 0 | 0.00 | 0.00 | | 2024-06-08 09:18:43.090682+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 | 0 | 0.00 | 0.00 | | 2024-06-10 05:51:20.681649+00 | | |
| public | r_user_site | 735 | 0 | 0.00 | 0.00 | | 2024-06-10 05:51:20.639416+00 | | |
| public | r_zone_category | 672 | 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-06-10 04:25:39.12104+00 | | |
| public | t_attendance | 395792 | 4782 | 0.00 | 1.00 | | 2024-06-08 09:18:42.794046+00 | | 2024-06-01 18:34:38.210707+00 |
| public | t_general | 32 | 0 | 0.00 | 0.00 | | 2024-06-08 09:18:43.124832+00 | | |
| public | t_mobile_device_history | 81808 | 0 | 0.00 | 0.00 | | 2024-06-08 02:36:02.0763+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-06-08 00:55:11.319072+00 | | |
| public | t_notify_history | 450705 | 4991 | 0.00 | 1.00 | | 2024-06-08 09:18:46.60335+00 | | 2024-06-06 18:32:39.176352+00 |
| public | t_operation_log | 2183996 | 10418 | 0.00 | 0.00 | | 2024-06-08 01:41:01.387692+00 | | 2024-05-22 05:27:44.476293+00 |
| public | t_plan | 3265901 | 298520 | 0.00 | 8.00 | | 2024-06-09 07:43:51.892995+00 | | 2024-06-10 21:54:15.772307+00 |
| public | t_plan_detail | 3695725 | 30002 | 0.00 | 0.00 | | 2024-06-11 22:32:22.664025+00 | | 2024-06-10 22:35:53.20779+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-06-10 21:48:13.06266+00 | | |
| public | t_plan_sync | 16590 | 2284 | 0.00 | 12.00 | | 2024-06-11 23:11:19.930253+00 | | 2024-06-12 00:48:01.813161+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-06-08 07:30:44.673235+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-06-08 07:41:41.396317+00 | | |
| public | t_recv_position_history | 8454 | 1488 | 0.00 | 14.00 | | 2024-06-12 01:45:17.285923+00 | 2024-06-11 12:42:01.063726+00 | 2024-06-12 01:45:17.319847+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-06-08 07:32:12.023339+00 | | |
| public | t_terminal | 15966 | 1712 | 0.00 | 9.00 | | 2024-05-31 18:48:08.159664+00 | | 2024-06-11 23:31:20.813459+00 |
| public | t_terminal_log | 4067747 | 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 | 2 | 3 | 1.00 | 60.00 | | 2024-06-08 01:04:17.390642+00 | | |
| public | w_latest_position | 10867 | 743 | 0.00 | 6.00 | | 2024-06-12 01:45:17.075418+00 | | 2024-06-12 01:45:17.098192+00 |
| public | w_latest_presence | 17538 | 6883 | 0.00 | 28.00 | | 2024-06-12 01:45:17.419085+00 | | 2024-06-12 01:45:17.539563+00 |
| public | w_latest_sensor | 113 | 63 | 0.00 | 35.00 | | 2024-06-12 01:43:16.758326+00 | | 2024-06-12 01:45:17.054359+00 |
| public | w_lock | 991 | 0 | 0.00 | 0.00 | | 2024-06-08 00:55:08.513222+00 | | |
| public | w_master_update | 15 | 6 | 0.00 | 28.00 | | 2024-06-11 23:13:20.748315+00 | | 2024-06-10 06:01:20.880912+00 |
| public | w_plan_with_detail | 3277902 | 312670 | 0.00 | 8.00 | | 2024-06-08 18:34:53.45185+00 | | 2024-06-11 11:12:46.171417+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-06-10 21:22:33.881849+00 | | |