## 72.1. Row Estimation Examples

[](<>)

The examples shown below use tables in the PostgreSQL regression test database. The outputs shown are taken from version 8.3. The behavior of earlier (or later) versions might vary. Note also that since`ANALYZE`uses random sampling while producing statistics, the results will change slightly after any new`ANALYZE`.

Let's start with a very simple query:

```
EXPLAIN SELECT * FROM tenk1;

                         QUERY PLAN
```