explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 1f7 : slow query when sorting on double precision field

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

Limit (cost=0.00..16.22 rows=1 width=46) (actual time=104,022.471..104,022.471 rows=1 loops=1)

2. 104,022.467 104,022.467 ↑ 30,540.0 1 1

Index Scan using "tableTimestamp" on table (cost=0.00..495,345.38 rows=30,540 width=46) (actual time=104,022.467..104,022.467 rows=1 loops=1)

  • Filter: ((id > 10106972) AND (devid = 5) AND (serid = '7810096790609417766'::bpchar))