explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Kbb

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 15,013.741 ↑ 1.0 5 1

Limit (cost=4,475.12..4,475.13 rows=5 width=24) (actual time=15,013.735..15,013.741 rows=5 loops=1)

2. 15,013.735 15,013.735 ↑ 453.2 5 1

Sort (cost=4,475.12..4,476.26 rows=2,266 width=24) (actual time=15,013.732..15,013.735 rows=5 loops=1)

3. 15,006.763 15,006.763 ↑ 1.5 1,495 1

Bitmap Heap Scan on entities (cost=43.31..4,467.60 rows=2,266 width=24) (actual time=0.872..15,006.763 rows=1,495 loops=1)

4. 0.549 0.549 ↑ 1.5 1,495 1

Bitmap Index Scan on gin_ix_entity_full_text_search_name (cost=0.00..43.20 rows=2,266 width=0) (actual time=0.549..0.549 rows=1,495 loops=1)