#	exclusive	inclusive	rows x	rows	loops	node
1.	0.019	22101.231	↓ 10.0	10	1	→ Limit (cost=27.99..28.00 rows=1 width=8) (actual time=22101.212..22101.231 rows=10 loops=1)
2.	2.681	22101.212	↓ 10.0	10	1	→ HashAggregate (cost=27.99..28.00 rows=1 width=8) (actual time=22101.205..22101.212 rows=10 loops=1)
3.	3.716	22098.531	↓ 3222.0	3222	1	→ Subquery Scan on bob (cost=27.97..27.99 rows=1 width=8) (actual time=22037.013..22098.531 rows=3222 loops=1)
4.	31.744	22094.815	↓ 3222.0	3222	1	→ Unique (cost=27.97..27.98 rows=1 width=16) (actual time=22037.011..22094.815 rows=3222 loops=1)
5.	89.680	22063.071	↓ 45421.0	45421	1	→ Sort (cost=27.97..27.97 rows=1 width=16) (actual time=22037.008..22063.071 rows=45421 loops=1) Sort Key: queryexecutioncategorydocuments.relevance, queryexecutioncategorydocuments.docid Sort Method: quicksort Memory: 3666kB
6.	65.013	21973.391	↓ 45421.0	45421	1	→ Nested Loop (cost=16.17..27.96 rows=1 width=16) (actual time=4956.961..21973.391 rows=45421 loops=1)
7.	7.991	4509.578	↓ 3222.0	3222	1	→ HashAggregate (cost=16.17..16.18 rows=1 width=8) (actual time=4506.190..4509.578 rows=3222 loops=1)
8.	4501.587	4501.587	↓ 4114.0	4114	1	→ Index Scan using idx_qecs_qxid_cat_pol on queryexecutioncategorysentences (cost=0.00..16.17 rows=1 width=8) (actual time=256.905..4501.587 rows=4114 loops=1) Index Cond: ((queryexecutionid = 2148) AND (lower(currentcategory) = 'secret world'::text))
9.	17398.800	17398.800	↓ 14.0	14	3222	→ Index Scan using idx_qe_docid_qecd on queryexecutioncategorydocuments (cost=0.00..11.75 rows=1 width=16) (actual time=2.270..5.400 rows=14 loops=3222) Index Cond: ((queryexecutionid = 2148) AND (docid = queryexecutioncategorysentences.docid))

"Limit  (cost=27.99..28.00 rows=1 width=8) (actual time=22101.212..22101.231 rows=10 loops=1)"
"  ->  HashAggregate  (cost=27.99..28.00 rows=1 width=8) (actual time=22101.205..22101.212 rows=10 loops=1)"
"        ->  Subquery Scan on bob  (cost=27.97..27.99 rows=1 width=8) (actual time=22037.013..22098.531 rows=3222 loops=1)"
"              ->  Unique  (cost=27.97..27.98 rows=1 width=16) (actual time=22037.011..22094.815 rows=3222 loops=1)"
"                    ->  Sort  (cost=27.97..27.97 rows=1 width=16) (actual time=22037.008..22063.071 rows=45421 loops=1)"
"                          Sort Key: queryexecutioncategorydocuments.relevance, queryexecutioncategorydocuments.docid"
"                          Sort Method: quicksort  Memory: 3666kB"
"                          ->  Nested Loop  (cost=16.17..27.96 rows=1 width=16) (actual time=4956.961..21973.391 rows=45421 loops=1)"
"                                ->  HashAggregate  (cost=16.17..16.18 rows=1 width=8) (actual time=4506.190..4509.578 rows=3222 loops=1)"
"                                      ->  Index Scan using idx_qecs_qxid_cat_pol on queryexecutioncategorysentences  (cost=0.00..16.17 rows=1 width=8) (actual time=256.905..4501.587 rows=4114 loops=1)"
"                                            Index Cond: ((queryexecutionid = 2148) AND (lower(currentcategory) = 'secret world'::text))"
"                                ->  Index Scan using idx_qe_docid_qecd on queryexecutioncategorydocuments  (cost=0.00..11.75 rows=1 width=16) (actual time=2.270..5.400 rows=14 loops=3222)"
"                                      Index Cond: ((queryexecutionid = 2148) AND (docid = queryexecutioncategorysentences.docid))"
"Total runtime: 22101.448 ms"

Per node type stats

node type	count	sum of times	% of query
HashAggregate	2	10.672 ms	0.0 %
Index Scan	2	21900.387 ms	99.1 %
Limit	1	0.019 ms	0.0 %
Nested Loop	1	65.013 ms	0.3 %
Sort	1	89.680 ms	0.4 %
Subquery Scan on bob	1	3.716 ms	0.0 %
Unique	1	31.744 ms	0.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
queryexecutioncategorydocuments	1	17398.800 ms	78.7 %
Index Scan	1	17398.800 ms	100.0 %
queryexecutioncategorysentences	1	4501.587 ms	20.4 %
Index Scan	1	4501.587 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: krv

Colorize:

Columns visibility:

Per node type stats

Per table stats