QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=325686.01..325686.26 rows=100 width=259) (actual time=2.124..2.125 rows=0 loops=1)
-> Sort (cost=325686.01..326215.02 rows=211604 width=259) (actual time=2.122..2.123 rows=0 loops=1)
Sort Key: id DESC
Sort Method: quicksort Memory: 25kB
-> Bitmap Heap Scan on sometable (cost=2509.00..317598.66 rows=211604 width=259) (actual time=2.087..2.087 rows=0 loops=1)
Recheck Cond: (((hstore_col -> 'email'::text) = 'randomemail'::text) AND ((type)::text = 'sometext'::text))
-> Bitmap Index Scan on index_hstore (cost=0.00..2456.09 rows=211604 width=0) (actual time=2.083..2.083 rows=0 loops=1)
Index Cond: ((hstore_col -> 'email'::text) = 'randomemail'::text)
Settings: effective_cache_size = '2GB', jit = 'off', max_parallel_workers_per_gather = '0', random_page_cost = '1.5', work_mem = '64MB'
Planning Time: 0.132 ms
Execution Time: 2.752 ms