Skip to content

Glossary: PostgreSQL Beyond the Basics

Sargable

Also written: non-sargable

A filter an index can use, from "search argument": the bare column on one side and a value on the other. Wrapping the column in a function, as with `date_trunc('month', placed_at)`, makes it non-sargable.

Where the book teaches it

Related terms

Keyset paginationExpression index