image_processing VS PgHero

Ruby on Rails 7 uses the image_processing gem to resize images, so either uncomment image_processingfrom you Gemfile, or add it if it is not already present.

- [image_processing](https://github.com/janko/image_processing)

image_processing

Working with images is as easy as possible; creating variants to display images in different sizes might be the most common use case in a Rails Application. The image_processing gem is responsible for abstracting the complexity of creating an image variant, like resizing the image to be 300px on the longest side.

I am using https://github.com/ankane/pghero/ and this is one of its features with GUI

I use either PgHero or Rails PG Extras on every project

There are tools available which can look at your Postgres logs and tell you if you need to add indexes, I've used https://github.com/ankane/pghero before and it seems decent.

https://github.com/ankane/pghero (open source equivalent to pganalyze)

- [pghero](https://github.com/ankane/pghero)

pghero

If you are using PostgreSQL you can enable logging of slow queries and connect to the server with pghero (https://github.com/ankane/pghero) and check top queries by the number of requests and total usage time. Also, you can just enable logging of queries in Django, and on each request, you will have a list of queries on development, sometimes it's just a missing select_related of prefetch_related to increase performance, or you need to create a complex index.

If you are using rails, pghero is a great gem to get better visibility on your Postgres performance

https://github.com/ankane/pghero

I know others can answer this better but we use a combination of PgHero and logging of slow queries trough jOOQ.