08 Database Table side check

back

schema	table	live_tupple	dead_tupple	ratio_of_dead_to_each_live	percent_of_dead	last_autovacuum_at	last_autoanalyze_at
e202501	a_proximity_sum	0	0	0	0
e202501	a_stay_time	0	0	0	0
e202501	t_position_history	0	0	0	0
e202501	t_presence_history	0	0	0	0
e202501	t_sensor_history	0	0	0	0
e202502	a_proximity_sum	0	0	0	0
e202502	a_stay_time	0	0	0	0
e202502	t_position_history	0	0	0	0
e202502	t_presence_history	0	0	0	0
e202502	t_sensor_history	0	0	0	0
e202503	a_proximity_sum	0	0	0	0
e202503	a_stay_time	0	0	0	0
e202503	t_position_history	381949	0	0.00	0.00
e202503	t_presence_history	2945464	435522	0.00	12.00	2025-03-21 01:29:53.411436+00	2025-03-21 01:39:04.078417+00
e202503	t_sensor_history	9290	0	0.00	0.00
public	__digdag_status	0	6	0	100.00
public	a_attendance_sum	0	0	0	0
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	b_attendance_group	5	0	0.00	0.00
public	b_attendance_hour	75	0	0.00	0.00
public	b_attendance_pot	19	0	0.00	0.00
public	b_attendance_pot_hour	285	0	0.00	0.00
public	b_check_in	20	0	0.00	0.00
public	b_check_in_hour	300	0	0.00	0.00
public	b_check_in_pot	95	0	0.00	0.00
public	b_check_in_pot_hour	1425	0	0.00	0.00
public	b_proximity_group	0	0	0	0
public	b_proximity_info	0	0	0	0
public	b_seat_reserve	0	0	0	0
public	b_seat_reserve_hour	0	0	0	0
public	b_usage	4	0	0.00	0.00
public	b_usage_hour	60	0	0.00	0.00
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	4	3	0.00	42.00
public	m_favorite_group	0	0	0	0
public	m_feature	0	0	0	0
public	m_group	0	0	0	0
public	m_holiday	0	0	0	0
public	m_lob	1	0	0.00	0.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_pot	31077	1338	0.00	4.00	2025-03-21 00:11:22.899567+00	2025-03-21 00:10:23.128071+00
public	m_pot_profile	2	8	4.00	80.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	38	0	100.00
public	m_setting_log	38	0	0.00	0.00
public	m_site	0	0	0	0
public	m_tenant	0	0	0	0
public	m_tx	1	0	0.00	0.00
public	m_user	0	0	0	0
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	0	0	0	0
public	r_pot_group	12336	1413	0.00	10.00	2025-03-20 21:05:23.658849+00	2025-03-20 23:32:31.414689+00
public	r_pot_tx	1	20	20.00	95.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	456	107	0.00	19.00
public	t_general	0	0	0	0
public	t_mobile_device_history	50	0	0.00	0.00
public	t_news	0	0	0	0
public	t_notify_history	523	168	0.00	24.00
public	t_operation_log	2279	1	0.00	0.00
public	t_plan	3685	15975	4.00	81.00
public	t_plan_cancel_history	36	0	0.00	0.00
public	t_plan_detail	3181	7195	2.00	69.00
public	t_plan_new	0	0	0	0
public	t_plan_sync	3	1694	564.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	13417	3591	0.00	21.00	2025-03-21 01:45:02.478459+00	2025-03-21 01:45:02.538649+00
public	t_sensor_history	0	0	0	0
public	t_terminal	2	18	9.00	90.00
public	t_terminal_log	1986	0	0.00	0.00
public	w_arrival_notify	0	0	0	0
public	w_latest_position	12799	1378	0.00	9.00	2025-03-21 01:45:02.357917+00	2025-03-21 01:45:02.386621+00
public	w_latest_presence	17963	18216	1.00	50.00	2025-03-21 01:45:02.623972+00	2025-03-21 01:45:02.731131+00
public	w_latest_sensor	113	26	0.00	18.00	2025-03-21 01:45:00.108154+00	2025-03-21 01:45:02.335432+00
public	w_lock	0	0	0	0
public	w_master_update	0	30	0	100.00
public	w_plan_sync_retry	0	0	0	0
public	w_plan_with_detail	3685	17637	4.00	82.00
public	w_plan_with_detail_new	0	0	0	0

back