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 1780.599 ↑ 1.0 100 1

Limit (cost=0.00..1575.48 rows=100 width=46) (actual time=1780.213..1780.599 rows=100 loops=1)

2. 1780.585 1780.585 ↑ 306.9 100 1

Index Scan using "tableSortTimeStamp" on table (cost=0.00..483483.83 rows=30688 width=46) (actual time=1780.210..1780.585 rows=100 loops=1)

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