Database Table side check

back

schema	table	live_tupple	dead_tupple	ratio_of_dead_to_each_live	percent_of_dead	last_vacuum_at	last_analyze_at
e202310	a_proximity_sum	0	0	0	0
e202310	a_stay_time	0	0	0	0
e202310	l_position_history	0	0	0	0
e202310	l_proximity_sum	0	0	0	0
e202310	l_stay_time	0	0	0	0
e202310	t_position_history	660	0	0.00	0.00
e202310	t_presence_history	0	0	0	0
e202310	t_sensor_history	0	0	0	0
e202311	a_proximity_sum	0	0	0	0
e202311	a_stay_time	0	0	0	0
e202311	l_position_history	0	0	0	0
e202311	l_proximity_sum	0	0	0	0
e202311	l_stay_time	0	0	0	0
e202311	t_position_history	38	0	0.00	0.00
e202311	t_presence_history	0	0	0	0
e202311	t_sensor_history	0	0	0	0
e202312	a_proximity_sum	412921	0	0.00	0.00
e202312	a_stay_time	1484759	0	0.00	0.00
e202312	l_position_history	0	0	0	0
e202312	l_proximity_sum	0	0	0	0
e202312	l_stay_time	0	0	0	0
e202312	t_position_history	21121104	0	0.00	0.00
e202312	t_presence_history	4390438	1033890720	235.00	99.00
e202312	t_sensor_history	981694	2	0.00	0.00
public	__digdag_status	0	96	0	100.00
public	a_proximity_sum	0	0	0	0
public	a_stay_time	0	0	0	0
public	b_attendance_group	15330	8998	0.00	36.00
public	b_attendance_hour	240692	132142	0.00	35.00
public	b_attendance_pot	0	0	0	0
public	b_attendance_pot_hour	0	0	0	0
public	b_check_in	94658	100329	1.00	51.00
public	b_check_in_hour	1503080	1381501	0.00	47.00
public	b_proximity_group	1431196	1310754	0.00	47.00
public	b_proximity_info	782522	43478	0.00	5.00
public	b_seat_reserve	28445	11970	0.00	29.00
public	b_seat_reserve_hour	488622	251460	0.00	33.00
public	b_usage	26135	18543	0.00	41.00
public	b_usage_hour	468268	332840	0.00	41.00
public	l_position_history	0	0	0	0
public	l_proximity_sum	0	0	0	0
public	l_stay_time	0	0	0	0
public	m_area	1	3	3.00	75.00
public	m_auth	2	0	0.00	0.00
public	m_category	0	0	0	0
public	m_exb	3	647	215.00	99.00
public	m_favorite	907	118	0.00	11.00
public	m_feature	0	0	0	0
public	m_group	2	2	1.00	50.00
public	m_holiday	0	0	0	0
public	m_lob	7	6	0.00	46.00
public	m_location	19	555	29.00	96.00
public	m_notify_template	0	0	0	0
public	m_outside	0	0	0	0
public	m_pot	98	9288	94.00	98.00
public	m_pot_profile	6	0	0.00	0.00
public	m_provider_user	0	0	0	0
public	m_region	0	0	0	0
public	m_role	2	1	0.00	33.00
public	m_sensor	0	0	0	0
public	m_setting	7	5159	737.00	99.00
public	m_setting_log	184	5520	30.00	96.00
public	m_site	0	0	0	0
public	m_tenant	0	0	0	0
public	m_tx	50	343411	6868.00	99.00
public	m_user	9	11	1.00	55.00
public	m_zone	1	2	2.00	66.00
public	r_auth_group	0	0	0	0
public	r_auth_zone	2	0	0.00	0.00
public	r_exb_sensor	0	0	0	0
public	r_group_auth	0	0	0	0
public	r_location_zone	46	940	20.00	95.00
public	r_pot_auth	6	10	1.00	62.00
public	r_pot_category	0	5	0	100.00
public	r_pot_group	3	255315	85105.00	99.00
public	r_pot_tx	24	63	2.00	72.00
public	r_pot_user	7	9	1.00	56.00
public	r_role_feature	1	1	1.00	50.00
public	r_tenant_feature	0	0	0	0
public	r_tx_sensor	0	0	0	0
public	r_user_region	7	10	1.00	58.00
public	r_user_site	4	10	2.00	71.00
public	r_zone_category	0	6	0	100.00
public	t_attendance	11932	25899	2.00	68.00
public	t_general	1	0	0.00	0.00
public	t_mobile_device_history	4363	0	0.00	0.00
public	t_news	0	0	0	0
public	t_notify_history	12631	20145	1.00	61.00
public	t_operation_log	42580	64408	1.00	60.00
public	t_plan	69072	810564	11.00	92.00
public	t_plan_detail	100385	681610	6.00	87.00
public	t_plan_sync	76	36381	478.00	99.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	6152	1814742	294.00	99.00		2023-12-25 12:42:01.977468+00
public	t_sensor_history	0	0	0	0
public	t_terminal	976	22541	23.00	95.00
public	t_terminal_log	209481	0	0.00	0.00
public	w_arrival_notify	0	14	0	100.00
public	w_latest_position	44	4353522	98943.00	99.00
public	w_latest_presence	20185	27719144	1373.00	99.00	2023-12-25 12:42:33.536139+00	2023-12-25 12:42:33.578802+00
public	w_latest_sensor	0	55979	0	100.00
public	w_lock	29	2	0.00	6.00
public	w_master_update	0	202	0	100.00
public	w_plan_with_detail	69071	853868	12.00	92.00

back