postgres extension pg_hint_plan - ghdrako/doc_snipets GitHub Wiki

• https://github.com/ossc-db/pg_hint_plan

Query plan hinting is not available in core PostgreSQL but can be added using the widely supported pg_hint_plan extension.

SET pg_hint_plan.enable_hint = ON"

select /*+ SeqScan(users) */... 

pg_hint_plan can be used for learning by forcing the use of some indexes and seeing what the performance is like, even if you don’t commit hints that you used for learning purposes.