Без названия

2025-03-04 19:30 | Публичная
                                                                  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
Вернуться ко Всем Вставкам
Открыть чат
Чат с Send-Code AI Закрыть чат