How to quickly get row count estimates for all tables
Vertica periodically run AnalyzeRowCount on all tables.
At least, database parameter AnalyzeRowCountInterval, default 84600, suggest what database is doing.
Is there a system view that allow very quickly to get this value for all tables?
I know I can export statistics into XML and get estimated row count value, but that takes forever and it is per per table.
I am currently getting row count (and disk size) per projection using system view projection_storage, and it is "expensive" on huge clusters with huge data.
Would be very nice if you can point me to some internal system view that will give me very quickly current statistics on row count per projection or per table. Key here - very quickly. I am pretty sure system view with this info does exist.
I am on v 12.0.4.