How to optimize multi-field search across a small subset of rows in a table, Postgres and Django?

Question

PostgreSQL

There is a table in basis in which approximately 200k records. search by one of the fields allows you to select about 3k records, which in turn need to be filtered by about a dozen more fields. How to optimize a query from django to cache a query that selects 3000 rows and then search only in this subset?

Answer 1

Start with indexes in the database, try a simple one on this field, then a composite one, well, with time measurements, otherwise it turns out that there is no problem.