2024-03-15 08:48:50.140
f5fd1f510f3f5283b5885678f0498f1b
 0.471 ms
#0 BHS |
tilemap |  piechart
time | bufferstilemap
#
node, ms
tree, ms
rows
Bitmap Heap Scan on salesBitmap Index Scan on sales_point_spgist
sh.ht
.373341
итоговые результаты
357
0
.282
.373
341
Bitmap Heap Scan on sales
338
1
.091
341
  ->  Bitmap Index Scan on sales_point_spgist
19
по затраченному времени | по использованию данныхsales_point_spgistsales_point_spgistsalessales
Bitmap Heap Scan on sales (actual time=0.128..0.373 rows=341 loops=1)
  Recheck Cond: (point(date_part('epoch'::text, (dt)::timestamp without time zone), (sum)::double precision) <@ '(1703980800,20000),(1701388800,10000)'::box)
  Heap Blocks: exact=338
  Buffers: shared hit=357
  ->  Bitmap Index Scan on sales_point_spgist (actual time=0.091..0.091 rows=341 loops=1)
        Index Cond: (point(date_part('epoch'::text, (dt)::timestamp without time zone), (sum)::double precision) <@ '(1703980800,20000),(1701388800,10000)'::box)
        Buffers: shared hit=19
Scan Table sales
"Bitmap Heap Scan on sales (actual time=0.128..0.373 rows=341 loops=1)"
"  Recheck Cond: (point(date_part('epoch'::text, (dt)::timestamp without time zone), (sum)::double precision) <@ '(1703980800,20000),(1701388800,10000)'::box)"
"  Heap Blocks: exact=338"
"  Buffers: shared hit=357"
"  ->  Bitmap Index Scan on sales_point_spgist (actual time=0.091..0.091 rows=341 loops=1)"
"        Index Cond: (point(date_part('epoch'::text, (dt)::timestamp without time zone), (sum)::double precision) <@ '(1703980800,20000),(1701388800,10000)'::box)"
"        Buffers: shared hit=19"
время % rows тип узла таблица индекс узлы sh.ht
.282
75.6
341
Bitmap Heap Scan
sales
0
338
.091
24.4
341
Bitmap Index Scan
sales
sales_point_spgist
1
19
tooltip