how to check files/images which are more than 400 KB Related to QA part of our Drupal site performance, we need to make sure that size of images on the site are not more than 400kb.

I know there will validation and configs we can use while uploading images to site. but for already existing, is there any way to find out images size which are more than specified limit?

A non-code solution would be preferred.
You can try direct SQL query

select fid, filename from file_managed where filemime like 'image/%' and filesize &gt; 400000;