| 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 | 1445230 | 0 | 0.00 | 0.00 | | 2024-12-12 02:23:46.4559+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 | 35494913 | 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 | 1047403 | 0 | 0.00 | 0.00 | | 2024-12-16 17:28:45.394479+00 | | 2024-12-18 15:34:48.643772+00 |
| e202412 | a_stay_time | 3207995 | 0 | 0.00 | 0.00 | | 2024-12-18 16:35:55.320746+00 | | 2024-12-18 17:00:50.817138+00 |
| e202412 | t_position_history | 23517170 | 0 | 0.00 | 0.00 | | 2024-12-18 01:31:45.66341+00 | | 2024-12-18 04:45:30.208738+00 |
| e202412 | t_presence_history | 3970294 | 318137 | 0.00 | 7.00 | | 2024-12-19 01:37:36.51424+00 | | 2024-12-19 01:40:51.827852+00 |
| e202412 | t_sensor_history | 761081 | 0 | 0.00 | 0.00 | | 2024-12-16 00:51:25.850165+00 | | 2024-12-18 23:36:40.641932+00 |
| public | __digdag_status | 12 | 18 | 1.00 | 60.00 | | 2024-12-17 13:10:11.730786+00 | | 2024-12-17 00:10:51.870173+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 | 562010 | 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 | 8769605 | 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 | 413007 | 0 | 0.00 | 0.00 | | 2024-12-11 03:32:02.493719+00 | | 2024-12-17 18:36:08.862871+00 |
| public | b_attendance_pot_hour | 6415755 | 0 | 0.00 | 0.00 | | 2024-12-10 03:35:30.094213+00 | | 2024-12-12 18:20:48.299836+00 |
| public | b_check_in | 4420367 | 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 | 67317328 | 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 | 198112 | 0 | 0.00 | 0.00 | | 2024-12-11 21:06:42.107509+00 | | 2024-12-14 18:26:36.74616+00 |
| public | b_check_in_pot_hour | 3894839 | 0 | 0.00 | 0.00 | | 2024-12-10 15:07:48.238361+00 | | 2024-12-04 18:27:03.789272+00 |
| public | b_proximity_group | 36397213 | 0 | 0.00 | 0.00 | | 2024-12-15 00:23:42.715452+00 | | 2024-11-19 03:27:58.773826+00 |
| public | b_proximity_info | 34034235 | 0 | 0.00 | 0.00 | | 2024-12-11 20:42:13.516142+00 | | 2024-11-27 17:51:03.911928+00 |
| public | b_seat_reserve | 1012715 | 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 | 19183466 | 0 | 0.00 | 0.00 | | 2024-12-14 12:51:48.954448+00 | | 2024-11-24 17:48:14.117716+00 |
| public | b_usage | 1128804 | 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 | 20894357 | 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 | 3836 | 0 | 0.00 | 0.00 | | 2024-12-10 02:31:11.706095+00 | | 2024-11-20 14:17:58.996858+00 |
| public | m_favorite | 36804 | 185 | 0.00 | 0.00 | | 2024-12-13 05:54:09.172901+00 | | 2024-12-03 06:11:37.005424+00 |
| public | m_favorite_group | 8231 | 8 | 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 | 3 | 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 | 26449 | 1995 | 0.00 | 7.00 | | 2024-12-19 00:10:42.890153+00 | | 2024-12-19 01:36:51.93996+00 |
| public | m_pot_profile | 695 | 11 | 0.00 | 1.00 | | 2024-12-14 23:23:45.104404+00 | | 2024-12-06 07:16:56.300649+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 | 402 | 0.00 | 14.00 | | 2024-12-17 05:16:48.147981+00 | | 2024-12-17 22:11:53.78045+00 |
| public | m_setting_log | 5050 | 220 | 0.00 | 4.00 | | 2024-12-17 12:30:39.101148+00 | | 2024-12-18 12:30:09.194219+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 | 30668 | 4 | 0.00 | 0.00 | | 2024-12-11 06:00:42.182138+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 | 992 | 1 | 0.00 | 0.00 | | 2024-12-14 23:32:00.168292+00 | | |
| public | r_pot_group | 12042 | 788 | 0.00 | 6.00 | | 2024-12-18 23:12:32.918227+00 | | 2024-12-18 23:33:42.749638+00 |
| public | r_pot_tx | 10284 | 4 | 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-11 05:31:08.954385+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 | 1 | 0.00 | 0.00 | | 2024-12-11 20:50:14.215108+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 | 424190 | 4784 | 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 | 120000 | 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 | 575427 | 3750 | 0.00 | 0.00 | | 2024-12-15 00:51:48.596696+00 | | 2024-11-29 06:02:48.833417+00 |
| public | t_operation_log | 2270455 | 2 | 0.00 | 0.00 | | 2024-12-14 13:32:41.3255+00 | | 2024-11-25 02:59:20.632326+00 |
| public | t_plan | 4668100 | 208225 | 0.00 | 4.00 | | 2024-12-13 17:10:07.643767+00 | | 2024-12-17 02:02:00.409493+00 |
| public | t_plan_detail | 5771634 | 154014 | 0.00 | 2.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 | 233567 | 27726 | 0.00 | 10.00 | | 2024-12-11 04:15:09.033985+00 | | 2024-12-18 23:11:33.94809+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 | 6441 | 2927 | 0.00 | 31.00 | | 2024-12-19 01:44:59.413845+00 | 2024-12-18 12:42:01.021053+00 | 2024-12-19 01:44:59.443019+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-12-14 23:13:17.389328+00 | | |
| public | t_terminal | 38672 | 430 | 0.00 | 1.00 | | 2024-12-18 19:54:06.876178+00 | | 2024-12-18 15:35:49.181155+00 |
| public | t_terminal_log | 5346849 | 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 | 2 | 3 | 1.00 | 60.00 | | 2024-12-14 13:10:39.326698+00 | | 2024-11-19 00:27:39.742116+00 |
| public | w_latest_position | 10806 | 1717 | 0.00 | 13.00 | | 2024-12-19 01:44:59.327043+00 | | 2024-12-19 01:44:59.352792+00 |
| public | w_latest_presence | 17513 | 14694 | 0.00 | 45.00 | | 2024-12-19 01:44:59.557016+00 | | 2024-12-19 01:44:59.661635+00 |
| public | w_latest_sensor | 113 | 85 | 0.00 | 42.00 | | 2024-12-19 01:42:59.054872+00 | | 2024-12-19 01:44:59.302064+00 |
| public | w_lock | 1115 | 0 | 0.00 | 0.00 | | 2024-12-14 13:08:50.060558+00 | | |
| public | w_master_update | 18 | 45 | 2.00 | 71.00 | | 2024-12-17 23:10:47.727356+00 | | 2024-12-17 23:12:55.407267+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2024-12-11 20:40:40.071661+00 | | |
| public | w_plan_with_detail | 4658044 | 236343 | 0.00 | 4.00 | | 2024-12-13 06:31:31.791387+00 | | 2024-12-17 01:43:41.012919+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-12-16 20:56:58.424241+00 | | |