slow query!

slow query

with current_config as
(
    select *
    from refractometer_config_history
    where now()::timestamp without time zone <@ effective
)

select rmsh.sump_id, rr.refractometer_reading, current_config.*

from refractometer_readings rr

join refractometer_manifold_selection_history rmsh
on rr.inserted::timestamp without time zone <@ rmsh.effective

cross join current_config

where rr.inserted::timestamp without time zone <@ tsrange(
    lower(rmsh.effective) + current_config.minutes_to_wait,
    upper(rmsh.effective))

and sump_id = 3 

order by inserted desc 

limit 10;