| 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 |
|---|
| e202310 | a_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202310 | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202310 | l_position_history | 0 | 0 | 0 | 0 | | 2023-12-28 02:59:37.736625+00 | | |
| e202310 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-12-28 03:05:36.576264+00 | | |
| e202310 | l_stay_time | 0 | 0 | 0 | 0 | | 2023-12-28 02:59:37.753905+00 | | |
| e202310 | t_position_history | 660 | 0 | 0.00 | 0.00 | | | | |
| e202310 | t_presence_history | 6554660 | 0 | 0.00 | 0.00 | | 2023-12-28 02:59:37.702951+00 | | |
| e202310 | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| e202311 | a_proximity_sum | 513156 | 0 | 0.00 | 0.00 | | 2023-12-28 09:00:23.718382+00 | | |
| e202311 | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202311 | l_position_history | 0 | 0 | 0 | 0 | | 2023-12-28 03:05:36.594024+00 | | |
| e202311 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-12-28 09:00:18.454263+00 | | |
| e202311 | l_stay_time | 0 | 0 | 0 | 0 | | 2023-12-28 22:00:21.536523+00 | | |
| e202311 | t_position_history | 34857866 | 0 | 0.00 | 0.00 | | 2023-12-28 03:04:42.732733+00 | | |
| e202311 | t_presence_history | 6297160 | 0 | 0.00 | 0.00 | | 2023-12-28 08:59:53.051454+00 | | |
| e202311 | t_sensor_history | 1717517 | 0 | 0.00 | 0.00 | | 2023-12-28 09:00:18.430336+00 | | |
| e202312 | a_proximity_sum | 489700 | 0 | 0.00 | 0.00 | | | | |
| e202312 | a_stay_time | 1774500 | 0 | 0.00 | 0.00 | | | | |
| e202312 | l_position_history | 0 | 0 | 0 | 0 | | | | |
| e202312 | l_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202312 | l_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202312 | t_position_history | 24729456 | 0 | 0.00 | 0.00 | | | | |
| e202312 | t_presence_history | 4948022 | 1184516831 | 239.00 | 99.00 | | | | |
| e202312 | t_sensor_history | 1361086 | 0 | 0.00 | 0.00 | | 2023-12-28 09:00:49.962495+00 | | 2023-12-28 09:00:53.475622+00 |
| public | __digdag_status | 6 | 9 | 1.00 | 60.00 | | 2023-12-28 09:00:55.380635+00 | | 2023-12-28 09:00:55.381092+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2023-12-27 07:59:37.72637+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2023-12-27 07:59:37.529709+00 | | |
| public | b_attendance_group | 344474 | 1047 | 0.00 | 0.00 | | 2023-12-27 07:46:01.382947+00 | | 2023-12-27 07:46:02.46884+00 |
| public | b_attendance_hour | 5333087 | 17383 | 0.00 | 0.00 | | 2023-12-27 08:20:54.837034+00 | | 2023-12-27 08:20:58.601742+00 |
| public | b_attendance_pot | 0 | 0 | 0 | 0 | | 2023-12-27 08:19:38.662951+00 | | |
| public | b_attendance_pot_hour | 0 | 0 | 0 | 0 | | 2023-12-27 08:19:39.130906+00 | | |
| public | b_check_in | 2991442 | 11581 | 0.00 | 0.00 | | 2023-12-27 08:21:38.989671+00 | | 2023-12-27 08:21:42.74261+00 |
| public | b_check_in_hour | 44175573 | 177304 | 0.00 | 0.00 | | 2023-12-27 08:28:00.372718+00 | | 2023-12-27 08:28:04.122918+00 |
| public | b_proximity_group | 41432820 | 136188 | 0.00 | 0.00 | | 2023-12-27 07:59:16.560393+00 | | 2023-12-27 07:59:20.50446+00 |
| public | b_proximity_info | 23341316 | 15298 | 0.00 | 0.00 | | 2023-12-27 07:52:12.370708+00 | | 2023-12-27 07:52:16.165265+00 |
| public | b_seat_reserve | 617182 | 1987 | 0.00 | 0.00 | | 2023-12-27 07:41:45.406293+00 | | 2023-12-27 07:41:47.317287+00 |
| public | b_seat_reserve_hour | 11379888 | 45052 | 0.00 | 0.00 | | 2023-12-27 07:43:34.894664+00 | | 2023-12-27 07:43:38.736142+00 |
| public | b_usage | 658459 | 2613 | 0.00 | 0.00 | | 2023-12-27 08:37:14.591015+00 | | 2023-12-27 08:37:16.645662+00 |
| public | b_usage_hour | 11929850 | 53190 | 0.00 | 0.00 | | 2023-12-27 07:45:51.566389+00 | | 2023-12-27 07:45:55.409413+00 |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2023-12-27 08:44:56.93965+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2023-12-27 08:44:56.919393+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2023-12-27 08:44:56.902131+00 | | |
| public | m_area | 98 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:17.129846+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2023-12-27 08:20:58.62552+00 | | |
| public | m_category | 344 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:17.615687+00 | | |
| public | m_exb | 3730 | 74 | 0.00 | 1.00 | | 2023-12-27 08:37:17.301361+00 | | 2023-12-27 08:37:17.315449+00 |
| public | m_favorite | 32498 | 23 | 0.00 | 0.00 | | 2023-12-27 08:28:21.976206+00 | | |
| public | m_feature | 149 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:57.601239+00 | | |
| public | m_group | 1922 | 0 | 0.00 | 0.00 | | 2023-12-27 08:19:32.885726+00 | | |
| public | m_holiday | 3990 | 0 | 0.00 | 0.00 | | 2023-12-27 08:45:30.27035+00 | | |
| public | m_lob | 2361 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:17.690153+00 | | |
| public | m_location | 5505 | 31 | 0.00 | 0.00 | | 2023-12-27 08:19:35.475868+00 | | 2023-12-27 08:19:35.566764+00 |
| public | m_notify_template | 104 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:16.705302+00 | | |
| public | m_outside | 62 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:06.408+00 | | |
| public | m_pot | 22264 | 16642 | 0.00 | 42.00 | | 2023-12-27 07:59:36.794577+00 | | 2023-12-27 07:59:37.512886+00 |
| public | m_pot_profile | 620 | 0 | 0.00 | 0.00 | | 2023-12-27 08:19:39.096971+00 | | 2023-12-27 08:19:39.104822+00 |
| public | m_provider_user | 16 | 0 | 0.00 | 0.00 | | 2023-12-27 07:59:37.679338+00 | | |
| public | m_region | 15 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:45.795988+00 | | |
| public | m_role | 76 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:45.73667+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2023-12-27 08:21:12.42995+00 | | |
| public | m_setting | 2093 | 435 | 0.00 | 17.00 | | 2023-12-27 08:37:16.983037+00 | | 2023-12-27 08:37:17.002159+00 |
| public | m_setting_log | 4158 | 506 | 0.00 | 10.00 | | 2023-12-27 08:38:00.640634+00 | | 2023-12-27 08:38:01.440615+00 |
| public | m_site | 21 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:16.682461+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2023-12-27 07:59:25.756216+00 | | |
| public | m_tx | 13951 | 36545 | 2.00 | 72.00 | | 2023-12-27 08:19:38.47694+00 | | 2023-12-27 08:19:38.617479+00 |
| public | m_user | 744 | 3 | 0.00 | 0.00 | | 2023-12-27 08:44:56.990449+00 | | |
| public | m_zone | 595 | 0 | 0.00 | 0.00 | | 2023-12-27 08:38:01.498412+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2023-12-27 07:43:38.749284+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2023-12-27 08:20:58.664021+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:16.751678+00 | | |
| public | r_group_auth | 288 | 0 | 0.00 | 0.00 | | 2023-12-27 07:41:33.692632+00 | | |
| public | r_location_zone | 3617 | 159 | 0.00 | 4.00 | | 2023-12-27 08:37:17.088275+00 | | 2023-12-27 08:37:17.099129+00 |
| public | r_pot_auth | 21 | 3 | 0.00 | 12.00 | | 2023-12-27 08:20:58.642506+00 | | |
| public | r_pot_category | 407 | 1 | 0.00 | 0.00 | | 2023-12-27 08:37:45.876577+00 | | |
| public | r_pot_group | 9536 | 27159 | 2.00 | 74.00 | | 2023-12-27 08:21:11.933494+00 | | 2023-12-27 08:21:12.409862+00 |
| public | r_pot_tx | 7386 | 15 | 0.00 | 0.00 | | 2023-12-27 08:37:17.537417+00 | | |
| public | r_pot_user | 453 | 3 | 0.00 | 0.00 | | 2023-12-27 07:45:55.64578+00 | | |
| public | r_role_feature | 734 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:45.708391+00 | | |
| public | r_tenant_feature | 550 | 0 | 0.00 | 0.00 | | 2023-12-27 07:59:25.949143+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:17.569578+00 | | |
| public | r_user_region | 521 | 3 | 0.00 | 0.00 | | 2023-12-27 08:37:16.730946+00 | | |
| public | r_user_site | 302 | 3 | 0.00 | 0.00 | | 2023-12-27 08:20:58.687033+00 | | |
| public | r_zone_category | 563 | 3 | 0.00 | 0.00 | | 2023-12-27 07:59:37.645018+00 | | |
| public | t_attendance | 239484 | 2603 | 0.00 | 1.00 | | 2023-12-27 08:37:45.372854+00 | | 2023-12-27 08:37:45.68306+00 |
| public | t_general | 20 | 0 | 0.00 | 0.00 | | 2023-12-27 08:37:45.757591+00 | | |
| public | t_mobile_device_history | 55924 | 0 | 0.00 | 0.00 | | 2023-12-28 22:00:20.174075+00 | | 2023-12-28 22:00:20.613569+00 |
| public | t_news | 0 | 0 | 0 | 0 | | 2023-12-27 08:37:16.762329+00 | | |
| public | t_notify_history | 297348 | 1975 | 0.00 | 0.00 | | 2023-12-27 08:37:56.933396+00 | | 2023-12-27 08:37:57.573678+00 |
| public | t_operation_log | 1379689 | 3080 | 0.00 | 0.00 | | 2023-12-28 03:05:32.995978+00 | | 2023-12-28 03:05:36.555324+00 |
| public | t_plan | 2436518 | 71882 | 0.00 | 2.00 | | 2023-12-27 08:37:04.630568+00 | | 2023-12-27 08:37:06.33013+00 |
| public | t_plan_detail | 3239690 | 146824 | 0.00 | 4.00 | | 2023-12-27 08:40:11.640308+00 | | 2023-12-27 08:40:12.117622+00 |
| public | t_plan_sync | 15672 | 24333 | 1.00 | 60.00 | | 2023-12-27 07:46:08.194696+00 | | 2023-12-27 07:46:08.459661+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2023-12-27 07:59:25.713596+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2023-12-27 07:43:38.797221+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2023-12-27 08:37:45.817378+00 | | |
| public | t_recv_position_history | 5429 | 594996 | 109.00 | 99.00 | | 2023-12-28 21:28:20.56195+00 | 2023-12-28 12:42:02.976597+00 | 2023-12-28 21:28:20.849268+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2023-12-27 07:46:02.51502+00 | | |
| public | t_terminal | 8040 | 2767 | 0.00 | 25.00 | | 2023-12-27 08:40:40.223476+00 | | 2023-12-27 08:40:42.091163+00 |
| public | t_terminal_log | 2520824 | 0 | 0.00 | 0.00 | | 2023-12-27 08:44:52.679747+00 | | 2023-12-27 08:44:56.880863+00 |
| public | w_arrival_notify | 1 | 0 | 0.00 | 0.00 | | 2023-12-27 08:45:57.861888+00 | | |
| public | w_latest_position | 13202 | 243491 | 18.00 | 94.00 | | 2023-12-27 08:42:40.497715+00 | | 2023-12-27 08:42:41.622542+00 |
| public | w_latest_presence | 20279 | 27987436 | 1380.00 | 99.00 | 2023-12-28 12:42:30.142019+00 | | 2023-12-28 12:42:30.183092+00 | |
| public | w_latest_sensor | 113 | 4605 | 40.00 | 97.00 | | 2023-12-27 08:40:28.964677+00 | | 2023-12-27 08:40:31.02618+00 |
| public | w_lock | 927 | 0 | 0.00 | 0.00 | | 2023-12-27 07:59:24.275038+00 | | |
| public | w_master_update | 15 | 91 | 6.00 | 85.00 | | 2023-12-27 08:37:06.374068+00 | | 2023-12-27 08:37:06.375425+00 |
| public | w_plan_with_detail | 2468984 | 16584 | 0.00 | 0.00 | | 2023-12-28 09:06:07.439695+00 | | 2023-12-28 09:06:09.5976+00 |