Dbt core + postgres, EXPLAIN pre hook on models

I have an issue with some models running long, seemingly at random, and I want to monitor this by running EXPLAIN on the compiled sql in a pre hook so if something runs log I can look at what it planned to do and compare it to previous runs.

But I cannot get the compiled sql into the pre hook. Doesn't anyone have any ideas or suggestions?

reddit.com
u/optimisticRamblings — 9 days ago

PlayStation / Nintendo DMA gatekeeper? (EU Law)

To me, game consoles feel quite like phones from an uneducated regulation perspective.

So my question is, at what point will PlayStation and Nintendo be considered gatekeepers under the EU Digital Markets Act?

I don't expect Xbox to fall into that category, as they have announced they intend to support alternative storefronts, but PlayStation and Nintendo are continuing to lock down their ecosystems, and it feels like killing disks might cause PlayStation to cross the line?

Location: European Union and it's member states

Edit 1: looks to me like it would fall short on the users side 45m MAU in the EU seems unlikely, that would put more than a third of PlayStation users in the EU which doesn't seem likely?

reddit.com
u/optimisticRamblings — 24 days ago
▲ 19 r/SteamOS

SteamOS CEC, as a dongle?

SteamOS has done wonders for other distros like bazzite and chimera, I wonder who would be interested in valve's steam machine work on CEC being put into a usb+DisplayPort->HDMI dongle so other systems and distros can make use the good work they've done.

I would be, but just curious to sanity check if that's a me thing or if others would be.

reddit.com
u/optimisticRamblings — 2 months ago

I'm on build 2604.1001.9.0 and in the my library section I can only see installed games, there is no way to browse the library of PC games I have purchased from Xbox. Where has this moved to?

reddit.com
u/optimisticRamblings — 4 months ago