Nik Cubrilovic

this is what is remaining unmapped from facility_scada, with their total generation to date alongside (ie. 0) ``` [2023-09-12 16:01:06,433] opennem.monitors.facility_seen INFO] Unmapped: NEM ASNSEL2 0.0 [2023-09-12 16:01:06,433] opennem.monitors.facility_seen INFO]...

One way to do it. Here is all of our `solar_utility` for `SA1` - which one are we missing? I'm going to assumed this is a _mismapped_ DUID

fixed in: https://github.com/opennem/opennem/commit/c8623a0e9e1399c5c634b0514d6dcc0d99de5522 where we were filtering DUID's and it was filtering out new units in certain conditions. facs added in: https://github.com/opennem/opennem/commit/92e0950cc1d76c26246a907c13c71e00372dab82 prod should be up-to-date in ~15 minutes.

APPIN I don't think has ever had stats The other two are taking < 500ms for me atm - but I'll hook up pingdom to these endpoints and plot them

* profile where it is slow * create `at_facility_monthly` for monthly aggregates

`at_facility_daily` isn't a timescale managed hypertable, i'm making it one on dev: https://docs.timescale.com/use-timescale/latest/hypertables/about-hypertables/ made a separate branch-build to test performance

related #196

1 hour lump this morning of *horrible* performance and 100% cpu - investigating now

facility query is in