My goto these days is TablePlus https://tableplus.com. Native desktop client (no electron). UI is pretty standard, polished, and IMHO great. Supports PG really well (amongst other RDBMSes and some NoSQL dbs).
Yes it's not open source but its free version is still great.
On the noisy NodeJS auto-instrumentation, it is indeed very noisy out of the box. Myself along with a bunch of other ppl finally got the project to allow you to select the instrumentations via configuration. Saves having to create your own tracer.ts/js file.
A while ago I wrote jlq, a utility explicitly querying/filtering jsonl/json log files. It’s powered by SQLite. Nice advantage is it can persist results to a sqlite database for later inspection or to pass around. Hope it helps someone :)
Yes it's not open source but its free version is still great.