Using the "Filter by fact value" feature of the Console creates a poorly performing postgres query that contains a nested loop for each fact. Here is the explain analyze output for a query filtering on `operatingsystem` and `operatingsystemmajrelease`. Each filter condition is evaluated in a separate nested loop, and this is exacerbated for each added fact.
Conversely, here is the explain analyze output for this equivalent PQL query:
The two filters are evaluated in the same step and the query is faster.
In addition to PE-29836, this can result in multiple slowly running queries that can negatively impact performance as a result of using this feature. I'll attach the explain outputs in case they are pruned from the website.