<div dir="ltr">I am experiencing the same behavior on all of my clouds. It's normal I believe because behind the command so many api calls go out to construct data. We have 500 vms in single projects so I wrote my own wrapper script to talk to mariadb and fetch that information directly from DB. This is not the best solution but works for me and now i can pull out any records within microseconds.<br><br>$ mysql -h 172.28.15.79 -u user1 --password=<PASSWORD> nova -e "select display_name as hostname,vm_state,node,availability_zone,vcpus,memory_mb,root_gb from instances WHERE (vm_state='active' OR vm_state='stopped');"<br><div><br></div></div><br><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Feb 7, 2023 at 2:07 PM Parsa Aminian <<a href="mailto:p.aminian.server@gmail.com">p.aminian.server@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">hello <div>On openstack wallaby version openstack server list result too slow :</div><div>| GET <a href="http://example.com:35357/v3" target="_blank">http://example.com:35357/v3</a>                                             |  0.040385 |<br>| POST <a href="http://example.com:35357/v3/auth/tokens" target="_blank">http://example.com:35357/v3/auth/tokens</a>                                |   0.49567 |<br>| GET <a href="http://example.com:9292/" target="_blank">http://example.com:9292/</a>                                                      |  0.011694 |<br>| GET <a href="http://example.com:8774/v2.1/servers/detail?all_tenants=True" target="_blank">http://example.com:8774/v2.1/servers/detail?all_tenants=True</a>                  | 16.032512 |<br>| GET <a href="http://example.com:9292/v2/images" target="_blank">http://example.com:9292/v2/images</a>                                             |  0.241679 |<br>| GET <a href="http://example.com:9292/v2/images?marker=b17469eb-4548-4fbb-b871-5880323a7a76" target="_blank">http://example.com:9292/v2/images?marker=b17469eb-4548-4fbb-b871-5880323a7a76</a> |  0.205339 |<br>| GET <a href="http://example.com:9292/v2/images?marker=eb00ee00-4401-4e59-bf92-602be2e45c4a" target="_blank">http://example.com:9292/v2/images?marker=eb00ee00-4401-4e59-bf92-602be2e45c4a</a> |  0.204854 |<br>| GET <a href="http://example.com:9292/v2/images?marker=edf7d33a-286a-4a00-a8d8-4b0055d06093" target="_blank">http://example.com:9292/v2/images?marker=edf7d33a-286a-4a00-a8d8-4b0055d06093</a> |  0.203524 |<br>| GET <a href="http://example.com:9292/v2/images?marker=75ab289d-90ce-496c-97a4-6fdd247c862a" target="_blank">http://example.com:9292/v2/images?marker=75ab289d-90ce-496c-97a4-6fdd247c862a</a> |  0.215708 |<br>| GET <a href="http://example.com:9292/v2/images?marker=b4eaf24c-94dc-4f2f-bd54-3eecbf290d75" target="_blank">http://example.com:9292/v2/images?marker=b4eaf24c-94dc-4f2f-bd54-3eecbf290d75</a> |   0.28073 |<br>| GET <a href="http://example.com:8774/v2.1/flavors/detail?is_public=None" target="_blank">http://example.com:8774/v2.1/flavors/detail?is_public=None</a>                    |  0.641211 |<br>| Total                                                                               | 18.573306<br></div><div><br></div><div>as you see nova api takes 16 seconds to load . I have one project with 1100 instance on it </div></div>
</blockquote></div>