Does hasura generate indexes?

Question

Hypothetically, given the gql query files, it could generate appropriate indexes itself, or just do so during the runtime. Searching the docs for index I got nothing.

Answer 1

Hasura does not automatically generate any indexes based on gql query files. You can verify this by querying the metadata in your Postgres instance; some helpful links to do that:

• https://www.postgresqltutorial.com/postgresql-indexes/postgresql-list-indexes/
• List columns with indexes in PostgreSQL

You can add indexes manually via a migration.

Related Github issue: https://github.com/hasura/graphql-engine/issues/2219