explain.depesz.com

A tool for finding a real cause for slow queries.

Result: T5b

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.025 224497.337 ↑ 7.1 140 1

Limit (cost=261978.57..261981.07 rows=1000 width=874) (actual time=224497.289..224497.337 rows=140 loops=1)

2. 0.339 224497.312 ↑ 1136.9 140 1

Sort (cost=261978.57..262376.49 rows=159167 width=874) (actual time=224497.288..224497.312 rows=140 loops=1)

  • Sort Key: unixtimestamp
  • Sort Method: quicksort Memory: 217kB
3. 224496.973 224496.973 ↑ 1136.9 140 1

Seq Scan on feed_document this_ (cost=0.00..253251.62 rows=159167 width=874) (actual time=136797.095..224496.973 rows=140 loops=1)

  • Filter: (((NOT keywordsextracted) OR (keywordsextracted IS NULL)) AND (article_id IS NOT NULL))