In PostgreSQL you can check if an index is being used for a query by using the EXPLAIN (ANALYZE , BUFFERS) before the query like: EXPLAIN (ANALYZE, BUFFERS) SELECT *…