[2.x, UI] 100% cpu usage for 1 regiond process when having hundreds of images

[Andres Rodriguez]

I have 1 mas region/rack where I uploaded 200+ images. I noticed that one of the twistd3 processes for the region controller was with 100% load.

Looking at the postgresql logs, i found multiple messagesssimilar to the following non-stop.

2017-07-20 15:40:32 UTC [29440-1272] maas@maasdb LOG: statement: SELECT "maasserver_bootresourceset"."id", "maasserver_bootresourceset"."created", "maasserver_bootresourceset"."updated", "maasserver_bootresourceset"."resource_id", "maasserver_bootresourceset"."version", "maasserver_bootresourceset"."label", SUM("maasserver_largefile"."size") AS "files_size", COUNT("maasserver_bootresourcefile"."id") AS "files_count", SUM("maasserver_largefile"."total_size") AS "files_total_size" FROM "maasserver_bootresourceset" LEFT OUTER JOIN "maasserver_bootresourcefile" ON ( "maasserver_bootresourceset"."id" = "maasserver_bootresourcefile"."resource_set_id" ) LEFT OUTER JOIN "maasserver_largefile" ON ( "maasserver_bootresourcefile"."largefile_id" = "maasserver_largefile"."id" ) WHERE "maasserver_bootresourceset"."resource_id" = 171 GROUP BY "maasserver_bootresourceset"."id", "maasserver_bootresourceset"."created", "maasserver_bootresourceset"."updated", "maasserver_bootresourceset"."resource_id", "maasserver_bootresourceset"."version", "maasserver_bootresourceset"."label" ORDER BY "maasserver_bootresourceset"."id" DESC
2017-07-20 15:40:32 UTC [29463-36] maas@maasdb LOG: statement: SELECT "maasserver_bootresourceset"."id", "maasserver_bootresourceset"."created", "maasserver_bootresourceset"."updated", "maasserver_bootresourceset"."resource_id", "maasserver_bootresourceset"."version", "maasserver_bootresourceset"."label", SUM("maasserver_largefile"."size") AS "files_size", COUNT("maasserver_bootresourcefile"."id") AS "files_count", SUM("maasserver_largefile"."total_size") AS "files_total_size" FROM "maasserver_bootresourceset" LEFT OUTER JOIN "maasserver_bootresourcefile" ON ( "maasserver_bootresourceset"."id" = "maasserver_bootresourcefile"."resource_set_id" ) LEFT OUTER JOIN "maasserver_largefile" ON ( "maasserver_bootresourcefile"."largefile_id" = "maasserver_largefile"."id" ) WHERE "maasserver_bootresourceset"."resource_id" = 182 GROUP BY "maasserver_bootresourceset"."id", "maasserver_bootresourceset"."created", "maasserver_bootresourceset"."updated", "maasserver_bootresourceset"."resource_id", "maasserver_bootresourceset"."version", "maasserver_bootresourceset"."label" ORDER BY "maasserver_bootresourceset"."id" DESC
2017-07-20 15:40:32 UTC [29440-1273] maas@maasdb LOG: statement: SELECT "maasserver_bootresourceset"."id", "maasserver_bootresourceset"."created", "maasserver_bootresourceset"."updated", "maasserver_bootresourceset"."resource_id", "maasserver_bootresourceset"."version", "maasserver_bootresourceset"."label", SUM("maasserver_largefile"."size") AS "files_size", COUNT("maasserver_bootresourcefile"."id") AS "files_count", SUM("maasserver_largefile"."total_size") AS "files_total_size" FROM "maasserver_bootresourceset" LEFT OUTER JOIN "maasserver_bootresourcefile" ON ( "maasserver_bootresourceset"."id" = "maasserver_bootresourcefile"."resource_set_id" ) LEFT OUTER JOIN "maasserver_largefile" ON ( "maasserver_bootresourcefile"."largefile_id" = "maasserver_largefile"."id" ) WHERE "maasserver_bootresourceset"."resource_id" = 170 GROUP BY "maasserver_bootresourceset"."id", "maasserver_bootresourceset"."created", "maasserver_bootresourceset"."updated", "maasserver_bootresourceset"."resource_id", "maasserver_bootresourceset"."version", "maasserver_bootresourceset"."label" ORDER BY "maasserver_bootresourceset"."id" DESC
2017-07-20 15:40:32 UTC [29463-37] maas@maasdb LOG: statement: SELECT "maasserver_bootresourcefile"."id", "maasserver_bootresourcefile"."created", "maasserver_bootresourcefile"."updated", "maasserver_bootresourcefile"."resource_set_id", "maasserver_bootresourcefile"."largefile_id", "maasserver_bootresourcefile"."filename", "maasserver_bootresourcefile"."filetype", "maasserver_bootresourcefile"."extra" FROM "maasserver_bootresourcefile" WHERE "maasserver_bootresourcefile"."resource_set_id" = 182

[Andres Rodriguez (andreserl)]

Once I closed the UI, the load reduced significantly.