| 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 |
|---|
| e202410 | a_proximity_sum | 1081198 | 0 | 0.00 | 0.00 | | 2024-12-14 18:25:35.337564+00 | | 2024-11-07 04:46:59.819351+00 |
| e202410 | a_stay_time | 3183991 | 0 | 0.00 | 0.00 | | 2024-12-13 18:38:35.645031+00 | | 2024-11-07 06:02:52.540901+00 |
| e202410 | t_position_history | 37554973 | 0 | 0.00 | 0.00 | | 2024-12-18 03:10:08.454969+00 | | 2024-10-29 23:37:01.175338+00 |
| e202410 | t_presence_history | 7871276 | 0 | 0.00 | 0.00 | | 2024-12-17 23:43:02.798809+00 | | 2024-10-31 14:52:46.384793+00 |
| e202410 | t_sensor_history | 1232953 | 0 | 0.00 | 0.00 | | 2024-12-17 05:16:48.555795+00 | | 2024-10-29 03:22:14.031407+00 |
| e202411 | a_proximity_sum | 1445166 | 0 | 0.00 | 0.00 | | 2024-12-22 00:08:58.825181+00 | | 2024-11-28 15:35:25.582184+00 |
| e202411 | a_stay_time | 4808444 | 0 | 0.00 | 0.00 | | 2024-12-17 01:23:06.233518+00 | | 2024-11-29 15:31:20.632353+00 |
| e202411 | t_position_history | 35494936 | 0 | 0.00 | 0.00 | | 2024-12-13 18:41:20.416526+00 | | 2024-11-29 08:22:26.529491+00 |
| e202411 | t_presence_history | 8650509 | 0 | 0.00 | 0.00 | | 2024-12-15 23:10:38.749773+00 | | 2024-11-30 14:49:12.174674+00 |
| e202411 | t_sensor_history | 1213993 | 0 | 0.00 | 0.00 | | 2024-12-13 09:11:10.568617+00 | | 2024-11-28 16:35:17.67372+00 |
| e202412 | a_proximity_sum | 1240758 | 0 | 0.00 | 0.00 | | 2024-12-19 15:34:16.824453+00 | | 2024-12-21 15:16:06.786991+00 |
| e202412 | a_stay_time | 3699286 | 0 | 0.00 | 0.00 | | 2024-12-18 16:35:55.320746+00 | | 2024-12-20 15:31:27.421517+00 |
| e202412 | t_position_history | 26772406 | 0 | 0.00 | 0.00 | | 2024-12-20 23:14:49.427433+00 | | 2024-12-19 07:38:22.862168+00 |
| e202412 | t_presence_history | 4497095 | 384078 | 0.00 | 7.00 | | 2024-12-22 01:35:55.388227+00 | | 2024-12-22 01:40:07.381728+00 |
| e202412 | t_sensor_history | 885291 | 0 | 0.00 | 0.00 | | 2024-12-19 19:04:58.70547+00 | | 2024-12-20 21:18:07.640942+00 |
| public | __digdag_status | 7 | 48 | 6.00 | 87.00 | | 2024-12-17 13:10:11.730786+00 | | 2024-12-20 21:20:07.197098+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2024-12-17 00:33:56.135471+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-12-14 13:08:53.151624+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-12-14 12:52:16.980027+00 | | |
| public | b_attendance_group | 566528 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:49.800713+00 | | 2024-12-07 17:45:04.626746+00 |
| public | b_attendance_hour | 8840321 | 0 | 0.00 | 0.00 | | 2024-12-14 23:24:11.065489+00 | | 2024-12-06 17:40:29.428151+00 |
| public | b_attendance_pot | 421366 | 0 | 0.00 | 0.00 | | 2024-12-20 08:24:50.572701+00 | | 2024-12-17 18:36:08.862871+00 |
| public | b_attendance_pot_hour | 6547293 | 0 | 0.00 | 0.00 | | 2024-12-19 07:48:36.854332+00 | | 2024-12-12 18:20:48.299836+00 |
| public | b_check_in | 4452023 | 0 | 0.00 | 0.00 | | 2024-12-15 00:42:50.665961+00 | | 2024-12-10 17:42:39.967486+00 |
| public | b_check_in_hour | 67803040 | 0 | 0.00 | 0.00 | | 2024-12-14 23:25:59.573933+00 | | 2024-12-13 17:31:51.541713+00 |
| public | b_check_in_pot | 196160 | 0 | 0.00 | 0.00 | | 2024-12-21 10:30:22.779613+00 | | 2024-12-14 18:26:36.74616+00 |
| public | b_check_in_pot_hour | 3964043 | 0 | 0.00 | 0.00 | | 2024-12-20 01:57:54.83856+00 | | 2024-12-04 18:27:03.789272+00 |
| public | b_proximity_group | 39304188 | 0 | 0.00 | 0.00 | | 2024-12-15 00:23:42.715452+00 | | 2024-12-20 17:42:57.939951+00 |
| public | b_proximity_info | 33971633 | 0 | 0.00 | 0.00 | | 2024-12-21 10:21:21.233029+00 | | 2024-11-27 17:51:03.911928+00 |
| public | b_seat_reserve | 1020704 | 0 | 0.00 | 0.00 | | 2024-12-14 23:48:19.151677+00 | | 2024-11-22 17:46:01.568763+00 |
| public | b_seat_reserve_hour | 19334930 | 0 | 0.00 | 0.00 | | 2024-12-14 12:51:48.954448+00 | | 2024-11-24 17:48:14.117716+00 |
| public | b_usage | 1138101 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.00419+00 | | 2024-11-19 12:16:20.249407+00 |
| public | b_usage_hour | 21065675 | 0 | 0.00 | 0.00 | | 2024-12-14 23:13:17.343413+00 | | 2024-11-20 17:36:08.827222+00 |
| public | m_area | 97 | 0 | 0.00 | 0.00 | | 2024-12-15 01:11:17.690965+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-12-14 23:32:00.095173+00 | | |
| public | m_category | 488 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.120266+00 | | |
| public | m_exb | 3804 | 0 | 0.00 | 0.00 | | 2024-12-19 06:46:23.303567+00 | | 2024-11-20 14:17:58.996858+00 |
| public | m_favorite | 36824 | 314 | 0.00 | 0.00 | | 2024-12-13 05:54:09.172901+00 | | 2024-12-03 06:11:37.005424+00 |
| public | m_favorite_group | 8244 | 12 | 0.00 | 0.00 | | 2024-12-16 18:33:55.401759+00 | | 2024-12-09 00:27:50.393044+00 |
| public | m_feature | 165 | 0 | 0.00 | 0.00 | | 2024-12-15 01:11:17.673733+00 | | |
| public | m_group | 2333 | 6 | 0.00 | 0.00 | | 2024-12-13 08:44:18.779223+00 | | |
| public | m_holiday | 5566 | 0 | 0.00 | 0.00 | | 2024-12-14 13:09:31.340822+00 | | |
| public | m_lob | 1180 | 6 | 0.00 | 0.00 | | 2024-12-13 08:32:00.099936+00 | | |
| public | m_lob_log | 10 | 0 | 0.00 | 0.00 | | 2024-12-18 15:30:46.54005+00 | | |
| public | m_location | 5487 | 0 | 0.00 | 0.00 | | 2024-12-13 08:44:18.96327+00 | | 2024-11-25 04:16:30.357563+00 |
| public | m_notify_template | 132 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.046948+00 | | |
| public | m_outside | 67 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:50.487801+00 | | |
| public | m_pot | 26471 | 3466 | 0.00 | 11.00 | | 2024-12-21 13:10:44.640623+00 | | 2024-12-22 00:10:58.703453+00 |
| public | m_pot_profile | 701 | 19 | 0.00 | 2.00 | | 2024-12-14 23:23:45.104404+00 | | 2024-12-20 07:31:42.338095+00 |
| public | m_provider_user | 59 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:50.452272+00 | | |
| public | m_region | 18 | 0 | 0.00 | 0.00 | | 2024-12-15 00:51:44.097319+00 | | |
| public | m_role | 83 | 0 | 0.00 | 0.00 | | 2024-12-15 01:10:49.055077+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-12-15 00:42:43.872885+00 | | |
| public | m_setting | 2434 | 516 | 0.00 | 17.00 | | 2024-12-19 16:48:05.148239+00 | | 2024-12-21 05:36:31.626143+00 |
| public | m_setting_log | 5048 | 872 | 0.00 | 14.00 | | 2024-12-17 12:30:39.101148+00 | | 2024-12-21 12:30:19.7183+00 |
| public | m_site | 27 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.023944+00 | | |
| public | m_tenant | 18 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:50.415256+00 | | |
| public | m_tx | 42958 | 0 | 0.00 | 0.00 | | 2024-12-20 12:12:16.059474+00 | | 2024-12-03 01:44:45.328615+00 |
| public | m_user | 3419 | 1 | 0.00 | 0.00 | | 2024-12-17 09:55:38.530318+00 | | 2024-12-17 09:55:38.578628+00 |
| public | m_zone | 892 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.139885+00 | | 2024-11-19 15:09:07.905763+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-12-14 23:52:18.903257+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-12-15 00:42:43.85157+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.068478+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-12-14 23:48:18.772744+00 | | |
| public | r_location_zone | 5596 | 0 | 0.00 | 0.00 | | 2024-12-18 19:31:37.47618+00 | | 2024-11-27 05:28:47.354369+00 |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-12-14 23:32:00.115728+00 | | |
| public | r_pot_category | 991 | 6 | 0.00 | 0.00 | | 2024-12-14 23:32:00.168292+00 | | |
| public | r_pot_group | 23601 | 967 | 0.00 | 3.00 | | 2024-12-21 23:13:26.441703+00 | | 2024-12-21 23:12:29.788556+00 |
| public | r_pot_tx | 10287 | 9 | 0.00 | 0.00 | | 2024-12-18 03:58:08.266209+00 | | |
| public | r_pot_user | 3046 | 1 | 0.00 | 0.00 | | 2024-12-15 09:39:21.900222+00 | | |
| public | r_provider_tenant | 165 | 0 | 0.00 | 0.00 | | 2024-12-20 11:11:22.708492+00 | | 2024-11-21 01:04:08.432267+00 |
| public | r_role_feature | 602 | 0 | 0.00 | 0.00 | | 2024-12-13 07:25:26.037212+00 | | |
| public | r_tenant_feature | 682 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:50.43313+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:53.10145+00 | | |
| public | r_user_region | 3104 | 1 | 0.00 | 0.00 | | 2024-12-15 09:39:21.928453+00 | | |
| public | r_user_site | 355 | 0 | 0.00 | 0.00 | | 2024-12-21 10:21:24.234939+00 | | |
| public | r_zone_category | 775 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:50.470895+00 | | 2024-11-19 15:09:07.863079+00 |
| public | t_ai_history | 35 | 0 | 0.00 | 0.00 | | 2024-12-16 07:07:10.914555+00 | | |
| public | t_attendance | 426519 | 7507 | 0.00 | 1.00 | | 2024-12-15 01:10:49.037504+00 | | 2024-12-15 01:11:17.652309+00 |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2024-12-15 00:51:44.079403+00 | | |
| public | t_mobile_device_history | 120233 | 0 | 0.00 | 0.00 | | 2024-12-14 14:50:57.190184+00 | | 2024-11-13 08:18:57.025024+00 |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-12-14 13:08:53.07957+00 | | |
| public | t_notify_history | 608017 | 4585 | 0.00 | 0.00 | | 2024-12-15 00:51:48.596696+00 | | 2024-12-20 01:11:29.422244+00 |
| public | t_operation_log | 2281192 | 2 | 0.00 | 0.00 | | 2024-12-14 13:32:41.3255+00 | | 2024-11-25 02:59:20.632326+00 |
| public | t_plan | 4694772 | 291041 | 0.00 | 5.00 | | 2024-12-13 17:10:07.643767+00 | | 2024-12-21 06:45:01.285154+00 |
| public | t_plan_detail | 5804896 | 261636 | 0.00 | 4.00 | | 2024-12-17 10:22:13.278963+00 | | 2024-12-18 09:40:36.243043+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-12-16 22:07:23.613692+00 | | |
| public | t_plan_sync | 233584 | 18845 | 0.00 | 7.00 | | 2024-12-20 09:12:08.7192+00 | | 2024-12-21 23:11:14.80522+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-12-14 13:08:50.395991+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-12-14 23:12:43.777033+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-12-14 23:32:00.134644+00 | | |
| public | t_recv_position_history | 5414 | 672 | 0.00 | 11.00 | | 2024-12-22 01:45:19.844782+00 | 2024-12-21 12:42:01.450113+00 | 2024-12-22 01:45:19.870665+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-12-14 23:13:17.389328+00 | | |
| public | t_terminal | 25139 | 1513 | 0.00 | 5.00 | | 2024-12-18 19:54:06.876178+00 | | 2024-12-21 23:12:32.405466+00 |
| public | t_terminal_log | 5373511 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:59.781963+00 | | 2024-12-04 20:05:43.670536+00 |
| public | w_arrival_notify | 1 | 4 | 4.00 | 80.00 | | 2024-12-14 13:10:39.326698+00 | | 2024-11-19 00:27:39.742116+00 |
| public | w_latest_position | 10812 | 629 | 0.00 | 5.00 | | 2024-12-22 01:41:06.543201+00 | | 2024-12-22 01:42:19.812187+00 |
| public | w_latest_presence | 17535 | 6943 | 0.00 | 28.00 | | 2024-12-22 01:45:19.96553+00 | | 2024-12-22 01:45:20.07165+00 |
| public | w_latest_sensor | 113 | 28 | 0.00 | 19.00 | | 2024-12-22 01:44:19.543085+00 | | 2024-12-22 01:45:19.783127+00 |
| public | w_lock | 1115 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:50.060558+00 | | |
| public | w_master_update | 18 | 25 | 1.00 | 58.00 | | 2024-12-21 00:10:05.228924+00 | | 2024-12-20 23:33:14.458296+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2024-12-21 10:19:49.109325+00 | | |
| public | w_plan_with_detail | 4693355 | 321876 | 0.00 | 6.00 | | 2024-12-13 06:31:31.791387+00 | | 2024-12-21 06:09:58.242126+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-12-16 20:56:58.424241+00 | | |