| 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 |
|---|
| e202408 | a_proximity_sum | 696351 | 0 | 0.00 | 0.00 | | 2024-10-14 05:21:00.716925+00 | | |
| e202408 | a_stay_time | 2193492 | 0 | 0.00 | 0.00 | | 2024-10-15 09:16:45.364693+00 | | |
| e202408 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-12 17:43:46.156661+00 | | |
| e202408 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-12 17:43:46.138978+00 | | |
| e202408 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-12 17:47:02.36364+00 | | |
| e202408 | t_position_history | 27712963 | 0 | 0.00 | 0.00 | | 2024-10-14 15:56:54.940814+00 | | |
| e202408 | t_presence_history | 5120420 | 0 | 0.00 | 0.00 | | 2024-10-13 22:10:38.921063+00 | | |
| e202408 | t_sensor_history | 1196084 | 0 | 0.00 | 0.00 | | 2024-10-16 08:51:59.038352+00 | | |
| e202409 | a_proximity_sum | 881205 | 0 | 0.00 | 0.00 | | 2024-10-15 09:29:48.222306+00 | | |
| e202409 | a_stay_time | 2549908 | 0 | 0.00 | 0.00 | | 2024-10-14 08:27:14.157404+00 | | |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-14 12:21:29.574268+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-14 12:18:28.790611+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-14 12:18:28.773266+00 | | |
| e202409 | t_position_history | 30787965 | 0 | 0.00 | 0.00 | | 2024-10-19 11:39:42.131949+00 | | |
| e202409 | t_presence_history | 6027295 | 0 | 0.00 | 0.00 | | 2024-10-15 01:46:16.408331+00 | | |
| e202409 | t_sensor_history | 1163444 | 0 | 0.00 | 0.00 | | 2024-10-14 03:21:08.114005+00 | | |
| e202410 | a_proximity_sum | 610105 | 0 | 0.00 | 0.00 | | 2024-10-18 15:30:35.350073+00 | | 2024-10-17 17:25:36.967647+00 |
| e202410 | a_stay_time | 1872195 | 0 | 0.00 | 0.00 | | 2024-10-18 15:30:44.462934+00 | | 2024-10-18 17:01:30.438207+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-15 00:30:52.602042+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-15 00:30:52.569237+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-15 00:30:52.580656+00 | | |
| e202410 | t_position_history | 22305563 | 0 | 0.00 | 0.00 | | 2024-10-17 13:53:38.939956+00 | | 2024-10-18 03:32:27.507695+00 |
| e202410 | t_presence_history | 3894220 | 524631 | 0.00 | 11.00 | | 2024-10-20 01:30:45.220272+00 | | 2024-10-20 01:42:03.449346+00 |
| e202410 | t_sensor_history | 814431 | 0 | 0.00 | 0.00 | | 2024-10-17 14:41:16.614034+00 | | 2024-10-19 16:57:18.75598+00 |
| public | __digdag_status | 6 | 38 | 6.00 | 86.00 | | 2024-10-16 12:30:56.22921+00 | | 2024-10-18 12:30:46.257301+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2024-10-11 01:42:22.156194+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-18 11:41:47.427459+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-10-18 11:34:58.913253+00 | | |
| public | b_attendance_group | 472403 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:46.702357+00 | | |
| public | b_attendance_hour | 7066974 | 0 | 0.00 | 0.00 | | 2024-10-18 20:50:59.585913+00 | | |
| public | b_attendance_pot | 242597 | 0 | 0.00 | 0.00 | | 2024-10-16 00:32:11.092097+00 | | 2024-10-15 18:36:01.888064+00 |
| public | b_attendance_pot_hour | 3755873 | 0 | 0.00 | 0.00 | | 2024-10-15 08:05:56.634411+00 | | 2024-10-16 16:50:43.992377+00 |
| public | b_check_in | 3826535 | 0 | 0.00 | 0.00 | | 2024-10-18 22:56:20.634781+00 | | |
| public | b_check_in_hour | 57368280 | 0 | 0.00 | 0.00 | | 2024-10-18 20:55:57.32376+00 | | |
| public | b_check_in_pot | 137079 | 0 | 0.00 | 0.00 | | 2024-10-16 04:56:38.279612+00 | | |
| public | b_check_in_pot_hour | 2613618 | 0 | 0.00 | 0.00 | | 2024-10-15 10:11:48.621699+00 | | 2024-10-19 18:26:52.270677+00 |
| public | b_proximity_group | 32913534 | 0 | 0.00 | 0.00 | | 2024-10-18 22:37:42.211505+00 | | |
| public | b_proximity_info | 28860310 | 0 | 0.00 | 0.00 | | 2024-10-16 04:54:37.573088+00 | | |
| public | b_seat_reserve | 860297 | 0 | 0.00 | 0.00 | | 2024-10-18 22:01:00.123058+00 | | |
| public | b_seat_reserve_hour | 16143360 | 0 | 0.00 | 0.00 | | 2024-10-18 11:34:23.671424+00 | | |
| public | b_usage | 965112 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.830698+00 | | |
| public | b_usage_hour | 17656099 | 0 | 0.00 | 0.00 | | 2024-10-18 20:22:02.756621+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-18 11:48:46.403754+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-18 11:48:46.38682+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-18 11:48:46.369373+00 | | |
| public | m_area | 93 | 0 | 0.00 | 0.00 | | 2024-10-18 23:05:02.700026+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-10-18 21:08:34.886653+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.946068+00 | | |
| public | m_exb | 4389 | 0 | 0.00 | 0.00 | | 2024-10-18 02:53:25.570053+00 | | |
| public | m_favorite | 33625 | 58 | 0.00 | 0.00 | | 2024-10-17 17:47:36.438331+00 | | 2024-10-08 09:37:31.834203+00 |
| public | m_favorite_group | 7192 | 17 | 0.00 | 0.00 | | 2024-10-08 09:38:33.212195+00 | | 2024-10-14 22:44:14.507633+00 |
| public | m_feature | 164 | 0 | 0.00 | 0.00 | | 2024-10-18 23:11:08.207042+00 | | |
| public | m_group | 2319 | 0 | 0.00 | 0.00 | | 2024-10-18 00:41:01.832322+00 | | |
| public | m_holiday | 5606 | 0 | 0.00 | 0.00 | | 2024-10-18 11:48:46.422316+00 | | |
| public | m_lob | 1171 | 1 | 0.00 | 0.00 | | 2024-10-18 00:41:04.288799+00 | | |
| public | m_location | 5434 | 0 | 0.00 | 0.00 | | 2024-10-18 00:41:02.036053+00 | | |
| public | m_notify_template | 124 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.871604+00 | | |
| public | m_outside | 63 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.444876+00 | | |
| public | m_pot | 26001 | 3397 | 0.00 | 11.00 | | 2024-10-19 13:10:08.52064+00 | | 2024-10-20 00:10:05.011516+00 |
| public | m_pot_profile | 675 | 0 | 0.00 | 0.00 | | 2024-10-18 20:31:03.714661+00 | | |
| public | m_provider_user | 59 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.396612+00 | | |
| public | m_region | 17 | 0 | 0.00 | 0.00 | | 2024-10-18 23:04:02.678976+00 | | |
| public | m_role | 79 | 0 | 0.00 | 0.00 | | 2024-10-18 23:05:02.685343+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-10-18 22:56:19.520896+00 | | |
| public | m_setting | 2270 | 312 | 0.00 | 12.00 | | 2024-10-18 14:32:22.279255+00 | | 2024-10-19 18:28:48.49682+00 |
| public | m_setting_log | 4713 | 862 | 0.00 | 15.00 | | 2024-10-15 12:31:57.197536+00 | | 2024-10-19 07:29:57.312451+00 |
| public | m_site | 26 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.847214+00 | | |
| public | m_tenant | 17 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.361075+00 | | |
| public | m_tx | 26274 | 0 | 0.00 | 0.00 | | 2024-10-17 11:06:09.4209+00 | | 2024-10-17 11:05:09.379783+00 |
| public | m_user | 3268 | 0 | 0.00 | 0.00 | | 2024-10-19 07:50:39.929351+00 | | |
| public | m_zone | 751 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.96724+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-10-18 22:01:44.657563+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-10-18 22:56:19.500945+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.893544+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-10-18 22:00:59.796889+00 | | |
| public | r_location_zone | 5490 | 74 | 0.00 | 1.00 | | 2024-10-13 18:26:24.084228+00 | | |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-10-18 21:08:34.912746+00 | | |
| public | r_pot_category | 988 | 0 | 0.00 | 0.00 | | 2024-10-18 21:07:34.865057+00 | | |
| public | r_pot_group | 12150 | 798 | 0.00 | 6.00 | | 2024-10-19 23:12:28.8848+00 | | 2024-10-19 23:35:29.881681+00 |
| public | r_pot_tx | 8134 | 25 | 0.00 | 0.00 | | 2024-10-12 12:51:10.996826+00 | | |
| public | r_pot_user | 3023 | 0 | 0.00 | 0.00 | | 2024-10-19 07:50:39.868916+00 | | |
| public | r_provider_tenant | 161 | 0 | 0.00 | 0.00 | | 2024-10-15 23:59:10.404471+00 | | |
| public | r_role_feature | 598 | 0 | 0.00 | 0.00 | | 2024-10-17 23:25:28.069746+00 | | |
| public | r_tenant_feature | 645 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.377025+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.926178+00 | | |
| public | r_user_region | 3081 | 0 | 0.00 | 0.00 | | 2024-10-19 07:50:39.889441+00 | | |
| public | r_user_site | 356 | 0 | 0.00 | 0.00 | | 2024-10-16 04:41:44.813899+00 | | |
| public | r_zone_category | 684 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.416062+00 | | |
| public | t_ai_history | 28 | 0 | 0.00 | 0.00 | | 2024-10-10 09:13:18.412496+00 | | |
| public | t_attendance | 545175 | 2 | 0.00 | 0.00 | | 2024-10-18 23:06:07.866429+00 | | |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2024-10-18 23:04:02.662027+00 | | |
| public | t_mobile_device_history | 94929 | 0 | 0.00 | 0.00 | | 2024-10-18 12:41:05.542495+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-10-18 11:41:47.904546+00 | | |
| public | t_notify_history | 504123 | 16 | 0.00 | 0.00 | | 2024-10-18 23:04:05.006716+00 | | |
| public | t_operation_log | 2353075 | 1 | 0.00 | 0.00 | | 2024-10-18 12:10:43.282728+00 | | |
| public | t_plan | 3915843 | 40033 | 0.00 | 1.00 | | 2024-10-18 04:08:36.548625+00 | | 2024-10-16 06:41:24.282386+00 |
| public | t_plan_detail | 4674380 | 183114 | 0.00 | 3.00 | | 2024-10-11 11:59:29.337827+00 | | 2024-10-17 06:37:49.191105+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-10-11 00:25:59.901208+00 | | |
| public | t_plan_sync | 226986 | 31447 | 0.00 | 12.00 | | 2024-10-15 21:06:01.510556+00 | | 2024-10-19 21:34:10.219573+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-10-18 11:41:47.344337+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-10-18 20:21:37.941096+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-10-18 21:07:34.832323+00 | | |
| public | t_recv_position_history | 5254 | 5314 | 1.00 | 50.00 | | 2024-10-20 01:43:03.691285+00 | 2024-10-19 12:42:01.080027+00 | 2024-10-20 01:43:03.719446+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-10-18 20:27:03.518657+00 | | |
| public | t_terminal | 22090 | 1414 | 0.00 | 6.00 | | 2024-10-13 18:31:15.698992+00 | | 2024-10-19 20:22:16.099837+00 |
| public | t_terminal_log | 4839702 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:52.917379+00 | | |
| public | w_arrival_notify | 1 | 0 | 0.00 | 0.00 | | 2024-10-18 11:49:46.395962+00 | | |
| public | w_latest_position | 10657 | 1741 | 0.00 | 14.00 | | 2024-10-19 17:01:17.262852+00 | | 2024-10-20 01:43:03.101092+00 |
| public | w_latest_presence | 17108 | 52843 | 3.00 | 75.00 | | 2024-10-20 01:43:03.824771+00 | | 2024-10-20 01:43:03.928395+00 |
| public | w_latest_sensor | 113 | 135 | 1.00 | 54.00 | | 2024-10-20 01:41:02.815243+00 | | 2024-10-20 01:43:03.056751+00 |
| public | w_lock | 1023 | 0 | 0.00 | 0.00 | | 2024-10-18 11:41:47.022601+00 | | |
| public | w_master_update | 17 | 53 | 3.00 | 75.00 | | 2024-10-18 00:10:16.779966+00 | | 2024-10-19 12:13:27.696067+00 |
| public | w_plan_with_detail | 3911444 | 66532 | 0.00 | 1.00 | | 2024-10-17 21:35:24.210588+00 | | 2024-10-16 06:42:23.758129+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-10-11 00:12:03.97027+00 | | |