#	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))

 Limit  (cost=261978.57..261981.07 rows=1000 width=874) (actual time=224497.289..224497.337 rows=140 loops=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
         ->  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))
 Total runtime: 224497.402 ms

Per node type stats

node type	count	sum of times	% of query
Limit	1	0.025 ms	0.0 %
Seq Scan	1	224496.973 ms	100.0 %
Sort	1	0.339 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
feed_document	1	224496.973 ms	100.0 %
Seq Scan	1	224496.973 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: T5b

Colorize:

Columns visibility:

Per node type stats

Per table stats