| 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 | 17024188 | 112503 | 0.00 | 0.00 | | 2024-02-28 20:41:40.501489+00 | | 2024-01-30 15:11:06.159905+00 |
| e202401 | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-01 23:04:55.951387+00 | | |
| e202401 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-01 23:04:55.973445+00 | | |
| e202401 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-01 23:04:55.962272+00 | | |
| e202401 | t_position_history | 340031295 | 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 | 354662695 | 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 | 15153418 | 0 | 0.00 | 0.00 | | 2024-03-12 16:20:12.387048+00 | | 2024-03-12 18:10:10.134563+00 |
| e202403 | a_stay_time | 7945012 | 14 | 0.00 | 0.00 | | 2024-03-12 15:11:58.908069+00 | | 2024-03-12 15:46:21.700766+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 | 167638512 | 0 | 0.00 | 0.00 | | 2024-03-11 11:57:19.323285+00 | | 2024-03-12 14:42:09.869656+00 |
| e202403 | t_presence_history | 22920771 | 2637958 | 0.00 | 10.00 | | 2024-03-13 09:09:58.165376+00 | | 2024-03-13 08:56:38.330564+00 |
| e202403 | t_sensor_history | 6963665 | 0 | 0.00 | 0.00 | | 2024-03-13 07:00:56.086439+00 | | 2024-03-12 23:12:14.781184+00 |
| public | __digdag_status | 2013 | 22 | 0.00 | 1.00 | | 2024-03-13 06:54:34.550436+00 | | 2024-03-13 06:18:59.90538+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-03 23:18:23.436231+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.903483+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.348161+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.925687+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.946567+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.369638+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.325325+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.457736+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.391651+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-03-03 23:18:23.413472+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 | 636 | 35 | 0.00 | 5.00 | | 2024-02-29 01:09:35.939618+00 | | 2024-03-08 02:07:46.986266+00 |
| public | m_auth | 109 | 0 | 0.00 | 0.00 | | 2024-03-11 08:13:47.942368+00 | | 2024-02-28 05:53:49.738173+00 |
| public | m_category | 1562 | 66 | 0.00 | 4.00 | | 2024-02-29 01:09:35.965439+00 | | |
| public | m_exb | 18031 | 2681 | 0.00 | 12.00 | | 2024-03-09 04:31:35.458182+00 | | 2024-03-13 08:18:08.975174+00 |
| public | m_favorite | 149296 | 2789 | 0.00 | 1.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 | 13331 | 1092 | 0.00 | 7.00 | | 2024-03-04 07:38:48.46419+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 | 15735 | 2286 | 0.00 | 12.00 | | 2024-03-08 06:25:36.586524+00 | | 2024-03-13 08:59:39.977714+00 |
| public | m_location | 33487 | 1086 | 0.00 | 3.00 | | 2024-03-12 08:32:44.032165+00 | | 2024-03-07 02:42:16.987907+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 | 185976 | 19864 | 0.00 | 9.00 | | 2024-03-13 00:19:32.939193+00 | | 2024-03-13 07:51:11.556806+00 |
| public | m_pot_profile | 32044 | 104 | 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 | 18827 | 2756 | 0.00 | 12.00 | | 2024-03-13 06:27:07.570269+00 | | 2024-03-13 06:18:59.853471+00 |
| public | m_setting_log | 51496 | 0 | 0.00 | 0.00 | 2024-02-16 03:34:50.060418+00 | 2024-03-13 05:10:36.089454+00 | | 2024-03-13 05:30:31.053122+00 |
| public | m_site | 169 | 1 | 0.00 | 0.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 | 80881 | 16096 | 0.00 | 16.00 | | 2024-03-09 06:02:27.542363+00 | | 2024-03-13 08:15:08.994084+00 |
| public | m_user | 28832 | 399 | 0.00 | 1.00 | | 2024-02-29 00:09:48.624224+00 | | 2024-02-21 08:40:30.943311+00 |
| public | m_zone | 5571 | 368 | 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 | 210 | 0 | 0.00 | 0.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 | 439 | 0 | 0.00 | 0.00 | | 2024-03-11 11:57:46.281112+00 | | |
| public | r_location_zone | 30918 | 1918 | 0.00 | 5.00 | | 2024-03-12 01:25:25.174198+00 | | 2024-03-12 01:31:52.71052+00 |
| public | r_pot_auth | 716 | 4 | 0.00 | 0.00 | | 2024-03-05 09:10:13.710061+00 | | 2024-02-26 06:33:33.188922+00 |
| public | r_pot_category | 6351 | 0 | 0.00 | 0.00 | | 2024-03-13 06:54:34.510313+00 | | 2024-03-13 06:18:59.885029+00 |
| public | r_pot_group | 150651 | 22593 | 0.00 | 13.00 | | 2024-03-13 09:11:22.476941+00 | | 2024-03-13 09:10:22.571972+00 |
| public | r_pot_tx | 44864 | 2530 | 0.00 | 5.00 | | 2024-03-08 17:37:08.367528+00 | | 2024-03-06 00:25:53.987522+00 |
| public | r_pot_user | 18673 | 125 | 0.00 | 0.00 | | 2024-03-04 09:01:28.357524+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 | 5201 | 221 | 0.00 | 4.00 | | 2024-03-04 07:38:48.277997+00 | | 2024-01-18 08:22:54.488926+00 |
| public | r_tenant_feature | 3397 | 33 | 0.00 | 0.00 | | 2024-03-01 17:41:37.744445+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 | 19218 | 171 | 0.00 | 0.00 | | 2024-03-04 09:01:28.19864+00 | | 2024-02-21 08:40:30.42447+00 |
| public | r_user_site | 5272 | 42 | 0.00 | 0.00 | | 2024-03-11 07:20:43.397337+00 | | 2024-01-11 06:16:33.979684+00 |
| public | r_zone_category | 2676 | 310 | 0.00 | 10.00 | | 2024-03-06 17:31:53.164394+00 | | 2024-03-12 01:20:24.64704+00 |
| public | t_attendance | 780084 | 57035 | 0.00 | 6.00 | | 2024-03-01 17:41:58.40272+00 | | 2024-03-07 10:34:43.966962+00 |
| public | t_general | 1483 | 0 | 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 | 405445 | 15313 | 0.00 | 3.00 | | 2024-02-28 10:30:42.956582+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 | 1990497 | 7720 | 0.00 | 0.00 | | 2024-03-12 08:33:03.348168+00 | | 2024-03-13 03:59:59.802987+00 |
| public | t_operation_log | 7743525 | 258056 | 0.00 | 3.00 | | 2024-03-06 23:21:57.646403+00 | | 2024-03-05 00:50:28.509838+00 |
| public | t_plan | 9310221 | 1288307 | 0.00 | 12.00 | | 2024-03-11 05:04:20.845855+00 | | 2024-03-13 06:18:59.736712+00 |
| public | t_plan_detail | 14515942 | 278895 | 0.00 | 1.00 | | 2024-03-13 07:45:09.294471+00 | | 2024-03-13 03:13:50.47915+00 |
| public | t_plan_sync | 30272 | 6436 | 0.00 | 17.00 | | 2024-03-13 09:16:31.735527+00 | | 2024-03-13 09:06:41.036626+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 | 108850 | 1741876 | 16.00 | 94.00 | | 2024-03-13 09:16:33.395745+00 | 2024-03-12 12:30:27.282273+00 | 2024-03-13 09:16:33.945519+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-03-11 08:13:47.892173+00 | | |
| public | t_terminal | 29489 | 1969 | 0.00 | 6.00 | | 2024-03-13 08:15:10.691164+00 | | 2024-03-13 08:44:21.564314+00 |
| public | t_terminal_log | 5310503 | 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 | 63 | 3 | 0.00 | 4.00 | | 2024-03-13 00:30:49.331531+00 | | 2024-03-05 23:34:33.525821+00 |
| public | w_latest_position | 44560 | 469412 | 10.00 | 91.00 | | 2024-03-13 09:16:32.080458+00 | | 2024-03-13 09:16:32.485272+00 |
| public | w_latest_presence | 187121 | 2983333 | 15.00 | 94.00 | 2024-01-18 12:30:06.016796+00 | 2024-03-13 09:16:34.838149+00 | 2024-01-18 12:30:06.178604+00 | 2024-03-13 09:16:35.256464+00 |
| public | w_latest_sensor | 443 | 11947 | 26.00 | 96.00 | | 2024-03-13 09:16:32.507206+00 | | 2024-03-13 09:16:32.622242+00 |
| public | w_lock | 11938 | 2 | 0.00 | 0.00 | | 2024-03-04 01:15:10.160408+00 | | 2024-01-31 02:02:19.791893+00 |
| public | w_master_update | 350 | 52 | 0.00 | 12.00 | | 2024-03-13 07:02:16.811603+00 | | 2024-03-13 06:36:28.532115+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-03-11 08:13:48.398239+00 | | |
| public | w_plan_with_detail | 9357054 | 1626638 | 0.00 | 14.00 | | 2024-03-10 09:22:59.617779+00 | | 2024-03-13 06:23:17.609992+00 |