Comment 3 for bug 1842150

I'm looking at stable/pike (sorry) and stable/rocky, the performance characteristics are similar there.

Agree, the main fundamental issue here is the fanout of SQL queries. I was wondering if we could change this to not do the _extend_trunk_port_details in "port list" type api calls and only on port show. alternatively we need a extra flag to suppress this by default.

Especially nova doing these calls are difficult from a scale perspective (but it completely ignores the result)