Dba: Optimise a LATERAL JOIN query on a big table

Optimise a LATERAL JOIN query on a big table
I hope you found a solution that worked for you :)
The Content is licensed under (https://meta.stackexchange.com/help/l...) CC BY-SA.
Attention! This video does always use the same license as the source!
Thanks to all those great people for their contributions!

(dba.stackexchange.com/users/97841/maxtrialfire)maxTrialfire
(dba.stackexchange.com/users/3684/erwin-brandstetter)Erwin Brandstetter
A special thanks goes out to the (dba.stackexchange.com/questions/143044/optimise-a-lateral-join-query-on-a-big-table)Stackexchange community

I wish you all a wonderful day! Stay safe :)
If anything is off, please write me at peter D.O.T schneider A.T ois42.de

postgresql-performance optimization performance greatest-n-per-group postgresql