Result: qu3S

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
359.312	2339.380	↓ 1.0	261815	1	→ Result (cost=22.75..43914.43 rows=261471 width=8) (actual time=2.699..2339.380 rows=261815 loops=1)
309.493	1980.068	↓ 1.0	261815	1	→ Append (cost=22.75..43914.43 rows=261471 width=8) (actual time=2.694..1980.068 rows=261815 loops=1)
11.164	13.100	↓ 1.7	1727	1	→ Bitmap Heap Scan on tsv_test (cost=22.75..2494.97 rows=1000 width=8) (actual time=2.691..13.100 rows=1727 loops=1) Recheck Cond: (v @@ '''lexeme3179'''::tsquery)
1.936	1.936	↓ 1.7	1727	1	→ Bitmap Index Scan on tsv_gin (cost=0.00..22.50 rows=1000 width=0) (actual time=1.936..1.936 rows=1727 loops=1) Index Cond: (v @@ '''lexeme3179'''::tsquery)
132.500	188.354	↑ 1.0	60088	1	→ Bitmap Heap Scan on tsv_test (cost=612.86..18837.09 rows=60498 width=8) (actual time=62.545..188.354 rows=60088 loops=1) Recheck Cond: (v @@ '''lexeme5'''::tsquery)
55.854	55.854	↑ 1.0	60088	1	→ Bitmap Index Scan on tsv_gin (cost=0.00..597.74 rows=60498 width=0) (actual time=55.854..55.854 rows=60088 loops=1) Index Cond: (v @@ '''lexeme5'''::tsquery)
1469.121	1469.121	↓ 1.0	200000	1	→ Seq Scan on tsv_test (cost=0.00..19967.66 rows=199973 width=8) (actual time=0.036..1469.121 rows=200000 loops=1) Filter: (v @@ '''fooblablabla'''::tsquery)

Result  (cost=22.75..43914.43 rows=261471 width=8) (actual time=2.699..2339.380 rows=261815 loops=1)
  ->  Append  (cost=22.75..43914.43 rows=261471 width=8) (actual time=2.694..1980.068 rows=261815 loops=1)
        ->  Bitmap Heap Scan on tsv_test  (cost=22.75..2494.97 rows=1000 width=8) (actual time=2.691..13.100 rows=1727 loops=1)
              Recheck Cond: (v @@ '''lexeme3179'''::tsquery)
              ->  Bitmap Index Scan on tsv_gin  (cost=0.00..22.50 rows=1000 width=0) (actual time=1.936..1.936 rows=1727 loops=1)
                    Index Cond: (v @@ '''lexeme3179'''::tsquery)
        ->  Bitmap Heap Scan on tsv_test  (cost=612.86..18837.09 rows=60498 width=8) (actual time=62.545..188.354 rows=60088 loops=1)
              Recheck Cond: (v @@ '''lexeme5'''::tsquery)
              ->  Bitmap Index Scan on tsv_gin  (cost=0.00..597.74 rows=60498 width=0) (actual time=55.854..55.854 rows=60088 loops=1)
                    Index Cond: (v @@ '''lexeme5'''::tsquery)
        ->  Seq Scan on tsv_test  (cost=0.00..19967.66 rows=199973 width=8) (actual time=0.036..1469.121 rows=200000 loops=1)
              Filter: (v @@ '''fooblablabla'''::tsquery)
Total runtime: 2498.908 ms

Per node type stats

node type	count	sum of times	% of query
Append	1	309.493 ms	13.2 %
Bitmap Heap Scan	2	143.664 ms	6.1 %
Bitmap Index Scan	2	57.790 ms	2.5 %
Result	1	359.312 ms	15.4 %
Seq Scan	1	1469.121 ms	62.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
tsv_test	3	1612.785 ms	68.9 %
Bitmap Heap Scan	2	143.664 ms	8.9 %
Seq Scan	1	1469.121 ms	91.1 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: qu3S

Colorize:

Columns visibility:

Per node type stats

Per table stats