AnsweredAssumed Answered

CMIS query taking long - performance issue?

Question asked by sepgs2004 on Oct 23, 2018
Latest reply on Oct 25, 2018 by sepgs2004

Alfresco Community Edition 5.2 (Default settings)


Has anyone done anything with the logging on the Postgresql database side for Alfresco?


In the postgresql.conf file, I have the following properties


log_destination  = 'stderr'

logging_collector = on

log_directory = 'pg_log'

log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'

log_min_messages = debug5

log_min_error_statement = debug5

log_min_duration_statement = 0

log_checkpoints = on
log_connections = on
log_disconnections = on
log_duration = on

log_error_verbosity = default

log_lock_waits = on

log_statement = 'none'


I tried different values for few of the properties above.

I could never make it to work for my situation. 

Sometimes, a log file has been created in this pg_log folder, but always with 0 bytes. Nothing gets written there.

For some settings, no file has been created.


My purpose is to get the Postgresql query for the CMIS select query that I am running from my application.

We know this CMIS query takes more than 20 seconds consistently.

This query has our own metadata custom (aspect) properties in the where clause. 

In order to tune the database with indices, I would like to see the raw database query on the other side.


Any ideas?