explain.depesz.com

A tool for finding a real cause for slow queries.

Result: tqwU

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.045 34.039 ↑ 1.0 10 1

Sort (cost=13,672.77..13,672.79 rows=10 width=1,140) (actual time=34.038..34.039 rows=10 loops=1)

  • Sort Key: divaevent."timestamp", divaevent.id
  • Sort Method: quicksort Memory: 18kB
2. 0.003 33.994 ↑ 1.0 10 1

Limit (cost=13,672.48..13,672.50 rows=10 width=1,140) (actual time=33.992..33.994 rows=10 loops=1)

3. 0.049 33.991 ↑ 11.0 10 1

Sort (cost=13,672.48..13,672.75 rows=110 width=1,140) (actual time=33.991..33.991 rows=10 loops=1)

  • Sort Key: divaevent."timestamp", divaevent.id
  • Sort Method: top-N heapsort Memory: 18kB
4. 0.014 33.942 ↑ 1.0 110 1

Limit (cost=13,668.73..13,669.00 rows=110 width=68) (actual time=33.923..33.942 rows=110 loops=1)

5. 13.474 33.928 ↑ 291.2 110 1

Sort (cost=13,668.73..13,748.82 rows=32,036 width=68) (actual time=33.919..33.928 rows=110 loops=1)

  • Sort Key: divaevent.id
  • Sort Method: top-N heapsort Memory: 31kB
6. 16.497 20.454 ↓ 1.0 32,282 1

Bitmap Heap Scan on divaevent (cost=2,236.58..12,422.31 rows=32,036 width=68) (actual time=4.242..20.454 rows=32,282 loops=1)

  • Recheck Cond: (deviceid = 1)
  • Filter: ((id > 1) AND (serverid = '7015498111931795223'::bpchar))
7. 3.957 3.957 ↑ 1.0 32,379 1

Bitmap Index Scan on "DivaEventDeviceId" (cost=0.00..2,228.57 rows=32,556 width=0) (actual time=3.957..3.957 rows=32,379 loops=1)

  • Index Cond: (deviceid = 1)