Sample Header Ad - 728x90

Relation does not exist while scanning schema

1 vote
1 answer
5158 views
My Postgres database is getting slow while executing some function. But another database of identical design and with more data is much faster than the first one. I have recently migrated data from MS SQL to PostgreSQL. So I have checked if there is any problem from following queries: SELECT relname AS TableName, to_char(seq_scan, '999,999,999,999') AS TotalSeqScan, to_char(idx_scan, '999,999,999,999') AS TotalIndexScan, to_char(n_live_tup, '999,999,999,999') AS TableRows, pg_size_pretty(pg_relation_size(relname :: regclass)) AS TableSize FROM pg_stat_all_tables WHERE schemaname = 'loan' AND 50 * seq_scan > idx_scan -- more then 2% AND n_live_tup > 10000 AND pg_relation_size(relname :: regclass) > 5000000 ORDER BY relname ASC; And I got the result: > ERROR: relation "mv_transaction_view" does not exist > SQL state: 42P01 What is the solution for this? I have a materialized view named mv_transaction_view.
Asked by Jeevan Gharti (125 rep)
Feb 16, 2019, 10:38 AM
Last activity: Nov 29, 2019, 04:01 PM