| 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-05-26 21:13:21.975465+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 | 1154976 | 0 | 0.00 | 0.00 | | 2024-05-25 16:06:03.305219+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 | 2856517 | 0 | 0.00 | 0.00 | | 2024-05-30 17:00:52.254652+00 | | 2024-05-31 15:45:55.077198+00 |
| e202405 | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-26 21:13:21.986166+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 | 47209346 | 0 | 0.00 | 0.00 | | 2024-05-31 06:38:06.871572+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 | 3792424 | 0 | 0.00 | 0.00 | | 2024-06-06 15:54:52.901544+00 | | 2024-06-06 15:54:53.404092+00 |
| e202406 | a_stay_time | 636783 | 0 | 0.00 | 0.00 | | 2024-06-06 15:30:55.778779+00 | | 2024-06-06 17:00:55.788222+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 | 11029758 | 0 | 0.00 | 0.00 | | 2024-06-06 10:30:18.828502+00 | | 2024-06-06 12:03:27.194367+00 |
| e202406 | t_presence_history | 1219115 | 165720 | 0.00 | 11.00 | | 2024-06-07 01:38:59.835689+00 | | 2024-06-07 01:42:00.860767+00 |
| e202406 | t_sensor_history | 258740 | 0 | 0.00 | 0.00 | | 2024-06-06 03:56:18.505884+00 | | 2024-06-06 22:22:01.19267+00 |
| public | __digdag_status | 12 | 14 | 1.00 | 53.00 | | 2024-06-05 21:50:26.951052+00 | | 2024-06-04 12:30:05.358445+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-26 20:43:53.387414+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-05-26 20:43:53.353729+00 | | |
| public | b_attendance_group | 415442 | 10395 | 0.00 | 2.00 | | 2024-05-26 20:43:52.238653+00 | | 2024-05-31 17:35:56.591531+00 |
| public | b_attendance_hour | 6446761 | 158001 | 0.00 | 2.00 | | 2024-05-27 01:53:32.506463+00 | | 2024-05-29 18:33:40.06548+00 |
| public | b_attendance_pot | 9352 | 112 | 0.00 | 1.00 | | 2024-06-06 08:04:34.549807+00 | | 2024-06-03 16:50:48.362638+00 |
| public | b_attendance_pot_hour | 153360 | 8400 | 0.00 | 5.00 | | 2024-06-02 13:24:18.358428+00 | | 2024-06-06 19:03:05.415349+00 |
| public | b_check_in | 3378953 | 89618 | 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 | 50420772 | 1267287 | 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 | 10560 | 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 | 158450 | 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 | 39582098 | 1320428 | 0.00 | 3.00 | | 2024-05-27 02:23:28.202388+00 | | 2024-06-06 18:34:40.455357+00 |
| public | b_proximity_info | 42162626 | 16354 | 0.00 | 0.00 | | 2024-06-06 16:09:31.294878+00 | | 2024-06-06 16:09:34.547938+00 |
| public | b_seat_reserve | 740950 | 18700 | 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 | 13723005 | 330240 | 0.00 | 2.00 | | 2024-05-26 20:41:50.391953+00 | | 2024-05-30 18:33:16.564907+00 |
| public | b_usage | 810333 | 18700 | 0.00 | 2.00 | | 2024-05-26 20:43:55.523193+00 | | 2024-05-31 17:46:02.633534+00 |
| public | b_usage_hour | 14778128 | 328840 | 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-05-26 21:03:44.015528+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-26 21:03:44.004758+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-26 21:03:43.993951+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-05-26 20:43:55.700874+00 | | |
| public | m_exb | 4835 | 87 | 0.00 | 1.00 | | 2024-05-27 02:50:05.629079+00 | | |
| public | m_favorite | 36516 | 402 | 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 | 2628 | 31 | 0.00 | 1.00 | | 2024-06-03 08:59:47.590259+00 | | |
| public | m_holiday | 5801 | 0 | 0.00 | 0.00 | | 2024-05-26 21:03:44.035079+00 | | |
| public | m_lob | 2271 | 3 | 0.00 | 0.00 | | 2024-05-27 01:56:07.607556+00 | | |
| public | m_location | 5393 | 187 | 0.00 | 3.00 | | 2024-05-26 20:43:53.564469+00 | | |
| public | m_notify_template | 119 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.55891+00 | | |
| public | m_outside | 57 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:53.581101+00 | | |
| public | m_pot | 25246 | 195 | 0.00 | 0.00 | | 2024-06-07 01:18:47.321591+00 | | 2024-06-07 00:10:35.742514+00 |
| public | m_pot_profile | 671 | 18 | 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-05-26 20:43:53.342894+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 | 2125 | 370 | 0.00 | 14.00 | | 2024-06-05 08:08:12.813605+00 | | 2024-06-06 15:41:47.731598+00 |
| public | m_setting_log | 4224 | 666 | 0.00 | 13.00 | | 2024-06-03 12:30:04.142568+00 | | 2024-06-06 20:52:41.693972+00 |
| public | m_site | 22 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.538736+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:53.299917+00 | | |
| public | m_tx | 15002 | 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 | 5 | 0.00 | 0.00 | | 2024-05-26 20:43:55.756803+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-05-26 20:43:55.581943+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-05-27 02:12:08.357201+00 | | |
| public | r_location_zone | 3361 | 242 | 0.00 | 6.00 | | 2024-05-26 17:34:03.006031+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 | 978 | 4 | 0.00 | 0.00 | | 2024-05-27 01:56:07.667051+00 | | |
| public | r_pot_group | 10431 | 741 | 0.00 | 6.00 | | 2024-06-06 23:12:48.260717+00 | | 2024-06-06 23:33:16.58433+00 |
| public | r_pot_tx | 8259 | 33 | 0.00 | 0.00 | | 2024-05-26 20:43:55.663389+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-05-26 20:43:53.323229+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.68095+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 | 5 | 0.00 | 0.00 | | 2024-05-26 20:43:53.376381+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 | 310720 | 19787 | 0.00 | 5.00 | | 2024-05-27 02:50:11.727443+00 | | 2024-06-01 18:34:38.210707+00 |
| public | t_general | 31 | 3 | 0.00 | 8.00 | | 2024-05-27 02:50:11.790043+00 | | |
| public | t_mobile_device_history | 80452 | 0 | 0.00 | 0.00 | | 2024-05-26 23:02:09.794125+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-05-26 20:43:55.592605+00 | | |
| public | t_notify_history | 419175 | 16742 | 0.00 | 3.00 | | 2024-05-27 02:50:15.541056+00 | | 2024-06-06 18:32:39.176352+00 |
| public | t_operation_log | 1949922 | 42188 | 0.00 | 2.00 | | 2024-05-26 22:12:16.045671+00 | | 2024-05-22 05:27:44.476293+00 |
| public | t_plan | 3266627 | 505532 | 0.00 | 13.00 | | 2024-05-31 18:35:22.42175+00 | | 2024-06-06 23:46:21.936522+00 |
| public | t_plan_detail | 3679839 | 526884 | 0.00 | 12.00 | | 2024-05-13 13:10:07.054646+00 | | 2024-06-05 02:13:44.75239+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | | | |
| public | t_plan_sync | 16583 | 2272 | 0.00 | 12.00 | | 2024-06-06 23:30:16.364693+00 | | 2024-06-07 00:52:14.48981+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-05-26 20:43:53.275414+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 | 8522 | 5473 | 0.00 | 39.00 | | 2024-06-07 01:45:00.340332+00 | 2024-06-06 12:42:01.050616+00 | 2024-06-07 01:45:00.371112+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-05-27 01:52:07.207854+00 | | |
| public | t_terminal | 15724 | 963 | 0.00 | 5.00 | | 2024-05-31 18:48:08.159664+00 | | 2024-06-06 22:41:22.694936+00 |
| public | t_terminal_log | 3926134 | 0 | 0.00 | 0.00 | | 2024-05-26 20:44:04.454232+00 | | |
| public | w_arrival_notify | 1 | 3 | 3.00 | 75.00 | | 2024-05-26 21:13:21.96418+00 | | |
| public | w_latest_position | 10863 | 1865 | 0.00 | 14.00 | | 2024-06-07 01:45:00.24878+00 | | 2024-06-07 01:45:00.274321+00 |
| public | w_latest_presence | 17522 | 15769 | 0.00 | 47.00 | | 2024-06-07 01:45:00.46249+00 | | 2024-06-07 01:45:00.589187+00 |
| public | w_latest_sensor | 113 | 53 | 0.00 | 31.00 | | 2024-06-07 01:44:00.220733+00 | | 2024-06-07 01:44:00.453708+00 |
| public | w_lock | 991 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:52.715739+00 | | |
| public | w_master_update | 15 | 32 | 2.00 | 68.00 | | 2024-06-05 21:05:39.998201+00 | | 2024-06-06 06:01:01.652416+00 |
| public | w_plan_with_detail | 3246742 | 523990 | 0.00 | 13.00 | | 2024-05-31 18:37:52.579332+00 | | 2024-06-05 18:32:32.354649+00 |
| public | w_plan_with_detail_new | 33 | 1 | 0.00 | 2.00 | | | | |