#	exclusive	inclusive	rows x	rows	loops	node
1.	0.014	1601.697	↑ 1.0	100	1	→ Limit (cost=72141.36..72141.61 rows=100 width=46) (actual time=1601.679..1601.697 rows=100 loops=1)
2.	24.380	1601.683	↑ 307.0	100	1	→ Sort (cost=72141.36..72218.11 rows=30697 width=46) (actual time=1601.675..1601.683 rows=100 loops=1) Sort Key: "timestamp Sort Method: top-N heapsort Memory: 30kB
3.	1506.208	1577.303	↓ 2.5	76252	1	→ Bitmap Heap Scan on table (cost=1142.39..70968.15 rows=30697 width=46) (actual time=95.972..1577.303 rows=76252 loops=1) Recheck Cond: ((devid = 16) AND (serid = '7810096790609417766'::bpchar) AND (id > 10101772))
4.	71.095	71.095	↓ 2.5	76252	1	→ Bitmap Index Scan on "tableDSI" (cost=0.00..1134.71 rows=30697 width=0) (actual time=71.095..71.095 rows=76252 loops=1) Index Cond: ((devid = 16) AND (serid = '7810096790609417766'::bpchar) AND (id > 10101772))

"Limit  (cost=72141.36..72141.61 rows=100 width=46) (actual time=1601.679..1601.697 rows=100 loops=1)"
"  ->  Sort  (cost=72141.36..72218.11 rows=30697 width=46) (actual time=1601.675..1601.683 rows=100 loops=1)"
"        Sort Key: "timestamp""
"        Sort Method:  top-N heapsort  Memory: 30kB"
"        ->  Bitmap Heap Scan on table  (cost=1142.39..70968.15 rows=30697 width=46) (actual time=95.972..1577.303 rows=76252 loops=1)"
"              Recheck Cond: ((devid = 16) AND (serid = '7810096790609417766'::bpchar) AND (id > 10101772))"
"              ->  Bitmap Index Scan on "tableDSI"  (cost=0.00..1134.71 rows=30697 width=0) (actual time=71.095..71.095 rows=76252 loops=1)"
"                    Index Cond: ((devid = 16) AND (serid = '7810096790609417766'::bpchar) AND (id > 10101772))"
"Total runtime: 1601.957 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	1506.208 ms	94.0 %
Bitmap Index Scan	1	71.095 ms	4.4 %
Limit	1	0.014 ms	0.0 %
Sort	1	24.380 ms	1.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
table	1	1506.208 ms	94.0 %
Bitmap Heap Scan	1	1506.208 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Eph

Colorize:

Columns visibility:

Per node type stats

Per table stats