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