explain.depesz.com

A tool for finding a real cause for slow queries.

Result: GIqM

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

Limit (cost=0.00..1,575.48 rows=100 width=46) (actual time=1,780.213..1,780.599 rows=100 loops=1)

2. 1,780.585 1,780.585 ↑ 306.9 100 1

Index Scan using "tableSortTimeStamp" on table (cost=0.00..483,483.83 rows=30,688 width=46) (actual time=1,780.210..1,780.585 rows=100 loops=1)

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