Have you seen Alexander Korotkov post "Faceted Search in the Single PostgreSQL Query" http://akorotkov.github.io/blog/2016/06/17/faceted-search/
Have you seen Alexander Korotkov post "Faceted Search in the Single PostgreSQL Query" http://akorotkov.github.io/blog/2016/06/17/faceted-search/