I am new to PostgreSQL, I am refreshing the materialized view before calling it from PHP code for reporting purpose. Is it needed?
Yes, you have to refresh it to
replace the contents of a materialized view