08 Database Dead tuples

back

schema	table	live_tupple	dead_tupple	ratio_of_dead_to_each_live	percent_of_dead	last_autovacuum_at	last_autoanalyze_at
e202604	a_proximity_sum	0	0	0	0
e202604	a_stay_time	0	0	0	0
e202604	t_position_history	0	0	0	0
e202604	t_presence_history	0	0	0	0
e202604	t_sensor_history	0	0	0	0
e202605	a_proximity_sum	0	0	0	0
e202605	a_stay_time	0	0	0	0
e202605	t_position_history	0	0	0	0
e202605	t_presence_history	0	0	0	0
e202605	t_sensor_history	0	0	0	0
e202606	a_proximity_sum	0	0	0	0
e202606	a_stay_time	0	0	0	0
e202606	t_position_history	0	0	0	0
e202606	t_presence_history	0	0	0	0
e202606	t_sensor_history	39251	0	0.00	0.00
public	__digdag_status	0	0	0	0
public	a_attendance_sum	248365	8900	0.00	3.00	2026-06-05 00:13:30.154207+00	2026-06-05 00:12:29.495798+00
public	a_plan_actual	0	0	0	0
public	a_proximity_sum	0	0	0	0
public	a_stay_time	0	0	0	0
public	area_history	0	0	0	0
public	del_b_attendance_group	0	0	0	0
public	del_b_attendance_hour	0	0	0	0
public	del_b_check_in	0	0	0	0
public	del_b_check_in_hour	0	0	0	0
public	del_b_proximity_group	0	0	0	0
public	del_b_proximity_info	0	0	0	0
public	del_b_seat_reserve	0	0	0	0
public	del_b_seat_reserve_hour	0	0	0	0
public	del_b_usage	0	0	0	0
public	del_b_usage_hour	0	0	0	0
public	l_area	0	0	0	0
public	l_auth	0	0	0	0
public	l_category	0	0	0	0
public	l_group	0	0	0	0
public	l_lob	0	0	0	0
public	l_location	0	0	0	0
public	l_location_zone	0	0	0	0
public	l_outside	0	0	0	0
public	l_pot	60	44	0.00	42.00
public	l_pot_category	33	0	0.00	0.00
public	l_pot_group	6	23	3.00	79.00
public	l_pot_tx	66	52	0.00	44.00
public	l_role	0	0	0	0
public	l_role_feature	0	0	0	0
public	l_site	0	0	0	0
public	l_tx	33	1	0.00	2.00
public	l_user	7	9	1.00	56.00
public	l_zone	0	0	0	0
public	l_zone_category	0	0	0	0
public	m_area	0	0	0	0
public	m_auth	0	0	0	0
public	m_category	0	0	0	0
public	m_env	0	0	0	0
public	m_exb	0	0	0	0
public	m_favorite	40	36	0.00	47.00
public	m_favorite_group	50	18	0.00	26.00
public	m_feature	0	0	0	0
public	m_group	0	0	0	0
public	m_holiday	0	0	0	0
public	m_lob	0	3	0	100.00
public	m_lob_log	0	0	0	0
public	m_location	0	0	0	0
public	m_notify_template	0	0	0	0
public	m_outside	0	0	0	0
public	m_personal_setting	141088	11728	0.00	7.00	2026-06-04 23:50:29.474189+00	2026-06-04 23:49:29.089776+00
public	m_pot	37	1177	31.00	96.00
public	m_pot_profile	0	4	0	100.00
public	m_provider_user	0	0	0	0
public	m_region	0	0	0	0
public	m_role	0	0	0	0
public	m_sensor	0	0	0	0
public	m_setting	0	411	0	100.00
public	m_setting_log	411	0	0.00	0.00
public	m_site	0	0	0	0
public	m_tenant	0	0	0	0
public	m_tx	33	0	0.00	0.00
public	m_user	0	10	0	100.00
public	m_zone	0	0	0	0
public	r_auth_group	0	0	0	0
public	r_auth_zone	0	0	0	0
public	r_exb_sensor	0	0	0	0
public	r_group_auth	0	0	0	0
public	r_location_zone	0	0	0	0
public	r_pot_auth	0	0	0	0
public	r_pot_category	33	0	0.00	0.00
public	r_pot_group	0	21	0	100.00
public	r_pot_plan_permission_group	0	0	0	0
public	r_pot_tx	18	52	2.00	74.00
public	r_pot_user	0	0	0	0
public	r_provider_tenant	0	0	0	0
public	r_role_feature	0	0	0	0
public	r_tenant_feature	0	0	0	0
public	r_tx_sensor	0	0	0	0
public	r_user_region	0	0	0	0
public	r_user_site	0	0	0	0
public	r_zone_category	0	0	0	0
public	t_ai_history	0	0	0	0
public	t_attendance	4654	241	0.00	4.00
public	t_general	0	1	0	100.00
public	t_job	0	0	0	0
public	t_mobile_device_history	336	0	0.00	0.00
public	t_mobile_status_history	658	0	0.00	0.00
public	t_news	0	0	0	0
public	t_notify_history	4765	2091	0.00	30.00
public	t_operation_log	17295	7	0.00	0.00
public	t_plan	20158	223749	11.00	91.00
public	t_plan_cancel_history	565	2	0.00	0.00
public	t_plan_detail	25713	949530	36.00	97.00
public	t_plan_permission	0	0	0	0
public	t_plan_permission_group	0	0	0	0
public	t_plan_sync	116405	3384	0.00	2.00	2026-06-04 22:59:28.764296+00	2026-06-04 22:57:28.136018+00
public	t_position_history	0	0	0	0
public	t_presence_history	0	0	0	0
public	t_proximity	0	0	0	0
public	t_recv_position_history	0	0	0	0
public	t_safr_event_history	0	0	0	0
public	t_sensor_history	0	0	0	0
public	t_terminal	21700	2908	0.00	11.00	2026-06-04 22:20:28.165264+00	2026-06-05 00:14:30.482454+00
public	t_terminal_log	16258	0	0.00	0.00
public	w_arrival_notify	1	4	4.00	80.00
public	w_latest_mobile_device	19	99	5.00	83.00
public	w_latest_mobile_status	62555	5897	0.00	8.00	2026-06-04 23:52:30.16998+00	2026-06-04 23:51:29.968622+00
public	w_latest_position	0	0	0	0
public	w_latest_presence	0	0	0	0
public	w_latest_sensor	403	3131	7.00	88.00	2026-06-05 00:27:28.619577+00	2026-06-05 00:27:29.02477+00
public	w_lock	106	0	0.00	0.00
public	w_lock_position	0	0	0	0
public	w_master_update	111	13	0.00	10.00	2026-06-05 00:05:28.462518+00	2026-06-05 00:04:28.468209+00
public	w_migration	0	0	0	0
public	w_plan_sync_retry	1	11	11.00	91.00
public	w_plan_with_detail	20152	329105	16.00	94.00

back