People Finder - java high CPU

[idm]

Alfresco 4.0.d is running fine bar the fact it appear to have an issue with the people finder.

Whenever a person search is performed, nothing is returned. Searching appears for a while, the site is unresponsive. Java is using 100% cpu.

Recently, 300000 users were added during an LDAP synch although this did not complete properly and alfresco process was killed (stop does not work, believe this is an known issue on 4.0.d)

Any pointers on where I may begin to look?

TIA

[idm]

To add,

Searching for a first name e.g. Mark, produces the above result.

Searching for Mark Smith, works - finds the user(s)

[idm]

One further piece of information.

Searching for (e.g.) "Joe " (no quotes) produces this error

Searching for "Joe" (no quotes) sees the high CPU

05280007 Wrapped Exception (with status template): 05280079 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/person/people.get.js': 05280078 Failed to execute query: Namespace: alfresco.node queryName: select_GetChildrenCannedQueryWithProps Parameter: org.alfresco.repo.node.getchildren.FilterSortNodeEntity@7a199711 Offset: 0 Limit: 2147483647

[mrogers]

try gathering the stats on your database.

[idm]

try gathering the stats on your database.

 datid |  datname  | numbackends | xact_commit | xact_rollback | blks_read | blks_hit  | tup_returned | tup_fetched | tup_inserted | tup_updated | tup_deleted 
——-+———–+————-+————-+—————+———–+———–+————–+————-+————–+————-+————-
     1 | template1 |           0 |           0 |             0 |         0 |         0 |            0 |           0 |            0 |           0 |           0
 11563 | template0 |           0 |           0 |             0 |         0 |         0 |            0 |           0 |            0 |           0 |           0
 11564 | postgres  |           0 |         551 |             1 |       180 |      9462 |       152774 |        1439 |            0 |           0 |           0
 38399 | alfresco  |          11 |     3004472 |          6033 |   8639979 | 120273002 |   1465852557 |   158708294 |        12270 |      474472 |        9506‍‍‍‍‍‍

I've compared a cold backup of the production db with a clean alfresco install and they are identical.