PostgreSQL slow query detected
When load testing my (LTS2015 HF27 + PosgreSQL 9.6 + ElasticSearch 1.x) platform with Tsung , i get a (very) slow query as shown below .
Even if create the index as suggested by PoWa : CREATE INDEX hierarchy_mixintypes_idx
ON public.hierarchy
USING gin (mixintypes COLLATE pg_catalog.“default”);
Regards, Henri
FILES:
slowquery2.png
slowquery.png
 |
Henri Jacob
Member (557) 1 2 3 |
08/31/2017 ( History) |
0 votes
2 answers
2709 views
Your query contains NX_ACCESS_ALLOWED which means you disabled the ACL optimizations. It's unavoidable that with a largish amount of data any query will become slow. See https://doc.nuxeo.com/nxdoc/read-acls/
Make sur you define nuxeo.vcs.optimizations.acl.enabled=true and follow the guide in the page above (REBUILDING READ ACLS) to make sure the indexes needed are recomputed after you do the switch.
 |
Florent Guillaume
Member (36K) 6 8 8 |
08/31/2017 ( History) |
A possible solution to move this slow query to ELS would be setting elasticsearch.override.pageproviders to a special CorePageProvider?
Could you execute your query in pgAdmin with EXPLAIN ANALYZE commands and check result on page https://explain.depesz.com/ or other you want ? You have no less than three options to do: