Very often, after opening a lid I have to restart MacBook. I see a black screen with a mouse cursor for a long time (the most I waited was 5 minutes). I assume this is a very common problem. MBP Mid 2014.
The best GUI for PostgreSQL I've ever seen is the one that is bundled in IntelliJ IDEA as a plugin (Database Tools and SQL). Autocompletion is amazing, lots of features.