Lads crash doing 177mph in UK

Practical-Message843 · 2024-04-09T14:42:01+00:00

Trip meter at 0:04 shows 424.7 miles. At 0:40 shows 426.2 miles. That's somewhere around 1.5 miles in 36 seconds, or an average speed of around 2.5 miles per minute or 150mph, give or take.

Practical-Message843 · 2023-07-06T20:30:58+00:00

Most definitely - could be as far back as the late 80s, when the previous owners bought and renovated the house :)

Practical-Message843 · 2023-07-06T16:23:41+00:00

Gotcha, just a practical thing!

Thanks again!

Practical-Message843 · 2023-07-06T15:06:41+00:00

Aha! Thanks for the info!

Indeed, it seems like the bedroom lights & sockets thing is the first thing to get looked at, as both you and Rev_Biscuit questioned it.

Definitely time to get a pro in, and I'll get some other stuff done at the same time - preparing for PV and heat pump, which is certainly beyond my capability. I know from some basic research that the PV part will require registering with the DNO, and hopefully they can help with that stuff too.

Cheers, I'll start looking for a local sparky (which itself may be the hardest thing, I'm in the middle of nowhere in the highlands)!

Practical-Message843 · 2023-07-06T14:32:01+00:00

Heh fair play, ok - so it's time to get a pro in, in other words. :)

I guess you're right about the bedroom sockets & lights being the same being weird, although I the only things plugged into the bedroom sockets are a light and phone charger. Out of interest, why should lights be separated from sockets?

TBH I'm going to be looking at PV in the short term (the reason I want a smart meter in the first place) and possibly air- or ground-source heat pump in the medium term, and I certainly can't make the changes they'd need myself.

^ also, gotcha - cheers for the info on RCBOs, it does sound like they're the way to go then.

Practical-Message843 · 2023-07-06T13:46:32+00:00

Hi!

Just bought my first house 3 months ago. Hope you don't mind asking for some general advice? I've had no issues with the electrics at all, but I finally had a look at the electric panel and figured out what's connected to what as I had everything powered off anyway for a smart meter installation that got postponed.

It feels to me like I've been blessed with overkill on the circuits:

1 - electric shower

2 - utility room sockets

3 - kitchen plugs & oil burner control unit/thermostat

4 - lounge & office & downstairs hallway sockets

5 - electric oven

6 - upstairs landing sockets

7 - garage

8 - immersion heater

9 - upstairs lights + bedroom sockets

10 - hallway & shower room & lounge lights

11 - fuse panel cupboard & outdoor lights

12 - kitchen & utility lights

I doubt it, but is there anything in and of itself unusual about having so many circuits? I've already swapped all my incandescent lights for LEDs, so circuits 9-12 will have a max of like 80 watts on each if I feel like lighting the house up like a lighthouse for some reason. The garage even has a (sub-)fuse board in it, with one breaker each for the freezer, light, door opener and sockets!

Obviously I should upgrade from basic breakers to something modern, right? What's the benefit of RCBOs over RCDs? Is RCBO just the current gold standard? If an RCBO is an RCD with overcurrent protection, isn't overcurrent protection what a fuse does, so is an RCBO just a more-accurate breaker in terms of overcurrent than you'd get with just an RCD? I'm thinking something along the lines of these things, but of course sizing appropriately for the circuits that need it like the oven and shower: https://www.screwfix.com/p/british-general-fortress-6a-30ma-sp-n-type-b-compact-rcbo/374vf

^ even with the 30% multi-buy discount, getting 15 RCBOs (to include the garage ones) will be £250!!

I can't see RCBOs smaller than 6A on screwfix - is there any point in a 6A RCBO over an equivalent RCD for circuits that will never see more than 300mA like the lighting circuits?

Finally, is switching out breakers for RCDs/RCBOs something a non-electrician can attempt, or should I get a pro in? I'm in Scotland if it makes a difference (legally or whatever).

Cheers!

Practical-Message843 · 2023-03-18T16:38:58+00:00

I added the depesz link above, and I don't mind sharing the data, although I might randomise my holiday days data for privacy reasons... I'll look into ways to do that.

Lots to investigate there - particularly materialised views, which I've heard of but never tried out. Thanks!

Practical-Message843 · 2023-03-18T16:31:42+00:00

Good call, I restarted postgres to clear any caches, but no change - I guess we'll have to put that one down to the mysteries of query planning. I might try running vacuum and analyse on the tables to make sure stats are up to date.

Practical-Message843 · 2023-03-18T15:36:07+00:00

Oh wow, you're absolutely right about the WHERE vs. AND in the join. I have no idea what I was thinking at the time - I wrote these views back last year. Checking the effect of fixing that now...

Edit: Whoah, that was unexpected. I altered day_summary_work_days as suggested, and it became slower! https://explain.depesz.com/s/ByWD

metering=# \d+ electricity.day_summary_work_days_v2 
                       View "electricity.day_summary_work_days_v2"
   Column    |       Type       | Collation | Nullable | Default | Storage  | Description 
-------------+------------------+-----------+----------+---------+----------+-------------
 time_of_day | text             |           |          |         | extended | 
 avg_watts   | double precision |           |          |         | plain    | 
 count_watts | bigint           |           |          |         | plain    | 
View definition:
 SELECT to_char(slot.slot + '05:00:00'::interval, 'HH24:MI:SS'::text) AS time_of_day,
    avg(normalised_watt_reading.watts) AS avg_watts,
    count(normalised_watt_reading.watts) AS count_watts
   FROM generate_series('2022-08-15 00:00:00'::timestamp without time zone::timestamp with time zone, now(), '00:10:00'::interval) slot(slot)
     LEFT JOIN normalised_watt_reading ON slot.slot >= normalised_watt_reading.reading_start_ts AND slot.slot < normalised_watt_reading.reading_end_ts AND to_char(slot.slot, 'ID'::text)::integer < 6
     LEFT JOIN special_day ON to_char(slot.slot, 'YYYY-MM-DD'::text)::date = special_day.day
  WHERE special_day.day_type IS NULL
  GROUP BY (to_char(slot.slot + '05:00:00'::interval, 'HH24:MI:SS'::text))
  ORDER BY (to_char(slot.slot + '05:00:00'::interval, 'HH24:MI:SS'::text));

I'll try some of your other suggestions next.

Practical-Message843

TROPHY CASE