explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ocJT

Settings
# exclusive inclusive rows x rows loops node
1. 78,939.000 79,287.140 ↑ 1.1 213,371 1

Bitmap Heap Scan on posts (cost=4,642.75..461,028.38 rows=241,791 width=4) (actual time=355.853..79,287.140 rows=213,371 loops=1)

  • Recheck Cond: ((text_search_words @@ '''rockendrockstar'' | ''proptech'' | ''propertymanag'' | ''arpm18'' | ''pmc18'' | ''rockend'' | ''propertytre'''::tsquery) OR (mentioned_uids && '{urn:li:organizat
  • Rows Removed by Index Recheck: 978360
  • Heap Blocks: exact=32622 lossy=106796
2. 0.001 348.140 ↓ 0.0 0 1

BitmapOr (cost=4,642.75..4,642.75 rows=241,847 width=0) (actual time=348.140..348.140 rows=0 loops=1)

3. 219.134 219.134 ↑ 1.1 222,096 1

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

  • Index Cond: (text_search_words @@ '''rockendrockstar'' | ''proptech'' | ''propertymanag'' | ''arpm18'' | ''pmc18'' | ''rockend'' | ''propertytre'''::tsquery)
4. 129.005 129.005 ↑ 1.9 721 1

Bitmap Index Scan on mentioned_uids_index (cost=0.00..1,886.17 rows=1,356 width=0) (actual time=129.004..129.005 rows=721 loops=1)

  • Index Cond: (mentioned_uids && '{urn:li:organization:648378,1295432328,168302926554064,1116570978400699,870775225,2193239737,4509659575}'::text[])