explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jxNe

Settings
# exclusive inclusive rows x rows loops node
1. 10.142 10.475 ↓ 1.0 1,684 1

Bitmap Heap Scan on search (cost=28.65..4,088.92 rows=1,633 width=0) (actual time=0.514..10.475 rows=1,684 loops=1)

  • Recheck Cond: (fulltext @@ '''exampl'''::tsquery)
  • Heap Blocks: exact=1,522
2. 0.333 0.333 ↓ 1.0 1,684 1

Bitmap Index Scan on search_fulltext (cost=0.00..28.24 rows=1,633 width=0) (actual time=0.333..0.333 rows=1,684 loops=1)

  • Index Cond: (fulltext @@ '''exampl'''::tsquery)
Planning time : 0.180 ms
Execution time : 10.564 ms