Tidy up queries in dashboard

[krzysztofrewak]

I was playing with local Toby and I noticed that (at least for my example) dashboard generates almost 100 database queries.

Query
96 queries, 54 of which are duplicated. 	Duration
64.21ms

I believe some of these could be replaces with proper eager loading or other forms of optimization:

select * from "profiles" where "profiles"."user_id" in (1) 	0.35ms 	
select * from "profiles" where "profiles"."user_id" in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15... 	0.75ms 	
select * from "profiles" where "profiles"."user_id" in (1, 2, 4, 5, 6, 7, 8, 9, 10) 	0.37ms 	
select * from "profiles" where "profiles"."user_id" in (10) 	0.24ms 	
select * from "profiles" where "profiles"."user_id" in (10) 	0.76ms 	
select * from "profiles" where "profiles"."user_id" in (3) 	0.28ms 	
select * from "profiles" where "profiles"."user_id" in (3) 	0.36ms 	
select * from "profiles" where "profiles"."user_id" in (3, 4, 8) 	0.43ms 	
select * from "profiles" where "profiles"."user_id" in (4) 	0.25ms 	
select * from "profiles" where "profiles"."user_id" in (4) 	0.36ms 	
select * from "profiles" where "profiles"."user_id" in (8) 	0.24ms 	
select * from "profiles" where "profiles"."user_id" in (8) 	0.24ms 	
select * from "profiles" where "profiles"."user_id" in (8) 	0.24ms 	
select * from "profiles" where "profiles"."user_id" in (8) 	0.25ms 	
select * from "profiles" where "profiles"."user_id" in (8) 	0.25ms 	
select * from "profiles" where "profiles"."user_id" in (8) 	0.26ms 	
select * from "profiles" where "profiles"."user_id" in (8) 	0.28ms 	
select * from "profiles" where "profiles"."user_id" in (8) 	0.38ms 	
select * from "profiles" where "profiles"."user_id" in (8) 	0.38ms 	
select * from "profiles" where "profiles"."user_id" in (8) 	0.41ms 	

select * from "users" where "users"."id" = 10 limit 1 	0.26ms 	
select * from "users" where "users"."id" = 3 limit 1 	0.37ms 	
select * from "users" where "users"."id" = 3 limit 1 	0.37ms 	
select * from "users" where "users"."id" = 4 limit 1 	0.35ms 	
select * from "users" where "users"."id" = 4 limit 1 	0.41ms 	
select * from "users" where "users"."id" = 8 limit 1 	0.25ms 	
select * from "users" where "users"."id" = 8 limit 1 	0.25ms 	
select * from "users" where "users"."id" = 8 limit 1 	0.26ms 	
select * from "users" where "users"."id" = 8 limit 1 	0.26ms 	
select * from "users" where "users"."id" = 8 limit 1 	0.26ms 	
select * from "users" where "users"."id" = 8 limit 1 	0.27ms 	
select * from "users" where "users"."id" = 8 limit 1 	0.32ms 	
select * from "users" where "users"."id" = 8 limit 1 	0.34ms 	
select * from "users" where "users"."id" = 8 limit 1 	0.38ms 	
select * from "users" where "users"."id" = 8 limit 1 	0.42ms 	

select * from "vacations" where "vacations"."vacation_request_id" = 12 and... 	0.30ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 21 and... 	0.59ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 31 and... 	0.54ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 39 and... 	0.53ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 45 and... 	0.64ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 56 and... 	0.48ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 57 and... 	0.47ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 59 and... 	0.55ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 6 and "vacations"."vacation_request_id"... 	0.66ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 60 and... 	0.53ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 64 and... 	0.31ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 66 and... 	0.39ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 7 and "vacations"."vacation_request_id"... 	0.82ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 75 and... 	0.54ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 79 and... 	0.62ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 83 and... 	0.38ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 90 and... 	0.31ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 91 and... 	0.38ms 	
select * from "vacations" where "vacations"."vacation_request_id" = 96 and... 	0.58ms 	

select * from "year_periods" where "year" = 2024 limit 1 	0.26ms 	
select * from "year_periods" where "year" = 2024 limit 1 	0.35ms 	
select * from "year_periods" where "year" = 2024 limit 1 	0.43ms 	
select * from "year_periods" where "year" = 2024 limit 1 	0.85ms 	

[mtracz]

It might be related to:

• resolve N+1 queries #400