Select shcmename,matviewname,matviewowner from pg_matviews;
--Raju
From: Wells Oliver <wells.oliver@gmail.com> Sent: Tuesday, June 18, 2024 6:29 PM To: pgsql-admin <pgsql-admin@postgresql.org> Subject: Materialized views & dead tuples
Apologies for the daft question, but I am surprised to see materialized views show up in pg_stat_user_tables with lots of dead tuples. These are rematerialized nightly and, I thought, this had the effect of replacing/recreating them anew. Can someone shed some light on this?