Hi, The patch that makes pg_stat_statements track the number of rows that REFRESH MATERIALIZED VIEW command processes was proposed at [1]. When reviewing the patch, I just wondered why the completion tag output for REFRESH MATERIALIZED VIEW doesn't include the row count. Is this an intentional behavior? I've not found the past discussion about this yet.
OTOH, CREATE MATERIALIZED VIEW reports something like "SELECT NNN" (NNN is the row count) as the completion tag output. If WITH NO DATA is specified, "CREATE MATERIALIZED VIEW" is reported instead. Is it better to make REFRESH MATERIALIZED VIEW do the similar thing? Or we should not do that, for example, since changing the completion tag output may break the client app? [1] https://postgr.es/m/71f6bc72f8bbaa06e701f8bd2562c...@oss.nttdata.com Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION
