The Admin Console currently only indicates if updates were detected. For a more complete picture of the query sets configuration DEBUG logging must be used:
logger.alfresco-enterprise-repo-queryaccelerator.name=org.alfresco.enterprise.repo.queryaccelerator logger.alfresco-enterprise-repo-queryaccelerator.level=debug
Logs when a Query Set Refresh was performed but there are no updates:
2021-01-14 17:12:33,020 DEBUG [repo.queryaccelerator.QuerySetConfigServiceImpl] [http-bio-8080-exec-6] Refreshing query sets - checking for updates... 2021-01-14 17:12:33,022 DEBUG [repo.queryaccelerator.QuerySetConfigFileFinder] [http-bio-8080-exec-6] file /Users/p3700509/Documents/build/queryaccelerator/test01-qs.json config read 2021-01-14 17:12:33,029 DEBUG [repo.queryaccelerator.QuerySetConfigServiceImpl] [http-bio-8080-exec-6] QuerySet: 'test01' with version: '2' already exists. 2021-01-14 17:12:33,030 DEBUG [repo.queryaccelerator.QuerySetConfigServiceImpl] [http-bio-8080-exec-6] Query set configuration - no new tables detected 2021-01-14 17:12:33,031 DEBUG [repo.queryaccelerator.QuerySetConfigServiceImpl] [http-bio-8080-exec-6] Query set configuration - no deleted tables detected 2021-01-14 17:12:33,033 DEBUG [queryaccelerator.population.PopulateRqaServiceImpl] [http-bio-8080-exec-6] Number of PopulateRqaTableWorkers found: 0
Logs when a Query Set Refresh has started:
2021-01-14 17:14:15,906 DEBUG [repo.queryaccelerator.QuerySetConfigServiceImpl] [http-bio-8080-exec-6] Refreshing query sets - checking for updates... 2021-01-14 17:14:15,907 DEBUG [repo.queryaccelerator.QuerySetConfigFileFinder] [http-bio-8080-exec-6] file /Users/p3700509/Documents/build/queryaccelerator/test01-qs.json config read 2021-01-14 17:14:15,911 DEBUG [repo.queryaccelerator.QuerySetConfigServiceImpl] [http-bio-8080-exec-6] Query set configuration - detected new version: test01 version: 3 2021-01-14 17:14:15,915 DEBUG [repo.queryaccelerator.QuerySetConfigServiceImpl] [http-bio-8080-exec-6] Query sets - creating table script for : test01 version: 3 2021-01-14 17:14:15,916 DEBUG [repo.queryaccelerator.QuerySetRegistryImpl] [http-bio-8080-exec-6] Registering table: test01, version: 3, status: INPROGRESS 2021-01-14 17:14:15,929 DEBUG [repo.queryaccelerator.QuerySetConfigServiceImpl] [http-bio-8080-exec-6] Query sets - adding to cache: alf_qs_test01_v3 2021-01-14 17:14:15,930 INFO [schema.script.ScriptExecutorImpl] [http-bio-8080-exec-6] Executing database script /var/folders/r7/mybxmf_d2sb2sw6g8ksg3h0x0ylsgp/T/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-562184015453156440.sql (Copied from file:/var/folders/r7/mybxmf_d2sb2sw6g8ksg3h0x0ylsgp/T/Alfresco/test01-11276349223693844289.sql). 2021-01-14 17:14:15,954 DEBUG [repo.queryaccelerator.QuerySetConfigServiceImpl] [http-bio-8080-exec-6] Query set configuration - no deleted tables detected 2021-01-14 17:14:15,957 DEBUG [queryaccelerator.population.PopulateRqaServiceImpl] [http-bio-8080-exec-6] Number of PopulateRqaTableWorkers found: 1 2021-01-14 17:14:15,959 DEBUG [queryaccelerator.population.PopulateRqaServiceImpl] [http-bio-8080-exec-6] PopulateRqaTableWorker(s) will be started at Thu Jan 14 17:17:15 EET 2021 on process 46672@L3700101035.ness.com (just in case you want to kill this JVM as we do not use daemon executors here)
It is also possible to obtain detailed logs for the query engine. The logs provide information about the process of selecting the query set, based on the query, by activating the DEBUG level, as in this example:
logger.alfresco-repo-search-impl-querymodel-impl-db.name=org.alfresco.repo.search.impl.querymodel.impl.db logger.alfresco-repo-search-impl-querymodel-impl-db.level=debug
Logs when a query is accepted by the engine:
15:02:26,097 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-10] Query request received
15:02:26,098 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-10] - query is being prepared
15:02:26,099 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-10] - query sent to the database
15:02:37,722 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-10] - query predicates list:
15:03:15,823 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-10] - aspect: qname={http://www.alfresco.org/model/content/1.0}titled
15:06:43,325 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-10] - Examining 1 queryset(s)...
15:06:43,326 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-10] - queryset table alf_qs_testbb01_v41 accepted for this query!
15:06:43,328 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-10] - using denormalised table for the query
Logs when a query is refused by the engine:
15:26:54,753 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-3] Query request received
15:26:54,753 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-3] - query is being prepared
15:26:54,755 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-3] - query sent to the database
15:26:58,389 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-3] - query predicates list:
15:26:58,389 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-3] - aspect: qname={http://www.alfresco.org/model/content/1.0}dublincore
15:26:58,389 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-3] - column: qname={http://www.alfresco.org/model/content/1.0}publisher
15:27:00,108 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-3] - Examining 1 queryset(s)...
15:27:00,108 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-3] - queryset table alf_qs_testbb01_v41 excluded as qname not found: {http://www.alfresco.org/model/content/1.0}dublincore
15:27:00,108 DEBUG [impl.db.DBQueryEngine] [http-bio-8080-exec-3] - using standard table for the query