[PDB-3838] Simple equality queries to the facts endpoint generates jsonb_each - Puppet Tickets

Details

Release Notes:
Bug Fix
Release Notes Summary:
Significantly improve performance of facts queries which constrain 'name' to a single value (for example: "facts [value, count()] { name = 'osFamily' group by value }"

This happens for simple equality:

puppet query "facts[name, value, count()] { name ='is_virtual' group by value }"

does this.

someone tried to work around the problem like this:

puppet query "facts[name, value, count()] { name in ['is_virtual','kernel','aio_agent_version'] group by name, value }"

But that was still slow. The resulting query plan:

(attached in facts_entitiy_jsonb_each.sql)