Result: njg

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
0.396	138.758	↑ 1.0	1	1	→ Aggregate (cost=15009.640..15009.650 rows=1 width=8) (actual time=138.757..138.758 rows=1 loops=1)
15.384	138.362	↑ 1.4	3712	1	→ Bitmap Heap Scan on uniform (cost=112.630..14996.790 rows=5138 width=8) (actual time=123.567..138.362 rows=3712 loops=1) Recheck Cond: (sierra = 1001)
122.978	122.978	↑ 1.4	3712	1	→ Bitmap Index Scan on whiskey (cost=0.000..111.350 rows=5138 width=0) (actual time=122.978..122.978 rows=3712 loops=1) Index Cond: (sierra = 1001)

Aggregate  (cost=15009.640..15009.650 rows=1 width=8) (actual time=138.757..138.758 rows=1 loops=1)
  ->  Bitmap Heap Scan on uniform  (cost=112.630..14996.790 rows=5138 width=8) (actual time=123.567..138.362 rows=3712 loops=1)
          Recheck Cond: (sierra = 1001)
        ->  Bitmap Index Scan on whiskey  (cost=0.000..111.350 rows=5138 width=0) (actual time=122.978..122.978 rows=3712 loops=1)
                Index Cond: (sierra = 1001)

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.396 ms	0.3 %
Bitmap Heap Scan	1	15.384 ms	11.1 %
Bitmap Index Scan	1	122.978 ms	88.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
uniform	1	15.384 ms	11.1 %
Bitmap Heap Scan	1	15.384 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: njg

Colorize:

Columns visibility:

Per node type stats

Per table stats