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 224,497.337 ↑ 7.1 140 1

Limit (cost=261,978.57..261,981.07 rows=1,000 width=874) (actual time=224,497.289..224,497.337 rows=140 loops=1)

2. 0.339 224,497.312 ↑ 1,136.9 140 1

Sort (cost=261,978.57..262,376.49 rows=159,167 width=874) (actual time=224,497.288..224,497.312 rows=140 loops=1)

  • Sort Key: unixtimestamp
  • Sort Method: quicksort Memory: 217kB
3. 224,496.973 224,496.973 ↑ 1,136.9 140 1

Seq Scan on feed_document this_ (cost=0.00..253,251.62 rows=159,167 width=874) (actual time=136,797.095..224,496.973 rows=140 loops=1)

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