explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nS2a

Settings
# exclusive inclusive rows x rows loops node
1. 29,075.072 29,247.347 ↑ 1.1 213,363 1

Bitmap Heap Scan on posts (cost=2,695.81..457,164.59 rows=240,491 width=4) (actual time=178.481..29,247.347 rows=213,363 loops=1)

  • Recheck Cond: (text_search_words @@ '''rockendrockstar'' | ''proptech'' | ''propertymanag'' | ''arpm18'' | ''pmc18'' | ''rockend'' | ''propertytre'''::tsquery)
  • Rows Removed by Index Recheck: 978363
  • Heap Blocks: exact=32616 lossy=106796
2. 172.275 172.275 ↑ 1.1 222,096 1

Bitmap Index Scan on tsw_idx (cost=0.00..2,635.69 rows=240,491 width=0) (actual time=172.275..172.275 rows=222,096 loops=1)

  • Index Cond: (text_search_words @@ '''rockendrockstar'' | ''proptech'' | ''propertymanag'' | ''arpm18'' | ''pmc18'' | ''rockend'' | ''propertytre'''::tsquery)