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
e202512	a_proximity_sum	0	0	0	0
e202512	a_stay_time	0	0	0	0
e202512	t_position_history	0	0	0	0
e202512	t_presence_history	0	0	0	0
e202512	t_sensor_history	0	0	0	0
e202601	a_proximity_sum	0	0	0	0
e202601	a_stay_time	0	0	0	0
e202601	t_position_history	525	0	0.00	0.00
e202601	t_presence_history	0	0	0	0
e202601	t_sensor_history	0	0	0	0
e202602	a_proximity_sum	8883186	0	0.00	0.00	2026-02-03 20:15:48.475177+00	2026-02-03 18:05:28.48655+00
e202602	a_stay_time	4826283	0	0.00	0.00	2026-02-03 20:11:36.743284+00	2026-02-03 20:11:37.315806+00
e202602	t_position_history	72007360	0	0.00	0.00	2026-02-03 23:51:04.92489+00
e202602	t_presence_history	5550915	756054	0.00	11.00	2026-02-04 00:27:07.288237+00	2026-02-04 00:29:31.149469+00
e202602	t_sensor_history	1264806	0	0.00	0.00	2026-02-03 20:35:28.234753+00	2026-02-03 18:13:33.323929+00
public	__digdag_status	120	35	0.00	22.00		2026-02-04 00:20:32.601113+00
public	a_attendance_sum	207008	11370	0.00	5.00		2026-02-03 23:49:33.165765+00
public	a_plan_actual	10664	0	0.00	0.00
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	2	0	100.00
public	l_lob	1	1	1.00	50.00
public	l_location	40	40	1.00	50.00
public	l_location_zone	1	2	2.00	66.00
public	l_outside	0	0	0	0
public	l_pot	15	2846	189.00	99.00
public	l_pot_category	3	3	1.00	50.00
public	l_pot_group	23	40	1.00	63.00
public	l_pot_tx	23	74	3.00	76.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	19	2	0.00	9.00
public	l_user	21	0	0.00	0.00
public	l_zone	0	0	0	0
public	l_zone_category	0	0	0	0
public	m_area	0	1	0	100.00
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	32	39	1.00	54.00
public	m_favorite_group	20	22	1.00	52.00
public	m_feature	0	0	0	0
public	m_group	0	1925	0	100.00
public	m_holiday	0	0	0	0
public	m_lob	3	7	2.00	70.00
public	m_lob_log	5	0	0.00	0.00
public	m_location	0	28	0	100.00
public	m_notify_template	0	0	0	0
public	m_outside	0	0	0	0
public	m_personal_setting	132151	11970	0.00	8.00		2026-02-04 00:30:33.195755+00
public	m_pot	8	11368	1421.00	99.00
public	m_pot_profile	0	0	0	0
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	977	0	100.00
public	m_setting_log	977	0	0.00	0.00
public	m_site	0	0	0	0
public	m_tenant	0	0	0	0
public	m_tx	19	5427	285.00	99.00
public	m_user	0	20	0	100.00
public	m_zone	0	5	0	100.00
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	1	0	100.00
public	r_pot_auth	0	0	0	0
public	r_pot_category	3	3	1.00	50.00
public	r_pot_group	0	38	0	100.00
public	r_pot_plan_permission_group	0	0	0	0
public	r_pot_tx	4	74	18.00	94.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	4276	1487	0.00	25.00
public	t_general	2	0	0.00	0.00
public	t_job	0	0	0	0
public	t_mobile_device_history	441	0	0.00	0.00
public	t_mobile_status_history	1227	0	0.00	0.00
public	t_news	0	0	0	0
public	t_notify_history	6495	2111	0.00	24.00
public	t_operation_log	21057	4	0.00	0.00
public	t_plan	20341	571494	28.00	96.00
public	t_plan_cancel_history	803	557	0.00	40.00
public	t_plan_detail	30885	1517948	49.00	98.00
public	t_plan_permission	0	0	0	0
public	t_plan_permission_group	0	0	0	0
public	t_plan_sync	73522	2689	0.00	3.00	2026-02-04 00:18:36.595236+00	2026-02-04 00:29:39.731443+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	157979	25699	0.00	13.00	2026-02-04 00:30:35.357523+00	2026-02-04 00:30:35.90675+00
public	t_safr_event_history	0	0	0	0
public	t_sensor_history	0	0	0	0
public	t_terminal	20824	3783	0.00	15.00	2026-02-03 19:25:59.322823+00	2026-02-04 00:16:36.012258+00
public	t_terminal_log	356303	0	0.00	0.00	2026-02-03 19:11:42.750149+00	2026-02-03 23:23:39.376301+00
public	w_arrival_notify	0	1	0	100.00
public	w_latest_mobile_device	9	114	12.00	92.00
public	w_latest_mobile_status	58671	8243	0.00	12.00		2026-02-04 00:30:32.761444+00
public	w_latest_position	87370	43217	0.00	33.00	2026-02-04 00:30:36.146219+00	2026-02-04 00:30:36.667066+00
public	w_latest_presence	124973	284130	2.00	69.00	2026-02-04 00:30:28.71287+00	2026-02-04 00:30:31.859614+00
public	w_latest_sensor	388	320	0.00	45.00	2026-02-04 00:30:33.205073+00	2026-02-04 00:30:33.249976+00
public	w_lock	1	0	0.00	0.00
public	w_master_update	114	17	0.00	12.00	2026-02-03 14:23:36.490214+00	2026-02-03 23:05:30.913053+00
public	w_migration	0	0	0	0
public	w_plan_sync_retry	0	2	0	100.00
public	w_plan_with_detail	20341	583586	28.00	96.00

back