Your question doesn't include the size or complexity of the database you're trying to visualize. With that preface said, schemaspy has been around for years and years and I've seen it at every tech company I've ever worked at for visualizing their production databases. I think it's free?

https://schemaspy.org/samples/chinook/relationships.html

Jet brains DataGrip is great for this. Compared to pgadmin an dbeaver. The DataGrip visualization options are so good that I grabbed a subscription.

100%… any new project I get involved I use DataGrip to build visualization to quickly get across the data model

Visual DB can do that: https://visualdb.com/

chartsdb[1][2] can be installed locally (or run through Docker) and import your database schema

[1]: https://chartdb.io/ [2]: https://github.com/chartdb/chartdb

DBeaver will generate an ER diagram from a connected DB

I find the auto-generated layout to be pretty poor. Requires a lot of jostling to get something more compact and immediately usable.

Proprietary and a bit pricy but Luna Modeller is good.