explain.depesz.com

A tool for finding a real cause for slow queries.

Result: krv

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.019 22,101.231 ↓ 10.0 10 1

Limit (cost=27.99..28.00 rows=1 width=8) (actual time=22,101.212..22,101.231 rows=10 loops=1)

2. 2.681 22,101.212 ↓ 10.0 10 1

HashAggregate (cost=27.99..28.00 rows=1 width=8) (actual time=22,101.205..22,101.212 rows=10 loops=1)

3. 3.716 22,098.531 ↓ 3,222.0 3,222 1

Subquery Scan on bob (cost=27.97..27.99 rows=1 width=8) (actual time=22,037.013..22,098.531 rows=3,222 loops=1)

4. 31.744 22,094.815 ↓ 3,222.0 3,222 1

Unique (cost=27.97..27.98 rows=1 width=16) (actual time=22,037.011..22,094.815 rows=3,222 loops=1)

5. 89.680 22,063.071 ↓ 45,421.0 45,421 1

Sort (cost=27.97..27.97 rows=1 width=16) (actual time=22,037.008..22,063.071 rows=45,421 loops=1)

  • Sort Key: queryexecutioncategorydocuments.relevance, queryexecutioncategorydocuments.docid
  • Sort Method: quicksort Memory: 3666kB
6. 65.013 21,973.391 ↓ 45,421.0 45,421 1

Nested Loop (cost=16.17..27.96 rows=1 width=16) (actual time=4,956.961..21,973.391 rows=45,421 loops=1)

7. 7.991 4,509.578 ↓ 3,222.0 3,222 1

HashAggregate (cost=16.17..16.18 rows=1 width=8) (actual time=4,506.190..4,509.578 rows=3,222 loops=1)

8. 4,501.587 4,501.587 ↓ 4,114.0 4,114 1

Index Scan using idx_qecs_qxid_cat_pol on queryexecutioncategorysentences (cost=0.00..16.17 rows=1 width=8) (actual time=256.905..4,501.587 rows=4,114 loops=1)

  • Index Cond: ((queryexecutionid = 2148) AND (lower(currentcategory) = 'secret world'::text))
9. 17,398.800 17,398.800 ↓ 14.0 14 3,222

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=3,222)

  • Index Cond: ((queryexecutionid = 2148) AND (docid = queryexecutioncategorysentences.docid))