DB utilization and Slowness after migrating to postgreSQL 10.13
Posted: 19 Nov 2020, 06:00
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')
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')