PostgreSQL: Documentation: 13: 70.1. Row Estimation Examples

PHOTO EMBED

Tue Aug 03 2021 04:35:44 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

EXPLAIN SELECT * FROM tenk1 WHERE stringu1 < 'IAAAAA';

                         QUERY PLAN
------------------------------------------------------------
 Seq Scan on tenk1  (cost=0.00..483.00 rows=3077 width=244)
   Filter: (stringu1 < 'IAAAAA'::name)
content_copyCOPY

https://www.postgresql.org/docs/current/row-estimation-examples.html