Sample Header Ad - 728x90

Refreshing a PostgreSQL materialised view and returning the rowcount

1 vote
1 answer
43 views
Immediately after refreshing a materialised view in Postgres I'd like to know how many rows are in it. Currently I do this by running a 2nd SQL command (SELECT count(*) FROM...) Is there a more efficient way of doing this? Can the REFRESH command be persuaded to return the rowcount?
Asked by ConanTheGerbil (1303 rep)
Apr 12, 2025, 09:12 AM
Last activity: Apr 13, 2025, 12:07 PM