Puppet Community

if Puppet Enterprise console is slow loading `matching nodes` inside a node group, where would I look to try identify the issue? I feel like its `puppetdb` given its got to figure out which nodes match the rules associated. Would this be a good start?

probably the classifer or its database, not puppetdb

how many node groups do you have? how many rules/pinned nodes in that specific group?

I was looking at the classifier logs earlier but couldn't really identify anything obvious. I even had `logback.xml` set to debug mode.

probably a couple hundred node groups in total.
2 rules in the node group but doing a regex match with 1 of the rules on a custom structured fact.

its one of the databases in pe-postgresql

and you can enable slow query log in the postgresql config

so I found the query in the `postgresql-Tue.log`
here is the execution time `36448.118ms`

I have 201 nodes in this particular node group. just FYI

setting up thr operational dashboard is a good step.  you can also get the query from the log and run it again with explain

sorry, I am not a DBA. How would I run the query with explain?

you can start the psql shell and paste the query there

the pdql binary is somewhere in /opt/puppetlabs

and the outlut of the explain can be added to <https://explain.depesz.com/|https://explain.depesz.com/>

you need to switch to the pe-postgresql user

a few options: your hardware is too old/small. you dont give postgres enough resources. you have too much old data in the db which slows it down

and running pgbadger and explain on queries is always a good start

for the most part, we have left it with vendor defaults :slightly_smiling_face: