Result: TwLw

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
0.000	0.000	↓ 0.0			→ Bitmap Heap Scan on suggestor_item (cost=48.19..127.70 rows=23 width=43) (actual time=.. rows= loops=) Recheck Cond: ((setweight(to_tsvector('english'::regconfig, (COALESCE(name, ''::character varying))::text), 'A'::"char") \|\| setweight(to_tsvector('english'::regconfig, COALESCE(description, ''::text)), 'B'::"char")) @@ '''monkey'''::tsquery)
0.000	0.000	↓ 0.0			→ Bitmap Index Scan on textsearch_idx (cost=0.00..48.19 rows=23 width=0) (actual time=.. rows= loops=) Index Cond: ((setweight(to_tsvector('english'::regconfig, (COALESCE(name, ''::character varying))::text), 'A'::"char") \|\| setweight(to_tsvector('english'::regconfig, COALESCE(description, ''::text)), 'B'::"char")) @@ '''monkey'''::tsquery)

 Bitmap Heap Scan on suggestor_item  (cost=48.19..127.70 rows=23 width=43)
   Recheck Cond: ((setweight(to_tsvector('english'::regconfig, (COALESCE(name, ''::character varying))::text), 'A'::"char") || setweight(to_tsvector('english'::regconfig, COALESCE(description, ''::text)), 'B'::"char")) @@ '''monkey'''::tsquery)
   ->  Bitmap Index Scan on textsearch_idx  (cost=0.00..48.19 rows=23 width=0)
         Index Cond: ((setweight(to_tsvector('english'::regconfig, (COALESCE(name, ''::character varying))::text), 'A'::"char") || setweight(to_tsvector('english'::regconfig, COALESCE(description, ''::text)), 'B'::"char")) @@ '''monkey'''::tsquery)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.000 ms	0.0 %
Bitmap Index Scan	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
suggestor_item	1	0.000 ms	0.0 %
Bitmap Heap Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: TwLw

Colorize:

Columns visibility:

Per node type stats

Per table stats