Improve port listing command

[Rodolfo Alonso]

As reported in https://bugzilla.redhat.com/show_bug.cgi?id=1772106, between Queens and Train there was a performance degradation in the port listing operation.

This could be caused because of the port DB object new relationships (portuplinkstatuspropagation) or new extensions added.

In any case, improving the server performance could be an arduous task. This bug proposes to improve the OSC query, adding a filter for those parameters shown in the list command: ID, name, MAC address, fixed IPs and status.

This bug and a possible solution are similar to https://bugs.launchpad.net/neutron/+bug/1865223.

[s10 (vlad-esten)]

The performance degradation between Queens and Train is huge. We see increase in time for the port listing API response for 2000 ports from 3 seconds in Queens to 120 seconds in Stein. I hope, this issue can be fixed in the API, not just in the SDK and CLI.

[Andrey Bolgov (a-bolgov)]

Reason of petformance degradation is implementation of this RFE (https://bugs.launchpad.net/neutron/+bug/1578989) by change (https://review.opendev.org/c/openstack/neutron/+/590363). Further investigation to optimize this behaviour is going in https://bugs.launchpad.net/neutron/+bug/1905726

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/python-openstackclient 5.5.0 release.