1 Risposta
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
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.
con risposta un anno fa
Contenuto pertinente
- AWS UFFICIALEAggiornata 3 anni fa
- AWS UFFICIALEAggiornata un anno fa