| 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 |
|---|
| e202402 | a_proximity_sum | 612115 | 0 | 0.00 | 0.00 | | 2024-04-10 02:22:38.747119+00 | | 2024-02-29 17:01:50.42159+00 |
| e202402 | a_stay_time | 2085809 | 0 | 0.00 | 0.00 | | 2024-04-10 02:22:16.88606+00 | | 2024-02-29 15:30:46.695619+00 |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-12 12:43:26.620619+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-12 13:38:20.979022+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-12 12:43:26.631601+00 | | |
| e202402 | t_position_history | 29296004 | 0 | 0.00 | 0.00 | | 2024-04-11 11:37:26.135284+00 | | 2024-02-29 05:55:59.50972+00 |
| e202402 | t_presence_history | 5905692 | 0 | 0.00 | 0.00 | | 2024-04-05 02:50:13.634297+00 | | 2024-02-29 14:49:45.707015+00 |
| e202402 | t_sensor_history | 1364721 | 0 | 0.00 | 0.00 | | 2024-04-08 23:18:33.43692+00 | | 2024-02-28 15:02:44.476238+00 |
| e202403 | a_proximity_sum | 676617 | 0 | 0.00 | 0.00 | | 2024-04-05 01:40:45.378978+00 | | 2024-03-27 17:01:22.117269+00 |
| e202403 | a_stay_time | 2220260 | 0 | 0.00 | 0.00 | | 2024-04-05 04:38:58.752177+00 | | 2024-03-29 15:31:24.472534+00 |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-30 17:38:40.793565+00 | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-30 17:38:41.112177+00 | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-30 15:10:57.213202+00 | | |
| e202403 | t_position_history | 31271630 | 0 | 0.00 | 0.00 | | 2024-04-09 23:14:09.622446+00 | | 2024-03-28 10:35:22.309871+00 |
| e202403 | t_presence_history | 9346840 | 0 | 0.00 | 0.00 | | 2024-04-13 20:35:05.032265+00 | | 2024-03-31 14:59:07.156357+00 |
| e202403 | t_sensor_history | 1265025 | 0 | 0.00 | 0.00 | | 2024-04-08 02:22:29.188957+00 | | 2024-03-30 15:27:03.173399+00 |
| e202404 | a_proximity_sum | 1896314 | 0 | 0.00 | 0.00 | | 2024-04-12 15:32:43.21658+00 | | 2024-04-12 15:32:45.443586+00 |
| e202404 | a_stay_time | 1335163 | 0 | 0.00 | 0.00 | | 2024-04-11 15:30:53.029055+00 | | 2024-04-12 15:31:31.917893+00 |
| e202404 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-12 12:43:26.642717+00 | | |
| e202404 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-30 17:38:40.826283+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-30 17:38:40.804465+00 | | |
| e202404 | t_position_history | 21482464 | 0 | 0.00 | 0.00 | | 2024-04-12 08:41:08.180505+00 | | 2024-04-12 10:56:28.418661+00 |
| e202404 | t_presence_history | 3176835 | 709167 | 0.00 | 18.00 | | 2024-04-14 01:27:16.637086+00 | | 2024-04-14 01:41:44.034885+00 |
| e202404 | t_sensor_history | 508662 | 0 | 0.00 | 0.00 | | 2024-04-14 01:14:44.219727+00 | | 2024-04-12 22:09:48.474268+00 |
| public | __digdag_status | 6 | 48 | 8.00 | 88.00 | | 2024-04-09 12:30:25.800793+00 | | 2024-04-14 00:10:23.044703+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-12 12:37:09.485796+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-04-12 12:37:09.45808+00 | | |
| public | b_attendance_group | 389398 | 1508 | 0.00 | 0.00 | | 2024-04-12 12:37:08.261436+00 | | 2024-03-25 18:45:31.372345+00 |
| public | b_attendance_hour | 5825559 | 11698 | 0.00 | 0.00 | | 2024-04-12 23:33:13.926078+00 | | 2024-04-10 17:45:32.721124+00 |
| public | b_attendance_pot | 6492 | 0 | 0.00 | 0.00 | | 2024-04-10 22:21:09.090039+00 | | 2024-04-08 16:51:00.522107+00 |
| public | b_attendance_pot_hour | 97830 | 0 | 0.00 | 0.00 | | 2024-04-07 16:50:51.211551+00 | | 2024-04-11 16:50:46.454729+00 |
| public | b_check_in | 3147787 | 7350 | 0.00 | 0.00 | | 2024-04-13 01:13:02.337221+00 | | 2024-04-12 17:43:09.406078+00 |
| public | b_check_in_hour | 47167634 | 107646 | 0.00 | 0.00 | | 2024-04-12 23:34:52.695126+00 | | 2024-04-11 18:32:22.016507+00 |
| public | b_check_in_pot | 4404 | 0 | 0.00 | 0.00 | | 2024-03-30 16:50:51.933608+00 | | 2024-04-10 16:50:34.572617+00 |
| public | b_check_in_pot_hour | 66094 | 0 | 0.00 | 0.00 | | 2024-04-09 16:51:03.847264+00 | | 2024-04-10 16:50:35.610919+00 |
| public | b_proximity_group | 42218753 | 99334 | 0.00 | 0.00 | | 2024-04-13 00:34:43.372759+00 | | 2024-04-13 00:34:49.786797+00 |
| public | b_proximity_info | 28740687 | 7056 | 0.00 | 0.00 | | 2024-04-12 23:32:55.040992+00 | | 2024-04-04 16:06:37.916983+00 |
| public | b_seat_reserve | 685997 | 1510 | 0.00 | 0.00 | | 2024-04-13 00:11:22.224944+00 | | 2024-04-11 17:37:14.566172+00 |
| public | b_seat_reserve_hour | 12632815 | 55002 | 0.00 | 0.00 | | 2024-04-12 12:37:05.344144+00 | | 2024-04-08 17:39:56.568386+00 |
| public | b_usage | 741609 | 3020 | 0.00 | 0.00 | | 2024-04-12 12:37:12.509326+00 | | 2024-04-09 17:34:29.538469+00 |
| public | b_usage_hour | 13503405 | 27594 | 0.00 | 0.00 | | 2024-04-12 23:30:34.165624+00 | | 2024-04-07 17:36:21.744729+00 |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-12 12:41:10.720639+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-12 12:41:10.709597+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-12 12:41:10.698594+00 | | |
| public | m_area | 97 | 0 | 0.00 | 0.00 | | 2024-04-13 01:20:55.10611+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-04-12 23:33:13.947029+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:13.478455+00 | | 2024-03-26 01:55:07.081821+00 |
| public | m_exb | 3790 | 0 | 0.00 | 0.00 | | 2024-04-13 01:20:55.214251+00 | | 2024-03-14 06:53:02.642813+00 |
| public | m_favorite | 34870 | 0 | 0.00 | 0.00 | | 2024-04-12 23:35:53.470286+00 | | 2024-04-02 07:41:52.488072+00 |
| public | m_feature | 155 | 0 | 0.00 | 0.00 | | 2024-04-13 01:21:04.950628+00 | | |
| public | m_group | 2442 | 99 | 0.00 | 3.00 | | 2024-04-07 06:50:08.326332+00 | | 2024-04-02 15:01:37.307282+00 |
| public | m_holiday | 5865 | 0 | 0.00 | 0.00 | | 2024-04-12 12:41:10.79183+00 | | 2024-04-05 08:45:08.676261+00 |
| public | m_lob | 2273 | 0 | 0.00 | 0.00 | | 2024-04-12 23:40:10.102259+00 | | 2024-03-31 15:01:05.267697+00 |
| public | m_location | 5353 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:09.647849+00 | | 2024-03-12 07:19:05.758866+00 |
| public | m_notify_template | 119 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:13.241948+00 | | |
| public | m_outside | 57 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:09.742148+00 | | |
| public | m_pot | 23545 | 3488 | 0.00 | 12.00 | | 2024-04-13 13:10:55.598654+00 | | 2024-04-14 00:10:23.029581+00 |
| public | m_pot_profile | 658 | 0 | 0.00 | 0.00 | | 2024-04-12 23:32:57.143354+00 | | 2024-03-20 09:37:46.4079+00 |
| public | m_provider_user | 58 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:09.44644+00 | | 2024-03-26 10:29:29.496795+00 |
| public | m_region | 15 | 0 | 0.00 | 0.00 | | 2024-04-13 01:21:01.157851+00 | | |
| public | m_role | 76 | 0 | 0.00 | 0.00 | | 2024-04-13 01:21:01.120141+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-04-13 01:12:54.79758+00 | | |
| public | m_setting | 2119 | 312 | 0.00 | 12.00 | | 2024-04-12 20:17:26.089583+00 | | 2024-04-13 13:50:35.438864+00 |
| public | m_setting_log | 4245 | 760 | 0.00 | 15.00 | | 2024-04-10 12:30:37.493769+00 | | 2024-04-13 12:31:01.29634+00 |
| public | m_site | 22 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:13.222976+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:09.402405+00 | | |
| public | m_tx | 27204 | 1646 | 0.00 | 5.00 | | 2024-04-02 12:25:35.506192+00 | | 2024-03-26 08:33:16.815049+00 |
| public | m_user | 959 | 0 | 0.00 | 0.00 | | 2024-04-12 12:41:10.756635+00 | | 2024-04-12 12:43:26.997086+00 |
| public | m_zone | 685 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:13.526822+00 | | 2024-03-14 07:28:09.871777+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-04-13 00:11:22.372561+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-04-13 01:12:54.777658+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:13.319827+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-04-13 00:11:19.604863+00 | | |
| public | r_location_zone | 4015 | 0 | 0.00 | 0.00 | | 2024-04-12 10:42:25.413011+00 | | 2024-03-14 07:28:09.84704+00 |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-04-12 23:33:13.975702+00 | | |
| public | r_pot_category | 969 | 0 | 0.00 | 0.00 | | 2024-04-12 23:40:10.167142+00 | | 2024-03-21 05:48:39.460847+00 |
| public | r_pot_group | 9941 | 1059 | 0.00 | 9.00 | | 2024-04-13 23:13:04.215282+00 | | 2024-04-13 23:33:18.233449+00 |
| public | r_pot_tx | 8099 | 1 | 0.00 | 0.00 | | 2024-04-12 12:37:13.433468+00 | | 2024-04-04 02:15:02.032134+00 |
| public | r_pot_user | 686 | 0 | 0.00 | 0.00 | | 2024-04-12 23:31:00.78444+00 | | 2024-03-26 08:36:16.538006+00 |
| public | r_provider_tenant | 189 | 0 | 0.00 | 0.00 | | 2024-04-10 03:31:44.899162+00 | | 2024-04-09 04:52:52.521831+00 |
| public | r_role_feature | 721 | 0 | 0.00 | 0.00 | | 2024-04-13 01:21:01.102175+00 | | |
| public | r_tenant_feature | 536 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:09.422594+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:13.452129+00 | | |
| public | r_user_region | 834 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:13.269069+00 | | 2024-03-13 04:48:24.616591+00 |
| public | r_user_site | 422 | 0 | 0.00 | 0.00 | | 2024-04-12 23:33:14.006204+00 | | 2024-02-21 05:42:24.614277+00 |
| public | r_zone_category | 638 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:09.474506+00 | | 2024-03-14 07:28:09.823024+00 |
| public | t_ai_history | 0 | 0 | 0 | 0 | | | | |
| public | t_attendance | 358216 | 641 | 0.00 | 0.00 | | 2024-04-13 01:21:01.085619+00 | | 2024-04-08 06:45:25.425494+00 |
| public | t_general | 29 | 0 | 0.00 | 0.00 | | 2024-04-13 01:21:01.14175+00 | | |
| public | t_mobile_device_history | 71512 | 0 | 0.00 | 0.00 | | 2024-04-12 13:38:20.967099+00 | | 2024-03-27 13:27:04.092288+00 |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-04-12 12:37:13.331809+00 | | |
| public | t_notify_history | 422140 | 740 | 0.00 | 0.00 | | 2024-04-13 01:21:04.93242+00 | | 2024-04-10 09:13:13.538491+00 |
| public | t_operation_log | 2030692 | 7643 | 0.00 | 0.00 | | 2024-04-12 13:21:12.291889+00 | | 2024-03-25 07:18:00.010513+00 |
| public | t_plan | 4248877 | 12408 | 0.00 | 0.00 | | 2024-04-12 23:38:09.112117+00 | | 2024-04-11 18:33:20.718045+00 |
| public | t_plan_detail | 5399599 | 12293 | 0.00 | 0.00 | | 2024-04-13 01:21:50.380062+00 | | 2024-04-12 12:19:19.914092+00 |
| public | t_plan_sync | 16361 | 1230 | 0.00 | 6.00 | | 2024-04-13 23:33:14.87371+00 | | 2024-04-14 00:51:35.424783+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-04-12 12:37:09.386802+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-04-12 23:30:00.762495+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-04-12 23:40:10.120962+00 | | |
| public | t_recv_position_history | 5568 | 10051 | 1.00 | 64.00 | | 2024-04-14 01:41:44.129122+00 | 2024-04-13 12:42:00.647198+00 | 2024-04-14 01:41:44.154175+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-04-12 23:31:00.824479+00 | | |
| public | t_terminal | 13123 | 1983 | 0.00 | 13.00 | | 2024-04-02 10:30:33.979128+00 | | 2024-04-13 22:55:04.168058+00 |
| public | t_terminal_log | 3533156 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:21.969117+00 | | 2024-03-27 07:38:48.597545+00 |
| public | w_arrival_notify | 1 | 0 | 0.00 | 0.00 | | 2024-04-12 12:43:27.015418+00 | | 2024-03-18 00:19:34.961652+00 |
| public | w_latest_position | 10658 | 411 | 0.00 | 3.00 | | 2024-04-14 01:44:46.955813+00 | | 2024-04-14 01:44:46.990367+00 |
| public | w_latest_presence | 17044 | 142591 | 8.00 | 89.00 | 2024-01-18 12:42:01.037741+00 | 2024-04-14 01:41:44.333854+00 | 2024-01-18 12:42:01.07062+00 | 2024-04-14 01:41:44.619324+00 |
| public | w_latest_sensor | 113 | 21 | 0.00 | 15.00 | | 2024-04-14 01:44:46.685012+00 | | 2024-04-14 01:44:46.924087+00 |
| public | w_lock | 987 | 0 | 0.00 | 0.00 | | 2024-04-12 12:37:08.821855+00 | | |
| public | w_master_update | 15 | 13 | 0.00 | 46.00 | | 2024-04-13 13:10:56.543615+00 | | 2024-04-13 23:33:18.246842+00 |
| public | w_plan_with_detail | 3032769 | 26557 | 0.00 | 0.00 | | 2024-04-12 13:23:33.49257+00 | | 2024-04-13 18:48:37.003426+00 |