Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-3838

Simple equality queries to the facts endpoint generates jsonb_each

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Normal
    • Resolution: Fixed
    • None
    • PDB 5.2.1
    • PuppetDB
    • None
    • Data Platform
    • 3
    • Data Platform 2018-03-14
    • Customer Feedback
    • Bug Fix
    • Significantly improve performance of facts queries which constrain 'name' to a single value (for example: "facts [value, count()] { name = 'osFamily' group by value }"

    Description

      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)

      Attachments

        Activity

          People

            russell.mull Russell Mull
            erik.hansen Erik Hansen
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Zendesk Support