Jira (PDB-5043) Collect common PDB queries used in PE console pages

[Zachary Kent (Jira)]

Title: Message Title

Zachary Kent created an issue   PuppetDB / PDB-5043 Collect common PDB queries used in PE console pages Issue Type: Task Assignee: Unassigned Created: 2021/02/22 1:58 PM Priority: Normal Reporter: Zachary Kent We want to collect a list of commonly issued queries against PDB to provide a list for a performance testing baseline and to help identify which queries we may be able to help optimize. For this ticket you'll need to get a PE install running using Frankenbuilder. Note that setting up a Platform 9 instance and running Frankenbuilder there will greatly reduce the time it takes to spin up a PE install due to the PE tarball needing to be copied back and forth from Portland and your local machine. We can help troubleshoot this setup in the pdb-sync room if there are any issues. Below is an example of a Frankenbuilder command I've used in the past for reference: ./frankenbuilder master --workdir=/Users/zachary.kent/frankenbuilder/franken-workdir --vmpooler --install --preserve-hosts=always --keyfile=~/.ssh/id_rsa-acceptance Once you have a running PE instance you'll need to enable log-queries in the PuppetDB config and restart the service. Once the logging is enabled clicking through the PE console should start logging the AST PDB is generating in the logs. The list of queries we generate doesn't have to be exhaustive for the first pass. Clicking through the main pages and the side navs of the console should generate a reasonable list. We should capture this list in a gist and link it to this ticket. Add Comment   This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.388381.1614031085000.148571.1614031140352%40Atlassian.JIRA.