DB utilization and Slowness after migrating to postgreSQL 10.13

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
Kamlesh
Posts: 1
Joined: 19 Nov 2020, 05:49

DB utilization and Slowness after migrating to postgreSQL 10.13

Post by Kamlesh »

Hi Team,

We have move our Mantis schema to PostgreSQL 10.13 from 9.6.16.
After migration we encountered the slowness and high DB utilization due to mantis schema.
We have found in the log below query frequently running from mantis.
Please help us to resolved the issue and enhance the performance.

Query:-
select table_name,'T' from information_schema.tables where table_schema not in ( 'pg_catalog','information_schema')
union
select table_name,'V' from information_schema.views where table_schema not in ( 'pg_catalog','information_schema')
cas
Posts: 988
Joined: 11 Mar 2006, 16:08
Contact:

Re: DB utilization and Slowness after migrating to postgreSQL 10.13

Post by cas »

Suggest to do some monitoring on the DB, erhaps the following can assist:
https://powa.readthedocs.io/en/latest/
Post Reply