| 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 |
|---|
| e202401 | a_proximity_sum | 27157170 | 0 | 0.00 | 0.00 | | 2024-03-12 00:15:58.288452+00 | | 2024-01-30 15:14:06.375164+00 |
| e202401 | a_stay_time | 17079645 | 0 | 0.00 | 0.00 | | 2024-03-14 01:39:34.831416+00 | | 2024-03-14 01:41:57.399547+00 |
| e202401 | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-16 02:06:31.154823+00 | | |
| e202401 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-16 02:06:31.183207+00 | | |
| e202401 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-16 02:06:31.171882+00 | | |
| e202401 | t_position_history | 340031838 | 0 | 0.00 | 0.00 | | 2024-03-12 10:12:24.102119+00 | | 2024-01-30 10:26:24.358574+00 |
| e202401 | t_presence_history | 36917534 | 2013998 | 0.00 | 5.00 | | 2024-03-08 02:40:11.871787+00 | | 2024-01-31 15:07:30.056064+00 |
| e202401 | t_sensor_history | 14217424 | 0 | 0.00 | 0.00 | | 2024-03-09 23:16:05.613212+00 | | 2024-01-30 12:58:27.389928+00 |
| e202402 | a_proximity_sum | 30539386 | 0 | 0.00 | 0.00 | | 2024-03-12 01:20:19.663884+00 | | 2024-02-28 18:03:25.795511+00 |
| e202402 | a_stay_time | 17180766 | 45194 | 0.00 | 0.00 | | 2024-03-12 01:17:24.713538+00 | | 2024-02-28 16:55:43.897188+00 |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-05 22:11:27.640288+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-05 22:11:27.651287+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-05 22:11:25.900213+00 | | |
| e202402 | t_position_history | 354662795 | 0 | 0.00 | 0.00 | | 2024-03-13 06:17:36.738143+00 | | 2024-02-28 06:24:03.251416+00 |
| e202402 | t_presence_history | 37734109 | 2039246 | 0.00 | 5.00 | | 2024-03-07 00:37:34.814248+00 | | 2024-03-11 14:49:28.789296+00 |
| e202402 | t_sensor_history | 15047940 | 0 | 0.00 | 0.00 | | 2024-03-12 03:59:58.647487+00 | | 2024-02-28 11:55:22.157867+00 |
| e202403 | a_proximity_sum | 21106394 | 0 | 0.00 | 0.00 | | 2024-03-14 18:01:47.185242+00 | | 2024-03-17 16:21:23.250794+00 |
| e202403 | a_stay_time | 10815971 | 0 | 0.00 | 0.00 | | 2024-03-14 15:11:03.552867+00 | | 2024-03-15 16:02:30.055992+00 |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-11 04:26:21.448646+00 | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-11 04:26:21.459732+00 | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-11 04:26:21.437256+00 | | |
| e202403 | t_position_history | 226832884 | 156 | 0.00 | 0.00 | | 2024-03-16 15:29:30.206104+00 | | 2024-03-17 02:00:42.60465+00 |
| e202403 | t_presence_history | 22752702 | 4267689 | 0.00 | 15.00 | | 2024-03-18 10:21:04.805442+00 | | 2024-03-18 11:28:18.549653+00 |
| e202403 | t_sensor_history | 9802690 | 0 | 0.00 | 0.00 | | 2024-03-16 06:45:45.483337+00 | | 2024-03-17 03:59:05.93847+00 |
| public | __digdag_status | 60 | 27 | 0.00 | 31.00 | | 2024-03-18 03:43:04.175916+00 | | 2024-03-18 03:43:04.176549+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-11 08:13:47.915546+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-03-11 08:13:47.903863+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:22.168522+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:33.285588+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:18.012776+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:33.426251+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:33.575014+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:18.055946+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:17.706633+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:30.388655+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:18.078423+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-03-17 23:58:18.104636+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-11 08:13:48.372409+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-11 08:13:48.360796+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-11 08:13:48.3493+00 | | |
| public | m_area | 621 | 19 | 0.00 | 2.00 | | 2024-03-14 03:21:00.70595+00 | | 2024-03-08 02:07:46.986266+00 |
| public | m_auth | 111 | 3 | 0.00 | 2.00 | | 2024-03-11 08:13:47.942368+00 | | 2024-02-28 05:53:49.738173+00 |
| public | m_category | 1564 | 0 | 0.00 | 0.00 | | 2024-03-14 03:21:00.803336+00 | | |
| public | m_exb | 18081 | 3052 | 0.00 | 14.00 | | 2024-03-09 04:31:35.458182+00 | | 2024-03-13 08:18:08.975174+00 |
| public | m_favorite | 149809 | 3211 | 0.00 | 2.00 | | 2024-03-12 03:24:56.196298+00 | | 2024-02-26 11:15:18.008043+00 |
| public | m_feature | 153 | 0 | 0.00 | 0.00 | | 2024-03-12 02:19:58.209396+00 | | |
| public | m_group | 13353 | 2 | 0.00 | 0.00 | | 2024-03-18 07:59:59.036778+00 | | 2024-03-13 06:29:07.782652+00 |
| public | m_holiday | 16588 | 0 | 0.00 | 0.00 | | 2024-03-11 05:22:13.674817+00 | | 2024-03-13 04:25:59.969397+00 |
| public | m_lob | 15727 | 2325 | 0.00 | 12.00 | | 2024-03-08 06:25:36.586524+00 | | 2024-03-13 08:59:39.977714+00 |
| public | m_location | 32429 | 2506 | 0.00 | 7.00 | | 2024-03-12 08:32:44.032165+00 | | 2024-03-14 07:34:32.414511+00 |
| public | m_notify_template | 716 | 16 | 0.00 | 2.00 | | 2024-03-11 08:13:48.04324+00 | | 2024-03-13 07:21:28.594642+00 |
| public | m_outside | 277 | 0 | 0.00 | 0.00 | | 2024-03-06 03:41:21.658342+00 | | |
| public | m_pot | 182951 | 9081 | 0.00 | 4.00 | | 2024-03-18 03:42:58.763382+00 | | 2024-03-18 05:31:12.827909+00 |
| public | m_pot_profile | 32207 | 117 | 0.00 | 0.00 | | 2024-03-12 03:01:54.037137+00 | | 2024-02-21 06:28:02.787527+00 |
| public | m_provider_user | 65 | 0 | 0.00 | 0.00 | | 2024-03-12 05:44:28.375723+00 | | 2024-03-11 04:55:18.470933+00 |
| public | m_region | 98 | 1 | 0.00 | 1.00 | | 2024-03-11 08:13:48.153032+00 | | |
| public | m_role | 518 | 10 | 0.00 | 1.00 | | 2024-03-11 08:13:48.127285+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-03-11 08:13:47.962687+00 | | |
| public | m_setting | 20273 | 778 | 0.00 | 3.00 | | 2024-03-18 10:13:03.036617+00 | | 2024-03-18 09:33:45.480554+00 |
| public | m_setting_log | 49040 | 0 | 0.00 | 0.00 | 2024-02-16 03:34:50.060418+00 | 2024-03-18 03:38:06.969837+00 | | 2024-03-18 05:50:57.369888+00 |
| public | m_site | 168 | 2 | 0.00 | 1.00 | | 2024-03-11 08:13:47.995052+00 | | |
| public | m_tenant | 97 | 0 | 0.00 | 0.00 | | 2024-03-11 08:13:48.301885+00 | | |
| public | m_tx | 81169 | 12970 | 0.00 | 13.00 | | 2024-03-18 03:42:49.198114+00 | | 2024-03-18 09:03:36.508724+00 |
| public | m_user | 28893 | 81 | 0.00 | 0.00 | | 2024-03-14 03:21:00.64057+00 | | 2024-02-21 08:40:30.943311+00 |
| public | m_zone | 5574 | 378 | 0.00 | 6.00 | | 2024-03-12 14:52:29.01301+00 | | 2024-03-12 01:31:52.816955+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-03-11 08:13:47.868521+00 | | |
| public | r_auth_zone | 212 | 3 | 0.00 | 1.00 | | 2024-03-09 06:15:25.025851+00 | | 2024-03-07 02:43:16.034776+00 |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-03-11 08:13:48.06694+00 | | |
| public | r_group_auth | 440 | 0 | 0.00 | 0.00 | | 2024-03-11 11:57:46.281112+00 | | |
| public | r_location_zone | 30912 | 2691 | 0.00 | 8.00 | | 2024-03-12 01:25:25.174198+00 | | 2024-03-12 01:31:52.71052+00 |
| public | r_pot_auth | 718 | 15 | 0.00 | 2.00 | | 2024-03-05 09:10:13.710061+00 | | 2024-02-26 06:33:33.188922+00 |
| public | r_pot_category | 6350 | 0 | 0.00 | 0.00 | | 2024-03-18 11:28:14.654239+00 | | 2024-03-18 11:28:14.670967+00 |
| public | r_pot_group | 91840 | 6535 | 0.00 | 6.00 | | 2024-03-18 09:11:25.268615+00 | | 2024-03-18 11:28:14.562662+00 |
| public | r_pot_tx | 45077 | 3030 | 0.00 | 6.00 | | 2024-03-08 17:37:08.367528+00 | | 2024-03-14 07:08:47.394561+00 |
| public | r_pot_user | 18681 | 0 | 0.00 | 0.00 | | 2024-03-18 07:59:58.589614+00 | | 2024-02-21 08:40:30.997445+00 |
| public | r_provider_tenant | 2655 | 0 | 0.00 | 0.00 | | 2024-03-11 06:21:59.694628+00 | | 2024-03-11 04:55:18.456461+00 |
| public | r_role_feature | 5200 | 0 | 0.00 | 0.00 | | 2024-03-18 07:59:58.683711+00 | | 2024-01-18 08:22:54.488926+00 |
| public | r_tenant_feature | 3397 | 0 | 0.00 | 0.00 | | 2024-03-15 22:04:10.814964+00 | | |
| public | r_tx_sensor | 455 | 0 | 0.00 | 0.00 | | 2024-03-05 17:38:47.09676+00 | | 2024-01-27 01:38:23.792244+00 |
| public | r_user_region | 19222 | 0 | 0.00 | 0.00 | | 2024-03-18 07:59:58.252187+00 | | 2024-02-21 08:40:30.42447+00 |
| public | r_user_site | 5257 | 66 | 0.00 | 1.00 | | 2024-03-11 07:20:43.397337+00 | | 2024-01-11 06:16:33.979684+00 |
| public | r_zone_category | 2677 | 310 | 0.00 | 10.00 | | 2024-03-06 17:31:53.164394+00 | | 2024-03-12 01:20:24.64704+00 |
| public | t_attendance | 790583 | 19558 | 0.00 | 2.00 | | 2024-03-15 22:04:36.450789+00 | | 2024-03-15 14:48:00.547674+00 |
| public | t_general | 1509 | 10 | 0.00 | 0.00 | | 2024-03-11 08:13:48.280938+00 | | 2024-03-01 01:35:10.979803+00 |
| public | t_mobile_device_history | 410812 | 0 | 0.00 | 0.00 | | 2024-03-13 16:17:25.885227+00 | | 2024-03-13 04:08:59.7831+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-03-11 08:13:48.087762+00 | | |
| public | t_notify_history | 2010692 | 34930 | 0.00 | 1.00 | | 2024-03-12 08:33:03.348168+00 | | 2024-03-13 03:59:59.802987+00 |
| public | t_operation_log | 7911654 | 321666 | 0.00 | 3.00 | | 2024-03-06 23:21:57.646403+00 | | 2024-03-17 19:43:32.241009+00 |
| public | t_plan | 9409780 | 178380 | 0.00 | 1.00 | | 2024-03-18 06:46:48.368999+00 | | 2024-03-18 00:46:26.053576+00 |
| public | t_plan_detail | 14747638 | 1091250 | 0.00 | 6.00 | | 2024-03-18 03:41:48.678871+00 | | 2024-03-18 05:31:10.772334+00 |
| public | t_plan_sync | 44900 | 8263 | 0.00 | 15.00 | | 2024-03-18 09:42:37.54518+00 | | 2024-03-18 09:40:37.954364+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-03-11 08:13:48.325807+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-03-11 08:13:47.880279+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-03-11 08:13:48.164625+00 | | |
| public | t_recv_position_history | 107075 | 458444 | 4.00 | 81.00 | | 2024-03-18 11:24:49.772258+00 | 2024-03-17 12:51:15.775621+00 | 2024-03-18 11:24:57.79094+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-03-11 08:13:47.892173+00 | | |
| public | t_terminal | 30780 | 3978 | 0.00 | 11.00 | | 2024-03-18 03:45:04.457318+00 | | 2024-03-18 09:01:45.848999+00 |
| public | t_terminal_log | 5436469 | 0 | 0.00 | 0.00 | | 2024-03-06 08:40:51.801674+00 | | 2024-03-01 09:43:44.604781+00 |
| public | w_arrival_notify | 64 | 11 | 0.00 | 14.00 | | 2024-03-13 00:30:49.331531+00 | | 2024-03-18 11:28:14.688607+00 |
| public | w_latest_position | 38378 | 9686 | 0.00 | 20.00 | | 2024-03-18 11:26:39.1722+00 | | 2024-03-18 11:26:40.122943+00 |
| public | w_latest_presence | 203781 | 68572 | 0.00 | 25.00 | 2024-01-18 12:30:06.016796+00 | 2024-03-18 11:26:06.578828+00 | 2024-01-18 12:30:06.178604+00 | 2024-03-18 11:26:35.022342+00 |
| public | w_latest_sensor | 443 | 370 | 0.00 | 45.00 | | 2024-03-18 11:28:15.087929+00 | | 2024-03-18 11:28:15.772943+00 |
| public | w_lock | 11961 | 0 | 0.00 | 0.00 | | 2024-03-18 03:42:47.55468+00 | | 2024-01-31 02:02:19.791893+00 |
| public | w_master_update | 97 | 66 | 0.00 | 40.00 | | 2024-03-18 06:46:48.385371+00 | | 2024-03-18 06:46:48.392459+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-03-11 08:13:48.398239+00 | | |
| public | w_plan_with_detail | 9354837 | 185730 | 0.00 | 1.00 | | 2024-03-18 06:31:33.395373+00 | | 2024-03-18 00:21:08.527387+00 |