explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Eph

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.014 1,601.697 ↑ 1.0 100 1

Limit (cost=72,141.36..72,141.61 rows=100 width=46) (actual time=1,601.679..1,601.697 rows=100 loops=1)

2. 24.380 1,601.683 ↑ 307.0 100 1

Sort (cost=72,141.36..72,218.11 rows=30,697 width=46) (actual time=1,601.675..1,601.683 rows=100 loops=1)

  • Sort Key: "timestamp
  • Sort Method: top-N heapsort Memory: 30kB
3. 1,506.208 1,577.303 ↓ 2.5 76,252 1

Bitmap Heap Scan on table (cost=1,142.39..70,968.15 rows=30,697 width=46) (actual time=95.972..1,577.303 rows=76,252 loops=1)

  • Recheck Cond: ((devid = 16) AND (serid = '7810096790609417766'::bpchar) AND (id > 10101772))
4. 71.095 71.095 ↓ 2.5 76,252 1

Bitmap Index Scan on "tableDSI" (cost=0.00..1,134.71 rows=30,697 width=0) (actual time=71.095..71.095 rows=76,252 loops=1)

  • Index Cond: ((devid = 16) AND (serid = '7810096790609417766'::bpchar) AND (id > 10101772))