N
N
nano_e_t_42015-12-12 06:55:23
PostgreSQL
nano_e_t_4, 2015-12-12 06:55:23

What does analyze verbose output mean in postgres?

Hello everyone
, I'm doing analyze verbose in the database, output (1 line):
"pg_type": scanned 11 of 11 pages, containing 373 live rows and 0 dead rows; 373 rows in sample, 373 estimated total rows
plz explain what does rows in sample and estimate total rows mean? and what does it mean if they are different
I read the documentation, translated it, but understood it very poorly. And I didn’t really find an explanation in Russian
Thank you

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Artem Kileev, 2015-12-12
@nano_e_t_4

Sample rows is a random set of rows for which the query execution plan cost analysis was performed.
Estimated total rows is the number of rows that is expected as a result of executing the query according to the resulting plan.
The execution plan is built on the basis of previously collected statistics, and since statistics are constantly updated, these two values ​​\u200b\u200bmay differ.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question