Study2025/_Infra/scripts/20240226_step3.sql

explain
select * from public.measurment_input_params as t1
inner join public.measurment_baths as t2 on t1.id = t2.measurment_input_param_id
inner join public.employees as t3 on t3.id = t2.emploee_id
where
	t2.emploee_id = 10

	--               ->  Seq Scan on measurment_baths t2  (cost=0.00..472.51 rows=500 width=20)

	create index ix_measurment_baths_emploee_id on measurment_baths(emploee_id)

	--               ->  Index Scan using ix_measurment_baths_emploee_id on measurment_baths t2  (cost=0.29..20.04 rows=500 width=20)