Try our free BI tool https://www.seektable.com It has PostgreSql connector; with 'flat table' report type you can easily filter/sort records without need to write SQL, and pivot tables/charts are good for summary reports (under the hood GROUP BY queries are generated)

BTW, SeekTable can connect to ElasticSearch so it may be used with this data source too.