In ../ucmdb_logs/server/cmdb.dal.slow.log you can see quite some entries like this
2018-01-17 01:01:01,432 INFO [UCMDB - scheduler for customer 1, id name: Default Client] - 1215ms 1354742674 SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_name=lower(?) and (table_schema=current_schema() or table_type like '%TEMPORARY%'); Values: 'HDMR_DBEXTENT_1'
The statement is called est 160 - 200 times a day.
This is a catalog query so one would expect that this is fast i.e. 1ms or even less.
INFORMATION_SCHEMA.TABLES is a quite complex view in Postgres and according to voices on the web this is inherently slow. See e..g.
Check whether the check could be rewritten and replace the SQL statement by a rewritten, faster one.. E.g. that it uses pg_tables or one of the base catalog tables.