explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qLXL

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 222.172 ↑ 1.0 10 1

Limit (cost=21,965.14..21,965.17 rows=10 width=1,306) (actual time=222.167..222.172 rows=10 loops=1)

2. 0.148 222.167 ↑ 76.2 10 1

Sort (cost=21,965.14..21,967.05 rows=762 width=1,306) (actual time=222.165..222.167 rows=10 loops=1)

  • Sort Key: (ts_rank(content_cards.ementa_vectors, query.query, 32)) DESC, content_cards.id
  • Sort Method: top-N heapsort Memory: 40kB
3. 0.332 222.019 ↑ 12.5 61 1

Nested Loop (cost=844.61..21,948.68 rows=762 width=1,306) (actual time=162.989..222.019 rows=61 loops=1)

4. 0.019 0.019 ↑ 1.0 1 1

Function Scan on to_tsquery query (cost=0.25..0.26 rows=1 width=32) (actual time=0.018..0.019 rows=1 loops=1)

5. 61.123 221.668 ↑ 12.5 61 1

Bitmap Heap Scan on content_cards (cost=844.36..21,938.89 rows=762 width=1,459) (actual time=162.962..221.668 rows=61 loops=1)

  • Recheck Cond: (query.query @@ ementa_vectors)
  • Rows Removed by Index Recheck: 5577
  • Filter: ((data_publicacao >= '2010-01-01'::date) AND (data_publicacao <= '2020-01-30'::date) AND (ts_rank(ementa_vectors, query.query, 32) > '0.001'::double precision) AND (entity = ANY ('{7,0,3,1,2}'::integer[])))
  • Rows Removed by Filter: 49
  • Heap Blocks: exact=5486
6. 160.545 160.545 ↑ 1.0 5,687 1

Bitmap Index Scan on ementa_vecs (cost=0.00..844.17 rows=5,835 width=0) (actual time=160.545..160.545 rows=5,687 loops=1)

  • Index Cond: (query.query @@ ementa_vectors)