SELECT
TO_CHAR(dt, 'Dy DD Mon') as "Period",
load_energy as "Load out",
grid_energy_in as "Grid in",
self_energy as "Self_kWh",
pv_energy as "Solar PV",
load_energy*tariff as "R Load",
grid_energy_in*tariff as "R Grid",
self_energy*tariff as "R Saved",
self_energy/load_energy * 100 as "Ratio",
EXTRACT(epoch FROM grid_time_off)/60 as "Load Shedding",
grid_cycles_off as "LS Events"
FROM solar_assistant_day
LEFT OUTER JOIN city_power_tariff ON date_trunc('month',solar_assistant_day.dt) = city_power_tariff.year_month
WHERE $__timeFilter(dt)
ORDER by dt desc