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	251639	0	0.00	0.00
e202312	a_stay_time	873905	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	12328557	0	0.00	0.00
e202312	t_presence_history	2597692	598955345	230.00	99.00
e202312	t_sensor_history	587313	0	0.00	0.00
public	__digdag_status	1	53	53.00	98.00
public	a_proximity_sum	0	0	0	0
public	a_stay_time	0	0	0	0
public	b_attendance_group	10496	4564	0.00	30.00
public	b_attendance_hour	171656	59106	0.00	25.00
public	b_attendance_pot	0	0	0	0
public	b_attendance_pot_hour	0	0	0	0
public	b_check_in	68832	51875	0.00	42.00
public	b_check_in_hour	1141276	644289	0.00	36.00
public	b_proximity_group	1005931	692124	0.00	40.00
public	b_proximity_info	501128	6866	0.00	1.00
public	b_seat_reserve	22615	2400	0.00	9.00
public	b_seat_reserve_hour	407666	50400	0.00	11.00
public	b_usage	21189	6469	0.00	23.00
public	b_usage_hour	396664	99228	0.00	20.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	0	0	0	0
public	m_auth	0	0	0	0
public	m_category	0	0	0	0
public	m_exb	3	108	36.00	97.00
public	m_favorite	583	95	0.00	14.00
public	m_feature	0	0	0	0
public	m_group	2	0	0.00	0.00
public	m_holiday	0	0	0	0
public	m_lob	6	3	0.00	33.00
public	m_location	2	36	18.00	94.00
public	m_notify_template	0	0	0	0
public	m_outside	0	0	0	0
public	m_pot	55	4989	90.00	98.00
public	m_pot_profile	4	5	1.00	55.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	3139	0	100.00
public	m_setting_log	171	3506	20.00	95.00
public	m_site	0	0	0	0
public	m_tenant	0	0	0	0
public	m_tx	38	12896	339.00	99.00
public	m_user	0	2	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	2	70	35.00	97.00
public	r_pot_auth	0	0	0	0
public	r_pot_category	0	5	0	100.00
public	r_pot_group	7	184120	26302.00	99.00
public	r_pot_tx	1	52	52.00	98.00
public	r_pot_user	0	1	0	100.00
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	1	0	100.00
public	r_user_site	0	1	0	100.00
public	r_zone_category	0	0	0	0
public	t_attendance	7638	14415	1.00	65.00
public	t_general	1	0	0.00	0.00
public	t_mobile_device_history	2644	0	0.00	0.00
public	t_news	0	0	0	0
public	t_notify_history	6870	13003	1.00	65.00
public	t_operation_log	20357	43499	2.00	68.00
public	t_plan	26813	624347	23.00	95.00
public	t_plan_detail	34334	416804	12.00	92.00
public	t_plan_sync	43	34633	805.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	6345	1930596	304.00	99.00		2023-12-17 12:42:01.955809+00
public	t_sensor_history	0	0	0	0
public	t_terminal	592	10449	17.00	94.00
public	t_terminal_log	127275	0	0.00	0.00
public	w_arrival_notify	0	7	0	100.00
public	w_latest_position	33	1947215	59006.00	99.00
public	w_latest_presence	22352	29032112	1298.00	99.00	2023-12-17 12:42:35.877681+00	2023-12-17 12:42:35.925291+00
public	w_latest_sensor	0	27595	0	100.00
public	w_lock	14	0	0.00	0.00
public	w_master_update	0	124	0	100.00
public	w_plan_with_detail	26812	647361	24.00	96.00

back