Result: osG

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
0.468	422.800	↓ 6.1	5000	1	→ Limit (cost=6075.61..6077.66 rows=817 width=66) (actual time=421.688..422.800 rows=5000 loops=1)
26.318	422.332	↓ 6.1	5000	1	→ Sort (cost=6075.61..6077.66 rows=817 width=66) (actual time=421.686..422.332 rows=5000 loops=1) Sort Key: (min(l.msoffset))ount as rl, Sort Method: top-N heapsort Memory: 1713kB(toplevelrid,'\|'\|\| (min(msoffset))::varchar)as varchar) as rqit,
134.134	396.014	↓ 41.0	33508	1	→ HashAggregate (cost=5978.90..6036.09 rows=817 width=66) (actual time=337.527..396.014 rows=33508 loops=1)
21.884	261.880	↓ 43.4	35458	1	→ Nested Loop (cost=18.33..5944.18 rows=817 width=66) (actual time=51.806..261.880 rows=35458 loops=1)
19.077	27.248	↓ 43.4	35458	1	→ Bitmap Heap Scan on aserror_ts_20120124 ts (cost=18.33..1966.88 rows=817 width=8) (actual time=9.427..27.248 rows=35458 loops=1) Recheck Cond: (as_msg_2_tsv_2 @@ '''enfinity'''::tsquery)count,
8.171	8.171	↓ 43.4	35458	1	→ Bitmap Index Scan on aserror_ts_20120124_tvi (cost=0.00..18.13 rows=817 width=0) (actual time=8.171..8.171 rows=35458 loops=1) Index Cond: (as_msg_2_tsv_2 @@ '''enfinity'''::tsquery)unt,
212.748	212.748	↑ 1.0	1	35458	→ Index Scan using pk_aserrorlist_20120124 on aserrorlist_20120124 l (cost=0.00..4.85 rows=1 width=74) (actual time=0.005..0.006 rows=1 loops=35458) Index Cond: (id = ts.id)e) then true end) as int) as oom_count,

 Limit  (cost=6075.61..6077.66 rows=817 width=66) (actual time=421.688..422.800 rows=5000 loops=1)
   ->  Sort  (cost=6075.61..6077.66 rows=817 width=66) (actual time=421.686..422.332 rows=5000 loops=1)
         Sort Key: (min(l.msoffset))ount as rl,
         Sort Method: top-N heapsort  Memory: 1713kB(toplevelrid,'|'|| (min(msoffset))::varchar)as varchar)  as rqit,
         ->  HashAggregate  (cost=5978.90..6036.09 rows=817 width=66) (actual time=337.527..396.014 rows=33508 loops=1)
               ->  Nested Loop  (cost=18.33..5944.18 rows=817 width=66) (actual time=51.806..261.880 rows=35458 loops=1)
                     ->  Bitmap Heap Scan on aserror_ts_20120124 ts  (cost=18.33..1966.88 rows=817 width=8) (actual time=9.427..27.248 rows=35458 loops=1)
                           Recheck Cond: (as_msg_2_tsv_2 @@ '''enfinity'''::tsquery)count,
                           ->  Bitmap Index Scan on aserror_ts_20120124_tvi  (cost=0.00..18.13 rows=817 width=0) (actual time=8.171..8.171 rows=35458 loops=1)
                                 Index Cond: (as_msg_2_tsv_2 @@ '''enfinity'''::tsquery)unt,
                     ->  Index Scan using pk_aserrorlist_20120124 on aserrorlist_20120124 l  (cost=0.00..4.85 rows=1 width=74) (actual time=0.005..0.006 rows=1 loops=35458)
                           Index Cond: (id = ts.id)e) then true end) as int) as oom_count,
 Total runtime: 426.040

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	19.077 ms	4.5 %
Bitmap Index Scan	1	8.171 ms	1.9 %
HashAggregate	1	134.134 ms	31.7 %
Index Scan	1	212.748 ms	50.3 %
Limit	1	0.468 ms	0.1 %
Nested Loop	1	21.884 ms	5.2 %
Sort	1	26.318 ms	6.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
aserror_ts_20120124	1	19.077 ms	4.5 %
Bitmap Heap Scan	1	19.077 ms	100.0 %
aserrorlist_20120124	1	212.748 ms	50.3 %
Index Scan	1	212.748 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: osG

Colorize:

Columns visibility:

Per node type stats

Per table stats