On Wed, Feb 22, 2017 at 11:13 AM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote: > Certainly easier, but I don't think it'd be better. Matviews really aren't > the same thing as tables. Off-hand (without reviewing the patch), update and > delete counts certainly wouldn't make any sense. "Insert" counts might, in > as much as it's how many rows have been added by refreshes. You'd want a > refresh count too.
Regular REFRESH truncates the view and repopulates it, but REFRESH CONCURRENTLY does inserts, updates, and deletes as needed to adjust the contents. So I think all the same counters that make sense for regular tables are also sensible here.
After digging into things further, just making refresh report the stats for what is it basically doing simplifies and solves it and it is something we can back patch if that the consensus. See the attached patch.