I use pgdash and netdata for monitoring and alerting, and plain psql for analyzing specific queries.