1 個回答
- 最新
- 最多得票
- 最多評論
1
This is an advanced topic - SVV_TABLE_INFO is a system view so you can check its DDL to find where the column it comes from.
First run show view SVV_TABLE_INFO;
. According to the DDL, estimated_visible_rows is defined as following.
(psi.stairows) :: numeric(38, 0) AS estimated_visible_rows,
In the DDL, you can find that psi an alias for pg_statistic_indicator.
The document says:
Stores information about the number of rows inserted or deleted since the last ANALYZE. The PG_STATISTIC_INDICATOR table is updated frequently following DML operations, so statistics are approximate.
To answer your question, this number is approximate and there's no guaranteed maximum delay since ANALYZE happens automatically or triggered by user. Check STL_ANALYZE for ANALYZE operation history.
已回答 1 年前
相關內容
- 已提問 6 個月前
- AWS 官方已更新 1 年前